Reports: Difference between revisions
Line 36: | Line 36: | ||
* XLSX | * XLSX | ||
When creating reports, the max row limit is set by default on instances to 1000, this can be increased to a maximum of 25000 rows using the following setting: | When creating reports, the max row limit is set by default on instances to 1000, this can be increased to a maximum of 25000 rows using the following system setting (Home - System - Settings - Advanced): | ||
api.xmlmc.queryExec.maxResultsAllowed | api.xmlmc.queryExec.maxResultsAllowed |
Revision as of 09:54, 24 April 2018
Home > Administration > Reports | Index |
IntroductionReports are used to collect specific data for your reporting needs. The reports in Hornbill are point in time, meaning that the data is accurate at the point when the report is run. There are various different options with reports which will be explored in more detail below. |
Related Articles |
Reports can be created in various formats and can be scheduled for distribution to documents in Document Manager.
Report Types
Reports can be created based on Entities, Measures or by using the SQL Schema Designer.
Output Options
Reports are output by default in PDF format. Optionally you can choose to output the report in the following formats
- CSV
- XLS
- XLSX
When creating reports, the max row limit is set by default on instances to 1000, this can be increased to a maximum of 25000 rows using the following system setting (Home - System - Settings - Advanced):
api.xmlmc.queryExec.maxResultsAllowed
The only exception to this is for the creation of PDF reports output, this is limited to the following max outputs:
- reporting.display.maxcolumns = 20
- reporting.display.maxrows=5000
If either of these limits are exceeded when trying to generate a PDF output, the PDF generation will fail and an entry in the log will explain why.
Generation of CSV, XLS, XLSX adhere to the maximum row limit you have set on your instance under the following system setting: api.xmlmc.queryExec.maxResultsAllowed
Schedule
As well as running reports manually, you can also schedule the reports to run and be distributed on definable intervals
Table References
Full schema information and table descriptions can be found in the Application entity viewer located in Hornbill Administration: Click here for more info