Change the named displayed based on value

[skiabox]

I have a crosstab with one Group (Row #1 Name : @Month (Number)).
This grouping produces 12 rows with the number 1-12 taken from the formula.
It is something like that
1
2
.
.
12
I am trying to get the Group name to print a month name like 'January' but no luck till now.
I use the group options with customize name field where I enter the following :

if ({@Month} = 01) then 'January'
else if ({@Month} = 02) then 'February'

but I get no results in the cross-tab.

Am I doing something wrong?

 

[dgillz]

Please post the formula for @month.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[skiabox]

I get results after refreshing the report.

 

[lbass]

If you use {@month} in the crosstab, you can select group options while it is selected->customize group name->use a formula and enter:

monthname({@month})

Then they will appear in the correct order without using specified order.

-LB