User-Defined Items |
Note: You must be authorized to use the Query/Report Generator to access this tab.
The User-defined Items tab enables you to specify special items included in the query or report. You can also use FA Web Modules or any other reporting tool sold separately (such as Microsoft Access) that can attach to the database. Refer to the related documentation for these products. See Examples of User-defined Items.
Special items are not included in the system database. Their values are either constant (fixed) or computed or derived from data items in the database or other user-defined items. A user-defined item type corresponds to each type of data item in the database.
The top section of this screen displays a list of existing queries or reports. If a query or report is highlighted, the user-defined items for that report display in the center area in the bottom section of the tab. This field has a list box.
The area at the top of the lower part of the tab contains the expression that defines the value of the user-defined item as you define it. The expression can be built of constant values or values derived or computed from database items or other special items.
The area on the left of the lower part of the tab lists the user-defined items that have already been defined for this query or report. As you specify items to include in the expression, they display in the top area.
To include user-defined items in the query or report, see How to Create User-Defined Items.
_______________
See Also