title: How to populate Crystal Report with data from multiple tables from SQL Server in VB.NET?
body: <p>I used the following:</p>
  
  <ul>
  <li>VB.NET in Visual Studio 2015</li>
  <li>SQL Server 2014 which I installed together with Visual Studio</li>
  <li>Crystal Reports service pack 18</li>
  </ul>
  
  <p>I am using a service-based database in Visual Studio. I created my Crystal Report by dragging database fields from the field explorer and finally placing the report in the Crystal Report viewer on a form. I didn't create a connection in the Crystal Report wizard because a dataset already exists. The dataset has multiple tables connected with a foreign key. </p>
  
  <p>This is the only code I used and placed it on the load event of the form. 
  My problem is the report loads with no data. </p>
  
  <pre><code>    Dim cryRpt As New ReportDocument
      cryRpt.Load("C:\Users\...IndividualReport.rpt") ' sample path
      CrystalReportViewer1.ReportSource = cryRpt
      CrystalReportViewer1.Refresh()
  </code></pre>