Hi there. I have a report that g

[stormtrooper]

Hi there.

I have a report that groups by {@Month} descending which looks like this:
totext({MY_DATE}, "yyyy/MM/dd&quot

My question is, when I preview the report, how do I get the left side bar to show "January", "February", "March", etc. instead of "2003/03/08", "2003/02/08", "2003/01/08", etc.?

 

[butkus]

make a new formula (named monthname or whatever)
and add this"
totext(monthname(month({MY_DATE})))+ " " +totext(year({MY_DATE}), "####&quot

then insert a group on MY_DATE and select "In ascending order" and "This section will be printed for each month"

Then under the "Group Options" section check the "Customize Group Name Field": check box
then
click the "Use a formula as Group Name" radio button
when the formula editor opens, type{@monthname}

This will display the month name and year (if your report spans years)

 

[stormtrooper]

I don't think cr7 has the monthname function. Please see my other post called Month formula needed.

 

[butkus]

Then try this

totext({MY_DATE}, "MMMM&quot+ " " +totext(year({MY_DATE}), "####&quot


then insert a group on MY_DATE and select "In ascending order" and "This section will be printed for each month"

Then under the "Group Options" section check the "Customize Group Name Field": check box
then
click the "Use a formula as Group Name" radio button
when the formula editor opens, type{@monthname}

This will display the month name and year (if your report spans years)