Date Range Component on Report Viewer

Hello,
I’ve created a report using Basic SQL Query and used the date range component in the report viewer. My report is working as it should, however, when I change the dates in the range component, the report doesn’t seem to update based on the dates provided. I’ve bound the StartDate property of report to the Start Date property of date range and made it bidirectional. A similar thing is done for the end date too.

I was looking to some topics on the same question and have tried to update my SQL Query based on the t_stamp as mentioned below:

SELECT * FROM Refrig_Tags
WHERE t_stamp >= {StartDate}
AND t_stamp < {EndDate}

However, I get an error with the format I believe. Can anyone suggest me to do it in a better way?

Thanks in advance.
Priyanshu

Please take a look at this part of the manual:
https://docs.inductiveautomation.com/display/DOC80/Basic+SQL+Query

There’s some datetime/string manipulation if you want to use that default Start/EndDate parameters with Basic SQL Query.

Another alternative as advised by Ignition trainer is as follows:
“Rather than converting your StartDate and EndDate report parameters to strings, you can use a query type of “SQL Query”, then use “?” characters in your query to inject parameters. This will gracefully handle dates passed in from the Report Viewer component.”

2 Likes