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.
So is there a way in the report to bind a specific section to a table out of the dataset?
Thanks!
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!