Skip to Content
0
Former Member
Nov 17, 2012 at 07:41 AM

Duplicate Rows

25 Views

Dear All,

Im working on a simple report as below...

Group 1: Region

Group 2: Area

Group 3: Territory

Detail:

Invoice Date Invoice Qty Invoice Net Invoice Tax Invoice Discount Invoice Gross

2012-05-01 1500 10000.00 100.00 100.00 12000.00

2012-05-02 1000 12000.00 150.00 120.00 12500.00

2012-05-03 1200 11000.00 120.00 120.00 13200.00

I want my report to be displayed as above. but in my case my detail part is not summing up for date as below...

Invoice Date Invoice Qty Invoice Net Invoice Tax Invoice Discount Invoice Gross

2012-05-01 500 2000.00 20.00 20.00 2000.00

2012-05-01 500 2000.00 20.00 20.00 2000.00

2012-05-01 500 2000.00 20.00 20.00 2000.00

2012-05-01 500 2000.00 20.00 20.00 2000.00

2012-05-01 500 2000.00 20.00 20.00 2000.00

2012-05-02 250 3000.00 30.00 30.00 2500.00

2012-05-02 250 3000.00 30.00 30.00 2500.00

2012-05-02 250 3000.00 30.00 30.00 2500.00

2012-05-02 250 3000.00 30.00 30.00 2500.00

2012-05-03 600 5500.00 60.00 60.00 7500.00

2012-05-03 600 5500.00 60.00 60.00 7500.00

how can i sort out this issue?

Thanks in Advance.