Does .rpt Inspector support ODBC drivers?

Synopsis

My connectivity uses ODBC. Does .rpt Inspector™ support ODBC connectivity?

Solution

Unlike Crystal Reports®, .rpt Inspector™ does not require connectivity for the majority of actions that you'll perform. You can make changes to the various properties without connectivity because you are are modifying the report template's existing objects and their properties.

There are two exceptions:

  • If you'd like to see a preview, that requires combining the template with data and that is when .rpt Inspector does need to make a connection to your database.
  • When working with the data source / database wizard, a connection to your destination database must be made for the process to work.
  • Version specific notes / restrictions / guidelines

    .rpt Inspector™ 1 (all builds): .rpt Inspector™ version 1 only supports ODBC connections to generate a preview. And the Datasource wizard only supports ODBC connections as well. However, if an ODBC connection requires a password, this version of .rpt Inspector does not prompt for one. The work around has been to establish a connection to the data source outside of .rpt Inspector first.

    Starting with .rpt Inspector™ 2 (all builds) and beyond: There is now support for ODBC / OLE DB / Native DB2 / Native Informix / Native Oracle / Native SQL Server / Native Sybase. When making connections to a database that requires authentication, you will be prompted for a user ID and password.

    Applies to

    .rpt Inspector 2 Professional Suite (for CR9.x-CR10.x)
    .rpt Inspector 3 Professional Suite (for CR 8.5)
    .rpt Inspector 3 Professional Suite (for CR 9)
    .rpt Inspector 3 Professional Suite (for CR 10)
    .rpt Inspector 3 Professional Suite (for CR XI)
    .rpt Inspector 3 Professional Suite (for CR XIr2)
    .rpt Inspector 3 Enterprise Suite (for CE 9 / CR 9)
    .rpt Inspector 3 Enterprise Suite (for CE 10 / CR 10)
    .rpt Inspector 3.1 Enterprise Suite (for CE 9 / CR 9)
    .rpt Inspector 3.1 Enterprise Suite (for CE 10 / CR 10)
    .rpt Inspector 1
    .rpt Inspector 2 Professional Suite (for CR5.x-CR8.5)
    .rpt Inspector 3.1 Enterprise Suite (for BO XI / CR XI)
    .rpt Inspector 3.1 Enterprise Suite (for BO XIr2 / CR XIr2)