I created a report that groups the three column of a Table under one Category and one Detail, e.g.,
Now I'd like to add a single line to the bottom the totals everything, e.g.,
What's the best way to do this? I can't add "TOTAL DUE..." to my table because I want "$460" to be on the same line. When I add "TOTAL DUE..." to the Page Footer it winds up on the bottom of the page, which isn't what I want either. I'm thinking I neet to add a second category(?) but don't know how to do this.
Thanks!
Rich
Code:
Balance
Previous Balance $100
Amount Received 50
Costs
Supplies 10
Fees
$1000 Fee X 50% Complete
less $100 Previously Billed 400
Code:
Balance
Previous Balance $100
Amount Received 50
Costs
Supplies 10
Fees
$1000 Fee X 50% Complete
less $100 Previously Billed 400
TOTAL DUE UPON RECEIPT $460
Thanks!
Rich