One report layout multiple report instances

[Christine]

I am trying to create a report layout that when run it will create an
individual report for each summary type. For instance, I have inventories
and I would like a separate report (not just page) for each inventory but I
only want to run the report once and have it create each report.

 

[Klatuu]

You don't say whether each inventory is in the same table or if there is a
different table for each inventory. That will make a difference.
Assuming you have done your database design correctly and all the
inventories are in the same table, and you have a specific field you will
filter on for each report. You can set up a control loop that will print a
report for each.
One way would be to create an array of the values to filter on. Then use a
For Next loop to read through the array and print a report for each entry in
the arry using the value in the current array element to establish the Where
argument for the OpenReport method.

 

[Christine]

Thanks - my inventories are in one table. I haven't used the control loop
before so I'll do some research and experimenting.

 

[Klatuu]

It is just a For Next loop.

Thanks - my inventories are in one table. I haven't used the control loop
before so I'll do some research and experimenting.