I want to build a report that is based on a master table and five (5) detail tables and is grouped by one field on the master table.
The report is ok and shows the right data, but I have a problem:
all the records of the master and five detail tables are in the same row, and the width of the report is huge.
It's possible to have the records of the master table and the five detail tables in separate rows?
Example:
master record
detail 1 records
detail 2 records
detail 3 records
detail 4 records
detail 5 records
master record
detail 1 records
detail 2 records
detail 3 records
detail 4 records
detail 5 records
(....)
Thank you.