Please help i wanted to display all this in one RDLC report header (school) and the rest in the details view.
whe i run it it shows error A data source instance has not been supplied for the data source 'DataSet1'.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
CategoryReport.Text = Request.QueryString("CategoryReport")
If Not Me.IsPostBack Then
If CategoryReport.Text = "Finance" Then
ReportViewer1.ProcessingMode = ProcessingMode.Local
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Reports/Sumsummary.rdlc")
Dim dsCustomers As SumsmaryDataset = GetData("select class,total from Sumsummary")
Dim datasource As New ReportDataSource("Customers", dsCustomers.Tables(0))
Dim dsCustomerst As SchoolDetailsdataset = GetDataschool("select school,box,telephone,email from Schools")
Dim datasource2 As New ReportDataSource("SchoolDetailsdataset", dsCustomerst.Tables(0))
ReportViewer1.LocalReport.DataSources.Clear()
ReportViewer1.LocalReport.DataSources.Add(datasource)
ReportViewer1.LocalReport.DataSources.Add(datasource2)
'ReportViewer1.LocalReport.DataSources.Add(New Microsoft.Reporting.WebForms.ReportDataSource("SchoolDetailsdataset", dsCustomerst))
Else
BindReport()
End If
'ReportViewer1.LocalReport.Refresh()
End If
End Sub