Floating Patterns and Floating Fields

A floating field pattern in Astera refers to the data points that are scattered throughout the report. The Floating Pattern option in Astera allows you to capture each data field no matter the location.

With this option, you must first specify a pattern in the pattern-matching bar and then check the Floating Pattern option. When the Floating Pattern option is enabled, it will capture all the lines that match the specified pattern.

Floating fields

The Floating Field option will automatically appear when the Floating Pattern option is checked. This option will capture all the misaligned data fields. It is enabled by default, however, you can disable it if you want the field positions to be fixed.

Working with Floating Patterns and Floating Fields

To work with floating patterns and floating fields in Astera, follow the steps mentioned below:

1. Go to File > New > Report Model and provide the path to the report on which you want to apply the floating pattern option. Click OK. The source report will open on the designer window.

You can download the sample text file here.

860B

4-Floating-Patterns.zip

archive

1. Right-click on the Record node present in the Model Layout panel and click on Add Data Region.

You will see an orange bar, which is the Pattern-Matching Bar appear along with the Pattern Properties and Region Properties section.

Write a pattern in the pattern-matching bar to capture the desired data region in your report. In this case, "ÆÆÆ-ÑÑÑÑ" is specified as the matching pattern "**.**"

All data regions and data fields except the misaligned ones will be captured.

1. Now, check the Floating Pattern option in the Pattern Properties section. You will see that all the misaligned patterns and fields will be captured.

1. Right-click on the data that you want to add in your data field and click on Add Data Field. This will create a sub-node in the model layout. This sub-node is a data field and contains the data that you have selected.

In this example, a sub-node for ITEM has been created with all the ITEM data being captured.

Note: The ITEM column in the first data field contains null values under OFFICE CHAIRS. Astera allows you to use any value from the “Value if Null” option in the Field Properties. In this case, we have selected the Use From Previous Record option.

1. Repeat these steps to create other fields.

1. You can now preview your data by clicking on the Preview Data option in the Toolbar.