Reporting Services tip: document outline

If you are relatively new to Reporting Services, it can be difficult to keep track of all the report elements. Your report quickly gets cluttered with elements that are contained within each other. Not a lot of people seem to be aware that there is an option called 'Document outline', that makes it easy to
Continue reading...

Are you doing all the work?

Scenario 1: You're standing in front of the class. The training you're giving is going fantastic...it is your favorite subject and you can easily talk about this for hours on end. After the course your students fill in a survey about how well they like your course and the reactions aren't that great. What's going
Continue reading...

Package generation with SSIS - an overview

Although you can hardly ignore BIML (with bloggers like Cathrine Wilhelmsen and Bill Fellows sharing good stuff), there are still other options for package generation in SSIS. While enjoying a small conversation on LinkedIn about the automation options, I suddenly remembered still having a slidedeck from a presentation I gave early 2014. Please note that these are my
Continue reading...

Visual Studio Eror Messages

Yes, that typo was intended. Remember when I said this? [Using Google to find a solution to] Error messages? Be sure to include the exact message - "in quotes" Recently I encountered a occasion where this helped especially well. A colleague emailed me with the question why his VS2010 install didn't load his SSRS Preview correctly. The 'Run' functionality worked, but the
Continue reading...

SSRS client side printing

Yesterday I was working with a client who virtualized all desktops using Citrix. Whenever you want to use the print function of an SSRS report, you are required to install an ActiveX plugin. However, end users are not allowed to install new software on a virtualized desktop, and Microsoft doesn't provide a direct link to a generic installer that could be
Continue reading...