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 always recommend that you create your query within SQL Server Management Studio (SSMS). How do you...

Enabling the Ruler within BIDS or SSDT

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! Whenever I use BIDS or SSDT I have to enable the ruler and I find this very frustrating. Since I...

BIDS Error – Passing Variables to Stored Procedures, Part II

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 Message #3 This error message is about having too many variables passed to the stored procedure. The solution to...

BIDS Error – Passing Variables to Stored Procedures, Part I

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 of our SQL Server Reporting Services (SSRS) reports, so I’m more likely than most to...