CONDITION
= optional in Column A
Parameter | Mandatory/Optional | Value (example) | Comment | |
|---|---|---|---|---|
FORMS | REPORT | |||
CONDITION |
|
| <1000 | State a having condition for a column. Default "having <> 0" will be added to the SQL queries. |
CONDITION is an optional parameter in the template. When all SQL queries are run towards the database, then the program will automatically add a having condition (having <> 0). To override the default condition, the keyword CONDTION can be added in column A and another having condition can be defined for any of the data columns. If CONDITION is used, then the FUNCTION keyword should also be defined for the column.
Note: If no having condition should be added, then <NOHAVING> should be defined in the CONDITION row for the particular column.
In the template worksheet the CONDITION row should be defined with ROWTYPE = DESIGN (the row will be hidden when document is generated).