Category: Visual Studio

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…

January 17, 2019
Finishing Touches: Adding a Row Count to Your Report

Over the last six months or so, I published a number of blog posts about many different types of finishing touches you can add to your reports and this post…

August 8, 2018
Adding a Prompt Value to the Title of a SCCM Report

Little things do make a difference and this is especially true when it comes to SCCM reports. Oftentimes in my report writing sessions I don’t have time to show folks…

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…

October 24, 2017
What Does the Error Message, “Unknown Report Version 9.0,” in Visual Studio 2015 Mean?

A long time ago I started working on two projects using SQL Server Business Intelligence Development Studio 2005 (BIDS). I wanted to keep working on these projects, so I upgraded…

October 19, 2017
How Do You Install SQL Server Data Tools?

Many of my blog posts about tips and tricks for reporting (mostly SQL Server Reporting Services (SSRS)) focus on System Center Configuration Manager (SCCM). Recently I noticed, while writing another…

October 5, 2017
Why is Using a SQL Server Alias for Column Names Important?

Here’s the error message that I kept getting, “Could not update a list of fields for the query. Verify that you can connect to the data source and that your…

June 22, 2017
How to Change the Page Measurements and Paper Size of a SSRS Report

By Garth Jones I recently was sent a SQL Server Reporting Services (SSRS) report that needed to be edited and updated. One of the items that I was tasked with…

June 6, 2017
SQL Server Data Tools (SSDT) and RDL Versions

You built your report using SQL Server Data Tools (SSDT) which saves the RDL in the SQL Server 2016 format. That’s great, but now you need the native RDL in…