How to Pass Parameter Values from Parent Report to Child Report via URL?
I have a Parent Report that has a Parameter ParamColorParent.This Parameter allows multiple section. My requirement is that when I click on 'Detail Report' text in the Parent Report, the Child Report should open up with the values selected for the ParamColorParent in the Parent report. The child Report has a parameter ParamColorChild which can be used to collect the passed values from the Parent. I want to pass these values via URL and not through SSRS default drill functionality.How do I achieve this? Thanks in advance.
August 10th, 2011 12:42am

In the navigate to you can select teh url and then write an expression with the report parameters you want. It is a java script I guess as I did this previously but dont remember the syntax.vineesh1701
Free Windows Admin Tool Kit Click here and download it now
August 10th, 2011 2:38pm

Hi hisxlnc, If you want to navigate to Detail Report from Parent Report with URL, we can set the Action with Go to URL option instead of Go to Report. And then append to the report’s URL with the following syntax: &rc:ParameterName=ParameterValue. More information about Using URL Access Parameters, please see: http://msdn.microsoft.com/en-us/library/ms152835(v=SQL.100).aspx There is also an example in this thread for your reference: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/8d2c0ef5-a434-44cc-bea8-b9b7928adb82 Thanks, Lola Please remember to mark the replies as answers if they help.
August 12th, 2011 6:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics