Disabling the creation of an Info sheet in Excel output
When you export report results to Microsoft Excel, the process creates a Data sheet and an Info sheet in the Excel file. The Info sheet contains the report title, filters used to generate the report, the date when the report was generated, and the number of results returned. If you want the report title and filters to display on the first sheet rather than the Info sheet, you can disable this default functionality.
Save a copy of the pyEnableExcelInfoWorksheet when rule to one of your application rulesets.
Edit the value of the when rule to return false instead of true.
- Setting resource limits for reporting
You can set system resource limits that apply when running reports and exporting report data. These resource limits specify the maximum number of rows to retrieve, the maximum elapsed time (in seconds) for the database query, and the number of rows to export at a time.