I know this has been asked before but I haven't been able to find an answer to this. I have Crystal 2008. I have a stored procedure which I am using as the source of my data. There are two dates in my stored procedure as parameter variables. One is FromDate and the other is ToDate.
When I define these date fields in the stored proc as type DATE, Crystal brings the parameters in as strings, making them useless for entering parameter values with a calendar control.
When I define the dates as DATETIME fields, Crystal interprets them as dates but requires that the time be entered along with the date.
This seems like a really stupid problem with Crystal, especially since SQL 2008 introduced the DATE datatype. But given that it is a problem, has anyone got a workaround somehow? I need to restrict the data on the server because of performance issues.
Thanks in advance for any help.