Looping list for a single parameter

rosscr

I am trying to run a report for individual labor assignments. One report with a parameter of the workers' name that gets populated from a list of names so that each worker has a report personalized for their assignments. That is, the report is run as many times as there are workers, with a new name automatically populating the name parameter.

johnw

What you can do is create a parameter that will contain a comma seperated list of names or ID's. Then, you use a Scripted Data Set and in the Open even, read in that parameter, and use a split method to split those ID's into an array, an iterate over the array in the fetch method. Drop that data set into a report, and have a sub-table with the actual labor assignments.

There is an example of using sub-table if you go to Window/Show View/Report Design/Report Designs. It will show you how to bind a table to another table.