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 [...]

In SQL  Server 2008, Reporting Services got quite an overhaul with many features that I really like. In SQL Server 2008 R2, there are even more improvements in  Reporting Services that I am anxious to put into production. There is one new feature in particular that I,  like many report developers, am eagerly anticipating – [...]