Help supressing "non NULL" fields. 2

[RobbieB]

Hey everybody, I writing a report on a table called "photo_Catalog". I have the fields "date_taken", "Photographer", "Location" and "Subject_Name". The client wants to know when data is missing from any off these fields. So, I need to supress all the lines that come back with all of these fields populated and show the lines that have a null value in any one of these fields. Understand? I could use any ideas any of you may have. Thanks in advance...

 

[vidru]

Instead of suppressing the lines that don't have any NULLs, just return the records that do have NULLs. Your Record Selection formula should look like this:

(isnull({Table.date_taken}))
or
(isnull({Table.Photographer}))
or
(isnull({Table.Location}))
or
(isnull({Table.Subject_Name}))


-dave

 

[Turkbear]

Hi,
One way would be to create a formula that tests each field for NULL and returns 1 if any are found. Then use that formula in your Record Selection Formula..

@testnull
If isNull({date_taken})  or
isNull({Photographer})  or
isNull({Location})  or
isNull({Subject_Name})  
Then 1
else 
0

Then in the Record Selection formula place:

@testnull = 1

Probably other ways as well, like using a conditional supress formula on the detail section.

 

[RobbieB]

Thanks guys, I came up with a variation of Turkbears formula and it works great....Thanks.