Pass parameters to stored procedure in report
Posted: Fri Mar 09, 2012 3:55 pm
I have been trying to programmatically pass the parameters to the report for weeks now with no success.
Every way under the sun has been tried and I still get this error, Procedure or function 'CONTACT_MAILINGLABEL' expects parameter '@GROUP_ID', which was not supplied. I am passing them this way.
report.CompiledReport.DataSources("CONTACT_MAILINGLABEL").Parameters(p).ParameterValue = Request.QueryString(qp)
Parameters for all of my reports are generated on-the-fly databases. This report works in Crystal Reports when passing programmatically and was not imported.
Any help would be appreciated.
Every way under the sun has been tried and I still get this error, Procedure or function 'CONTACT_MAILINGLABEL' expects parameter '@GROUP_ID', which was not supplied. I am passing them this way.
report.CompiledReport.DataSources("CONTACT_MAILINGLABEL").Parameters(p).ParameterValue = Request.QueryString(qp)
Parameters for all of my reports are generated on-the-fly databases. This report works in Crystal Reports when passing programmatically and was not imported.
Any help would be appreciated.