SSRS Return Data from One Dataset where it does not exist in another
Posted on 2013-11-18
Hi, I am using Report Builder 3 on SQL 2008 and am wondering if it is possible to return values in one dataset based on whether the value is present in another dataset.
For example, my first dataset is the one my Tablix is based on and has a list of property references.
My second dataset just pulls through a list of property references that have a certain charge against them.
I don't want to see the properties in my first dataset if they exist in the second dataset?
Many thanks in Advance.