PRE_GENERATE_BREAK
Feature available from Bizview version - Bizview 21.3.1)
= optional in PARAM
Parameter (col A in PARAM) | Mandatory/Optional | Value in col C | Value in col D | Occurrence in PARAM sheet | Comment | |
|---|---|---|---|---|---|---|
FORM | REPORT | |||||
PRE_GENERATE_BREAK |
|
| TRUE/FALSE | n/a | 1 | Important: Only applicable to v1 templates (new data engine). If this parameter is "True", forms and reports will create break sheets before data is fetched. |
By default, when Bizview generates v1 reports and forms (new data engine templates) the data is first retrieved and from that actual data the break sheets are created. The reason for first retrieving the actual data and thereafter creating the break sheets is to improve the overall performance when opening a report or form. In some scenarios , however, this cannot be applied and therefore a new parameter in PARAM can be used in v1 templates (new data engine templates).
If the parameter PRE_GENERATE_BREAK is "True" in PARAM, forms and reports will create break sheets before the actual data is retrieved. This is used when the break sheets are dependent on the break value. For example, if the template designer has a formula to the ADDSHEET parameter and this formula should be used in the query.
When setting this parameter as TRUE, every query that exists in the template will be executed for each break sheet. This will have a negative effect of the overall performance when creating the report or form.
Access PRE_GENERATE_BREAK from the right panel in Template Design by selecting Parameters > Data Retrieve > Pre-generate Break Sheets.
