SEARCHVAL (Col A)
= mandatory in combination with another parameter
Parameter | Mandatory/Optional | Value (example) | Occurrence in column A | Comment | |
|---|---|---|---|---|---|
FORMS | REPORT | ||||
SEARCHVAL | i.e *, % or 10-15 | 1 | Parameter to define which search values that should be dynamically expanded in the columns. | ||
SEARCHVAL in column A is a parameter that must be defined if the columns should be expanded dynamically. This parameter should state which search values for the defined SEARCHCOL should be expanded for each column. If all values for the defined value in SEARHCOL should be expanded, then state * or %. If specific values should be expanded for each column, then state a value, interval or value, or other combination of values in SqlSmart syntax (i. e 10, 10-15, or 10#11#15#16).
This parameter needs to be defined for each column that has COLEXPAND as TRUE.
In order for the column to expand dynamically, it is also necessary to define three other parameters:
To expand several columns in a group, the following must apply:
- COLEXPAND = TRUE for all of these columns.
- Identical values in SEARCHCOL and SEARCHVAL.
- No blank column between them (the columns that should be expanded together need be in consecutive order).