I Have a Report with multiple Department Numbers,and orders. How do I total the totals for dept in it's footer, then total all footers at the end of the report.
Dept:8500 Total cost each order: $
Footer------------------------
Dept:8600 Total cost each order: $
Footer------------------------

Try this.

=Sum[Text Box Title] for each department in the footer and then at the end of the report do the same thing again, but refer to the Text Box Title in the footer.

Hope this works.
Eason