Dynamically generate a new instance of a subreport for every selected parameter

  • Hello.

    I have 2 parameter fields I'm passing through to a sub-report to get it to populate. They are 'Year' (only 1 selected) and 'ID' (multiple selected).

    I'd like to dynamically generate a new instance of the sub-report (aka, template) for each selected parameter.

    For example...

    Let's say the ID's selected are "1,5,13' and the year is '2020'.

    I'd like it to know it needs to create 3 instances of the same sub-report template using the following info:

    1. ID=1, Year=2020
    2. ID=5, Year=2020
    3. ID=13, Year=2020

    How might I configure SSRS to do that?

    Thanks in advance for any help!


  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • You can group you sub report with ID and apply page breaks. This way every ID will be displayed in different pages.

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

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