ROWGROUP_PROC
Feature available from Bizview version - Bizview 2011 R3 (1.0404.1530)_03)
= 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) | Occurrence in PARAM sheet | Comment | |
|---|---|---|---|---|---|---|---|
FORM | REPORT | ||||||
Available from Bizview 2011 R3 (1.0404.1530)_03 |
|
| <procedure name> | n/a | n/a | 1 | Instead of using standard code when expanding rowgroups, there is a possibility to define a customized data view that should run when generating the expanded rowgroups. |
ROWGROUP_PROC is an optional parameter that can be used in combination with ROWGROUP parameter when several rows should be expanded together. When rows are about to be searched for each ROWGROUP, then the views/tables used in the template will be used as default. All unique values (of the SEARCHCOL object in all tables/views) for each search interval defined for each ROWGROUP will be returned and rows will be expanded. In other words, only search values returning any data values will be expanded.
However, if the designer, for example, wants to force Bizview to create rows for all values within the specified search values defined in the ROWGROUP, then this parameter can be used to define a data view that should be run in order to create the wanted rows for each ROWGROUP.
Access ROWGROUP in the Template Design right panel by selecting Parameters > Row Groups.
Three different values must be defined if a customized data view should be used to create the row groups:
- The data view that should be executed (only data views with query_type=0, plain SELECT data views, is selectable).
- The column in the data view that should be selected.
- The column in the data view that the data should be ordered by.
For more information about Row Groups and how they are handled in v1 templates (new data engine), see Row Groups.