mcsh
December 27th, 2005, 10:42 AM
I am using VB.net 2003 integrated with Crystal Reports. My back-end is SQL Server. In designing the report, in the Database Expert window, I do not see the option to add Stored Procedure to the report. I can only see Tables and Views. Is there an option to 'turn on' to view Stored Procedures.
Also when create a query using the 'Add Command' option, the query needs a parameter. I create the query with the parameter as ?Param_IN.
It gives me an error 'No value given for one or more required Parameters. There is no 'Parameter List' area where I can add parameters.
Please help.
Also when create a query using the 'Add Command' option, the query needs a parameter. I create the query with the parameter as ?Param_IN.
It gives me an error 'No value given for one or more required Parameters. There is no 'Parameter List' area where I can add parameters.
Please help.