The first step in record selection is to define your criteria for selection. For example, do you want to focus on one city or customer, or are you interested in specific regions or countries? Would a date range or all records below a particular value work best?
The Select Expert dialog box defaults to "any value." If you enter a choice other than "any value" in the drop-down list box, a second drop-down list appears that contains some sample data from your database. You can choose values directly from the drop-down list or manually enter the value at the cursor prompt.
If you are familiar with the Crystal formula language, you can enter your formula here. You can click Show Formula to view the formula, if any, used by Crystal Reports. You can also activate the Formula Editor from this extended window and modify the formula. For example, you want only the records in which profits are over a certain percentage. Once the percentage is calculated, the record selection decides whether the record is included on the report.