isnull question

[sheely654]

This seems like it should be so easy. I want to group first by state, then by city to show all members that I have no address in the address field. I cannot get it to run correctly. Please help.
I have group header 1 as state, group header 2 as city and then I have isnull ({tblEmployee.address1}) and
{tblMemberStatus.is_active_ind} to show me all active members with no address. What am I doing wrong?

 

[Turkbear]

Hi,
How are you specifying that criteria?

Try a selection formula something like:

(
IsNull({tblEmployee.address1})
Or
Trim({tblEmployee.address1}) = ""
)
and
{tblMemberStatus.is_active_ind} = whatever shows activestatus




To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Madawc]

Let's clarify. Group 1 is state, Group 2 is city. For city, you want to show detail lines for members who are active but have a null address line?

That should work, but note that any reference to a field with null values will stop the formula. Is that the problem?

If that's not it, please explain just what is happening.

Madawc Williams (East Anglia, UK). Using Crystal 11.5 with SQL and Windows XP

 

[sheely654]

so this is what I have...

({tblMemberStatus.is_active_ind} and
isnull({tblEmployee.address1} )

for some reason it doesn't show all the members with no address. Could it be because of my grouping? I have it grouped by state...

 

[Turkbear]

Hi,
If no state then no detail for that state..

Create a formula for the state group:

If IsNull({tblEmployee.State})
then
"No State"
else
{tblEmployee.state}

Group on the formula not the field.

Also, test for NULL first in any formula or selection criteria:

(
isnull({tblEmployee.address1} )
and
{tblMemberStatus.is_active_ind}
)





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[sheely654]

Yay!!! Thank you!!!