Stored procedures with Crystal.Net

[VBGuy2112]

I'm having a problem with reports in Crystal.net I have a stored procedure in SQL Server for the record source. When I have a date field in the procedure, I get a date conversion error in the .net crystal report designer. Anyone know why this is? Is there a better way to set a record source?

As a workaround, I took all parameters off the stored procedure and used the record selection formula to pick off the records. The problem is, SQL will then get all the records and hand it to Crystal to sort them out. This is slow.

Can anyone describe the best way to set the record source for a crystal report in the .net environment.

Thanks in advance!

 

[RiverGuy]

I have used date parameters before, never had a problem. Anyways, the best way to set the source would be to base the original report off of an SQL schema. You can write one fairly easy from your dataSet. Its a lot easier than writing Crystal TTX files from VB6. Then pass your dataSet to the report with only the data that you want--no parameters. Only have your dataSet contain the date range that you want.