Change the Order of Report Footers

[Karl Burrows]

I added some new groupings to a report with subtotals, but when I added the
footers, it put them at the bottom of the other footers, so now all my
subtotals are out of order. Is there a way to rearrange the footer order
without having to rename them and reformat all the information?

Thanks!

 

[Wayne Morgan]

I don't know of one. The footers should be in reverse order of the headers.
The first header's associated footer should be the last footer, the second
header's associated footer should be the next to the last footer, etc.
Another way to look at this is that the "outside" header will have the
"outside" footer and the "inside" header will have the "inside" footer. If
you aren't using all of the footers, you can set their Visible property to
No or just shrink them to zero height (Report and Page footers). If the
footer is a group footer then in the Grouping and Sorting box set the Footer
to No to remove the footer.

 

[Karl Burrows]

I re-arranged the grouping order and didn't realize you have to save and
re-open the report to see the changes.

Thanks!

I don't know of one. The footers should be in reverse order of the headers.
The first header's associated footer should be the last footer, the second
header's associated footer should be the next to the last footer, etc.
Another way to look at this is that the "outside" header will have the
"outside" footer and the "inside" header will have the "inside" footer. If
you aren't using all of the footers, you can set their Visible property to
No or just shrink them to zero height (Report and Page footers). If the
footer is a group footer then in the Grouping and Sorting box set the Footer
to No to remove the footer.