i had create a report to show out the date and the sale amount.
if the day don't have any sale (sales = 0), report will suppress the date.

but i found out that the amount show out not fulfill my request.

the example report currently show out as below:

Date                            Net Sales Value
27/10/2009                    29.00
28/10/2009                  100.00
28/10/2009                    20.00
30/10/2009                  100.00
                             _____________
                  Total :         249.00
                             _____________

but actually what i need as below:

Date                            Net Sales Value
27/10/2009                    29.00
28/10/2009                  120.00   <-- sum the total of the date
30/10/2009                  100.00
                             _____________
                  Total :         249.00
                             _____________

may i know how to do it?
anyone know how to do this?
please advice.
Thank you...