Parameter missing

Hi,

I was developed the rdl report and i deployed to the server, In my report having the single input parameter When i run the report

asking parameter value and i was gave the value it was generated the report it is working fine.

Then this rdl report bind to the reportviewer control using

Report viwer tasks :

Choose Report : < Server Report>

Server Report Url:http://localhost/reportserver

Report Path : /Sales/Details

then i run the error should shown:

An error has occurred during report processing.

Query execution failed for data set 'Details'.

Procedure 'Usp_Details' expects parameter '@.PId', which was not supplied.

How i pass the parameter value in reportviewer.

Plz any one would help to me.

regards

kumar

First deploy it and go to the IIS and open the Report folder and browse it.You can find your report there.Run that report.If that is working fine so some other problem was there.Do like that way if it is working so the page should work fine.

|||

Hi,

Thanks for your response

I did you told that way it is working fine and i was bind the rdl report to Reportviewer in my webpage then i ran the error should occured

An error has occurred during report processing.

Query execution failed for data set 'Details'.

Procedure 'Usp_Details' expects parameter '@.PId', which was not supplied|||

ptParameters[0] =
new Microsoft.Reporting.WebForms.ReportParameter("ClientId", sessParam );

this.ReportViewer1.ServerReport.SetParameters(RptParameters);
this.ReportViewer1.ServerReport.Refresh();

check this article for more infohttp://www.codeproject.com/sqlrs/ReportViewer2005.asp

|||

It is working fine thanks lot

regards

kumar

sql