Master Detail Reports - subreports or groups?

[2005 IR Help]

By: dhm - dmoore75

Master Detail Reports - subreports or groups?

2004-02-10 13:43

I am looking for some opinions....

 

I am writing a test report with employee (master) / address (detail) records based on iReport's Sub-Report tutorial for iReport.

 

However, I want to use custom data sources instead of SQL for data access. After some research and experimentation, I think I know how I can do it using sub reports.

 

Are sub reports using custom data sources the best way to do master / detail reporting?

 

Or is it better to have a single report with a single custom data source (containing both employee and address data) where the report has an "ID" header, and address data is printed in the "ID" footer?

 

By the way, here is the Database Schema.

 

Employee

ID integer

first-name char(30)

last-name char(30)

 

Address

ID integer

Street char(30)

City char(30)

State char(10)

Country char(30)

Postal Code char(30)

 

Each employee can have 0 or more address

 

Thanks