Category: SSDT

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…

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

By Garth Jones 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…

May 18, 2017
How to Install SQL Server Integration Services Tools

By Garth Jones I’m working on a project to clone a SQL Server database (aka the ConfigMgr database) because a customer wants all querying and reporting off-loaded from the main…

May 16, 2017
How to Insert a Report Description into a ConfigMgr Report

By Garth Jones Oftentimes I get my best ideas for blog post topics from you! This time is no exception. In this blog post I’ll walk you through the process…

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

By Garth Jones 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…