Skip to main content
LinkedIn
Copied!

Table of Contents

Disabling the creation of an Info sheet in Excel output

Version:

Only available versions of this content are shown in the dropdown

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.

  1. Save a copy of the pyEnableExcelInfoWorksheet when rule to one of your application rulesets.

  2. Edit the value of the when rule to return false instead of true.

  3. Click Save.

  • 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.

Did you find this content helpful?

50% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Ready to crush complexity?

Experience the benefits of Pega Community when you log in.

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice
Contact us