Hi All
I have a report consisting of 4 columns;
Facility ID, Outstanding ID, Customer Name and Outstanding Type
Facility ID and Customer Name comes from dataprovider A and Outstanding ID, and Outstanding Type comes from dataprovider B.
And the link between the data providers is Facility RID.
Not all Facility ID will have and Outstanding RID against it hence Outstanding Type will only appear where there is an Outstanding RID.
Below is a sample of the report
Facility RID Outstanding RID Customer Name Outstanding Type
1!4JQK46 TESCO PLC
A15B92MK .R5DM2G9 TESCO PLC SBLC
A15B92MK TESCO ABC
YI5JU7CC TESCO PLC
E(5KLW1C TANGO FINANCE LTD
WO4LHIY6 -H5HD6A7 SMITH & NEPHEW PLC LOAN
WO4LHKCH 175GYD27 SMITH & NEPHEW PLC LOAN
I am trying to filter those Outstanding Type <> SBLC, that is picking up LOAN and Blank (as it appears).
But this is not so, instead it is only picking up those Outstanding type of LOAN
In reality the blank cells only appears when the Facility ID, and Customer Name are included in tables, and it is not really blank in the database level, Does anyone how to add a global filter to the table above so that it will only pick up LOAN and the blank cells.
Any assistance is really appreciated
Rachelle
rachelle (BOB member since 2002-11-13)