Report Viewer in ASP.NET - Subreport page 2 goes back to Main report page 2 on paging

Report Viewer in ASP.NET - Subreport page 2 goes back to Main report page 2 on paging by Robz1

Closed

as Fixed

Type:	Bug
ID:	311781
Opened:	11/21/2007 10:43:11 PM
Access Restriction:	Public

Workaround(s)

view

User(s) can reproduce this bug

What we've found is that when you have two reports where one navigates to the other, if you click on the second page of the second report, it takes you to the second page of the original report. If you navigate over to the subreport again and click for the second page, it works appropriately. This is definitely a no-go for production code and this may delay our ship date because I would think this is definitely undesirable.

Conditions:
*ASP.NET Report Viewer using Remote Reports
*Report that links to another report
*Both reports output more than one page
*Reporting Services installed

Here is a link with source code and a more detailed explanation: http://geekswithblogs.net/robz/archive/2007/11/21/Reporting-Services-2005-BUG-Report-Linking-and-Paging---ASP.NET.aspx

So what I am looking for is both a workaround for now and if this is determined to be a bug, to be fixed in the next service pack.

Also posted on the forums here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2444497&SiteID=1&mode=1

Details (expand)

English

SQL Server 2005 SP2 - Enterprise Edition

Reporting Services

Windows XP SP2 Professional

US English

1. Download the source code here: http://geekswithblogs.net/robz/archive/2007/11/21/Reporting-Services-2005-BUG-Report-Linking-and-Paging---ASP.NET.aspx
2. Follow the directions (near the bottom of the post) to get the project set up.
3. Run it and click on a link in the first report to go to the second report.
4. Click the arrow for page 2 of the second report.
5. Notice how it takes you back to page 2 of the first report (this doesn't happen when you are in preview mode in the Reporting Services project and I don't believe it does this in a smart client application).
5. Click on a link in the first report to go back to the second report.
6. Click the arrow for page 2.
7. Notice how it takes you to page 2 of the second report.

Clicking on page 2 of the second (linked) report takes you to page 2 of the original report.

Clicking on the arrow for page 2 of the second (linked) report should take you to page 2 of the second (linked) report.

1 attachments

ReportingTests_10.zip

Posted by Robz1 on 11/28/2007 at 1:39 PM

Go to the subreport. Try printing it.

Now try to export it.

It prints AND exports the original report.

Posted by Microsoft on 12/3/2007 at 11:37 AM

Thank you for reporting this issue. This bug has been fixed in our VS 2005 SP1 redist, available here:

Full Install:
http://www.microsoft.com/downloads/details.aspx?FamilyId=E7D661BA-DC95-4EB3-8916-3E31340DDC2C&displaylang=en

Upgrade:
http://www.microsoft.com/downloads/details.aspx?FamilyId=35F23B3C-3B3F-4377-9AE1-26321F99FDF0&displaylang=en

Posted by Robz1 on 11/28/2007 at 2:39 PM

http://geekswithblogs.net/robz/archive/2007/11/28/Reporting-Services-Workaround.aspx

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

Posted by Robz1 on 11/28/2007 at 2:41 PM

I have a workaround that we found today.
http://geekswithblogs.net/robz/archive/2007/11/28/Reporting-Services-Workaround.aspx

Basically you subscribe to the drill through event of the report viewer and inject the reportviewer.Reset() function. This seems to be a good workaround for the issue above, but I would still like to see the bug get fixed.

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