I have created a crystal report and tried to attach it to a dataset so I get certain rows from a table to populate the report with, but the report is pulling all the data from the table, so I end up with a report that fills over 300 pages. I have tried to attach the viewer to the report and the dataset using the code below.

        Dim oReport As New ItemsReport
        Dim ItemsData As New DataSet

        ItemsData.Clear()
        ItemsData = CItems.ItemsReport(ItemsReportJobID)


        oReport.SetDataSource(ItemsData)
        CrystalReportViewer1.ReportSource = oReport

Thanks,

Louisa