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
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