Rendering report from URL

[ChuckG]

Hi,

We're just getting started with SQL Reporting Service, and we've run into a snag.

We have a report that's we designed. If I go into the properties and to the Parameters, if I set it to no default value and to Hide the user prompt, it does not seem to accept the parameter that I'm passing it via URL.
I get an error of "The 'CO_NUMBER_P' parameter is missing a value"

If I turn Hide off, and manually key the data, it pulls the report fine.

Here's the URL I'm passing to it.

http://server1/Reports/Pages/Report...&rs:Command=Render&CO_NUMBER_P=EO030207-00076

Was wondering if anyone had any quick tips on getting this working. BTW this is SQL 2005 Reporting Service.

Thanks
Chuck

 

[paulkeys]

Not sure if it's what you've intended (as this site displays ampersand signs as &amp), but try using just the ampersand sign, and try removing the semi-colon also.

Hope this helps

 

[ChuckG]

No I just put Ampersand, no semi-colon nor the word amp.

 

[ChuckG]

Found the problem. The original programmer who was trying to pull this, was using REPORT.ASPX instead of REPORTVIEWER.ASPX

Switched it around to the correct ASPX file and it's working correctly now.

 

[sudhirjangir]

http://192.168.1.22/Reports/Pages/R...es&rs:Command=Render&manufacturer=Mac

its not working for me. Any clue please urgently

 

[sudhirjangir]

Following works:

List<ReportParameter> paramList = new List<ReportParameter>();
paramList.Add(new ReportParameter("manufacturer", "Sudhir", true));
paramList.Add(new ReportParameter("startDate", "1-1-2007", true));
paramList.Add(new ReportParameter("endDate", "1-1-2009", true));
ReportViewer1.ServerReport.SetParameters(paramList);