SCALE (Col A)
= optional in Column A
Parameter | Mandatory/Optional | Value (example) | Comment | |
|---|---|---|---|---|
FORMS | REPORT | |||
SCALE | 1000 | Define a scale factor for each CVAL column. Can be defined in column A, row 1, and/or in PARAM. If no SCALE is defined in column A, row 1, or in PARAM, then by default it is set to 1. The value needs to be a valid number. | ||
SCALE is a common parameter which can be used both for FORMS and REPORTS. The parameter is used to re-calculate the values returned from the database, or values updated to the database. It can be used either in PARAM, row 1, and/or in column A in the template. If no value is defined for SCALE, then the default value 1 will be used.
For example, a SCALE value of -1000 in a form is used to multiply the value when updating them to the database, which means that the end-user can enter values signed reversed in thousands. In certain cases, different SCALE values need to be used for different columns or different rows in a document. If so, then SCALE should be used in column A or row 1 in the template. If the same SCALE applies to all columns and rows in the template then it is better to define the parameter in PARAM.
Note: If SCALE factors are defined both in PARAM, row 1, and/or column A, then Bizview will multiply each SCALE to each cell value. For example, if SCALE in PARAM is set to -1000 and SCALE is also defined in column A as -0,001, then the cell values in the column will be calculated as <cell value>*(-1000)*(-0,001).
Values will be multiplied with the SCALE factor(s) when updating values in the database and when fetching values to the form/report then values will be divided by the SCALE factor(s).
The SCALE row should be defined with ROWTYPE = DESIGN (the row will be hidden when document is generated)