I'm writing several reports in Crystal Reports, that retrieve data from a SQL Server 7 database by calling stored procedures.
I have a VB6 app that fires my stored-procerude based reports. The VB app prompts for the parameters and then uses StoredProcParam() to pass them to the ActiveX. The code I'm using looks like this:
rpt.StoredProcParam(0) = cmbDial.ListIndex
rpt.StoredProcParam(1) = iShiftID
rpt.StoredProcParam(2) = txtStartDateTime.Text
rpt.StoredProcParam(3) = txtEndDateTime.Text
This was working fine in Crystal version 7, with SQL Server 7 (I'm using SQL Server driver). When I upgraded to Crystal's MR1, all my reports started to show up empty. A little research and I discovered that the stored procedures are not receiving the parameters (they came as empty strings).
Any clue on this problem ? (please, write a copy to my email addr)
Thanks a lot !