1496698 - Error: "Error in File <name of the report>: The Table could not be found" when viewing a Crystal Reports report

• Get the error when viewing a report using stored procedure as customized data source location
• Creating new report from the same stored procedure has no issue
• The error occurs only when data source location is changed dynamically at view time
• Error: "Error in File <name of the report>: The Table could not be found"

• Crystal Reports Server XI Release 2 Service Pack 5 (CRS XIR2 SP5)

0. Create a report using stored procedure in Crystal Reports designer.
0. Publish or save it to Enterprise folder.
0. Login to CMC as administrator.
0. Click Folders then go to the folder where the report created at step 1 is stored.
0. Click the report title, click Process tab, then click Database.
0. Click radio button Use custom database logon information specified here, then specify new location of stored procedure.
0. Click Update button.
0. Click Properties.
0. Click Preview button then get the error.

The issue has been identified and logged under Problem Report ID ADAPT01218364.

The issue has been fixed in Fix Pack 5.4 for BusinessObjects Enterprise XI Release 2 but no fix is delivered for CRS XIR2 since CRS XIR2 SP5 is the final release for the CRS XIR2 series.

Workaround:

• Downgrade to SP4
• Use newer crdb_odbc.dll that is delivered with Fix Pack 5.4, Service Pack 6, or later patches for BusinessObjects Enterprise XI Release 2 or Crystal Reports XI Release 2

1481948 - Error; The Table 'table_name' could not be found when using the Report Designer Component

1497646 - Error: "Error in File <name of the report>: The Table could not be found" when viewing a Crystal Reports report

database, stored procedure, stored function, datadirect, odbc, change, 1218364 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , BI-BIP-SDK , Obsolete; BI-DEV-JAV, BI-DEV-NET-SDK, BI-DEV-WEB , Bug Filed