How to Configure Another Region Starts, Region Property in a Report Model

Some reports contain repeating records where the beginning of each record follows a consistent pattern, but the number of lines within each record may vary. Optional fields, blank lines, or multi-line details can cause records to span different lengths. In such scenarios, defining a data region using a fixed number of lines may not produce accurate results.

The Another Region Starts option for the Region End Type property is used when the start of a new record indicates the end of the previous record.

Video

Sample Use-Case

In this case, the Orders file contains multiple order records. Each order begins with an ORDER ID, followed by additional order-related details. Since each order may span a different number of lines, the start of the next ORDER ID indicates the end of the previous order.

01-order-records

Creating Data Regions

To extract order records from a report, a data region must first be added.

1. Right-click on the Record Node.

2. Select Add Data Region.

02-add-data-region

Once the data region is added, a pattern must be defined to identify the beginning of each record.

1. In the region pattern, specify ORDER ID to identify the start of each order record.

03-pattern-matching

Configuring the Region End Type

Once the data region is created, the region end behavior is defined.

1. Select the data region.

2. In the Region Properties panel, locate Region End Type.

3. Set the value to Another Region Starts.

04-region-end-type-another-region-starts

With this configuration, the current order ends when the next ORDER ID is encountered.

05-data-region

Adding Data Fields

After configuring the data region, data fields are added to extract order details.

1. Right-click on the data region in the Model Layout panel.

2. Select Add Data Field.

3. Click on the ORDER ID value in the report to create the Order ID field.

06-adding-data-fields

1. Repeat the process to add additional fields such as Ship Date, Item, Quantity, Description, and Item Code.

2. Each field is defined by selecting the corresponding value in the report.

07-data-fields

This concludes the configuration of the Another Region Starts option for the Region End Type property in Astera.