Category: BIDS

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…

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…

November 9, 2016
How to Set the Page Size for a ConfigMgr Report

By Garth Jones You took the time to make sure that your report fits perfectly onto a landscape-sized letter page (11 x 8.5 inches) or an A4 (210 x 297…

September 8, 2016
Dashboards for ConfigMgr

By Garth Jones I hear this all the time: I need a dashboard, but you can only create reports for ConfigMgr, so I need third-party software. Not true, I say!…

February 18, 2016
SQL Query Troubleshooting Tip

By Garth Jones Before starting to write a SQL Server Reporting Services (SSRS) report, you need to create a SQL query that will be used within the report and I…

October 27, 2015
Trouble Finding the Report Data Window Pane in BIDS 2008 R2/SSDT?

By Garth Jones In the past, I created a lot of reports by using Business Intelligence Development Studio (BIDS) 2005, but now I’m working on a project for a client…

October 21, 2015
Enabling the Ruler within BIDS or SSDT

By Garth Jones The disabled ruler feature within SQL Server Data Tools (SSDT) and SQL Server Business Intelligence Development Studio (BIDS) (post SQL 2005) is one of my pet peeves!…

February 26, 2014
Business Intelligence Development Studio (BIDS) Error – Passing Variables to Stored Procedures, Part II

By Garth Jones As promised in yesterday’s blog post, here are a couple more BIDS error messages that I come across from time-to-time with quick ways to fix them. Error…

February 25, 2014
Business Intelligence Development Studio (BIDS) Error – Passing Variables to Stored Procedures, Part I

By Garth Jones Every so often I run across errors involving passing variables to stored procedures when I’m using Business Intelligence Development Studio (BIDS). We use stored procedures for all…