none
Lookup in RDLC Local Report

    Question

  • Hi Everyone,

     

    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,

    Jesse

    Sunday, May 30, 2010 12:04 AM

Answers

  • The Lookup functionality isn't available in local mode, but it does work if you point the ReportViewer control to your SS2008R2 server.

    Thanks,
    Jamie

    Sunday, May 30, 2010 3:43 PM

All replies

  • The Lookup functionality isn't available in local mode, but it does work if you point the ReportViewer control to your SS2008R2 server.

    Thanks,
    Jamie

    Sunday, May 30, 2010 3:43 PM
  • Ok then, thanks Jamie.

     

    Monday, May 31, 2010 1:50 AM
  • Is there any alternative for this. Because I tried to use an custom assembly to overcome this issue. but in .NET 4.0 it also not possible due to some security implementation(CAS). 
    Saturday, September 17, 2011 6:04 AM