Returning Very Large Datasets in Tabular Reports

By default, the tabular report format is limited to five thousand rows of data or less. Typically, reports won't ever reach that limit (5,000 rows is approximately 250 pages!), but the reporting system can be adjusted to permit a user to pull more than that if they need to.

If you'd like to, you can raise that reporting limitation. That change effects all users and all reports in the system. Just follow these simple instructions.

1. Goto the Tools... System Settings... Report Settings page
2. Adjust the Maximum Tabular Report field at the bottom of the page to the desired value

The more information you return from your reporting server, the bigger "buffer" you'll need on your web server in order to download that data to your machine. If you increase your maximum row limit significantly, then you may need to adjust the maximum ASP buffer in your web server.

To edit that value, you'll need to edit the "metabase" value "AspBufferingLimit" on your server (take a look at the microsoft website for information on how to edit your web server's metabase file. In general, it's a good idea to provide for about 1MB of buffer space for every 1000 rows of data.