Dear Team,

I am building an Item Filter.

I would like to prevent items codes - V ????????? and Z ????????? from showing.

Any guidance welcomed.

Many Thanks
Edward

Hi Edward:

If there are no "W", "X" or "Y" Items, the Filter would be: Item Code <= "UZZZZZZZZZZZZZZZ".

But from the way you phrased the question, there are likely Items in the range "W", "X" or "Y". You would need logic like:

Item Code <= "UZZZZZZZZZZZZZZZ"
OR
(Item Code >= "W000000000000000" AND Item Code <= "YZZZZZZZZZZZZZZZ")

The part in brackets is "nested". You can do that with GridView but not with Filters.

Therefore, the solution would be the same as one of your recent posts - use Report Group or an Optional field to distinguish the 2 classes of Items.

Hi Bruce,

Many thanks for taking a shot.

Yes the later is the case, there are Items in the range "W", "X" or "Y".
...
Therefore, the solution would be to use Report Group or an Optional field to distinguish the 2 classes of Items.
...
Item Filter is my TRUMP CARD where I EMPOWER ordinary CLIENTS into the programmers to PULL DATA on their own.

Just wanted to be sure I was not overlooking an easier fix.


Regards
Edward