Crystal Report - Data Display Problem

[Rupesh Kumar]

Hi Guys,

I'm using latest version or Crystal Report (CR) and i have to display an
item in following format

Report 1:
======================================
Item Name Quantity1 Quantity2 Quantity3
======================================
Apple 48 45 05
08 08 02
02

Banana 20 15 02
07 07 00
======================================

If you follow closely (for Apple)
Row1 = Quantity1 = 48, Quantity2 = 45 and Quantity3 = 5
Row2 = Quantity1 = 08 (48-45+5), Quantity2 = 08 and Quantity3 = 2
Row3 = Quantity1 = 02 (8-8+2), Quantity2 = and Quantity3 =

When i try to display above data, it displays perfectely all records are
store in database, but in actual senario i want to display

Report2:
======================================
Item Name Quantity1 Quantity2 Quantity3
======================================
Apple 48 08 02

Banana 20 07 00
======================================
Apple = 48 (First row of Quantity 1), 08 (last row of Quantity 2), 02 (Last
row of Quantity 3),
similarly for
Banana = 20 (First row of Quantity 1), 07 (last row of Quantity 2), 00 (Last
row of Quantity 3),

Could anyone help me how can i display Report2. I'll really appriciate.

Thanking you,

Rupesh Kumar