Running SSRS Report by passing parameters in the URL doesn't show any result of the report

Question

I'm trying to run an SSRS report on the server which takes a parameter as input. When I enter input in the textbox it displays the result. Also works fine in the visual studio BIDS. But, I want to pass parameter in the URL and see the report result which is not working.

I have seen solutions to other similar SO posts SSRS passing Report Parameters which mentioned checking the dataset parameters properties. My parameter name is @TestId and value is set to =Parameters!TestId.Value So, it is correct as suggested in the solution.

Now I try o access my report using URL patterns as below

Just giving parameter and value http://testssrs14/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fTest%2fTestReport%2fTest+Report&TestId=1234

using command = render http://testssrs/Reports/Pages/Report.aspx?ItemPath=%2fReports%2fTest%2fTestReport%2fTest+Report&rs:Command=Render&TestId=1234

when I hit enter it doesn't throw any error in both cases but just shows a blank page instead of the result of the report. Is there anything I'm missing?

Answer 1

Based on your comments, Here's some detail.. though I guess it must be figured out as of now..

Here goes the report server:

and below goes the Report Manager..

and in VS Data Tools or BIDS, the same is set as in Projects->Properties below

So, you got to try your URL parameters in ReportServer, not in Report Manager. What you had been accessing so far is Report Manager..

Hope it makes some sense, now : ) ,

Thus, your link should be something like http://testssrs14/Reportserver/..

This link is also a good source!

Answer 2

Please use this URL instead and try

 http://testssrs14/ReportServer/

And navigate to the report that you're looking for.

When you get to the report page, then pass the parameter value.

&<Parameter Name> = <value>

In your case

&TestId=1234

Add this at the end of the URL.

Let me know if you need any further clarification.