Filling Empty Cells in a Field
Many reports are designed so that duplicate field values do not repeat down the page. When Monarch Classic extracts data from the report and builds a database table, it does not automatically duplicate these values, resulting in empty cells throughout the field. You can fill these empty cells with the proper field values using a setting in the Field Properties or Field List dialog.
Applying the Fill Empty Cells setting to a single field
-
Select Input Fields from the Table Design Ribbon. The Input Field Properties Window displays.
-
Go to the Template tab.
-
Click Copy from previous record.
-
Select Accept.
Applying the Fill Empty Cells setting to several fields
-
Select Field List from the Table Design ribbon. The Field List window displays. This window displays the properties for all fields in the table, including the field types.
-
Ensure that the Show Template Properties check box is selected. This check box is located at the lower-left corner of the Field List window.
-
To fill empty cells using the value from the previous record, select the appropriate check box in the Fill Empty (cells) column.
-
Repeat Step 3 to apply this setting to additional fields.
-
Click Accept to close the Field List window and apply the changes to the table.
© 2024 Altair Engineering Inc. All Rights Reserved.