I have a drill down report in ssrs. Trying to pass the value of a parameter from parent report to child. Now in child report i already have a set of available values for that parameter. What i am trying to achieve is, when the child report loads the default value should be the one I am passing from the parent report and the report data should get loaded based on that and after the initial load the user can select form the drop down and refresh the report. For me the problem is when the child report is getting loaded its not taking the value of the parameter passed from the parent report. Kindly help. Thanks.
2 Answers
0
votes
I've set up a dummy report that does what you asked for and found that SSRS will just not work - not give an error at all - if you don't have it exactly right.
Here are the steps I followed to make it work.
- Create the parameter on the parent report and ensure it is set and that you are setting it either at run time or via default.
- Ensure that the parameter you want to SET exists in the child report and has NO default value (this may not be necessary, but will help with debugging if it goes wrong)
- Make sure the child report parameter has the the available values for your drop down set and that the one you are passing is there
- Set up the drill through using the action section of the properties and Go to report
- Specify the drill through report
- Choose the parameter from the Name drop down (the available parameters in the child report WILL be there) and set the Value to [@ParameterName]
- Test
If you don't want a parameter on the parent report and just want to hard code the value you can skip step 1 and change step 6 to just use the value.
