Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

TOTALSHEET_FIRST

Optional parameter in PARAM = 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

Optional parameter in PARAM

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.

TOTALSHEET_FIRST

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:

TOTALSHEET_FIRSTEx

Published:

TOTALSHEET_FIRST

Optional parameter in PARAM = 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

Optional parameter in PARAM

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.

TOTALSHEET_FIRST

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:

TOTALSHEET_FIRSTEx

For an optimal Community experience, Please view on Desktop
Powered by Zendesk