well thanks expert team it solve some of my prob but tell me how can i pick up reports on sql query basis bcz it works in sql but doesnt shows any result there would be a single command plz tell me that or if just ignore the sql query method hten its possible for to do it with record selection formula........i just wrriten code here plz tell me for this...........the prob is that i used also record selection formula then it gives arror that "remaining part of text is not a part of this" so wats this prob.........solve this also i know it was a time problem when picking it from database how it can be solve and how i can rid of this itme prob..........here is the code
Dim ds1 As New DataSet
If cn.State = ConnectionState.Open Then
cn.Close()
End If
cn.Open()
Try
With da
.SelectCommand = New OleDbCommand
.SelectCommand.Connection = cn
.SelectCommand.CommandText = "select * from invoice where datepart(vdate) = '" & dt2.Value & "' between '" & dt3.Value & "' "
.Fill(ds1, "invoice")
End With
Dim obj As New crv2
'obj.RecordSelectionFormula = "{invoice.vdate}= '" & dt2.Value & " ' "
rpt2.ReportSource = obj
rpt2.Refresh()
Catch ex As Exception
MsgBox(ex.Message)
End Try
