How to create user-defined items |
You can use the User-defined Items tab of the Queries/Reports -> Query/Report Generator screen to create user-defined items for inclusion in a query or report.
Step 1. In the New Field box, type a unique name for the item you want to include in the query or report.
Step 2. Click the New Field box.
The name of the new item displays in the list of defined items.
Step 3. In the area at the top of the tab section, build the expression that defines the value of the user-defined item for each row of data included in the query or report. The expressions can include the following fields:
Position the cursor in the top area and type the constant.
Double-click Tables to display a list of selected tables.
In the center area of the tab, double-click the name of the table that contains the data item you want to include.
Double-click the name of the data item in the right section of the tab.
Double-click user-defined items to display a list of user-defined items for the current query or report.
Double-click the user-defined item in the right-side section of the tab.
Double-click Operators in the center area of the tab.
Double-click the operator in the right-side section of the tab.
Functions
Double-click Functions in the center area of the tab. Three choices appear:
Note: If you choose either String functions or Numeric functions, the functions display in the right-side section of the tab. Double-click the appropriate function.
Prompt
The Prompt function instructs the application to prompt for a value when you run a query or report. If you choose Prompt, a prompt expression displays in the top area of the tab.
To insert a prompt:
Step 1. Position the cursor in the top area
Step 2. Type <PROMPT:>
Step 3. Position the cursor between the colon and the closing angle bracket (>).
Step 4. Type a label for the prompt. The label displays as the title of a prompt window when you run the query or report.
You can also type all or part of the expression directly in the top area. In addition to lists of Operators and Functions, you can use any other operator or function supported by the relational database management system. Refer to your database documentation for a list of available operators and functions.
_______________