Category: Reports

March 25, 2020
How to Match the Colors in a SSRS Chart and Table

This is the third and final blog post of a three post set that shows you how to create a color palette code, how to use it in a chart…

March 11, 2020
Color Palette Codes in SSRS Defined and Explained

This blog post is the first in a three-part set on how to create, use and synchronize color palette codes when using a chart, a table or a matrix in…

February 12, 2020
Unexpected Power BI Results? Turn Off the Keep All Filters Option

Let me begin by telling you how I ended up writing this blog post. It all started when one of my first Power BI report sets was still in development….

February 5, 2020
Why Am I Getting Incorrect Results in Visual Studio?

When I first encountered this issue, some time ago, I checked all of my queries in SQL Server Management Studio (SSMS) and guess what? As I suspected, the queries were…

February 3, 2020
Computer AutoStart Software Details

February 2020’s free Configuration Manager (ConfigMgr/SCCM/MEMCM) giveaway is the Computer AutoStart Software Details report. This report is available in both Power BI and SSRS formats. Why do you need this…

January 29, 2020
How to Hide Unused Rows in a Tablix

Hi All! I’m sure that each and every one of you have used a Tablix at one point or another when creating SQL Server Reporting Services (SSRS) reports. All rows,…

December 24, 2019
Top 10 Configuration Manager Posts in 2019

With the end of 2019 in sight, I thought it would be useful to look back and see what posts were the most popular this year. After reviewing the posts,…

November 27, 2019
How Do You Add the Total Number of Computers in a SSRS Table?

Today, I’m going to show you how to add the total number of computers in a SSRS table. This is a slightly different take on what my colleague Leonard showed…

November 19, 2019
How to Add the Total Number of Rows in a SSRS Table

Hi Everyone! Today I want to talk about a very simple, but effective feature that you can setup on your SQL Server Reporting Services (SSRS) reports. Wouldn’t it be useful…

November 13, 2019
How to Add a Card to Display the Total Number of Computers in a Power BI Table

Hi Everyone! In this blog post I show you how to add a card in order to display the total number of computers in a Power BI table. It doesn’t…