APEX

I need to know how to NOT show the report total line when using the sum functionality with a break in a report.

I am summing two columns, a debit amount and credit amount. I am breaking on the first column which is the level of a hierarchical query. I want to see something like this:

Parent Record xxxxxxxxxxxxxx
Parent Sum $$ $$

Child Record xxxxxxxxxxxxxx
Child Record xxxxxxxxxxxxxx
Child Sum $$ $$

However, when I run the report, I also get a report total line under the child sum which is really meaningless for this report.

I have also tried creating this report as an interactive report. When applying the sum on the two columns, I do get the sum totals on the break only - no report total - however, it is reversing the order of the hierarchical query results putting the child records first and the parent records second.

Thanks in advance for your help.