Enter Query String Parameter in SSRS Report

I made a report in SSRS (SQL Server 2012) that takes one parameter called "STUDENT_ID". This report is deployed to the report server and works fine. My report url is something like this:

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

      

So when I open the above URL in my browser, it asks for the STUDENT_ID that I entered and click View Report and the report is displayed. Is there a way to pass the STUDENT_ID parameter directly to the report instead of asking first? Ex. something like below:

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

      

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

+3


source to share


1 answer


Using the following url.



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

      

+4


source







All Articles