Last week I posted about a bug in the SQL Reporting Services Report Viewer for ASP.NET. I think today after someone's suggestion we found a possible workaround. If we subscribe to the DrillThrough event on a report and then reset our ReportViewer before displaying the report, it works as it should.
Add the below to the default.aspx Code Behind File.
Private Sub rvReports_Drillthrough(ByVal sender As Object, ByVal e As Microsoft.Reporting.WebForms.DrillthroughEventArgs) Handles rvReports.Drillthrough
Dim rpt As ServerReport = CType(e.Report, ServerReport)
rvReports.Reset()
rpt.Refresh()
End Sub
Follow all of the directions in the previous post to get the thing to run and you are set. Done. Like dinner. P0wn3d!