Stored Procedure input parameter 1

[RobbOrt]

When using a SQL stored procedure in Crystal Reports (XI), can you edit the input parameter that the user needs to fill in to run the report?
My SP input variable is set as DATETIME, but I would like the user to be able to input only the date.

 

[briangriffin]

SQL Server syntax:

Create a parameter in Crystal with a date datatype.

Base your report on a command object instead of the stored procedure itself:

exec yourspname {?DatePrompt}

Modify the date filtering in your sp to use a converted value:

create procedure timetest @cutoffdate smalldatetime
as

select  * from dbo.yourtable where
yourdatefield < convert(smalldatetime,@cutoffdate,101)

 

[zemp]

Thanks Brian, just what I was looking for.

zemp