We help IT Professionals succeed at work.

Pass Parameter from one SSRS report to the parameter values in a second SSRS report

Gary Harper
Gary Harper asked
on
Can I pass a parameter value from one report to the parameter value of another report?  On the action tab of the field I want them to be able to drilldown on I select the 2nd report and choose the parameters to pass.  However only the dataset fields are available, not the parameter fields on the 2nd report.  Doesn't seem like there is an option to pass one parameter value to another parameter value.  Is this the case or is there something simple I am missing?
Comment
Watch Question

SQL Server Data Dude
BRONZE EXPERT
Most Valuable Expert 2013
Author of the Year 2015
Commented:
<wild guess>  
Have you tried to hit the Expression ( fx ) button, then in the Category treeview in the lower left click Parameters, then double-click on your parameter so it appears up top?

Author

Commented:
Yes.  This is what I was looking for.  Had the wrong syntax in there.  Thanks.
Jim HornSQL Server Data Dude
BRONZE EXPERT
Most Valuable Expert 2013
Author of the Year 2015

Commented:
Thanks for the grade.  Good luck with your project.  -Jim

Explore More ContentExplore courses, solutions, and other research materials related to this topic.