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

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

Report exported to PDF causes all the spaces in between the words to be compressed

Have you come across a similar situation when you’ve a report with textbox within or outside a tablix, containing an expression. When you view the report in browser everything looks great. The moment you export the report to PDF and open the same, to your disappointment you see the space in between the words are…

0

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

#Error on RDLC report with built in report server fields running on and above .NET 4.0 with ASP.NET role manager enabled

How many times you’ve run in to the issue where you see #error for any build in Reporting service fields (or even for some expressions for that matter) with role manager enabled for the ASP.NET site running on and above .NET framework 4.0? Whatever you do, nothing changes until you disable the Role manager? If…

1

ReportViewer control with SSRS 2012 in SharePoint Integrated mode throws rsExecutionNotFound exception

With ReportViewer control, you could do wonders towards your reporting capabilities within your windows and web applications. Recently I had an interesting scenario to work with. We have an ASP.NET web page with ReportViewer control pulling server side reports from Reporting services 2012 which is in SharePoint integrated mode. If you’ve a doubt on whether…

1

Bursting the mysteries of InvalidReportParameterException in Reporting service

When you’re working with subscribing to a report that contains parameters and the source table of the parameter has a nature of updating, deleting and inserting the values frequently, then there is a very good chance that you would have experienced this issue. Here is a typical scenario: You have a report that has a…

0