SAP Knowledge Base Article - Public

1701719 - Tables and Views are not shown in Database Expert with Microsoft ODBC(RDO) connection in Crystal Reports 2008

Symptom

  • Tables and Views are not seen in Microsoft ODBC(RDO) connection.
  • Same Tables and Views can be seen using Oracle Server (Oracle Native Client) connection.
  • In Crystal Reports Designer -> File -> Options -> Database, checkbox for Tables, Views and Stored Procedures is checked.
  • No Table level or Owner level filter is applied.
  • Only Stored Procedures can be seen.

Environment

  • Crystal Reports 2008 SP03
  • Oracle 10g

Reproducing the Issue

  1. Create a new report in Crystal Reports 2008
  2. Select the Microsoft ODBC (RDO) connection that points to Oracle 10g database
  3. No Tables or  Views are displayed

Resolution

  1. Open Crystal Reports 2008
  2. Go to File -> Options -> Database
  3. Uncheck the checkbox for Stored Procedures and click on Ok
  4. Create a new report on Microsoft ODBC (RDO) connection
  5. You will see the Tables and View under the ODBC (RDO) connection

Keywords

Tables and View not displayed, issue ODBC connection, Crystal Reports 2008 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

Crystal Reports 2008 V1