SQL Server Performance Forum – Threads Archive

Parameter problem

Hi all, I am trying to pass some parameter through URL. Here’s what i did.
First I created a query with parameter, for example: Select * from customer where id = @id then before i load the page in asp.net i apply the code below
<code>
ReportViewer1.ServerUrl = "http://localhost/reportserver?/Report Project1/report1&rs:Command=Render&id=7"
<code> An error has occur.
<error>
Reporting Services Error An attempt was made to set a report parameter ‘ID’ that is not defined in this report. (rsUnknownReportParameter) Get Online Help
<error> Is this the right way to pass parameter through URL… Thanks,
Henry

---

]]>