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 | From version XXXXXX then empty break sheets will be deleted and not shown. Only sheets with values will be visible for the end-user. To override this and show empty break sheets then set this parameter to TRUE. Default is FALSE. |
VIEW_EMPTY_ADDSHEETS is a REPORT specific parameter, which can be used in combination with the ADDSHEET parameter. From Bizview 2011 (1.09XX.XX) version 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.
To access ADDSHEETs from the right panel in Template Design, select Parameters > Frequently Used > ADDSHEET > New worksheet for each selected object.
View empty addsheets: TRUE/FALSE (FALSE is the default state)
