Rendering a large report in SharePoint mode fails with maximum message size quota exceeded error message

Recently, i was working on a scenario where reporting services 2012 was configured in SharePoint 2013 integrated mode. We were exporting a report that was ~240MB in size. When we do that, the reports fails with the following exception: 07/19/2017 13:37:57.46  w3wp.exe (0x2C80)                        0x0834 SQL Server Reporting Services  Service Application Proxy      00000 Monitorable Notified the…

0

URL access with rc:Toolbar command fails with rsRenderingExtensionNotFound

Recently i was working on a scenario where Reporting Services 2016 is configured for SharePoint (Applicable to both 2013 and 2016) integrated mode. Now, when you use URL access with the rc:Toolbar command, the reports would fail with the following error: You have attempted to use a rendering extension that is either not registered for this report server or…

0

Configuring Reporting Services 2016 with ARR

Recently, i was working on a deployment where we need to configure SQL Server Reporting Services 2016 with ARR so that reporting services is exposed over the internet without exposing the machine itself. If you are looking for such implementations, then this guide is for you. Please do note that I’ve tested this against Reporting Services…

0

Intermittent E_ACCESSDENIED when opening SSRS related contents

Have you ever wondered why does your Reporting Services behave in a weird way when you either try to access report manager page or open a report or open a shared data source etc. by throwing errors like: (You’ll find these errors either in the page itself on in the Reporting Services log files located under…

0

IE 11 browser support for Reporting services versions prior to 2012

I frequently come across customers who use IE 11 to view reports (From Report manager as well from applications using Report viewer controls) that are deployed on Reporting service version prior to 2012 and end up in facing unexpected viewing experiance right from: Multi line tool bar Print button not visible. Page getting stuck with just…

3

Using Report Viewer control in ASPX pages

If you’re developing a ASP.NET page and planning to use the Microsoft Report Viewer web control for showing reports that are deployed to SSRS prior to 2016, here is a word of recommendation for you. Make sure the page that hosts the Report viewer control has the compatibility setting enabled as shown below: You need…

2

Performance improvement feature request for the Reporting Services in SharePoint mode

If you are looking for features outlined in the connect site and would like to see this improved, please feel free to visit these links and vote for the feature as this will help Microsoft to prioritize these items. 1. Configurable value for the number of report executions to keep in the history (for back…

0

Displaying fixed number of rows in Report using expression based page break

Have you ever ran in to a requirement where you want to accommodate only X number of rows in a page? Have you ever wondered how this can be achieved through Reporting services? In the first place, Is it even possible to achieve this? I have one answer for all the questions and that is…

0

Using Reporting Service web part with SharePoint custom master pages

Recently I and my team were working on an interesting issue where when you use a custom master page built out of a HTML script with the help of SharePoint 2013, the reports that are referred with in a web part page doesn’t render. Here is the article that could help you with building custom…

5

SSRS SharePoint List data provider querying a SharePoint List in Claims enabled site with Windows and Forms Based Authentication selected

Have you tried creating a report in BIDS / SSDT / Report Builder 3.0 using the Reporting Services(SSRS) SharePoint List extension against a SharePoint list in a Claims based SharePoint site? The Claims authentication has both Windows and Forms based authentication enabled. The unique property for the SSRS SharePoint list provider is, it only accepts windows…

0