Category: Report Builder

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…

August 21, 2019
No Rows – What It Is and Why You Should Use It

Instead of showing empty report sections because a query produced no results, I wanted to add some text to explain the outcome. I turned to an option called, No Rows,…

July 24, 2019
Setting Up Security for SCCM Power BI Reports

What do I mean by, “Setting up security for SCCM Power BI reports?” First, in order to create and run Power BI reports, you need to access the SQL Server…

March 13, 2019
How to Add a Dynamic Image into a SSRS Report for SCCM

How many times have you wanted to make your System Center Configuration Manager (SCCM) SSRS reports quickly convey a small piece of information? Adding a dynamic image might be exactly…

October 10, 2018
Set the Page Size of SCCM Reports

I always talk about the importance of doing the little things when it comes to enhancing reports and dashboards and also when it comes to creating reports in Power BI….

July 18, 2018
How Can I Install Report Builder?

Why would you want to install Report Builder? I must admit that I don’t use Report Builder an awful lot, but I find it particularly useful when I can’t access…

July 11, 2018
Seven Tips for Writing SCCM Dashboards

At the last Midwest Management Summit which was held at the Mall of America, I was stopped in the hallway after one of my SCCM reporting presentations. I was asked…

June 27, 2018
How to Start Editing SCCM Reports with Report Builder

Did you know that you need a Role-Based Administration (RBA) security role when you want to edit System Center Configuration Manager (SCCM) Current Branch or 2012 R2 reports with Report…

January 10, 2017
How to Change the AutoRefresh Time on a SQL Server Reporting Services (SSRS) Report

This question comes up from time to time, “I have a dashboard report and I want it to refresh automatically every two minutes. How can I do this?” Or worse…

November 9, 2016
How to Set the Page Size for a ConfigMgr Report

You took the time to make sure that your report fits perfectly onto a landscape-sized letter page (11 x 8.5 inches) or an A4 (210 x 297 mm). When you…