## Select Expert

This Expert appears:

- when you choose the Select Expert command from the Report menu, or
- when you click the Select Expert button on the Standard toolbar.

Use the Select Expert to select the records or groups you want to include in your report (if you do not want them all included). For example, you may have a customer database that contains records for customers from every state and Canadian province but you want to do a report only on Texas customers. Select Records enables you to restrict your report so that only Texas customers are included. When using the Select Expert, the program automatically generates a record or group selection formula based on settings you specify in the dialog box.

Note: This Expert allows you to set up reasonably complex selection criteria, but to have more control over the formula that is generated, use the Formula Editor.

##### Search settings

Use the lists to select the condition that best finishes this sentence:

`"I want to select all records where the value in the field I have selected is"`

You can select primary conditions, date conditions or boolean conditions, depending on the type of field you have selected.

##### Speed Tip

Click this button to get further information to speed up the reporting process.

##### Browse

The Browse button has been included as an aid in selecting the values that define your selection formula. When you click this button, the program displays a list of field values in the database. If the value you want is on the list, select the value and click the Paste Data button. The program enters the value selected in the active text box (the text box displaying the insertion point).

Note: If you need to select multiple values (for example, if you want to include records in which the field value is one of three values), the insertion point automatically moves to the next text box as soon as it finishes pasting data in the previous box.

##### Show/Hide Formula

Record selection criteria that you enter via the Expert automatically generates a record selection formula. You can review and modify this formula by clicking the Show button. When you click the button the Expert expands to show the formula. When you are finished editing/reviewing, click the Hide button to hide the formula from view. The Select Expert is automatically updated with any modifications you make to the formula.

##### Record Selection/ Group Selection

Select the Record Selection option to create a record selection formula.

Select the Group Selection option to create a group selection formula.

##### New

Click the New tab or button to create a new selection formula. When you click this tab, the Choose Field dialog box appears where you select a field to create the selection formula on.

##### Del

Click this button to delete the active selection formula and its associated tab.

##### Formula Editor

When you click this button, the Formula Editor appears with the selection formula shown in the Formula text box.

###### Related topics

Record Selection

Seagate Software, Inc. http://www.seagatesoftware.com Please send comments to: techpubs@seagatesoftware.com