Hi,
I am stuck.
I have created a stored procedure on SQL Server which accepts one parameter.
I have then setup a Crystal report which reports from this Stored Procedure.
In Visual basic, i want to Call this Crystal report and pass it the parameter it needs to return data.
The following is the code i use.
On Error GoTo errhandler
CrystalReport1.ReportFileName = "d:\shipping.rpt"
CrystalReport1.StoredProcParam(0) = retstring ' This holds the parameter.
CrystalReport1.PrintReport
errhandler:
Exit Sub
End Sub
Unfortunately the report returns nothing.
Any help at all would be much appreciated
Conor
I am stuck.
I have created a stored procedure on SQL Server which accepts one parameter.
I have then setup a Crystal report which reports from this Stored Procedure.
In Visual basic, i want to Call this Crystal report and pass it the parameter it needs to return data.
The following is the code i use.
On Error GoTo errhandler
CrystalReport1.ReportFileName = "d:\shipping.rpt"
CrystalReport1.StoredProcParam(0) = retstring ' This holds the parameter.
CrystalReport1.PrintReport
errhandler:
Exit Sub
End Sub
Unfortunately the report returns nothing.
Any help at all would be much appreciated
Conor