Dataset with multiple DataTables

[mkasuboski]

I was wondering if I can set a report's datasource equal to a Dataset that contains multiple datatables, and in the code-behind for the report set the different sections to a specific table from the dataset, i.e. the ReportHeader Section, the Detail Section, etc.

This code would be in the ASPX page to create the dataset and datatables, and then bind them to the report.

            Dim mainDataSource As New DataSet
            Dim rptHeader As New DataTable("rptHeader")
            Dim rptDetail As New DataTable("rptDetail")
            Dim rptFooter As New DataTable("rptFooter")
            mainDataSource.Tables.Add(rptHeader)
            mainDataSource.Tables.Add(rptDetail)
            mainDataSource.Tables.Add(rptFooter)

            Dim sampleReport As New MySampleReport
            sampleReport.DataSource = mainDataSource

So is there a way in the report to bind a specific section to a table out of the dataset?

Thanks!

[Steve]

Hi mkasuboski,

The DataSource can be set only once directly to the report and is applicable for the whole report (all sections). For your scenario you might take advantage of the subreport and table report items.

Kind regards,
Steve
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.