patternMinor
SSRS Report joining data sets in BID 2008
Viewed 0 times
ssrs2008bidreportsetsdatajoining
Problem
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.
Thank you.
Solution
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.
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.
Context
StackExchange Database Administrators Q#23572, answer score: 4
Revisions (0)
No revisions yet.