## Search Expert

This Expert appears:

- when you choose the Find command from the Edit menu, then click Advanced Find.
- when you click the Find button on the Standard toolbar, then click Advanced Find.

Use the Search Expert to search for specific values in a report.

Note: The Search facility is only available in the Preview tab.

##### 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.

##### Search Direction

Choose the Forward option to search the records from your current position in the report forward to the end of the report.

Choose the Backward option to search the records from your current position in the report backward to the beginning of the report.

Note: If you do not have a field selected, the Search will begin at the top of the current page.

##### Search

Click this button to begin a search.

##### New

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

##### Delete

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

##### Browse

The Browse button has been included as an aid in selecting the values that define your search. When you click this button, the program displays a list of field values for the records 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.

##### Formula Editor

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

##### Show/Hide Formula

Search 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.

##### Add

Type a new search value in the box, then click this button to add it to the list.

##### Delete

Click this button to delete the currently selected field value from the list.

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