Can't Group my formula fields?

[CherrySoda]

Crystal v.10

I have a formula field in my report that uses a global variable and some if statements. I want to group using this field, but it is not an available field in Group Expert. I thought it might have been the If Statements in the formula, so I then created a simple formula that prints "Hello" and that won't show up in Group Expert either.

Any idea why these will not show up for me to group?

 

[kskid]

Please show the contents of the formula and indicate in what section it is located

 

[CherrySoda]

Here is my formula. It is placed into details of the report. The reason for the global variable is because some the the ACTIVITY fields are null and I want them assigned the most recent used value for CODE. The formula works just fine, but it just wont show up in the Group Selection box.

global stringvar CODE;

whileprintingrecords;
CODE;

if (isnull({ACTIVITY.ACTIVITY_CODE})) or ({ACTIVITY.ACTIVITY_CODE} = "") then
CODE
else if not isnull({ACTIVITY.ACTIVITY_CODE}) then
CODE := {ACTIVITY.ACTIVITY_CODE}
else CODE := "ERROR

 

[CherrySoda]

Any idea on what I can do to group this formula field?

 

[lbass]

You don't need a variable for this, and your whileprintingrecords is the problem. Use a formula like this:

if isnull({ACTIVITY.ACTIVITY_CODE})) or {ACTIVITY.ACTIVITY_CODE} = "" then
"ERROR" else
{ACTIVITY.ACTIVITY_CODE}

-LB

 

[CherrySoda]

Thanks. I am going to back up and start from the beginning to better ask my question for what I am trying to do. I have posted it here:

http://www.tek-tips.com/viewthread.cfm?qid=1525899&page=1