Friday, March 23, 2012

Problem in calling SQL Server Report through URL

I called a sql server report from asp.net using the following URL

http://phx-ps01/Reports/Pages/Report.aspx?ItemPath=%2fISTEPS_REPORT%2fEQAPCompleteActionsPHX&rs:Parameters=false&rno=" & a &"'

I passed one report parameter whhich is "a".

Report is called correctly, but the problem is parameter is not passed to the report and also parameter bar is visible on the tool bar in the report.

Is there any help that parameter value is passed correctly and parameter option is not displayed on the tool bar of the report.

Hope for the best.

Thanks in advance.

Hello,

To pass paramter to server report use the following code

List<ReportParameter> ReportParamters = new List<ReportParameter>();

ReportParameter paramA = new ReportParameter("a", "test");
ReportParamters.Add(paramA);

rptViewer.ServerReport.SetParameters(ReportParamters);
rptViewer.ServerReport.Refresh();

No comments:

Post a Comment