Category: Tips

July 17, 2019
Why Is It Important to Use Supported SQL Server Views with SCCM Reporting?

While I was at the Midwest Management Summit at the Mall of America (MMSMOA) in May, the topic of supported SQL Server views came up. Someone mentioned an easy way…

July 10, 2019
RBA and Non-RBA Queries: When is Slower Actually Faster?

Up until now, my experience working with SCCM’s Role-Based Administration (RBA) queries showed them to be slower than the normal SQL Server views. My thoughts changed, however, when I recently…

July 3, 2019
How to Send a Smile to the SCCM Product Team

Starting with SCCM current branch version 1806, you can now send feedback to Microsoft directly through the console. Send a smile or a frown is part of this new feedback…

June 26, 2019
Why Did My Column Headers Stop Working in SSRS 2016?

What happened to my column headers in SQL Server Reporting Services (SSRS) 2016?! This was the question I kept asking myself over and over again. It took some time, but…

June 19, 2019
How to Deploy SSRS Reports from Visual Studio to the SSRS Server

Normally, I work on SQL Server Reporting Services (SSRS) reports in Visual Studio until they are done, so I don’t need to deploy SSRS reports directly to the SSRS server….

June 12, 2019
MP Function Error After Re-Attaching the SCCM Database

As I write this blog post, I am sitting in my hotel room after a long day of Midwest Management Summit at the Mall of America (MMSMOA) sessions. Here I…

May 29, 2019
How to Add Repeating Header Rows Within a SSRS Matrix

I am working a lot with matrices these days for a new SQL Server Reporting Services (SSRS) report in Enhansoft Reporting. The more I use a matrix the more things…

May 22, 2019
What Are the Supported SQL Server Views to Use with SCCM Reporting?

Have you ever wondered what SQL Server views you can use with SCCM current branch reporting? You wouldn’t be alone in asking this question because the views are not clearly…

May 8, 2019
How to Enable Interactive Sorting in a SSRS Matrix

Interactive sorting is one of my favorite features and I think it is under-used. I add it to all of my reports, but the other day I made a discovery….

May 2, 2019
How to Tint Images Using Snagit

We decided to update one of our reports in Enhansoft Reporting to give it a more modern look and feel. Part of the enhancement involved purchasing some stock images of…