How can we join to Data sets in SSRS? For example we have Dataset1 and Dataset2 and the common columns between them are c1 and c2. I know we can use lookup, but wondering if there is a shortcut like using variables to do that based on your experience?
Thank you.
Best Answer
Hi I am afraid that this is not possible in 2008. You can workaround it though by implementing the logic in the dataset itself or you can create sub-reports to achieve what you are after.
However, if you have the ability to use a 2008R2 instance you can indeed do what you are asking by using the Lookup functions. Here is more information on it:
LOOKUP:
http://msdn.microsoft.com/en-us/library/ee210531.aspx
LOOKUPSET:
http://msdn.microsoft.com/en-us/library/ee240819.aspx
I hope this helps you.