Category: SQL Server Data Tools

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….

August 15, 2018
How to Leverage the Interactive Sorting Feature in SCCM Reports

Have you ever watched someone use one of your reports/dashboards? I have and it is always fascinating to see how someone will review the data. If they have prior experience…

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…

October 26, 2017
What Happened to the Tools Gauge in My SSRS Dashboard?

In the screenshot below, you can see that there is clearly an issue with the Tools gauge in my SQL Server Reporting Services (SSRS) dashboard. The purple arrow is pointing…

October 25, 2017
How Do I Bulk Upgrade SSRS RDLs from SQL Server 2005 to SQL Server 2008 R2?

I discussed how I needed to update each SQL Server Reporting Services (SSRS) RDL in yesterday’s blog post called, “What Does the Error Message, “Unknown Report Version 9.0,” in Visual…

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…

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 8, 2017
Query Designer in SQL Server Management Studio (SSMS)

By Garth Jones The other day I was showing a ConfigMgr Administrator how to write a query and also how to create drill-throughs from within his reports. I began by…