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

0
votes

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?

2
reporting-servicesssrs-2014
I guess you are trying to access your reports from Report Manager , try from report server instead, and then pass on the values, same, as you have tried so far. – Irf
What browser are you using? (Chrome will render blank, IE will work). If you are in Chrome, you can confirm by running it, and exporting to a file once run. If file has data then it's a browser issue. – GandRalph
@GandRalph, I'm not using Chrome, running on IE. Still doesn't work. – LearnCodeFun
@Irf, I'm using report server. – LearnCodeFun
So when you hit the export button and save the report to Excel for example, the excel doc is empty? (Confirming there is indeed no data) – GandRalph

2 Answers

1
votes

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.

0
votes

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

Here goes the report server:

report server

and below goes the Report Manager..

Report Manager

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

VS Data Tools

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!