Home Dashboard Directory Help
Search

Easy to reproduce, significant SSRS performance degradation when using Go To Report actions by samsonfr


Status: 

Active


21
0
Sign in
to vote
Type: Bug
ID: 833306
Opened: 3/13/2014 5:40:51 AM
Access Restriction: Public
0
Workaround(s)
view
6
User(s) can reproduce this bug

Description

Affected Products
•    Reporting Services 2008, 2008 R2 and 2012 – Integrated mode
•    Windows SharePoint Services 3.0, SharePoint Foundation 2010 / 2013

Problem description
When a SSRS report uses Go To Report for actions, performance degrades at every hit, regardless of:
•    Destination report (it can be the same report);
•    Number of parameters (problem was reproduced with 1 parameter);
•    Execution endpoint:
o    RSViewerPage.aspx(worse degradation)
http://testserver/BIDSTest/_layouts/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/BIDSTest/SSRS/GoToReportPerformanceIssue.rdl&Source=http%3A%2F%2Ftestserver%2FBIDSTest%2FSSRS%2FForms%2FAllItems%2Easpx&DefaultItemOpen=1
o    Report Server
http://testserver/reportServer/?http%3a%2f%testserver%2fBIDSTest%2fSSRS%2fGoToReportPerformanceIssue.rdl&rs:Command=Render
•    Report complexity: sample report is self-contained using embedded dataset ;
•    Browser: IE9, IE10, IE11, Chrome.
Details
Sign in to post a comment.
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
GoToReportPerformanceIssue.zip 3/13/2014 3 KB
Microsoft Support Issue - GoToReport.pdf 3/13/2014 431 KB
Tests results.xlsx 3/13/2014 13 KB