SAP Knowledge Base Article - Public

1925391 - Crystal Reports cannot find table


Refreshing a report that was moved from Development to Production cannot find a table


  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013

Reproducing the Issue

  1. Migrate reports from Development to Production
  2. Refresh reports
  3. Receive an error about cannot find table


Production database is missing select rights for your user on specific tables needed for the report


Ensure all tables used in reports and sub reports have select permission granted to your user


  • Cannot find field
  • Remove table from report
  • report now fixed up
  • report now verified
  • ODBC
  • subreport
, KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013