How to run multiple parameters per Loop in a Report Book?

db_pdx
Contributor III

Hi all:

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.

Example:

db_pdx_0-1638385918424.png

 

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:

  • User populates a simple CSV file with their report sets consisting of a name, UD2, UD3, UD4, and owner
  • User opens the report book
  • User selects their report set CSV file
  • The report book loops over each set (of multiple parameters) generating any # of reports using these parameters

Any suggestions are appreciated.

Thanks,

Dave

0 REPLIES 0