TABLE
= mandatory in combination with another parameter
Parameter | Mandatory/Optional | Value (example) | Comment | |
|---|---|---|---|---|
FORMS | REPORT | |||
TABLE | <view name or table name> | Mandatory for all keyword columns in row 1 in which the SOURCE is NOT defined as * or BV. Should be a column name or view name in the defined SOURCE. | ||
TABLE is mandatory in combination with the SOURCE parameter, when SOURCE <> * or BV. In other words, for all columns with keywords in row 1 and SOURCE defined as a data source ID, then a TABLE value must be stated.
Important: There are new validation rules that apply when designing a template in template version one. With this new validation process, you are unable to save templates when the value for TABLE is empty or duplicated.
TABLE values:
- A view name including schema (in the defined SOURCE).
- A table name including schema (in the defined SOURCE).
- Data views. The data views visible in the TABLE row are the ones that have data view field definitions saved (from Bizview 7.1).
Template worksheet:
- For columns with SOURCE as * or BV, no TABLE value needs to be defined. TABLE values are only mandatory for other data sources.
- The TABLE row should be defined with ROWTYPE = DESIGN (the row will be hidden when document is generated).
- cust.invoicestat is a table in the defined data source BIZVIEW_DEMO (and the keyword "quantity" in row 1 is a column in table cust.invoicestat).