Category: Business Intelligence Development Studio

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…

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

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…

January 29, 2014
BIDS Error

By Garth Jones If you work with Business Intelligence Development Studio (BIDS), on very rare occasions you may see the following two errors: This server version is not supported. You…

December 17, 2013
SCCM 2007 Built-in Reports Do NOT Open in Report Builder 1.0

By Garth Jones I was working on some of the built-in System Center Configuration Manager 2007 (CM07) SSRS reports when I tried to access one of the reports via Report…