SAP Knowledge Base Article - Public

1256159 - Error in file <report name>.rpt: The table could not be found.

Symptom

  • Create a crystal report based on MYSQL as reporting database.
  • Get error "Error in file  <report name>.rpt: The table could not be found." while opening a report from Infoview.
  • Report works fine in designer

Environment

  • Crystal Report server 2008
  • Database: MYSQL
  • Windows 2003

Reproducing the Issue

  1. Create a Crystal Report based on MYSQL.
  2. Save the Report to Enterprise.
  3. Refresh the Report in InfoView, get error "Error in file  <report name>.rpt: The table could not be found."

Cause

If the database name has a underscore ’_’ and the MYSQL driver version is older then 3.51 then it creates the issue

Resolution

1. Update the version of ODBC driver for MYSQL to 3.51.25 or greater version.

OR

2.Make the copy of database and save it with different name ( without underscore) and point the crystal report to it.

Keywords

MYSQL , underscore, database,table , KBA , BI-BIP-ADM , BI Servers, security, Crystal Reports in Launchpad , Problem

Product

Crystal Reports Server XI R2