how to connect using odbс in Crystal Reports

how to connect using odbс in Crystal Reports

Connecting to an ODBC source.

Create a Crystal Reports application and select a report type.




Click on Create New Connection >> ODBC

From the list of available connections, select the connection we need:





After selecting a connector, a list of available driver objects for building a report will appear:




We can select objects in the following ways:

-visually move objects (tables and columns) using Drag and drop to the right object selection area

-Apply the query script (by clicking on "ADD Command")





    • Related Articles

    • how to work in Power Query using odbс driver

      Connect to an ODBC source. In the Power BI Desktop Home tab, select Get Data> to connect to an ODBC source. From the list of available connections, select the required DSN connection created in ODBC-Administration You can familiarize yourself with ...

    • How to Connect to MySQL Server

      In the second article of the series uncovering how to get started with MySQL, we talk about the ways of connecting to MySQL Server. You can connect to MySQL Server using MySQL Client, dbForge Studio for MySQL, and MySQL Workbench. In this article, we ...

    • unable to connect macOS DSN Configuration

      On Mac, I installed the ODBC driver to connect . This driver is installed successfully but in this directory, the IODBC Data Source administer apk is not created. So I do not perform the next steps. lease be informed that to check the test ...

    • How to Install MySQL on Windows Using MySQL Installer

      The article provides a comprehensive walkthrough outlining the aspects of how to install MySQL Server on Windows using MySQL Installer. Learn the subtleties of the MySQL installation process step-by-step to ensure you have MySQL Server together with ...

    • System Views Missing in SSMS When Using Devart Connector as a Linked Server

      We wanted to inform you that the necessary information can be obtained by accessing the following internal views: SYS_TABLES - lists available tables and their parameters SYS_COLUMNS - lists table columns, determines to which tables they belong, ...