Create crystal report according to a specific order

[Niki_S]

I have my crystal report like this.

Code    Value    Quantity   HS
VTM     10       450        600.02
SGL     20       100        600.02

Code    Value    Quantity   HS
FMF     1        250        20.34
FMF     50       200        20.34
FMF     20       250        20.34

Code    Value    Quantity   HS
FMA     20       20         545
FMA     45       100        545

Code    Value    Quantity   HS
VTM     10       100        120.80
SGL     20       200        120.80
GTM     30       300        120.80

I need it to be like this.

[b]FMA[/b]
Code    Value    Quantity   HS
FMA     20       20         545
FMA     45       100        545
                 [b]120[/b]
[b]Total            120[/b]

[b]FMF[/b]
Code    Value    Quantity   HS
FMF     1        250        20.34
FMF     50       200        20.34
FMF     20       250        20.34
                [b]700[/b]
[b]Total            700[/b]

[b]VTM/SGL/GTM[/b]
Code    Value    Quantity   HS
VTM     10       100        120.80
SGL     20       200        120.80
GTM     30       300        120.80
                 [b]600[/b]

Code    Value    Quantity   HS
VTM     10       450        600.02
SGL     20       100        600.02
                 [b]550[/b]
[b]
Total            1150[/b]

How can I make my format as above?
Thank you.

 

[kray4660]

You can group by specified order. That is the only way I know how to do it. There is a lot of information on the web on how to do it.