three levels of detail

[Al Wagner]

I really need help on this, I've been trying to get help
in the reports group, but cannot get a response.

I'm writing a report with 3 cascading levels of
information; from a group to orders to parts in the order.
The parts are in a subreport. All works, but I'd like to
hide the order labels (in a row above the data) when there
are no parts under the preceding record. In this way, each
order will stack underneath its headings, like the part
subreport format.

If I have a new order, I want to repeat the label if the
previous order had parts (underneath in the subreport),
otherwise I do not want to repeat the label.

Here's
how the data should look:

Net Start (top level)
000205000 1/1/04

Order (next level)
000504231
000642385
Part (subreport level)
23232323

Order
000589898

Net
000206000

Order (grouped, labels not repeated)
000569694
000696985
000489654
000358654
Part
23589
56879

Order
000569874

What I get is like this:

Net Start (top level)
000205000 1/1/04

Order (next level)
000504231

Order
000642385
Part (subreport level)
23232323

Order
000589898

Net
000206000

Order (Orders not grouped)
000569694

Order
000696985

Order
000489654

Order
000358654
Part
23589
56879

Order
000569874