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.