The problem I am having is that I have created an SQL 2000 stored procedure that has two parameters StartDate and FinishDate, which are smalldatetime data types. I have also created a Crystal 8.0 report with this stored procedure. I am having problems passing the parameters to the report from my VB 6 app because crystal is looking for a string. This is the code that I have now is:
With crpt1
.ReportFileName = constReportPath & stReportFileName
.ParameterFields(0) = "@StarDate;" & _
format(dtbeginDate, "mm/dd/yyyy hh:mm:ss"
& ";true"
.ParameterFields(1) = "@FinishDate;" & _
format(dtEndDate, "mm/dd/yyyy hh:mm:ss"
& ";true"
.Action = 1
End With
The error I get is "The specified value type is different to the current value type".
With crpt1
.ReportFileName = constReportPath & stReportFileName
.ParameterFields(0) = "@StarDate;" & _
format(dtbeginDate, "mm/dd/yyyy hh:mm:ss"
.ParameterFields(1) = "@FinishDate;" & _
format(dtEndDate, "mm/dd/yyyy hh:mm:ss"
.Action = 1
End With
The error I get is "The specified value type is different to the current value type".