1744309 - Option of Stored Procedure is missing in Crystal Reports under Database Expert.

SAP Knowledge Base Article - Public

1744309 - Option of Stored Procedure is missing in Crystal Reports under Database Expert.

Symptom

  • Option of Stored Procedure is missing in Database Expert.
  • In OLEDB connection the option for Stored Procedure is not available.

Environment

  • Crystal Report 2008
  • Ms Access 2010 

Reproducing the Issue

  1. Open Crystal Reports and click on blank report.
  2. Expand the option of Create New Connection and navigate to OLEDB.
  3. Click on it to create a new connection. A new window will pop up to select the drivers.
  4. Select the driver which is highlighted in the image given below. This is the only available driver with OLEDB connection.
  5. Once you are connected to the database expand the connection option.

driver.JPG

 Note: The option of Stored Procedure is selected under Data Explorer in Connection Options but still the option of Stored procedure won't be visible. Refer the image given belowstore proc missing.JPG

Cause

When you create a connection under OLEDB, the drivers available are Microsoft Office 12.0 Access Database Engine OLEDB Provider. Using these drivers when a connection is made the option of Stored Procedure is not available in Database Expert.

Resolution

  1. Create a System DSN using the latest drivers for accdb file i.e. 14.00
  2. Create an ODBC connection from Crystal Reports
  3. Now the option of Stored procedure will be listed under the connection in Crystal Reports.

Keywords

KBA , BI-RA-CR , Crystal Reports designer or BusinessViews Manager , Problem

Product

Crystal Reports 2008 V0 ; Crystal Reports 2008 V1