Tips & Tricks
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 100% correct! I was troubled because I couldn’t figure out why, if my queries were correct, I was...
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 TO SETUP PBRS TO USE A Certificate
The blog post was originally post in 2019, however based on feedback, update it to provide more details. It is continuation from How To Request Certificate to Use HTTPS / SSL On SSRS or PBRS, where I left off after showing you how to prepare Power BI Report...
How To Request Certificate for PBRS or SSRS
Originally, I posted back in December 2019 as blog set one How to Setup SSRS to user HTTPS, parts 1 and part 2. Since the original I had a number of questions and clarifications about both posts. So, I thought that I would update the whole set. This first in the set...
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...
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 to know, automatically, how many rows are within a table instead of counting each one? I think...
How to Quickly Rebrand the ConfigMgr Reports
Have you ever wanted to rebrand the ConfigMgr reports with your own logo? This video and blog will show you how to do it. Default Branding Above is what the default Microsoft branding looks like. It works but it would be better if it had my logo on it. How to Quickly...
How to Quickly Rebrand the ConfigMgr Reports
Have you ever wanted to rebrand the ConfigMgr reports with your own logo? This video and blog will show you how to do it. Default Branding Above is what the default Microsoft branding looks like. It works but it would be better if it had my logo on it. How to Quickly...
How to Configure AD Certificate Server
This step-by-step guide will show you how to configure AD certificate server. Active Directory (AD) Certificate Services acronym is either ADCS or AD CS. You should also note that many people will call it a cert server or just certs. This article assume that you have...
How to Install AD Certificate Services
A Microsoft Endpoint Configuration Manager (MEMCM / MECM / SCCM / ConfigMgr) administrator wears many hats. One of the hats means that we need to know about Certificate. This is becoming more import as thing move to the cloud and become more secure. Most ConfigMgr...