Link Multiple Tables in Crystal Report with Foreign Key

checked connection string .its rite. and checked also query its executed and returned data...

this s my coding
DataSet dd = null;
dd = getdatasetfromquery("SELECT DISTINCT P.PNo, P.PDate, P.PM, P.DisAmt, P.NT,P.LT,P.EID,C.EName FROM PurchaseDetails AS P INNER JOIN CustomerDetails AS C ON P.EID = C.EID");

Report_PurchaseAll_View report1 = new Report_PurchaseAll_View();
ConnectionInfo crConnectionInfo;
Tables crTables;
TableLogOnInfo crTableLogOnInfo;
crTables = report1.Database.Tables;
crConnectionInfo = new ConnectionInfo();
crConnectionInfo.ServerName = ValidationT_SQLC.Path;
crConnectionInfo.DatabaseName = ValidationT_SQLC.Name;

foreach (CrystalDecisions.CrystalReports.Engine.Table aTable in crTables)
{
crTableLogOnInfo = aTable.LogOnInfo;
crTableLogOnInfo.ConnectionInfo = crConnectionInfo;
aTable.ApplyLogOnInfo(crTableLogOnInfo);
}
report1.SetDataSource(dd.Tables[0]);
crystalReportViewer1.ReportSource = report1;
crystalReportViewer1.Refresh();

public DataSet getdatasetfromquery(string query)
{
DataSet ds = new DataSet();
cmd = con.CreateCommand();
cmd.CommandText = query.ToString();
cmd.CommandType = CommandType.Text;
da = new SqlCeDataAdapter(cmd);
da.Fill(ds);
return ds;
}

tnks for fast reply... i got solutions