SAP Knowledge Base Article - Public

1925391 - Crystal Reports cannot find table

Symptom

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

Environment

  • 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

Cause

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

Resolution

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

Keywords

  • 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

Product

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