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 out that the gauge is not displaying properly. What’s the matter with it? In this blog post, I...

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 report’s page size from centimeters to inches and changing the page layout from A4 to 11” x 8.5” (letter...

Query Designer in SQL Server Management Studio (SSMS)

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 recommending that reports should be created in SQL Server Management Studio (SSMS) and then the finished SQL Server...

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 the SQL Server 2008 R2 format. In this blog post I will show you where to find the SQL Server 2008 R2 RDL in...