title: How to change schema name in Crystal report 11?
body: <p>The report is being designed in Crystal Reports XI. </p>
  
  <p>It uses an ODBC connection to an Oracle database using the CR Oracle ODBC driver 4.1. </p>
  
  <p>I need this report to be easily distributed across 14 sites that use the same ODBC DSN, but the database at each site has a different owner and/or schema name.</p>
  
  <p>I followed Business Objects instructions to modify the fully qualified name for each table in a report:</p>
  
  <ol>
  <li><p>On the 'Database' menu, click 'Set Datasource Location'. The 'Set Datasource Location' dialog box appears.</p></li>
  <li><p>In the 'Current Data Source' area, expand the list of current connections in order to view each table in the report.</p></li>
  <li><p>For each table in the report:</p>
  
  <p>i. Expand the 'Properties' list.</p>
  
  <p>ii. Click 'Overridden Qualified Table Name', and then press the F2 key or double-click.</p>
  
  <p>iii. Move the cursor to the end of the text and type the table name.</p>
  
  <p>iv. Press Enter.</p></li>
  </ol>
  
  <p>I am getting error </p>
  
  <blockquote>
    <p>Crystal Reports</p>
    
    <p>Failed to retrieve data from the database.</p>
    
    <p>Details: ORA-00942: table or view does not exist</p>
    
    <p>[Database Vendor Code: 942 ]</p>
  </blockquote>
  
  <p>I either need a fix for these errors or a better way to make these Oracle reports more portable.</p>