Multi-detailed report?

C

Chris

I need to produce a report that summarizes disparate information; the first
part of the report needs to summarize customers, the second part needs to
summarize parts, the third part needs to summarize services, etc. Simplified
sample:

ABC COMPANY
SALES SUMMARY FOR OCTOBER 2002

Customer Summary
Customer Orders Sales
Jones, Robert 5 $442.00
Smith, Jack 3 $728.00
....

Parts Summary
Part Qty Sales
Whatnot 562 $653.32
Widget 32 $1005.89
....

Service Summary
Service Hrs Sales
Dry 54 $348.12
Wash 32 $529.78
....

The way I see it, each part of the report is its own Detail section. Can a
report have multiple Detail sections? If not, what are the alternatives?
Worst case, I suppose I could create X different reports and have them all
print (on separate pages) when the user selects this summary report. Yuck.
 
S

Shelley

Couldn't you just create the Customer Summary as the main
report and then have two sub-reports (one for parts, one
for service)? The key would be that the sub-reports have
nothing in the Link Child Fields and Link Master Fields
properties.
 
Top