I've searched the forums and tried multiple suggestions on here about similar issues to no avail, I am wondering if anyone can help?
I have a report that users StartDate and EndDate as a parameter. We have lots of reports that use this and for some reason, a small selection of reports do not work.
The user enters a DATE only, for a DATETIME field in MySQL.
So they enter say 18/01/2023 (2023-01-18) and the end date can be anything. If they enter a date any time after the next day, i.e. 19/01/2023 then the report returns results. If they enter the same day (i.e. to get the full days results), then no results are returned.
In other reports, using the same data type field, Crystal seems to automatically set the date to include a timestamp of 00:00:00 -> 23:59:59 but for some reason, in the case of these few reports I have, it doesn't. It looks for a start date EQUAL to 18/01/2023 for example, which obviously returns no results because the DB needs to look for > "2023-01-18 00:00:00"
The issue is causing me major problems on some reports and I can't figure out how to fix it. The reports that DO work use the exact same data type in MySQL (datetime) and the exact same parameters in Crystal...but they just act differently and behave differently. I cannot fathom it.
I have also tried to re-create the report from scratch but it doesn't make a difference.
We are using SAP Crystal Reports 2020 SP2 P1