Category: Visual Studio

June 26, 2019
Why Did My Column Headers Stop Working in SSRS 2016?

What happened to my column headers in SQL Server Reporting Services (SSRS) 2016?! This was the question I kept asking myself over and over again. It took some time, but…

June 19, 2019
How to Deploy SSRS Reports from Visual Studio to the SSRS Server

Normally, I work on SQL Server Reporting Services (SSRS) reports in Visual Studio until they are done, so I don’t need to deploy SSRS reports directly to the SSRS 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…

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

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 was converting the…