Crystal Reports and Components

[fuzzie bear]

I'm currently writing a report in Crystal so I can export products to feeds.

My report looks like the following for non component products:

Main Section | Subsection | Subsection (product) |Size | Price
Dogs | Dog Collars | Crystal Collar Pink | | 7.99

For component products I want to see :
Main Section | Subsection | Subsection (product) | Size | Price
Dogs | Dog Collars | Crystal Collar Blue |32cm (P) | 29.99
Dogs | Dog Collars | Crystal Collar Blue |37cm (P) | 39.99
Dogs | Dog Collars | Crystal Collar Blue |42cm (P) | 45.99

The report works fine for products that don't have components, however when I start querying components I'm not just getting one row back from a query, but...
1 row for Component name, 1 row for selection, rows for sizes, rows for prices

So for a product with 3 size choices, I'm getting 8 rows of data back when I join the table on "Product Reference"

eg...

Product Ref | nType | nValue1 |sString1 |
1915 |5 |1 |Customer Selection |
1915 |6 |0 |Size|
1915 |7 |0 |32cm (P)(T15793) - €29.99|
1915 |7 |0 |37cm (P)(T15803) - €39.99|
1915 |7 |0 |42cm (P)(T15813) - €45.99|
1915 |8 |2479 |139037:139038 |
1915 |8 |3305 |139037:139039 |
1915 |8 |3801 |139037:139040 |

So, is it possible to merge the two rows of data - the one for the size (sString1) with the one with the price (nValue1)

Not sure if this even makes any sense to anyone...