Multi-detailed report?

  • Thread starter Thread starter Chris
  • Start date Start date
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.
 
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.
 
Back
Top