CURR
= optional in PARAM sheet or in template worksheet
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C (example) | Value in col D (example) | Occurrence in PARAM sheet | Comment | |
---|---|---|---|---|---|---|
FORMS | REPORT | |||||
CURR | <CURRENCY ID> | <CURR ID> Available from Bizview 2011 (1.0901.1427) | 1 (or several if several sections) | A valid currency ID. Can be defined in PARAM, or in template worksheet in row 1 or in column A. Can only be defined in one of these places. |
CURR is a FORM specific parameter that is optional either in PARAM or in the template worksheet (in row 1 or in column A). When updating values in the database, the data rows can be tagged to a specific currency in order to keep the updated data cells separated and not risk that existing data would be updated with incorrect data.
This parameter can also be used in REPORTS if data from the Bizview data table should be retrieved to the report. Then, one specific currency maybe need to be specified in the PARAM sheet in order to get the correct numbers in the report; however, that is only the case if data is registered in several different currencies.
Access CURR in the Template Design right panel by selecting Parameters > Data Dimensions > Currency.
In the Currency field, you can either directly add the currency ID you want to filter the data on, enter a formula, or you can use the buttons to the right to select a specific currency from the Currency drop-down.
The value you enter in the Currency field in the right panel will be written to the CURR parameter in column C.
If the template contains several sections, you can add specific currencies for each section or define one for all sections. If you leave the Section drop-down empty, the currency will apply for all sections.
Retrieve/Update Values - Column C and D in PARAM
In a FORM, if only a value in column C in PARAM is defined for the CURR parameter, then that value will be used both when retrieving data to the form and when updating values to the database.
If you want to retrieve values for a different set of currencies compared to the CURR value you want to be updated, then you need to define those retrieve value(s) manually in column D in PARAM sheet. If several currency values should be retrieved, then these currency values need to be separated with # in column D in PARAM (CURR1#CURR2).
REPORT templates only support values in column C in PARAM (column D in PARAM should not be used).