Using select expert

[mitmat]

When using Select expert to omit fields containing Text
Is not one of "Assigned to CSB"
It omits this but all the blank fields as well, which I do need to display in my report.

I'm sure this is simple to solve but I just can't see it

Many Thanks in advance

 

[codrutza]

this is just an ideea you can build on
- In report options, check convert null values to default
- build a @formula:
if {yourfield}="" then "empty" else {yourfield}
- in record selection formula
@formula in ["Assigned to CSB", "empty"]

or you can build formula directly for nulls

 

[lbass]

Go to report->selection formula->record and enter:

isnull({table.field}) or
{table.field} <> "Assigned to CSB"

If you actually have other results you want excluded, then change the formula to:

isnull({table.field}) or
not({table.field} in ["Assigned to CSB","Your Other Result"])

This assumes you have NOT checked "convert null values to default".

-LB

 

[mitmat]

Thanks guys

My full formula is now

isnull ({TASKS.CLSDDATE}) and
{TASKS.TYPE} = "Coins"
and
isnull ({TASKS.LOOKUP2}) or
{TASKS.LOOKUP2} <> "Assigned to CSB"

but it now seems to be ignoring the first two lines of the formula..
I think I'm some formula rules

 

[lbass]

You generally have to use parens when using an "or" statement. If the last two lines belong together, then use:

isnull ({TASKS.CLSDDATE}) and
{TASKS.TYPE} = "Coins" and
(
isnull ({TASKS.LOOKUP2}) or
{TASKS.LOOKUP2} <> "Assigned to CSB"
)

-LB

 

[mitmat]

You're good,

Muchas gracais

Thats worked a treat