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