I am working on a bill that is a series of subreports. Most of the tables have an override field. For example FlowCost, FlowOverride, SewerCost, SewerOverride. The first person that wrote the report did not take into account the override fields. So my problem is that I have a report that I'm using uses NVL (FlowOverride,flowCost). and I can sum all of the cost for one subreport. The problem is that there are more number that I need and then be able to sum them all up into a grand total.
First subreport vvvvvv vvvvvvvv vvvvvvv
xxxxx xxxxxxx xxxxxx
YYYYY YYYYYYY YYYYYYY
Total ZZZZZ ZZZZZZ ZZZZZZZ
Second subreport aaaaaa aaaaaa aaaaaaa
bbbbbb bbbbbb bbbbbbb
cccccccc cccccccc ccccccccc
Total dddddd ddddddd ddddddd
Grand Total FFFFFF FFFFFFFF FFFFFFFF
Thank you.