12-01-2021 02:20 PM
Looking for advice on how to implement multiple parameters in a report book. The standard loop functionality does not meet current needs. Our reporting requires a user to specify 3 UD's to report out their area of responsibility. Each user will have multiple sets of 3 UD's to generate all of their reports. In theory, they need to 'loop over' this set of parameters generating reports for each set. However, the standard loop functionality is only 1 parameter and nested loops will generate unnecessary combinations as it would be the cartesian product of all parameters.
Anyone have suggestions on how to implement this? Is there a way to call a BR from the report book to substitute multiple variables at a time?
I envision the ideal state as:
Any suggestions are appreciated.