Post reply

Dynamically changing parameters in the linked report

  • May 11, 2015 at 8:26 am

    #300444

    I want to know how to change the parameters of the linked report and still they are dynamic. Here is an example, the actual report has a date parameter that is set to populate first day of the month dynamically. I create a linked report and now I want that date parameter to populate first day of the week dynamically.Can you please help me on how to do this in SSRS with out redeploying the main report.

    Thanks.

  • May 11, 2015 at 9:33 am

    #1796990

    The best way would be to have a second parameter that allows the user to specify what they want (first day of the month, week, etc) then have the next parameter get the first day of the week, month, etc based on the first parameter. That's how I'd do it.

    "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

    -- Itzik Ben-Gan 2001

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

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