Page 1 of 1

Filter by Data in Master

Posted: Fri Jul 24, 2009 7:26 am
by Andreas Tastler
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

Filter by Data in Master

Posted: Fri Jul 24, 2009 10:16 am
by Brendan
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.

Filter by Data in Master

Posted: Thu Aug 13, 2009 1:56 am
by Andreas Tastler
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

Filter by Data in Master

Posted: Thu Aug 13, 2009 2:41 am
by Brendan
Hi

Try this Download