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

Demystifying Last Run column in Report Manager Details View

We often see our reporting services users asking us the question why the “Last Run” column in Report Manager details view is blank. This post would help you to get the necessary clarification on the behavior. The Last Run column was supposed to only show the value when the report is based on execution snapshots….

0

Reporting services support for Microsoft EDGE browser

EDGE is the latest browser released by Microsoft along with Windows 10. There are so much of questions around the supportability of SSRS with Microsoft EDGE browser. Microsoft EDGE is not supported till SQL Reporting services 2014. The browser supportability till SSRS 2014 stands as it is documented in https://msdn.microsoft.com/en-us/library/ms156511(v=sql.120).aspx. However the good news is…

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