Store Procedures with CR 9

[alvintse]

I have a report created with CR9 Developer and MSSQL 2000 using Store Procedure with 2 parameters.

CREATE PROCEDURE stp_sample
@Name varchar(50),
@AsOfDate DateTime
....

When I run the report, it prompts the user to input the date as expected. However, it also requires the hour and minutes. I only want the user to input the data only.

I know in CR, we can declare the datatype as date so it only prompts for date. But in MSSQL, only dateTime is avail.
Is there any way I can do so the report will only prompt for date only?

Thanks

 

[synapsevampire]

The only workarounds I use are:

-Either inform the users to ignore the date and strip it within the SP
-Prompt using a varchar and CAST/CONVERT within the SP
-Use a View instead, and create a Crystal parameter to pass to the View.

-k