rsUnknownReportParameter

I created a report from VS.Net with 2 parameters (@.site_id and @.year) supplied to the stored procedure, I can preview the report fine w/i VS.net and can also run it from Report Manager. However, when try to run the report using ReportViewer control (the control came with SQL Server Reporting Services CD), it keeps coming back with an error 'An attempt was made to set a report parameter 'site_id' that is not defined in this report. (rsUnknownReportParameter) '. Here is what I had defined in then ReportViewer when trying to run ReportPath=/Site_Portal_Rpts/report1&site_id=10065@.year=0&rc:Parameters=false, ServerURL=http://localhost/reportserver
Can you please tell me what I am missing? On the same token, I created another report with supplying only 1 parameter to the stored proc and it works fine.
Your input will greatly appreciated> I created a report from VS.Net with 2 parameters (@.site_id and @.year) supplied
[cut]
>not defined in this report. (rsUnknownReportParameter) '. Here is what I had
>defined in then ReportViewer when trying to run
>ReportPath=/Site_Portal_Rpts/report1&site_id=10065@.year=0&rc:Parameters=fals
>e, ServerURL=http://localhost/reportserver
I think parameter name in URL is not correct... the parameter is "@.site_id" and not "site_id" so the I think the correct URL is
ReportPath=/Site_Portal_Rpts/report1&@.site_id=10065@.year=0&rc:Parameters=false, ServerURL=http://localhost/reportserver
HTH M.rkino
--
Marco Barzaghi - [MVP-MCP]
http://mvp.support.microsoft.com - http://italy.mvps.org
UGIDotNet - User Group Italiano .NET, http://www.ugidotnet.org
Read my WebLog: http://www.ugidotnet.org/436.blog