Category: Tips

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 19, 2020
How to Use GetColor in a SSRS Chart

This is the second blog post of a three-part set that shows you how to create a color palette code, how to use it and then how to match the…

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 26, 2020
How to Install Power BI Report Server 2019

In order to keep my Microsoft Endpoint Manager Configuration Manager (MEMCM/SCCM) reporting guides current, I decided to write blog posts about how to install SQL Server 2019 and Power BI…

February 19, 2020
How to Install SQL Server 2019

With the release of SQL Server 2019, I thought that I would create a blog post on how to install it. This way my blog posts about reporting in System…

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…

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,…

January 22, 2020
AVMA License Keys for Windows Server 2019

It’s time to update my old AVMA license keys blog post! What are AVMA license keys? Automatic Virtual Machine Activation (AVMA) license keys are used to license virtual machines (VMs)…

January 15, 2020
Add Tables to the ConfigMgr Data Warehouse

Back in October, I was asked via Twitter, what tables (apart from the default ones) do I add to my Configuration Manager (ConfigMgr/SCCM/MEMCM) data warehouse? That was a great question…