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

ROWGROUP_PROC

Optional parameter in PARAM= 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

ROWGROUP_PROC

Click for info Available from Bizview 2011 R3 (1.0404.1530)_03

Optional parameter in PARAM

Optional parameter in PARAM

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

Published:

ROWGROUP_PROC

Optional parameter in PARAM= 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

ROWGROUP_PROC

Click for info Available from Bizview 2011 R3 (1.0404.1530)_03

Optional parameter in PARAM

Optional parameter in PARAM

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

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