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

• mortenburg

  SSC Enthusiast

  Points: 112

  More actions

  July 19, 2023 at 8:50 pm

  #4239488

  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!

  Mitch

• Site Owners

  SSC Guru

  Points: 80318

  More actions

  July 20, 2023 at 9:10 pm

  #4240394

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

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

• Sezam

  Ten Centuries

  Points: 1232

  More actions

  August 15, 2023 at 7:07 am

  #4261510

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