Date parameters

[ByzantianX]

I tried to bound a new report to the stored procedure on sql server. Stored procedure requires 2 smalldate parameters and there is no way I can pass the value in "Enter parameter value" dialogue. Everytime I am getting the message "Error detected by database DLL". I am using European date format DD.MM.YYYY
I really don't know what to do. I had to change stored procedure and to pass string values (I converted those two date parameters with convert(smalldatetime,@dateparameter) function but that can be only an ad hoc solution. I'm using Crystal Reports 7. Please, help!

 

[Jackthelad]

I've had a similar prob when trying to pass dates from a VB6 front end to a CR8 report using CR8 ocx.

I found the answer on Seagates KB (now crytaldecisions). Article c2006910 shows you how to do it. Basically you must include a Time value and pass the date in yyyy,mm,dd format.

eg
CrReport1.parameterfields(0)="BegDateate(2001,05,31)Time(00,00,00,000);TRUE"
where BegDate is your report parameter

You must also set DiscardSavedData property of OCX to false.

Hope this helps.