Hi I am loading my report and using this line of codes
I'm thinking how can I change the command if I want to filter the output on my report.Code:Dim reportData As New ReportDataSource Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Me.ReportViewer1.LocalReport.ReportPath = Application.StartupPath & "\\Report1.rdlc" Me.ReportViewer1.LocalReport.DataSources.Clear() Dim ds As New WindowsApplication1.DataSet1 Dim da As New WindowsApplication1.DataSet1TableAdapters.tbl_sentTableAdapter da.Fill(ds.tbl_sent) reportData = New ReportDataSource("DataSet1", ds.Tables(0)) Me.ReportViewer1.LocalReport.DataSources.Add(reportData) Me.ReportViewer1.RefreshReport() End Sub
on my table I have 'date' column. I want to insert a filter by date range sql command on my current code.




Reply With Quote