SAP Knowledge Base Article - Public

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


  • 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.


  • 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


  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


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


Crystal Reports 2008 V1