CODEWITHSUNDEEP
reporting-servicessql-server-2012parameter-passingreportviewerssrs-2012
Frank Martin
Frank Martin

Reputation: 3441

Pass query string parameter to SSRS report

I have made a report in SSRS (SQL Server 2012) that takes one parameter called "STUDENT_ID". This report is deployed on report server and is working fine. My report URL is something like:

http://myserver/Reports/Pages/Report.aspx?ItemPath=%2fExportReport%2fStudentReport

So when I open the above URL in browser, it asks for STUDENT_ID, which I enter and press "View Report" and report is displayed. Is there are way to pass STUDENT_ID parameter directly to report rather than it first asking? For e.g. something like below:

http://myserver/Reports/Pages/Report.aspx?ItemPath=%2fExportReport%2fStudentReport&STUDENT_ID=5

I tried but it doesn't work. Any ideas?

Upvotes: 4

Views: 5344

Answers (2)

Steven Farkas
Steven Farkas

Reputation: 1

In the SSRS 20216 Report Manager, I had to set the parameter in my report (e.g., p0453_RefNo) to hidden. Afterwards, I was able to pass values to the RDL via URL. The name of the RDL file is rpt045_EP6_Complaints. There was no need to include the .rdl file extension. Parameter name is case sensitive. For example:

http://redacted/Reports/report/redacted/rpt045_EP6_Complaints?p0453_RefNo=0612400

Upvotes: 0

Frank Martin
Frank Martin

Reputation: 3441

Using the following URL worked.

http://<your server>/ReportServer?/<folder>/<reportname>&STUDENT_ID=5

Upvotes: 4

Related Questions