On the first report you will need to decide where you want your user to click to pull up the second report. In our example here, we have a reservation list. We will be clicking on the Customer Name to get more details about that customer.
Next, we will go to the text box properties and then the Action tab. Select ‘Go to URL’ and then click on the expression button.
Here is where the magic happens. Using SSRS URL Access, we will send commands to the report server and pull up the second report.
Here is the code we will use for our reports.
&CustomerID="& Fields!CustomerID.Value &"
','CustomerDetailsWindow','left=370,top=180,width=940,height=300,status=no,menubar=no,scrollbars=no,location=yes'" & ")"
The first line uses a global variable to populate the report server URL and report viewer. The second line puts in a report folder value, and specifies a report name. Our pop up report is called ‘Customer Details.rdl’, but as you can see here we just specify the report name without the .rdl at the end. We will also pass in a parameter option of ‘Parameters=False’ on the second line. This will turn off the parameter drop down box on the controls. We don’t want our report to give the option of selecting a different customer. If you need to pass more than one parameter, simply copy the third line and paste the copy below line three and modify with the new parameter values. In our example, the third line specifies the parameter name (CustomerID) on the second report, and the value from the main report. For this report, we will be passing in (Fields!CustomerID.Value). Finally, on the last line we specify some additional properties that we want the pop up window to have such as the width and height.
We only use one URL parameter value (Parameters=False) in our example. However, there are quite a few more that can help customize your secondary report window. To find more information about parameter values, follow this link:
Here is a screenshot of our final solution. When we click on the Customer Name, we get a second report with additional customer information.
More information on using SSRS URL Access can be found here:
Thank you Rashid. 🙂
Please provide some more examples like this.
WOW!! i’ve been trying to resolve this issue for quite a while…thank you thank you thank you for such a detailed and well-written instructional. i’m only 9 months into my SQL/SSRS career and i understood everything perfectly, and i got it to work! you, sir, are a Guru!!! 🙂
Can we move the parameters drop down box inside the report? I need to have a rop down list box just liek the prompt to create a dash board.
I have tried above example but its working fine on local machine but its not working when i send the paramters in url it does not open new report on client server.How to solve it.
gracias, siempre estaba buscando algo asi, por fin lo encontre, tengo otra pregunta, yo puedo crear algun grafico y que este contenga movimiento…