This blog post covers using Report Builder 3 (with Microsoft SQL Server 2008R2) to lookup a value in another dataset. Scroll straight to the bottom for the key function, the rest of the article is setup. NOTE: The back end of this example is an Oracle database but the solution will work for any database, you just will need to modify the SQL. Start Report Builder 3Select "Blank Report" from the New Report or Dataset wizard.Right click "Dataset"...
