Selecting data to be use in a report

See more:

VB

SQL

SQL-Server

Visual-Studio

, +

I wrote the following code to open a report using visual basic, however what I would like to do is select a range of dates in which I want to use as the sample for the report. I tried a select statement and tried feeding that into the report but got a dataset error.

If anyone would help me out that would be great!

Dim reportDataSource As New ReportDataSource
Try
    With Me.ReportViewer1.LocalReport
        .ReportPath = "C:\CallReport.rdlc"
        .DataSources.Clear()
    End With
    Dim ds As New OCTCADataSet
    Dim da As New OCTCADataSetTableAdapters.CallDataTableAdapter
    da.Fill(ds.CallData)

    reportDataSource = New ReportDataSource("DataSet1", ds.Tables("CallData"))
    Me.ReportViewer1.LocalReport.DataSources.Add(reportDataSource)
    Me.ReportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.Normal)
Catch ex As Exception
    MsgBox("Could not compile and open that report.")
End Try