title: Crystal Report Table Cannot Be Found Error
body: <p>All. </p>
  
  <p>I using SAP Crystal Reports for Enterprise 4 and have created a custom report. When generating the report via the application (Syteline ERP) I get the below error. </p>
  
  <p>Crystal Experienced an exception while executing [ExecuteReport]; The table Rpt_TestSp;1 could not be found.</p>
  
  <p>There are many custom reports, that all run fine, which use the same data connection that I've chosen when building this report. (SQL Server ODBC using the sa account as auth)</p>
  
  <p>The ODBC connects without issue. I can choose my Stored Procedure and see all of the relevant columns and I can also see the data in Crystal on the Page Designer. </p>
  
  <p>Can anyone offer some advise on how to troubleshoot this? </p>
  
  <p>I've already ran SQL Profiler and it's not even getting to the EXEC Rpt_TestSp;1. I believe it's failing in Crystal first.</p>