Hello,
I am trying to get a drillthrough report working in Visual Web Developer Express 2005, using the Report Viewer. I have created a report that is the parent report. I have created the report that is the report that is being "drilled to". There are no parameters for the report that is being "drilled to". I set the Jump to Report to the "drill to" report in the parent report. I added the listed code to the Load and Drillthrough events in the ParentReport.aspx.vb file. When I run the ParentReport.aspx.vb file the data appears fine. When I click on one of the values that sends me to the "drill to" report, the report header appears and there is no data. I have tested the "drill to" report directly and the data appears. So, there is nothing wrong with the "drill to" report. Can someone please help me?
Protected
Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
'Add a handler for drillthrough.
AddHandler ReportViewer1.Drillthrough, AddressOf DrillthroughEventHandler
End Sub
Public Sub DrillthroughEventHandler(ByVal sender As Object, ByVal e As DrillthroughEventArgs)
Dim localReport = e.Report
'prepare report data source
Dim rds As ReportDataSource = New ReportDataSource()
Dim dsReport As New BirthdayDataSet
rds.Name =
"BirthdayDataSet_HoursTable"
rds.Value = dsReport.Tables(0)
localReport.DataSources.Clear()
localReport.DataSources.Add(rds)
End Sub
Thanks,