Report Dates parameters not working within Report Designer?

1 Answer 34 Views
Conditional Formatting Filtering Report Designer (standalone) Report Viewer - HTML5 WebForms
Austin
Top achievements
Rank 1
Austin asked on 20 Aug 2021, 03:06 PM

Good Morning Telerik,

 

The query I am using within Telerik to query my data from the SQL database is the following.

SELECT *

FROM WebTasks

WHERE COMPLETEDDATE BETWEEN TO_DATE(:FromDate,'MM/DD/YYYY HH24:MI:SS') AND TO_DATE(:ToDate,'MM/DD/YYYY HH24:MI:SS')

 

It creates two parameters the "To Date" and "From Date" however- selecting the date and clicking preview just returns the entire table with all the data going back before and after the selected dates. one of the tables with the dates is "COMPLETEDDATE" but it seems to be ignoring this I guess?

 

What am I doing wrong?

1 Answer, 1 is accepted

Sort by
0
Neli
Telerik team
answered on 25 Aug 2021, 01:33 PM

Hello Austin, 

Can you please test replacing the : with @? Also, it will help me a lot if you can send me a video that demonstrates the problem.

I will be looking forward to receiving an update from you.

Regards,
Neli
Progress Telerik

Brand new Telerik Reporting course in Virtual Classroom - the free self-paced technical training that gets you up to speed with Telerik and Kendo UI products. Check it out at https://learn.telerik.com/.
Tags
Conditional Formatting Filtering Report Designer (standalone) Report Viewer - HTML5 WebForms
Asked by
Austin
Top achievements
Rank 1
Answers by
Neli
Telerik team
Share this question
or