This article is specific to PaperCut NG and PaperCut ChargeBack. It does not apply to PaperCut Quota.

PaperCut includes a large range of reports, each with varying features and purpose. Some reports, for example the 'print logs' report, can produce a lot of output, especially for large organizations with a lot of printing activity. It most cases these reports will be run over a specific (limited) date range - 'last week' or 'yesterday' for example. Running the report over a larger time period may produce too much data, and have negative effects such as:

• Overloading the server, which may cause other requests to be slow or denied.
• Causing the server to run out of memory.
• Generating a very large file that takes up a lot of disk space to store, and bandwidth to download.

For these reasons, PaperCut has a max rows setting that prevents reports getting too large. By default, this is set to 10,000 (e.g. a user list report will show only the first 10,000 users).

In some cases, you may have reason to generate a report with more that 10,000 rows. For example, exporting a print log CSV report over a large date range. In this case, the max rows setting can be increased (either temporarily or permanently).

To change the max rows setting:

• From the PaperCut Admin interface, click the Options tab.
• From the Actions list, click Config editor (advanced)
• In the Quick find box, type reports.max-rows and press Enter
• Increase the value to something higher. In general, this is the number of rows that will appear in your report. So if you want a 15,000 row report, enter 15000 or more.
• Click Update to the right of the entry field.
• Run your report again and confirm that all the data is now shown.

Keywords: missing data, truncated report, reporting limit

Categories: PaperCutNG, Reports, Troubleshooting