I'm building a RDLC (local) report for a .NET app in Visual Studio 2008 and I am attempting to display a value from a second table in the DataSet in a field on a table in the report. Searching forums I see there is a 'Lookup' function you can use in SS 2008 R2 to accomplish this task. The Visual Studio 2008 report builder however does not recognize this command even after SS2008R2 is installed.
Does anyone know what I need to install or setup to get this working from the Visual Studio 2008 report builder?
Thanks in advance,