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

Posted on 2012-08-16
Medium Priority
Last Modified: 2012-08-16
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?
Question by:Gary Harper
  • 2
LVL 66

Accepted Solution

Jim Horn earned 1200 total points
ID: 38302013
<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 Comment

by:Gary Harper
ID: 38302273
Yes.  This is what I was looking for.  Had the wrong syntax in there.  Thanks.
LVL 66

Expert Comment

by:Jim Horn
ID: 38302289
Thanks for the grade.  Good luck with your project.  -Jim

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this short article I will be talking about two functions in the SQL Server Reporting Services (SSRS) function stack.  Those functions are IIF() and Switch().  And I'll be showing you how easy it is to add an Else part to the Switch function. T…
Hi All, I am here to write a simple article to move SSRS (SQL Server Reporting Services) reports from one server to another. When I have faced the same issue to move reports those were developed by developer on development server and now need to …
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Suggested Courses
Course of the Month16 days, 15 hours left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question