<SQLCOLUMN> (Row 1)
=optional in row 1
Parameter | Mandatory/Optional | Value (example) | Comment | |
|---|---|---|---|---|
FORMS | REPORT | |||
<SQLCOLUMN> |
|
| <SQLCOLUMN> | Any SQL column in the defined data source (SOURCE and TABLE parameters). |
In row 1, any SQL column in a view/table in a defined datasource can be stated. In row 1 the column is defined, in the SOURCE row the data source is stated and in the TABLE row the table or view is entered.
The SQL column does not need to exist in every data source (SOURCE in col A) used in the template. Instead, the program will evaluate in which of the used data sources the defined SQL column exists, and add the parameter as a where-clause in the SQL queries run towards that/those particular data source(s).
Mandatory parameters for <SQLCOLUMN>:
quantity (row 1) is a column in table cust.invoicestat (TABLE) in data source BIZVIEW_DEMO (SOURCE).