Summarizing records in a subreport

[goodguy]

I have the following tables in my database:
Customers -> Orders -> OrderItems -> Items -> Components -> Parts -> Specifications -> Costs, each linked to the next in a 1-M relationship with appropriate FKs.

I have designed a report which displays the records for each order from all 8 tables in a grouped and nicely stepped format right up to specs and costs. But in order for it to make sense to the user, I also need to show summary data on a separate subreport for the total requirement per order of each material in specs. This too I have managed to do nicely enough.



Where I am getting stuck is trying to make a second subreport which will show ALL requirements in detail per order and per item but WITHOUT the components and parts levels. If I exclude these immediate levels, all I get is a totals of each spec whereas I need to show each detail.

Any help will be appreciated.

[June7]

You want Specs and Costs without Components and Parts? Would that output make sense?

[goodguy]

No, I mean I want to show the detail records for specs and costs at Grouping Level 1 and 2, whereas Components and Parts are at Grouping Levels 3 and 4.
Hope that makes sense.

[goodguy]

Any help will be appreciated.

[June7]

Maybe understand. The query has to include Components and Parts because that's how the linking is set up. Just don't show the Components and Parts fields in the report and set report grouping at the higher levels. How does that look?

[goodguy]

Yes, I suspected that. Thanks for the pointer, I will try it out and revert if it fails.