DYNCOL
= optional in PARAM sheet
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C (example) | Value in col D (example) | Value in col E (example) | Value in col F(example | Occurrence in PARAM sheet | Comment | |
|---|---|---|---|---|---|---|---|---|
FORM | REPORT | |||||||
DYNCOL | <data view ID> | <select columns> | <order by columns> | TRUE /FALSE (break exclusive) | 1 | Parameter to be used when generating dynamic columns. | ||
DYNCOL is a parameter to use when the document should generate the columns dynamically. In this parameter a data view, select column(s) and order by column(s) for getting data to expand the columns dynamically should be defined.
The data view can be defined to return 1 or several columns. If the SQL query returns several columns, then the program will search for all these columns in Column A in the template, and if any of these columns exist in column A, then that row will be updated with values for each dynamic column. If the SQL query only returns one value (i.e objval_id as UNIT), then the program will search for UNIT in column A and then updated that row with values for each dynamic column.
DYNCOL values in PARAM:
- Column C: Data view ID.
- Column D: The columns to select from the data view.
- Column E: The columns that the data should be ordered by, can be defined with ASC or DESC.
- Column F: TRUE/FALSE (break exclusive).
Break Exclusive is true if dynamic columns must execute after break sheets has been generated. This will slow the execution of the template but is necessary to have in certain circumstances when the number of dynamic columns are different between the break sheets. Break Exclusive is true if you, for example, have $BREAK in the data view for dynamic columns. Please note that if you have a Total sheet in your template you cannot write <object> = '$BREAK' in your where statement in the data view. If you have a total sheet you must write <object> IN($BREAK). Notice that $BREAK cannot be surrounded by '' in this case.
For more information about DYNCOL parameter for v1 templates, see Dynamic Columns.
Access DYNCOL in the Template Design right panel by selecting Parameters > Dynamic Columns:
Select the data find icon to view a list of available data views:
The Data view list will show all data views containing a plain SELECT statement (query type 0).
One, or several, select columns can be defined (separated with comma , in PARAM cell).
One, or several, order by columns can be defined with either ASC or DESC. It is also possible to re-order with drag-and-drop (separated with comma , in the PARAM cell).
Break exclusive TRUE/FALSE.
In order for the column to expand dynamically, it is also necessary to define three parameters in column A in the template: