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.





    • Related Articles

    • Unable to Connect Using macOS DSN Configuration

      If you’ve installed an ODBC driver on macOS but can’t proceed with setting up a DSN because the iODBC Data Source Administrator app is missing, here’s how to resolve the issue. Step 1: Install iODBC Manager To test and manage ODBC connections on ...

    • Setting up a Connection to ODBC in Delphi Using Devart ODBC Driver

      This guide will walk you through the steps of setting up a connection to an ODBC driver in Delphi. We'll use ODBC Driver for Salesforce as an example. Prerequisites: Devart ODBC Driver for Salesforce installed on your machine. A Salesforce account ...

    • Using ODBC Drivers with Power BI Online

      Power BI Online supports working with ODBC drivers, but to ensure proper functionality—especially for scheduled data refresh—you need to configure the setup correctly. Make sure the Power BI Data Gateway is installed on the same computer where the ...

    • Setting up a Connection to QuickBooks Desktop Using Devart ODBC Driver

      This knowledge base article provides step-by-step instructions on how to set up a connection to QuickBooks Desktop using the Devart ODBC Driver. Following these steps will help you successfully connect to QuickBooks Desktop and retrieve your ...

    • Setting up a Connection to Power BI Online Using Devart ODBC Driver

      In this guide, we will walk you through the process of setting up a connection to Power BI Online using the Devart ODBC Driver. This involves creating a DSN connection, setting up an on-premises gateway, and verifying Power BI report settings. Step ...