SAP Knowledge Base Article - Public

1292392 - Error: 'The database table cannot be found...' when refreshing a report in Crystal Reports

Symptom

  • Error: The database table cannot be found.
  • When performing a Verify Database, it display the message: "Table cannot be found..."
  • When refreshing a report in Crystal Reports, it fails with the error: 
        
     "The database table "<Table Name>" cannot be found. Proceed to remove this table from the report?"
       
      
     Table Cannot be found.png

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Reproducing the Issue

  1. In Crystal Reports, open a report.
  2. When refreshing the report, it displays the following message:  
    "The database table "<Table Name>" cannot be found..."

Cause

  • The table displayed in the error message does not exist on the database the report connects to; or
  • The user connecting to the database does not have rights to see the tables.

Resolution

  • Contact your Database Administrator to:
    • Verify the table(s) exist on the database.
    • Verify your report is connecting to the right database.
    • Verify the user used to connect to the database, have rights to see the table(s) on the database.

Keywords

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

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020