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

VIEW_EMPTY_ADDSHEETS

Parameter (col A in PARAM)

Mandatory/Optional

Value in col C (example)

Occurrance in PARAM sheet

Comment

FORMS

REPORT

VIEW_EMPTY_ADDSHEETS

N/A

Optional parameter in PARAM

TRUE/FALSE

1

Only sheets with values will be visible for the end-user and the sheets without any values will be deleted. Default is FALSE. To override this and show empty break sheets then set this parameter to TRUE.

VIEW_EMPTY_ADDSHEETS is a REPORT specific parameter, which can be used in combination with the ADDSHEET parameter. Any empty worksheet will not be shown to the end-user if ADDSHEET is used to create new worksheets for each object value. To override this default state, and force Bizview to show also the empty worksheets that have been created  then this parameter can be used.

For example, if the report is generated for units 20, 30 and 40, and the worksheet for unit 30 contains no values, then Bizview will by default delete this sheet and not show it to the end-user. However, if the end-user should be able to also view the empty worksheet for unit 30, then VIEW_EMPTY_ADDSHEETS need to be defined as TRUE in PARAM.

Access the VIEW_EMPTY_ADDSHEET parameter in Template Design by selecting the PARAM tab in the worksheet:

The VIEW_EMPTY_ADDSHEETS parameter displays in the Common parameters section of the PARAMETER SHEET, shown below:

In the example above, VIEW_EMPTY_ADDSHEETS is empty, or FALSE (default value). When generating a document with VIEW_EMPTY_ADDSHEETS set as TRUE, then all worksheets will be visible.

Published:

VIEW_EMPTY_ADDSHEETS

Parameter (col A in PARAM)

Mandatory/Optional

Value in col C (example)

Occurrance in PARAM sheet

Comment

FORMS

REPORT

VIEW_EMPTY_ADDSHEETS

N/A

Optional parameter in PARAM

TRUE/FALSE

1

Only sheets with values will be visible for the end-user and the sheets without any values will be deleted. Default is FALSE. To override this and show empty break sheets then set this parameter to TRUE.

VIEW_EMPTY_ADDSHEETS is a REPORT specific parameter, which can be used in combination with the ADDSHEET parameter. Any empty worksheet will not be shown to the end-user if ADDSHEET is used to create new worksheets for each object value. To override this default state, and force Bizview to show also the empty worksheets that have been created  then this parameter can be used.

For example, if the report is generated for units 20, 30 and 40, and the worksheet for unit 30 contains no values, then Bizview will by default delete this sheet and not show it to the end-user. However, if the end-user should be able to also view the empty worksheet for unit 30, then VIEW_EMPTY_ADDSHEETS need to be defined as TRUE in PARAM.

Access the VIEW_EMPTY_ADDSHEET parameter in Template Design by selecting the PARAM tab in the worksheet:

The VIEW_EMPTY_ADDSHEETS parameter displays in the Common parameters section of the PARAMETER SHEET, shown below:

In the example above, VIEW_EMPTY_ADDSHEETS is empty, or FALSE (default value). When generating a document with VIEW_EMPTY_ADDSHEETS set as TRUE, then all worksheets will be visible.

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