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