This formula field comes back blank instead of "Unlabeled". Any idea? 1

[willz99ta]

Hi and thanks for your help,

I am using this formula to try to return "Unlabeled" on my report when the GroupName field is blank:

whileprintingrecords;
if GroupName ({ITEMMAST.USER_FIELD4}) = "" Then "Unlabeled"
Else "blah"

When it finds a blank groupname, this formula returns nothing. But, if it doesn't find the blank group name the thing works and it returns "blah".

I put this formula in the group footer.

Any idea?

Thanks,
Will

 

[CoSpringsGuy]

if isnull (GroupName ({ITEMMAST.USER_FIELD4}) Then "Unlabeled"
Else "blah"

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 

[willz99ta]

Perfection