Linking Reports in Crystal 8.5

[cis12232004]

I have a report that generates the inventory items that are on order and I want to link this inventory report with another report that generates the usage for each inventory item that the company uses. My question is, how do I integrate the two reports without losing any data since there are items in the usage analysis report that will not have any items on order but I still want these items to show. I'm using Solomon 5.5 to generate/display the crystal reports.

Thanks for ANY help I can get..............

 

[cis12232004]

Fields for the @Inventory formula in the subreport report are:

Transform({PurOrdDet.InvtId}, RIPARAM( "SegInvenMask" )) + " " + {Inventory.Descr}


Fields for @Inventory formula in the main report are:

Inventory

Trim( Transform({vr_10630.InvtID}, RIPARAM( "SegInvenMask" ))) + " " + {vr_10630.Descr}

So in linking all the data from these two reports, I want like IDs to be grouped together and the others to fall in lline sequentially. For e.g. if there is a 100 number in both reports I want the data from both to be together and if 200 does not have any data in the subreport, I want that to fall under the 100 number with whatever information is in the main report for that ID.

 

[cis12232004]

Jcfx, I thought I should use that because that is what the fields are made up of on the report and because it provided some commonality between the two reports. And, yes, your example portrays a good example of what I want these reports to do.