Omitting Records

[rbescos]

I’m trying to come up with a way to omit records from my report. Each record has four dates we need to track. I only want to display records that are missing all four dates or only one of the four. I would like to omit the records that have all four dates in the fields we are tracking.

Any assistance would be greatly appreciated.

 

[pmax9999]

As I understand it, you want the report to return data where any 1 or more of the 4 date fields is empty (Null). Assuming my understanding is correct, add the following code to your Record Selection formula:

(
    Isnull({Table.Date1}) or
    Isnull({Table.Date2}) or
    Isnull({Table.Date3}) or
    Isnull({Table.Date4}) 
)

If you have other record selection criteria, place this code at the beginning of the existing code.

Cheers
Pete

 

[rbescos]

That is just what I needed. Works great!! Thank you!!