Skip to Content
0
Former Member
Jan 13, 2011 at 02:38 PM

Grouping of data

19 Views

I have the following data, there are 2 line for invoice INV1.

Invoice Number      Invoice Line  Invoice Date Start    Invoice End Date     Quantity    Price
INV1                        001              1/1/2010            2/1/2010        100        1.5
INV1                        002              2/1/2010            2/1/2010        200        2.5

But When I use group by in Crystal Report,it will show in this way:
    Invoice Number      Invoice Line  Invoice Date Start    Invoice End Date     Quantity    Price
INV1 
     INV1                    001              1/1/2010           2/1/2010        100        1.5
     INV1                    002              2/1/2010           2/1/2010        200        2.5
                                                                                300        4.0

But I wish not to display the grouping header "INV1" and display 2 lines, and the subtotal in the bottom.

In crystal report I would like to group it into showing only one line as following. Invoice Number, Invoice Line, Invoice Date Start, Invoice End Date will take the first line of data whereas, Quantity and price is a sum of two line.

Invoice Number      Invoice Line  Invoice Date Start    Invoice End Date     Quantity    Price
INV1                        001         1/1/2010                   2/1/2010      300        4

Would it be possible to do it? Thanks in advance

Edited by: Renee123 on Jan 13, 2011 3:48 PM