How to Create a Color Palette for Your MECM Reports

I often get asked how someone without a visual arts background can choose or create a color palette for Microsoft Endpoint Configuration Manager (MECM) reports. I’ll admit that I’m not great at mixing colors together either, but I’ve learned a few tricks along the...

How to Create Cascading Prompts

Prompts are extremely useful because with a prompt you can limit what is displayed within a report. You can get even more granular results when you add a second or a third prompt. Adding additional prompts, however, can lead to some minor inconveniences and unintended...

Display a Date in a Text Box

The idea for this blog post was on my list of “things to do” for quite a while. Why? Again, and again, I saw comments such as, “My date is in the wrong format,” and, “I just want the short date, I don’t need the time.” There are numerous ways to solve these problems,...

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, by default, are displayed in a Tablix, but in some instances, you may want to hide unused rows and allow...

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 you in last week’s post, How to Add the Total Number of Rows in a SSRS Table. Before starting, I must tell you...

Power BI Title Padding Work Around

Hi Everyone! Here’s a problem that I encountered with Power BI title padding and how I solved it. I created this great Power BI report set about mapped printers that is part of Enhansoft Reporting. As soon as I finished designing the home page, I instantly saw the...