Report selection on field filtering

Business Central/NAV User Forum
1

Hi,

I am using NAV 5.0 and would like to filter sales report with salesperson.

Instead of selecting many salesperson codes, I would like to filter out a few salesperson code in the report.

I am trying to use the selection below but still display all salesperson including those (Joe, Jane & Mary) selected as exclusion.

Salesperson code : <>Joe|<>Jane|<>Mary

Only a selection works in the output, for example Salesperson code: <>Joe but not with more exclusion

Is there anyway to display option in the report selection ?

Seeking for advice.

Regards,

Lee

2

Moved into the NAV user forum.

3

HI Lee,
Just a few Days back One of Member in Group used Just like above you described …
If you want to exclude Joe,jane &Mary then try like

<>Joe&<>Jane&<>Mary.
Let us know it Worked or not

4

See this link

5

Hi Raja Venkat,
Perfect, it works as what I requested. Thank you.

What is the difference between these symbols | and & in report filer ?

Regards,
Lee

6

| is Or and & is And…