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

ADDSHEET_NAME

Parameter

Mandatory/Optional

Value (example)

Comment

FORMS

REPORT

ADDSHEET_NAME

Optional in column A

Optional in column A

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:

ADDSHEET_NAME

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.

ADDSHEET_NAME_2

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.

Published:

ADDSHEET_NAME

Parameter

Mandatory/Optional

Value (example)

Comment

FORMS

REPORT

ADDSHEET_NAME

Optional in column A

Optional in column A

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:

ADDSHEET_NAME

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.

ADDSHEET_NAME_2

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.

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