Enhanced Reporting Optimization

To speed up the processing time for large reports that contain many fGetVal functions, you can use the enhanced reporting optimization functionality.

You have to make additional settings to all the reports that use this functionality.

Note: Note that additional settings also have to be made during installation and configuration of your installation. Contact your system administrator for more information.

Procedure

  1. Open a report in Microsoft Excel.
  2. Position the cursor in cell A1 in the first Excel worksheet of the report.
  3. From the Insert menu, select Name, Define.
  4. Type Optimise2 in the Names in workbook cell, and click OK.