VIEW_EMPTY_ADDSHEETS
Feature available from Bizview version -Bizview 2011 (1.0928.2019))
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C (example) | Occurrance in PARAM sheet | Comment | |
---|---|---|---|---|---|
FORMS | REPORT | ||||
N/A | 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.