Skip to content
ODBC and client applications › Create data sources from other apps using ODBC driver › Additional integration resources › Web services › API implementation › API implementation and reference
Release: Australia · Updated: 2026-03-12 · Official documentation · View source

Use the ODBC driver in Crystal Reports

After installing the ODBC driver and its associated DSN, use it in Crystal Reports as a data source provider.

About this task

Note: Crystal Reports includes the configuration file CRConfig.xml that contains the JVM minimum heap size (Xms) and maximum heap size (Xmx) values. When configuring the ODBC driver with Crystal Reports, ensure that the ODBC driver uses the same minimum and maximum JVM heap size as Crystal Reports. If these values do not match, update the ODBC driver settings, not the Crystal Reports settings.

Procedure

  1. Create a new Standard Report.
Image omitted: CrystalStandard.png
Crystal Reports Standard Report
  1. Create a new connection using the ServiceNow DSN.
Image omitted: ServiceNowDSN.png
Creating a New Connection Using the ServiceNow DSN
  1. Select a table from the list of available tables.
Image omitted: AvailableTables.png
Selecting a Table from List of Available Tables
  1. Select the available fields from the selected table.
Image omitted: AvailableFields.png
Selecting the Available Fields from the Selected Table
  1. Click Finish to render the report.
Image omitted: RenderedCrystalReport.png
Rendered Crystal Report

Parent Topic:ODBC and client applications