Hi All,

I need a bit of help with one of my reports. Any advice is appreciated.

I'm designing a report running on a bank account report listing the current balances. This is linked to a static table to establish if the account currency is the functional currency of a given company or not. So I have a flag to say "Y" or "N". Which is working just fine for all items.

In the select expert I choose to only display all items with flag "N". However after this not all of the items are displayed even though they had "N" flag before.

Thanks

Thanks.
All my tables are joined with left outer link. And this N flag is the only selection criteria.
What I don't understand is that if I don't have any selection criteria than all my records are displayed some with flag N some with Y.
If in Select expert I set this formula field to be N only then only the items with N flag are displayed but not all of them. It seems a bit random to me.

Thank you!