problem to send commandtext to crystalreport

See more:

C#

SQL

CrystalReports

hi i use this code to execute a query and it works to show result in datagridview exactly right(3 records).but when i want to send it to crystalreportviewer it will show 30 rocords!!
i create crystalreport by using the wizard in 2010.

here thid code:

cmd.commandtext="select fname,lname,startDate,EndDate from personel,leave where personid=id and id='"+txtID.text+"'";
da.selectcommand=cmd;
da.fill(dt);
form1 newform=new form1();
crystalreport1 cr=new crystalreport1();
cr.setdatasource(dt);
newform.crystalreportviewer1.reportsource=cr;
newform.show();

problem is:
query works in datagridview,BUT no works in crystalreport viewer.
when query is on one table,everything is ok,BUT no works for 2 tables which have relationships.
thanks