Referencing Data in multiple datasets
Hi, I have 2 datasets, 1 using SQL to reference data and the other is fetchxml to MSCRM2011 Dataset1 has a list of numbers Dataset2 has a List of numbers and relating Names I need to be able to look up the name of the value in Dataset1 from Dataset2 Is this possible, if so how? Thanks Pete
February 25th, 2011 4:33pm

anyone?Pete
Free Windows Admin Tool Kit Click here and download it now
February 27th, 2011 2:43am

I think that is available only since SQL Server 2008 versionBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
February 27th, 2011 2:45am

This is 2008 R2. How is it done? Are there any guides? I cant find any :( ThanksPete
Free Windows Admin Tool Kit Click here and download it now
February 27th, 2011 2:50am

Take a look at LOOKUP function http://prologika.com/CS/blogs/blog/archive/2009/08/12/reporting-services-lookup-functions.aspx http://msdn.microsoft.com/en-us/library/ms170438.aspxBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
February 27th, 2011 2:57am

Hi Pete, Have you solved your issue following Uri's reply? Please give a feedback. I think Lookup function should work for you, actually, we could use Lookup to retrieve the value from the specified dataset for a name/value pair where there is a 1-to-1 relationship. For example, for an ID field in a table, you can use Lookup to retrieve the corresponding Name field from a dataset that is not bound to the data region. If you want to retrieve multiple values for a single name or key field where there is a 1-to-many relationship, use LookupSet Function (Report Builder 3.0 and SSRS). To call Lookup for a set of values, use Multilookup Function (Report Builder 3.0 and SSRS). For more information about Lookup Function (Report Builder 3.0 and SSRS), please see: http://msdn.microsoft.com/en-us/library/ee210531.aspx Thanks, Challen Fu Challen Fu [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Free Windows Admin Tool Kit Click here and download it now
March 4th, 2011 8:30pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics