Wonky Column Headers in SSRS
Have you run in to issues where your SSRS column headers just won’t scroll with the data? How about losing the column headers when you go to your next page? Well, there seems to be some ambiguity about this topic,…
cseferlis
SSRS Calculating and Converting Time with Expression
Recently I came across a challenging issue with calculating a time span within a group inside an SSRS Report. I am working on an issue where I need to be able to calculate labor pace operations per hour, and the…
Pragmatic Works SSRS Master Class Review
A little while back, the boys from Pragmatic Works (www.pragmaticworks.com) came up to Boston for their “Master” level training series on SSRS. I attended the class, and wanted to share my experience so other interested people can get a preview…
Take 1: My first presentation at Sql saturday
I just recently presented at my first SQL Saturday event, SQL Saturday#334 – The Boston BI Session, and wanted to share my experience for future first-timers in the hopes it might help them with their presentations. Special thanks to Mike…
Unable to deploy package to ssis 2014 Catalog
Recently ran into trouble because our Active Directory environment was upgraded to 2012, and I could no longer deploy packages to our SQL Server 2014 SSIS Catalog due to the following error: A .NET Framework error occurred during execution of…
Odd authentication behavior
Just recently I came across some odd behavior when trying to connect to my SQL 2012 server via and SSIS package and ultimately SSMS from an external connection. I’ll cut to the chase and tell you that the error I…
SSRS 2008R2 Parameterized Reports stop working
SSRS 2008R2 Parameterized Reports suddenly stop working After a recent round of Windows Updates, one of my SQL Server Reporting Server 2008 R2 users complained that reports were not working properly. After some digging, I realized that in-fact, some of…