title: Crystal Reports Does Not Show Data From View
body: <p>Using VS2010, Oracle 11g.</p>
  
  <p>I have a view linking two tables:</p>
  
  <pre><code>SELECT table1.Address1, table1.Address2, table1.City, table1.Name
  table2.product_name, table1.product_num
  FROM table1
  inner join table2
  on table1.orderid = table2.orderid
  </code></pre>
  
  <p>I can see all the fields from table1 but none from table2.</p>
  
  <p>When I right click on the table2 field and choose "Browse Data", I do see results.</p>
  
  <p>When I click on "Main Report Preview" - I see results.</p>
  
  <p>When I run (F5) I DO NOT see the results, nor when I put the report on the server.</p>
  
  <p>I put some code in the report to tell me that the fields are empty when generated.</p>