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.
I would just filter your dataset that feeds the Tablix.
OR You could change the first query to include a nested query that excludes the properties with a charge.
Open in new window