Dear People,

I have doubt regarding group expert in crystal report 2008.

Our scenario:

We have designed a layout in crystal reports 2008 for SAP.
This layout is printed on preprinted paper.

The logic of this report is to fetch the itemcode,itemname,quantity,price from one table.The table will duplicate the records since the quantity is different.

for Ex:

Itemcode Itemname Quantity price

101        plastic     4      100
102        plastic     5      100

If i am using command report i will directly add the group by command and sum the quantity in sql query,so there are no more duplicate records.and the result will be:
Itemcode Itemname Quantity price

101        plastic     9      100

But,this layout is designed by just linking the tables.
Its not done through 'Add Command'.So, i need to use 'Group expert',but i don't know how to use the group expert to arrive my result.

Please guide me and remember that 'using the group expert' should not change the alignment of layout.