I have a report with3 Group Headers. I would like to let the user choose if they want to seethe three headers or drop it down to just the two. One of the three alwaysneeds to be there, but depending on whether the other two are selected, it can bethe first or the last Group header.
Many posts mentionhiding a group header, which I do. The problem with hiding is that thesort hierarchy still applies resulting in a sort result that isn't obvious whenviewing the report (as the hidden group heading still has sorting control).
The order of thegroup headings can be manually changed in the "Group, Sort and Total' panein the report design. I'm really looking for how to do the same thing inVBA (eg use the 'move up' and 'move down' buttons). By hiding the group headingI don't want and moving it to bottom, the sort occurs as required.