IsNull formula help

[hld24]

I am building a report that needs to look at a database and pull only the data that is incomplete. Incomplete is defined as being empty or "null".
IE: I want to see all the reference numbers that have certain fields that are NOT filled out. There are twenty fields that should be filled out each and every time by a review team. This will look out over that data and give me exposure to see which fields have NOT been filled out by reference number. If all the fields are filled out than I wouldn't expect to see any data returned.
CR10

 

[fsreport]

Hi
try this
this should be the first line in your record selecttion

if (isnull({your_field} or ({your_field} = ""0
then
this
else
whatever

fsreport

 

[synapsevampire]

Group by the referencenumber.

Placesomething likethis in the Report->Selection Formula->Record:

(
isnull({table.field1})
or
{table.field1} <> ""
)
or
(
isnull({table.field2})
or
{table.field2} <> 0
)
or
...etc...

You speak to theory, so we can respond only in kind.

Note that the second 1/2 of each criteria checks for a blank or empty field, this is based on the data type, which you didn't share, so you need towork thisout based on the fields you are intendingto check.

-k

 

[fsreport]

ops
fat finger
try this
this should be the first line in your record selecttion

if (isnull({your_field} or ({your_field} = "")
then
this
else
whatever

fsreport

 

[hld24]

My formula looks like this and I am getting a missing ) error message.

if (isnull({FILE1.Reviewer} or ({FILE1.Reviewer} = "")

 

[hld24]

Using this formula (isnull({FILE1.Reviewer})
or {FILE1.Reviewer} <> "") which is entered in the Group selection formula editor I am still getting all the reference numbers back. What I would expect to see is only those reference numbers that have FILE1.Reviewer field blank or "null".
The formula comes back with no errors found, but it doesn't have an impact on my results. I also tried entering the same formual in the records selection formula editor with the same results.

 

[synapsevampire]

AS for this:

if (isnull({FILE1.Reviewer} or ({FILE1.Reviewer} = "")

Change the record selection to :

(
isnull({FILE1.Reviewer})
or
trim({FILE1.Reviewer}) = ""
)

Removeany suppression you might have and other recordselection criteria (might just start fresh for testing).

-k

 

[hld24]

Thank you. I am getting closer. Once I completed the boolean arguement I was successful for that one field. Now I need to put together a series of these formulas to look at all the fields on this report and evaluate accordingly. Here is what I have so far. Please comment where needed. There are 20 fields all together and these represent two of them.

if isnull({FILE1.Reviewer})
or {FILE1.Reviewer} = ""
then True else
if isnull({FILE1.Event})
or {FILE1.Event} = ""
then True

 

[synapsevampire]

You can just use:

(
isnull({FILE1.Reviewer})
or
{FILE1.Reviewer} = ""
)
or
(
isnull({FILE1.Event})
or
{FILE1.Event} = ""
)
or
...etc...

No IF...THEN needed, it's Boolean logic.

-k

 

[hld24]

Thank you very much. I am all set. Great help!