SEARCHCOL (Col A)
= mandatory in combination with another parameter
Parameter |
Mandatory/Optional |
Value (example) |
Occurrence in column A |
Comment |
|
---|---|---|---|---|---|
FORMS |
REPORT |
||||
SEARCHCOL |
<OBJECT> |
1 |
Parameter to define which search column that should be dynamically expanded in the column. |
SEARCHCOL in column A is a parameter that must be defined if the columns should be expanded dynamically. This parameter should state which search column (in the table/view stated in the SQL query in parameter DYNCOL) that should be expanded for each column.
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).