Select Expert Dialog Box
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). When using the Select Expert, the program automatically generates a record or group selection formula based on settings you specify in the dialog box.
This dialog box appears when you right-click in the Report Designer, point to Report and click Select Expert, or when you click the Select Expert button in the Crystal Reports toolbar.
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. |
| 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. |
| Delete | Click this button to delete the active selection formula and its associated tab. |
| 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. |
| Formula Editor | When you click this button, the Formula Editor appears with the selection formula shown in the Formula text box. |