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, we’ll take a closer [...]

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