Crystal Reports  

Basic Record Selection

The Select Expert makes it easy to specify the records you want included in your report. When you work with the Select Expert, you select the field to which you want to apply selection conditions and then you specify those conditions.

The Select Expert can be used to set up simple record selection requests. For example:

The Select Expert can also be used to set up some sophisticated requests:

These are all range limit requests. One or more constants define the range. The program compares the field value in each record to the constant(s) and rejects records with values outside the range. The report is limited to values within the range. You can set up all of these types of record selection requests without any previous knowledge of the formula language.

Note   The Select Expert can be used to set up both record selection and group selection requests. When a group name or summary field is selected, the program knows that the selection criteria set up is intended for group selection. In all other cases, the program knows that you are setting up record selection.

To set up record selection using the Select Expert

  1. Right-click in the Crystal Reports ActiveX Designer, point to Report and click Select Expert.
  2. In the Choose Field dialog box, highlight the field on which you want to base record selection and click OK.
  3. In the Select Expert dialog box, use the drop-down lists to enter your selection criteria for the indicated field.
    Tip   To base record selection on more than one field, click the New tab. Select the next field from the Choose Field dialog box.
  4. Click OK when finished.

    A selection formula is generated based on your specifications, limiting the report to the records you indicated.

    Note   To view the selection formula, click the Show Formula button. The Select Expert expands to show the formula. Click the Formula Editor button to modify the formula.

See Also

Pushing Down Record Selection to the Database Server | Customizing Record Selection Formulas