Selecting Null Value fields in record selection expertCRXI

[lcutliffe]

I want to filter out the fields that have "no data" or null and display them in a report. What type of forumula do I need to identify the null field in record selection? Thanks

 

[lbass]

You probably want to test for blanks or nulls, so the syntax would be:

(
isnull({table.string}) or
trim({table.string}) = ""
)

For dates, try:
(
isnull({table.date}) or
{table.date) = date(0,0,0)
)

isnull({table.number}) //should be sufficient

-LB

 

[lcutliffe]

worked like a charm, thanks a bunch =)