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) for the v0 templates.
Note: In v1 (template version one ) templates, if the condition is not stated it will be IS NOT NULL.
Bizview will automatically add a HAVING on aggregate columns. The condition, if no CONDITION is stated, will be IS NOT NULL. If an aggregate column ends up with NULL means no records are found for this column. This should not be confused with zero values. The column can end up with 0 (zero) but in this case there are records that has been summarized to 0. Example two records with values 100 and -100 (100 + -100 = 0).
If you do not want to show rows where the aggregated value is 0, then you must add a CONDITION parameter in the template and write !0 for these columns. BizView will consider all NULL values as 0 in this case and sort these out to.
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).