Pass query string parameter to SSRS report

Question

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?

Can you clarify it doesn't work? Is the report showing with STUDENT_ID parameter but you still need to press View Report or is the report not showing up at all when you use the STUDENT_ID parameter? — Tak
– Tak, Commented Sep 9, 2014 at 12:54
Ok I got it that to make it work like this I need to use a different URL which is http://<your server>/ReportServer?/<folder>/<reportname>&STUDENT_ID=5 — Frank Martin
– Frank Martin, Commented Sep 9, 2014 at 14:12

Frank Martin · Accepted Answer · 2014-09-10 06:55:44Z

4

Using the following URL worked.

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

answered Sep 10, 2014 at 6:55

Frank Martin

3,46916 gold badges55 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

RichardD Over a year ago

http://<your server>/ReportServer/ throws a 404 for me. Is there an option we need to enable on the server?

Frank Martin Over a year ago

Did you also write folder name and complete report name at the end?

RichardD Over a year ago

Thanks Frank. I did, with and without URL encoding as the folder path contains slashes and the report name contains white space.

Frank Martin Over a year ago

@RichardD So is it fixed?

RichardD Over a year ago

Sadly not. 404 every time. The "ReportServer" routing must not be installed/configured on our install of SSRS.

Steven Farkas · Accepted Answer · 2021-12-21 18:59:00Z

0

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

answered Dec 21, 2021 at 18:59

Steven Farkas

1

Collectives™ on Stack Overflow

Pass query string parameter to SSRS report

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related