DateTime issue with Reports in Crystal Enterprise 9

[bessebo]

We are converting to Crystal Enterprise 9 from Seagate Info 7. I have a number of reports whose parameters are startdate and enddate that come from a stored procedure. These 2 parameters are datetime fields. With the advent of Crystal Enterprise 9 there are now pop-up calendars that allow you to enter a date. If I do nothing but import the existing reports into Crystal Enterprise 9 it will allow you to click on the pop-up calendar but it will default to 0,0,0 for the hour, minute, and second. I would like to convert these to just Date fields rather than DateTime. I am using SQLServer but I think I can only use a DateTime field that I can use for the StartDate and EndDate parameters.
I do not have the option to change the parameter to a Date Field within Crystal Reports since it is coming from a stored procedure. I do not want a user to have to enter anything but click on the pop-up calendar. But if they do not change the 0,0,0 for hours, minutes, seconds on the EndDate parameter to 23,59,59 they will not get anything for the last date.
I would rather not change anything in the stored procedure and handle this issue on the Crystal Report side but am unsure how to do this. Any help would be appreciated.

Regards,
Bessebo

 

[synapsevampire]

Since the dates are deetermined by what you passed in the Stored Procedure, you shouldn't be surprised that a newer version of Crystal now supports it.

I would resolve this in the SP, since by your own definition you didn't want times, alter the lower to 0,0,0 and the upper to 23,59,59.

If you want to supply either, add in another parm which flags when to ignore the times.

-k

 

[bessebo]

synapsevampire,
I pretty much decided to adjust the hour, minutes, and seconds in the procedure and leave it at that. When you say, "If you want to supply either, add in another parm which flags when to ignore the times." I'm not sure what you mean. Can you elaborate?

Regards,
Bessebo