How to Connect Using ODBC in Crystal Reports

How to Connect Using ODBC in Crystal Reports

Crystal Reports allows users to build custom reports by connecting to various data sources. To connect using an ODBC driver, follow these steps:

Step 1: Create a Crystal Reports Application

​

Launch Crystal Reports and create a new report. Select a report type suitable for your needs.

Step 2: Connect to an ODBC Source

Click on Create New Connection, then choose ODBC from the list of connection options:

Step 4: Choose Objects for the Report

After connecting, a list of available tables and views (driver objects) will appear.

You can add data to your report in two ways:

- Drag and drop tables and columns into the selection area on the right.

- Use a custom SQL query by clicking Add Command.