Sub-Table Values (STAB)

Extrapolates data from an additional table (e.g.: extrapolate how many items have been sold within invoices in a range filtered by date).

Parent TableIt is the starting table.
Date fieldThe date type field to use in the filter.
SubtableThe additional table of the document used for data extraction.
Subtable fieldIt is the Subtable field within the additional table used in the filter.
SQL filterAny additional SQL string to filter the data being extracted.
Descriptive fieldsThese are the fields that describe the report (e.g. by referring to the example above, the descriptive fields for the articles are code and description).
Numeric FieldsThey are all the numeric fields of the report (e.g. referring to the example above, the numeric fields for the items are usually the quantity and the total price of the item and the type of grouping is the sum): Field: indicates the additional table field. Grouping: indicates the type of grouping you want to do for that field.