SQL Expression Can Not Be Used In Report

See more:

VB

CrystalReports

Hello Friends,
i am working with Crystal Report with Vb.Net i got the Error like as below
" SQL Expression Can Not Be Used In Report".

Dim rpttitle As String = "All Data Of Employee"
      Dim rptcomment As String
      con = New SqlConnection("Data Source=192.168.101.102;Initial Catalog=test_data;Persist Security Info=True;User ID=wml;Password=win")
      con.Open()

      'cmd = New SqlCommand("select * from test where dt ='" & Format(CType(DateTimePicker1.Text, Date), "MM/dd/yyyy") & "' , con)
      'cmd.ExecuteNonQuery()

      adpt = New SqlDataAdapter("select * from test where dt between'" & Format(CType(DateTimePicker1.Text, Date), "MM/dd/yyyy") & "'and '" & Format(CType(DateTimePicker2.Text, Date), "MM/dd/yyyy") & "' order by dt", con)
      ds = New Data.DataSet
      adpt.Fill(ds)

      If ds.Tables(0).Rows.Count > 0 Then

          Dim strRptName As String = "D:\Dipak Nakum\Fil_Pipe_Calculator\Fil_Pipe_Calculator\WindowsApplication1\reports\Report1.rpt"
          rptcomment = "Date Between " & Format(CType(DateTimePicker1.Text, Date), "dd/MM/yyyy") & " And " & Format(CType(DateTimePicker2.Text, Date), "dd/MM/yyyy")
          rpt.Load(strRptName)
          rpt.SetDatabaseLogon("wml", "win")
          rpt.SetDataSource(ds.Tables(0))
          rpt.SummaryInfo.ReportTitle = rpttitle
          rpt.SummaryInfo.ReportComments = rptcomment
          CrystalReportViewer1.ReportSource = rpt

end if

end sub

in the dataset which ever is output i want is i got in the dataset . i have done debugging deelpy bu t i don't found any error till last line, there is no any error comes till last line , then after above error was shown.