Post reply

Can you link a Report (that requries parameters) from another report

  • June 2, 2010 at 3:40 pm

    #387070

    I was given a requirement to create a report which can link to another report when clicking on a field. However I'm not sure if I can do this if the 2nd report requires a parameter.

    Basically when someone opens report number 1 and clicks on personname field, they want it to open an existing report we have in another browser which requires that person's id as parameter.

    I'm not sure if this is possible in SSRS report builder? I think it will probably be easier as a subreport.

  • June 2, 2010 at 6:54 pm

    #1175640

    You will just have to build the URL as an expression. Determine what the URL needs to be to pass the parameter (you do know that you can pass parameters through the URL, correct?)

    On the first report, right-click the text box and select "text box properties". Go to the "Action" tab, and change the Hyperlink option to "go to URL". Under "select URL", click the expression builder, and define the URL as an expression.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • June 3, 2010 at 7:57 am

    #1175960

    Thanks Wayne. I didn't know you could pass parameters via URL.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply