[Question | StandAlone Designer]: Narrow results by time-range over several days?

[Austin]

Good Afternoon Telerik,

I am trying to narrow my report results on a DateTime value for an entire month of results. due to it being a schedule some of the times will go into the next day (in example: 11:00 PM 11/02 Thursday to 7:00 AM 11/03 Friday) However, when I run the report. It is only showing times for 7:00 AM to 11:00 PM that night. it reversed the entry instead of it going from 11:00 PM first day to 7:00 AM next day. Is there anyway for me to fix this?

[Dimitar]

Hello Austin,

Could you explain in more detail what have you tried so far to narrow the time range?

In the thread tags, I see DataSource SQL which I assume means the results are retrieved from a database through the SqlDataSource component.

In this case, you may either try to filter the data by the DateTime column through the data items' Filters collection - Filtering the Report at a Glance - Telerik Reporting & Filtering the Table and Crosstab items at a Glance - Telerik Reporting.

Alternatively, you may filter the data in the SQL query itself, the following Stackoverflow threads may help with doing that:

• sql - How to get records in specific time range when the time range is between two days - Stack Overflow
• python - How to return values only within a specific date range? - Stack Overflow
• sql - MySQL return value depending of date range - Stack Overflow
• sql - Given a date/time range, how to filter results by time range? - Stack Overflow

Please let me know if you have additional questions.