I am working on designing a Crystal Report that is derived from an existing report.  The original report would search for planned or released purchase orders for type "D" parts in MAX within a timeframe specified by the user when the report is run (typically 3 months).  This report would group the results by part number, and show only the group headers, containing the part number, part description, and two cacluated fields, one showing a total demand for each part, and the other being a monthly average for each part.  The report I'm deriving from this first one is intended to print labels for storage locations, to better aid inventory control.  The user requesting the report print labels with just the part number and description from a generic list of type d parts, formatting the details section in multiple columns.  They would like a report utilizing the information of the first report, and the format of the second.  Here is the intended format:

 

Part 1 Tot.Qty.P1              Part 2   Tot.QtyP2

Desc1  Avg.Qty.P1            Desc2   Avg.Qty.P2

 

I understand that groups can be formatted in multiple columns, but prior attempts have yielded duplicate data (that is, Part 1 in the example above appears in both columns, with Part 2 in the next row, etc.).

 

Any thoughts on how to achieve the result I'm looking for?

 

Thanks in advance.