Running very large reports

KB Home   |   Running very large reports

Main.ReportsRowLimit History

Hide minor edits - Show changes to output

Changed lines 15-16 from:
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, set the value to @@15000@@ or more. Then run your report again and confirm that all the data is now shown.
to:
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, set the value to @@15000@@ or more. Then run your report again and confirm that all the data is now being shown correctly.
Changed lines 12-20 from:
To change the ''max rows'' setting you will need to change this config key: @@reports.max-rows@@.

* 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.
to:
To change the ''max rows'' setting you will need to change this config key: @@reports.max-rows@@
Please see the section called [[https://www.papercut.com/products/ng/manual/sys-mgmt-config-editor.html|Using the Config Editor]] to find out how to change config keys.

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, set the value to @@15000@@ or more. Then run your report again and confirm that all the data is now shown.
Changed lines 12-13 from:
To change the ''max rows'' setting:
to:
To change the ''max rows'' setting you will need to change this config key: @@reports.max-rows@@.
Deleted lines 2-3:
''This article is specific to PaperCut NG and PaperCut ChargeBack. It does not apply to PaperCut Quota.''
Changed lines 20-22 from:
[-Keywords: missing data, truncated report, reporting limit -]

''Categories:'' [[!PaperCutNG
]], [[!Reports]], [[!Troubleshooting]]
to:
----
''Categories
:'' [[Category.Reporting|+]], [[Category.Troubleshooting|+]]
----
[-Keywords: missing data, truncated report, reporting limit-]
Changed line 18 from:
* Increase the value (the default is 2500) 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.
to:
* 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.
Changed lines 12-13 from:
In some cases, you may have reason to generate a report with more that 10,000 users.  For example, exporting the entire list of 50,000 users and their balances to synchronize or import into another program.  In this case, the ''max rows'' setting can be increased (either temporarily or permanently).
to:
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).
Changed lines 22-23 from:
[-Keywords: missing data, trucated report, reporting limit -]
to:
[-Keywords: missing data, truncated report, reporting limit -]
Changed lines 1-2 from:
(:title Running very large reports (2500+ rows):)
to:
(:title Running very large reports:)
Changed lines 10-13 from:
For these reasons, [=PaperCut=] has a ''max rows'' setting that prevents reports getting too large.  By default, this is set to 2500 (e.g. a user list report will show only the first 2500 users).

In some cases, you may have reason to generate a report with more that 2500 users.  For example, exporting the entire list of 50,000 users and their balances to synchronize or import into another program.  In this case, the ''max rows'' setting can be increased (either temporarily or permanently).
to:
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 users.  For example, exporting the entire list of 50,000 users and their balances to synchronize or import into another program.  In this case, the ''max rows'' setting can be increased (either temporarily or permanently).
Changed line 18 from:
* Increase the value (the default is 2500) to something higher. In general, this is the number of rows that will appear in your report.  So if you want a 10,000 row report, enter @@10000@@ or more.
to:
* Increase the value (the default is 2500) 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.
Changed line 5 from:
[=PaperCut=] NG 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:
to:
[=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:
Changed lines 12-13 from:
In some cases, you may have reason to generate a report with more that 2500 users.  For example, exporting the entire list of 50,000 users and their balances to synchronize or import into another program.  In this case, the ''max rows'' setting can be increased (either temporarily or permanantly).
to:
In some cases, you may have reason to generate a report with more that 2500 users.  For example, exporting the entire list of 50,000 users and their balances to synchronize or import into another program.  In this case, the ''max rows'' setting can be increased (either temporarily or permanently).
Changed lines 3-4 from:
''This article is specific to PaperCut NG. It does not apply to other PaperCut editions.''
to:
''This article is specific to PaperCut NG and PaperCut ChargeBack. It does not apply to PaperCut Quota.''
Changed line 19 from:
* Click @@Update@@.
to:
* Click @@Update@@ to the right of the entry field.
Changed line 24 from:
''Categories:'' [[!PaperCutNG]], [[!Reports]]
to:
''Categories:'' [[!PaperCutNG]], [[!Reports]], [[!Troubleshooting]]
Added lines 1-2:
(:title Running very large reports (2500+ rows):)
Changed lines 22-24 from:
[-Keywords: missing data, trucated report, reporting limit -]
to:
[-Keywords: missing data, trucated report, reporting limit -]

''Categories:'' [[!PaperCutNG]], [[!Reports]
]
Changed line 20 from:
[-Keywords: missing data -]
to:
[-Keywords: missing data, trucated report, reporting limit -]
Changed lines 18-20 from:
* Run your report again and confirm that all the data is now shown.
to:
* Run your report again and confirm that all the data is now shown.

[-Keywords: missing data -]
Changed lines 1-18 from:
Describe ReportsRowLimit here.
to:
''This article is specific to PaperCut NG. It does not apply to other PaperCut editions.''

[=PaperCut=] NG 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 2500 (e.g. a user list report will show only the first 2500 users).

In some cases, you may have reason to generate a report with more that 2500 users.  For example, exporting the entire list of 50,000 users and their balances to synchronize or import into another program.  In this case, the ''max rows'' setting can be increased (either temporarily or permanantly).

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 (the default is 2500) to something higher. In general, this is the number of rows that will appear in your report.  So if you want a 10,000 row report, enter @@10000@@ or more.
* Click @@Update@@.
* Run your report again and confirm that all the data is now shown
.

Comments

Share your findings and experience with other PaperCut users. Feel free to add comments and suggestions about this Knowledge Base article. Please don't use this for support requests.

Article last modified on March 22, 2012, at 10:14 PM
Printable View   |   Article History   |   Edit Article