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).