It's now the end of 2022 and reporting pagination and load times is still a big problem on reports. On top of the slow load times discussed previously, you can't quickly get from one page to another in a larger dataset. For example, I have a rolling year hour report with ~60k records. I desperately need to see the whole dataset to make sure everything is correctly included. I need to go from page 1 to the last page for example and I have to keep clicking the right arrow, wait for a load, click again, wait for a load, click again.
1) If you must keep only 2k records for page for performance, which I agree with for default but then allow for that 2k to be overridden once you are done building the report and just need output.
2) Add a first page <<, text box to enter the page # to jump to, and >> last page like so many sites have when there are large data sets.
Ex: << < Page X of 28 > >>
3) Allow more than 20k records to be exported into Excel.
I sure hope some of this is solved in the new reporting canvas, but that is delayed and my small company still hasn't even gotten a preview glimpse of it yet. We are officially hitting the ceiling in what Workfront reporting can do and are going to need to look elsewhere if reporting capabilities are not significantly improved.