Search code examples
sql-server-2008reporting-servicesssrs-2008

Passing a dynamic parameter through URL in SSRS

I have two reports, the first one passes two parameters through the second report which works fine when using 'Go to Report'

However I need to use 'Go to URL' as I need to be able to control the Zoom.

The problem is, I also need to pass the 2 parameters through the URL.

These Parameters are @Reason1 and @Reason2.

I have tried using the following:

http://servername/ReportServer/Pages/ReportViewer.aspxnameofmyreportpart&rs:Command=Render&Reason1=@Reason1&Reason2=@Reason2

But then it hard codes @Reason1 and @Reason2 as the values of my Reason1/Reason2 parameter value box's which obviously yields no results.

How do I structure the URL to receive the 2 parameters from the selection made in the previous report.

Solution

  • Why are you not calling the sub report as an action and adding the parameters? It seems like you are trying to make the URL do an action that is already built into the code. Is there a specific reason?

    If you had to I would use the expression but I may build the url first and verify you could copy and paste it and it would work. Call the WebService:

    ="http:// (ServerName)/ReportServer/(pathtoreport)&(ParameterName)=" + Parameters!(ParameterName).Value + "&(ParameterName2)=" + Parameters!(ParameterName).Value