From Date and To date

Stimulsoft Reports.Web discussion
shravan.pitla
Posts: 15
Joined: Wed Jul 22, 2020 1:11 pm

From Date and To date

Post by shravan.pitla » Tue Jul 28, 2020 7:18 am

Please help me,
I am trying to filter the data based on from date and to date.
Please check the bellow filter condition and my query
after adding the filter condition the data is not showing in the report.
(userstat.actiondate >= fromdate) && (userstat.actiondate <= todate)
{userstat}select distinct time_stamp as actiondate,user_name as username ,event_description as action,event_name as actiontype from dm_audittrail where event_name in ('dm_connect','dm_disconnect','d2_connect') and user_name not in ( 'dm_bof_registry','DCTM Reports','d2_mail_method' ) and user_name not like 'dm\_%' ESCAPE '\' and user_name not like 'd2\_%' ESCAPE '\' and user_name not like 'c2\_%' ESCAPE '\' and (string_1 in ('inline password','ldap','OS password') or event_description='Logoff' ) and user_name is not nullstring order by time_stamp desc ENABLE(RETURN_TOP 1000);
Attachments
1 Capture.PNG
1 Capture.PNG (65.4 KiB) Viewed 167 times
2 Capture.PNG
2 Capture.PNG (12.23 KiB) Viewed 167 times
Lech Kulikowski
Posts: 2707
Joined: Tue Mar 20, 2018 5:34 am

Re: From Date and To date

Post by Lech Kulikowski » Wed Jul 29, 2020 2:49 pm

Hello,

Please send us a sample report with test data that reproduces the issue for analysis.

Thank you.
shravan.pitla
Posts: 15
Joined: Wed Jul 22, 2020 1:11 pm

Re: From Date and To date

Post by shravan.pitla » Wed Jul 29, 2020 2:54 pm

Hi Thanks for the replay,

Please find the sample report and help me please.
Attachments
Test login statistic Report.mrt
(30.62 KiB) Downloaded 4 times
Lech Kulikowski
Posts: 2707
Joined: Tue Mar 20, 2018 5:34 am

Re: From Date and To date

Post by Lech Kulikowski » Thu Jul 30, 2020 5:18 pm

Hello,

Please send us a test data for your report.

Thank you.
shravan.pitla
Posts: 15
Joined: Wed Jul 22, 2020 1:11 pm

Re: From Date and To date

Post by shravan.pitla » Fri Jul 31, 2020 4:50 am

Hi,

Please find the test data for reference, its showing only 100 rows
Do i need to do anything related to browser like cache.
Attachments
Report (2).docx
(7.8 KiB) Downloaded 2 times
Lech Kulikowski
Posts: 2707
Joined: Tue Mar 20, 2018 5:34 am

Re: From Date and To date

Post by Lech Kulikowski » Fri Jul 31, 2020 12:40 pm

Hello,

It is not possible to use word document as data in your report.

Please send us a sample that reroduces the issue for anlaysis.

Thank you.
shravan.pitla
Posts: 15
Joined: Wed Jul 22, 2020 1:11 pm

Re: From Date and To date

Post by shravan.pitla » Fri Jul 31, 2020 1:10 pm

How to send test data, which format is needed to test the data, can you please explain so i will send you according to you
Lech Kulikowski
Posts: 2707
Joined: Tue Mar 20, 2018 5:34 am

Re: From Date and To date

Post by Lech Kulikowski » Sun Aug 02, 2020 9:38 am

Hello,

Any format - XML, JSON, etc, that we can use in your report and reproduce the issue.

Thank you.
shravan.pitla
Posts: 15
Joined: Wed Jul 22, 2020 1:11 pm

Re: From Date and To date

Post by shravan.pitla » Mon Aug 03, 2020 4:53 am

Please find the sample data and help me
Attachments
Sample.xlsx
(12.74 KiB) Downloaded 1 time
shravan.pitla
Posts: 15
Joined: Wed Jul 22, 2020 1:11 pm

Re: From Date and To date

Post by shravan.pitla » Mon Aug 03, 2020 4:55 am

Please find the sample data and help me
Attachments
AnyConv.com__Report (2).xml
(19.27 KiB) Downloaded 2 times
Post Reply