Expression in filter - filters too many records
Posted: Mon Jul 30, 2012 7:11 am
I hope you can help me with this. I have set up filters with expressions in my report, but it is not working as I expected. My business objects:
List of realestates. Each realestate can have a list of owners. (A realestate can also contain another list of realestates with owners.) Each owner has a boolean property called DoNotSend. It is this property I want to filter on. When I set up the expression, all owners for a real estate are filtered away - not just the individual owners.
I have sent a sample project to your helpdesk. There are two buttons on the main page : Full report and filtered report.
The class ReportDesignerData contain the data that populates the report. As you can see in the sample, about half the owners have DoNotSend set to true. I therefore expected 50% of the owners to show up in the filtered report. Instead there are none.
Can you please take a look? Your help would be greatly appreciated.
List of realestates. Each realestate can have a list of owners. (A realestate can also contain another list of realestates with owners.) Each owner has a boolean property called DoNotSend. It is this property I want to filter on. When I set up the expression, all owners for a real estate are filtered away - not just the individual owners.
I have sent a sample project to your helpdesk. There are two buttons on the main page : Full report and filtered report.
The class ReportDesignerData contain the data that populates the report. As you can see in the sample, about half the owners have DoNotSend set to true. I therefore expected 50% of the owners to show up in the filtered report. Instead there are none.
Can you please take a look? Your help would be greatly appreciated.