When exporting a report's results to Excel it breaks up the pages, much like viewing it online. This doesn't make a lot of sense because I want to use the filtering and other functionalities of Excel, and with blank lines and headers every so often I have to delete them all in order for to use Excel the way it is intended.
How can I turn off pagination in the export of report results?
Thank you!!