Revision history [back]

To select data in Crystal Reports, follow these steps:

1. Open the Crystal Reports program and create a new report or open an existing one.

2. Click on the "Database" menu and select "Show SQL Query."

3. In the SQL Query window, write a SELECT statement that specifies the fields you want to retrieve from your database. For example: SELECT CustomerName, OrderNumber, OrderDate FROM Orders

4. Add any necessary WHERE clauses to filter the data. For example: WHERE OrderDate >= '1/1/2020' AND OrderDate <= '12/31/2020'

5. Click on the "Database" menu and choose "Verify Database" to ensure that the query runs correctly.

6. Preview the report to see the selected data.

Note: You can also use the "Select Expert" tool in Crystal Reports to specify more complex selection criteria.