Search Results: LookUpSet function

• 
  LookUp and LookUpSet Functions New in SSRS 2008 R2

  With the release of R2 came a couple of pretty nifty new expressions in SSRS. The LookUp function allows us to perform a look up against a separate data set in our report using a field in our source data set where there is a 1 to 1 relationship. Likewise,

  Author:  DustinRyan     Date: 7/27/2011     Section: Blog

  tags : Join function, LookUp function, LookUpSet function, SSRS 2008 R2
• 
  Using SharePoint List data in a Stacked Column Chart in SSRS 2008 R2

  I need to create a Stacked Column Chart with data from SharePoint 2010. What is the best way to get counts from the SP list grouped on one value? I have tried using separate datasets and the LookUpSet function, but I get errors trying to get the count. I

  Author:  skoch     Date: 5/30/2012     Section: Forum

  tags : sharepoint 2010, SSRS 2008 R2, Stacked Column Chart
• 
  Report from two data sources/data sets

  I don't know of a way to join two SSRS datasets together in a data region outside of LookUp and LookUpSet functions: http://sqldusty.wordpress.com/2011/07/27/ssrs-2008-r2-lookup-and-lookupset-functions/ . Maybe that will be of some help.

  Author:  DustinRyan     Date: 10/25/2011     Section: Forum
• 
  Can we pull the data from two data marts in SSRS?

  If you're asking how to join datasets in a single SSRS report, the only way you'll be able to do that is to use the LookUp and LookUpSet functions: http://sqldusty.wordpress.com/2011/07/27/ssrs-2008-r2-lookup-and-lookupset-functions/ But if you're just as

  Author:  DustinRyan     Date: 8/31/2012     Section: Forum