As you might have guessed if you’ve been reading my blog lately, I’ve been spending a lot of time working with the business intelligence features in SQL Server 2008 R2. Not just Reporting Services, but the whole BI stack. However, it just so happens that today is T-SQL Tuesday and the topic this month is Reporting [...]

Today’s post is the 3rd post in a series about the new lookup functions in SQL Server 2008 R2 Reporting Services. I covered the Lookup function in Part I of this series and the MultiLookup function in Part II.  The third and final lookup function is LookupSet. First, a quick review. The Lookup function evaluates one value per row in [...]

In today’s post, I’m continuing an exploration of the lookup functions in SQL Server 2008 R2 Reporting Services. I began with the Lookup function in Part I of this series.  In general, the lookup functions allow you to combine data from two datasets in a single data region in report. There are three lookup functions available: Lookup MultiLookup LookupSet Today, [...]

SQL Server 2008 R2 Reporting Services is loaded with features for the report author. In today’s post and two posts that will appear next week, I’ll explore the lookup functions which enable you to combine data from two datasets in a single data region which not possible in earlier versions of Reporting Services. If all of [...]

In earlier versions of Reporting Services, when you create or modify a data source in Report Manager, you don’t have a straightforward way to confirm that the connection string or credentials are valid at the time that you save the data source. Instead, you must open a report that uses that data source to ensure [...]