ADDSHEET_TOTAL
= optional PARAM sheet
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C | Occurrence in PARAM sheet | Comment | |
|---|---|---|---|---|---|
FORM | REPORT | ||||
ADDSHEET_TOTAL | N/A | <worksheet name> | 1 | If the ADDSHEET parameter is used, then this optional parameter can be used for REPORTS if a total worksheet should be created when break reports have been generated. | |
ADDSHEET_TOTAL is a REPORT specific parameter that can be used in combination with the ADDSHEET parameter. If ADDSHEET is used to create new worksheets for each object value, then this parameter can be used to automatically create a total worksheet, summarizing the values for each of the individual worksheets. The total sheet summarizes the values for each of the individual worksheets into a total.
If you want the total sheet to be created, then the Totalsheet Name field should be filled out. The value for this field is the name of the total tab (e.g. "Total").
For example, if the report is generated for units 20, 30, and 40, then the ADDSHEET_TOTAL parameter will create a total worksheet summarizing the values for units 20, 30, and 40 with the name specified in this parameter. The total worksheet will be placed last, after worksheets for 20, 30, and 40. If the totalsheet should be placed first, see TOTALSHEET_FIRST.
Access ADSHEET_TOTAL in the Template Design right panel by selecting Parameters > Worksheets > Totalsheet Name:
Total worksheet name: Define the worksheet tab name of the total worksheet that should be created.
In a PARAM worksheet:
Parameter name in column A: ADDSHEET_TOTAL
Value in column C: <worksheet name>
In an open report:
If a name is specified in Totalsheet Name field, then:
- A total sheet will be created in the report with break values.
- The name specified for the parameter will be the name of the total tab.