I have a basic report that the user can select the start and end date/time to get the data for the day. It works correctly (img1) when the user selects the day range (example: start date: 01/10/2024 12:00 AM and end date: 01/10/2024 12:00 PM.
However, if the user selects multiple date range (example: start date 01/01/2024 12:00 AM and end date 01/10/2024 11:59 PM, the data for each day is wacked out as shown in img-2)
(img1)
(img2)
this is the report data settings.
Any thoughts on why the query breaks down when spanning multiple days?
is the interval that's causing it?