TOTALSHEET_FIRST
= optional in PARAM
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C (example) | Occurrence in PARAM sheet | Comment | |
---|---|---|---|---|---|
FORMS | REPORT | ||||
TOTALSHEET_FIRST | N/A | TRUE/FALSE | 1 | In reports with ADDSHEET functionality the total sheet is placed last in the worksheet tabs. To place the total sheet first you set this parameter to TRUE. |
TOTALSHEET_FIRST is a REPORT specific parameter to manage where the total sheet should be placed in the worksheet tabs. By default, the total sheet is placed last after each value sheet but if this parameter exist and has the value TRUE that total sheet is placed first.
Access the TOTALSHEET_FIRST from the right panel in Template Design by selecting the Parameters tab > Worksheets > Place Totalsheet First.
If TRUE = Total worksheet will be placed first in the generated report.
If FALSE (default) = Total worksheet will be placed last in the generated report.
In PARAM worksheet:
- Parameter name in column A: TOTALSHEET_FIRST
- Value in column C: TRUE/FALSE
In open report, if Place Totalsheet First is set to TRUE, then the Total sheet will be visible first in the break report: