Adding null values to a group in the crosstab 1

[shaleen7]

I've created groups in a crosstab table.

DOGS 5
CATS 8
FROGS 6
OTHER (INCLUDES BLANK FIELDS (7) AND BIRDS (2)) 9


How do I include blank fields in my Other group?

I've tried "", NULL, ISNULL. Nothing seems to work.

 

[synapsevampire]

That would depend upon how you're creating these groups, and what version of Crystal you're using.

One formula containing:

If {table.beast} = "DOGS" then
"DOGS"
else If {table.beast} = "CATS" then
"CATS"
else If {table.beast} = "FROGS" then
"FROGS"
ELSE
"OTHER"

Now use this formula to group on (you could also use the SWITCH function here).

-k

 

[lbass]

I would try:

if isnull({table.animal}) or
trim({table.animal}) = "" or
not({table.animal}) in ["Dogs","Cats","Frogs"]) then
"Other" else
{table.animal}

-LB

 

[synapsevampire]

Odd, you stated that you tried isnull and "" yet LB's formula uses those and it seemingly worked.

Anyway, glad that you found a solution, I should have known it was a bad post, LB picks up on those things very well.

-k

 

[shaleen7]

Actually it didn't work. I accidentally hit the valuable post star.

 

[synapsevampire]

Show us what you tried. And what are you getting that's incorrect?

Also note that I suggested that you post the version of Crystal and database, add to that sample data and expected output and you'll likely get a good result.

-k