Report Builder 3.0 --- Invoice Report --- Need to show 7 line invoice totals at bottom of last page.
If the total lines are part of the invoice number group in the tablix or in the body outside the tablix, they show up immediately after the last invoice listing which may be on the last page but not necessarily at the bottom.
If the total lines are located on the footer, they can be hidden on all pages except the last page. In that case the invoice totals do show up at the bottom of the last page. However, the space they take in the footer is not collapsed so that invoices listings on previous pages can cover the whole page. There is a large space at the bottom of each page except the last page where the totals are.
In addition, there is a page number field on each page of the invoice located on the footer so the footer cannot be hidden on all pages except the last page even if there was a method to do this which I have not found yet.