I have a tabular report that has Show/Hide grouping on the rows. The end user wants all data displayed when first running the report, which is no problem. It covers roughly 3 or 4 pages. Can I make so that if I hide all the data, it then refreshes to show the "rolled" up table on a single page rather than split across multiple pages?
I decided to go with the report all rolled up when first run. Expanding from that state seems to keep the report on a single page plus I can roll it back up to a single page (although probably simpler to just re-run it).