Decode Group Name 2

[maulae]

I am working on crystal 11 and need help for a problem,
I have grouping on a field xyz containing numeric data 1,2,3 etc and it shows in the report’s navigator as
1
2
3
I need to show as if data is 1 then one or if data is 2 then two or data is 3 then three,
I can create a formula to decode in report description section and suppress the group name and show only description but I don’t know how to decode in grouping tree (navigator). I totally don’t want to show these numeric numbers in the report.
Thanks for the help.

 

[lbass]

If you go to the group expert->options->customize group name->use a formula->x+2, you can enter:

towords({table.groupfield},0)

Or if you want it in proper case:

propercase(towords({table.groupfield},0))

-LB

 

[maulae]

I tried you suggestion but, probably I did not understand how to write the code, would you please explain little detail.
Thanks.

 

[maulae]

Oh, my question is little confusing, I did not mean I need to change numbers in words, actually I want to decode it me be words or any text, i.e
if {table.groupfield} = 1 then New York else if
if {table.groupfield} = 2 then Florida else if
if {table.groupfield} = 3 then California etc.

I hope it's more clear now.
Thanks.

 

[synapsevampire]

Try:

if {table.groupfield} = 1 then "New York"
else
if {table.groupfield} = 2 then "Florida"
else
if {table.groupfield} = 3 then "California"
...etc...

-k