ADDSHEET_NAME
Parameter available from Bizview version -Bizview 8.9
Parameter | Mandatory/Optional | Value (example) | Comment | |
|---|---|---|---|---|
FORMS | REPORT | |||
ADDSHEET_NAME | N/A | Parameter that can be used if the designer wants another value to be shown in the different worksheet tabs created from the ADDSHEET parameter. By default, it is always the value ID that displays as the tab name. However, with this parameter, the designer can define that the tab name should only be the description or a combination of the ID and description. | ||
This parameter can be used if the designer wants another value to be shown in the different worksheet tabs created from the ADDSHEET settings. By default, the ID is always shown as tab name when opening a report/form with break values. With this new parameter stated in the template in column A, the designer can state a formula in column C on the ADDSHEET_NAME row that would, for example, return both ID and description as tab name ([ID] Description). ADDSHEET_NAME in column A must be used in combination with the ADDSHEET parameter in the PARAM sheet.
This topic contains the following sections:
Template Worksheet
By entering the parameter ADDSHEET_NAME in column A in the template, you can enter how to format the worksheet tab name in column C. Using the row where you have the parameter ADDSHEET, you can retrieve the break id (column C) and description (column D), or only the description if that is desired.
In the template, add the new parameter ADDSHEET_NAME. Entera formula in column C to retrieve the value that should be shown in worksheet tabs.
In this example, both ID and description is retrieved from the ADDSHEET parameter in the row above:
In the opened form, each breakvalue is inserted in the ADDSHEET parameter row (the ID in column C and description in column D). The ADDSHEET_NAME formula retrieves those values and that value will be shown in the worksheet tabs.
Conditions
Note: The ADDSHEET_NAME will only be reflected when opening the form/report in the HTML5 client. The worksheet tab name is only exchanged on the client side and only in HTML version.
Since the ADDSHEET_NAME value is only reflected on the client side, it will not be visible when:
Exporting the form/report to Excel, then the original break ID value will be shown as tab name.
Performing a drill down and tab names are shown in drilldown breadcrumb navigation, then the actual break ID value will be shown as value (drilldown breadcrumb navigation only available from version 8.8).
Any other action/function in Bizview that retrieves a worksheet tab name from server.