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.
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:
- ID=1, Year=2020
- ID=5, Year=2020
- ID=13, Year=2020
How might I configure SSRS to do that?
Thanks in advance for any help!