Connecting Crystal to Stored Procedure

[neskin]

Hi,
I am connecting a stored procedure with date parameters to the report .
My issue is since in SQL date is datetime the parameters in crystal show the time.How can i edit parameters not showing time

regards,
Nat

 

[rb2005]

Let me know which Database you are using? What is the data type of date parameter in you stored proc.

 

[synapsevampire]

One of the nuisances of SQL Server I'm afraid.

Since you are using a Stored Procedure, you are FORCING Crystal to use the parameter, and SQL Server only has a datetime data type.

Options some people use are to change the parameter to a string, or to place the report as a subreport and make the main report use a date parameter which links to the subreport.

Right, both solutions are kludgy. Remind MS next time you speak with one of them that they need to support basic data types.

-k

 

[neskin]

I am using SQL 2000 and datatype is datetime
thank you
Nat

 

[rb2005]

Are you showing parameter in the report? For displaying without time you can format that field.

 

[vidru]

For years, we've trained our users to ignore the time part of the parameter, and we handle it (the time, that is) in the stored procedure. This works great if the time doesn't matter as far as the data being retrieved.