[RESOLVED] Subreport within a subreport?

[bmahler]

Ok, I am running CR9 and I have a problem. I am making an invoice and within this invoice are Instruments and each instrument can have multiple line items.
I made the report like so

Main Report -Invoice

Details a -Calibration Subreport
Subreport Details a -Instruments
Subreport Details b -LineItems This is the problem

Details b -Repairs Subreport
Subreport Details a -Instruments
Subreport Details b -Line Items This is the problem

The problem I am running into is that when an Instrument has Multiple line items, It repeats the Instrument for each line item. The only way that i know how to solve this is to have a subreport containing all the line ites, however, I can't seem to place a subreport within a subreport. Does anyone have any suggestions at all on this one, because I am stumped at this point.

Thanks for any help.

[brucevde]

Based on your post it looks like you have 6 sub-reports. You probably only need 2.

Do you use Grouping at all? That would help to eliminate the repitition of records?

What are the links between Calibration, Instruments and Line Items? As well as Repairs, Instruments and Line Items?

[bmahler]

I only use 2 subreports the Instruments and line items are just detail sections of the 2 subreports. I do use grouping. I have actually solved this issue using shared variables and checking records, but thanks for your help.