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

Posted on 2012-08-16
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
    LVL 65

    Accepted Solution

    <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
    Yes.  This is what I was looking for.  Had the wrong syntax in there.  Thanks.
    LVL 65

    Expert Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
    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 …
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now