Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

TABLE

        Mandatory in combination with another keyword/parameter = mandatory in combination with another parameter                                                                                                                                                

Parameter

Mandatory/Optional

Value (example)

Comment

FORMS

REPORT

TABLE

Mandatory in combination with another keyword/parameter

Mandatory in combination with another keyword/parameter

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

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

    TABLE

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

Published:

TABLE

        Mandatory in combination with another keyword/parameter = mandatory in combination with another parameter                                                                                                                                                

Parameter

Mandatory/Optional

Value (example)

Comment

FORMS

REPORT

TABLE

Mandatory in combination with another keyword/parameter

Mandatory in combination with another keyword/parameter

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

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

    TABLE

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

For an optimal Community experience, Please view on Desktop
Powered by Zendesk