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 1
Applies to:
.rpt Inspector 2 Professional Suite (for CR5.x-CR8.5)
Applies to:
.rpt Inspector 2 Professional Suite (for CR9.x-CR10.x)
Applies to:
.rpt Inspector 3 Professional Suite (for CR 8.5)
Applies to:
.rpt Inspector 3 Professional Suite (for CR 9)
Applies to:
.rpt Inspector 3 Professional Suite (for CR 10)
Applies to:
.rpt Inspector 3 Professional Suite (for CR XI)
Applies to:
.rpt Inspector 3 Professional Suite (for CR XIr2)
Applies to:
.rpt Inspector 3 Enterprise Suite (for CE 9 / CR 9)
Applies to:
.rpt Inspector 3 Enterprise Suite (for CE 10 / CR 10)
Applies to:
.rpt Inspector 3.1 Enterprise Suite (for CE 9 / CR 9)
Applies to:
.rpt Inspector 3.1 Enterprise Suite (for CE 10 / CR 10)
Applies to:
.rpt Inspector 3.1 Enterprise Suite (for BO XI / CR XI)
Applies to:
.rpt Inspector 3.1 Enterprise Suite (for BO XIr2 / CR XIr2)
