deborahhowson00
asked on
SSRS Return Data from One Dataset where it does not exist in another
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I figured out how to do it myself.
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.
Like this.
Open in new window