Print report from multiple tables

[DukeS]

Hi!

I have one table company and related tables employees, computers, vehicles, etc.

I know how to create report to show data separately for each table for example computers:

Company name

Computers

- Computer 1

- Computer 2

...

How can I create report that show all the data for one company like:

Company name

Employees

- Employee 1

- Employee 2

...

Computers

- Computer 1

- Computer 2

...

Vehicles

...

Thanks

[-Queue-]

I think the easiest way to do this is use an additional table and import all the desired records from the other tables (employees, computers, vehicles, etc.) Then you can sort and summarize by Company and Category (table type), print your report, and delete all records from the additional table. You could, of course, use multiple portals or multiple fields to hold different ValueListItem results instead, but I think it's easier and cleaner to use a 'holding' table instead.