Customized group name

[TLSlusher]

I feel like I am losing my mind and this should be so simple! I have a report that is counting objects in a date range. Right now I have the report grouped quarterly on date. The group name is showing as 01/2008, 04/2008, 07/2008, 10/2008 and I would like them to say "1st Quarter", "2nd Quarter" and so on. What is the easiest way to accomplish this? I feel like it should be so easy but I'm working myself into circles..

Thanks!

 

[Turkbear]

Hi,
Create a formula that decodes those dates and use that formula as the Group object.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[TLSlusher]

Okay, a step in the right direction!

I'm dealing with a a datetime field, I converted to date:

{@Convert Record Date} = cdate({field.RECORDDATE})

When I group on the formula, I added a section group header & footer for each quarter. I selected the Customize Group Name Field and selected Use a Formula as Group Name option. I entered the following formula here:

if {@Convert Record Date} in Calendar1stQtr
then "1st Quarter"
else "nope"

Even though the date is in the 1st quarter, I'm getting my else result. Any ideas???

Thank you in advance!!

 

[lbass]

Use a formula like this:

if datepart("q",{Orders.Order Date}) = 1 then "1st Qtr" else
if datepart("q",{Orders.Order Date}) = 2 then "2nd Qtr" else
if datepart("q",{Orders.Order Date}) = 3 then "3rd Qtr" else
if datepart("q",{Orders.Order Date}) = 4 then "4th Qtr"

Calendar1stQtr refers only to the current year.

-LB