Add a text field

When working with a text sheet, the user can add text fields to the sheets.

Text fields enable the user to dynamically change text sheet contents. The following values are available:

Actual value. It is defined directly in the field editing dialog box.

Calculated using connected modules. The name of custom Fore and Fore.NET function, which calculates field value, is set. For example: =MODULE.MY(50), where MODULE is the identifier of the Fore module connected to the report; MY is the function name; 50 is the function parameter value.

Calculated using built-in functions. The name of built-in function, which calculates field value, is set. For example: =Abs(-14), where Abs is the Abs function name; -14 is the Abs function parameter value.

Value from the cell on table sheet. The address of report table sheet cell, containing value to be shown in the field, is specified. For example: ="Sheet1"!B11, where Sheet1 is the table sheet name containing the cell; B11 is the cell address.

Calculated by means of functions using the PrxReport or MetabaseClass class. The PrxReport or MetabaseClass class function name is set. For example: =PrxReport.ActiveReport.DataSources.Item(0).Name, this function displays the name of the first data source in regular report.

To work with text fields, use:

The Field Properties dialog box:

The Fields panel:

To display the panel, click the Show the Fields Panel

button on the Text Sheet.Format ribbon tab in the Text Fields group.

Working with Text Fields

To add a text field to the sheet:

Click the Insert Field button in the Text Fields group on the Text Sheet.Format ribbon tab.
Select the Add item in the text field's context menu on the Fields dialog box.
Click the button in the Fields dialog box.

The Field Properties dialog box opens after executing one of the operations.

To edit a text field selected in the list:

Click the Edit button in the Text Fields group on the Text Sheet.Format ribbon tab.
Select the Edit item in the text field context menu on the Fields panel.
Click the button on the Fields panel.
Double-click the text field name on the Fields panel.

After executing one of the operations the Field Property dialog box opens.

To delete the selected text fields:

Click the Delete button in the Text Fields group on the Text Sheet.Format ribbon tab.
Select the Delete item in the text field's context menu on the Fields panel.
Click the button on the Fields panel.

To delete all text fields, click the button on the Fields panel.

A confirmation dialog box opens after executing one of the operations. Select the Yes button, the field or fields are to be deleted.

To find a text field on the sheet, select the Show in Text item in the selected field's context menu on the Fields panel. After this command is executed, the cursor is set to the field position on the text sheet. Field value is highlighted in gray.