User-defined fields

You can create new report fields on the User-defined fields tab. To add a user-defined field to a report, add it to the list of selected fields. The application automatically determines whether the field can be added to a specific report item.

There are two types of user-defined fields: selection field and expression field.

Fig. 141. User-defined fields in report option settings

A selection field can have multiple values. The first value that satisfies the filter condition is included in the report. Specify a title and an expression, a value, and an optional short filter presentation.

Fig. 142. Report customization. User-defined selection field

Filter conditions are defined in a new window. To add a filter condition, click Add. Then select a field from the list of available ones, select a comparison type, and specify a value for comparison.

To define the order of filter items, use the arrows on the command bar or arrange the items by dragging them.

A user-defined expression field is displayed in a report as an expression result. You can compose expressions using available report fields and the expressions of the data composition system language. You can use user-defined fields anywhere in a report. You cannot use user-defined resource fields as grouping fields.

In the Edit user field dialog box, select a title and expressions for detailed and total records.

Fig. 143. User-defined expression field

If a field name contains spaces or special characters, enclose them in brackets [].

Use aggregate functions to write expressions for total records, for example: SUM (Field) * 2.

For more information about the data composition language, see 1C:Enterprise User Manual, Appendix 1. Data Composition System Expressions Language.

Add comment