How to display multiple table data in crystal report

See more:

C#

C#4.0

The project contains two tables 1) PatientTB & 2) ListTB,
PatientTB contains all patient details, and ListTB consist of item that patient's purchase.
now the column Patient_Id is an primary key in PatientTB and same column is an foreign key to ListTB table.
when I create a crystal report with anyone of above table it works fine.
but when I select both the tables no data will display.

if I select PatientTB or ListTB from dataset crystal report will work fine.
but selection of both tables can not display anything because of relationship of primary-foreign key in both the tables.

my query is :

con.Open();
cmd = new SqlCommand("SELECT Date,Doctor,Patient.Patient_Id,Patient_Name,Contact_No,Payment_Type,Item_Count,Grand_Total,List.Batch_No,List.Item_Code,List.Item_Name,List.Exp_Date,List.Qwantity,List.MRP,List.Amount FROM Patient INNER JOIN List ON Patient.Patient_Id = List.Patient_Id WHERE Patient.Patient_Id = '" + Main.txt_crs_pid.Text + "'", con);
SqlDataReader sdr = cmd.ExecuteReader();
DataTable dt = new DataTable();
dt.Load(sdr);
CrystalSale report = new CrystalSale();
report.SetDataSource(dt);
crystalReportViewer1.ReportSource = report;
con.Close();

Thanking you in advance.