Filter by Data in Master

Andreas Tastler · Post by **Andreas Tastler** » Fri Jul 24, 2009 7:26 am

Hi all

I have Master/Detail databands based on a dataSet with two tables and a relation.
Is it possible to use a filter expression, which compares to data from the master databand?

The master databand contains information of a person, the detail databand shows related persons.
In my case I want to filter all related persons, who do not have the same state as the main person.
So i tried the filter expression

Code: Select all

detailTable.State != masterTable.State

But this does not work...

Thanks
Andreas

Brendan · Post by **Brendan** » Fri Jul 24, 2009 10:16 am

Hi,

What you describe seems to be the correct thing to do.

Here is a sample that lists Customers and their Addresses. The Customer.PrimaryAddressID is filtered from the CustomerAddresses.AddressID Detail Databand.
Download Sample

You should be able to see the filter on the CustomerAddressesDataBand that does this.
The Data is hard coded into the reports Code Behind.

Andreas Tastler · Post by **Andreas Tastler** » Thu Aug 13, 2009 1:56 am

Hi Brendan

Thanks for your answer. I read it today because I was in holiday.
I tried to download your sample, but the server seems to be down?

Thanks
Andreas

Brendan · Post by **Brendan** » Thu Aug 13, 2009 2:41 am

Hi

Try this Download