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