Display per quarter

[Thant]

Greetings,
I have a report grouped by quarter but the title of the group keeps coming in as a date (01/2010) etc. What I would like is this group title to show as quarter (1st Quarter 2nd Quarter etc.) I know there is a way to do this in crystal but im not sure how to go about it.
Any ideas and thanks in advance


Anything worth doing is worth messing up at least 5 times before you get it right!

 

[lbass]

In the group expert->options->customize groupname->use a formula->x+2:

select datepart("q",{table.date})
case 1 : "1st Quarter"
case 2 : "2nd Quarter"
case 3 : "3rd Quarter"
case 4 : "4th Quarter"

-LB