I have a Crystal 2008 report hitting a SQL Server 2008 database using a stored procedure. The stored procedure takes a parameter of type Date (new to SQL Server 2008).

When Crystal automatically creates the parameter for me in the report, it makes the parameter a type of String. I don't want a type of String because then the user is required to type in a date and doesn't see the Crystal date dialog that he/she would see if the parameter type is Date. The problem is that Crystal is not allowing me to change the parameter type to the type I want.

I don't want to change the stored procedure parameter to a dateTime type because then Crystal would create a report parameter type of datetime and the user would be required to enter a time value. I don't want this either.

Do I have any options here?

Thanks.