CR xi - formula for Histogram

[campia]

Hi,

I created a histogram with this formula : MonthName(month ({Table.Creation_Date}))
but the months on the report are put at the bad place.
I have for example: April, June, March and May...but I should be March, April, May and June.

Can you help me?

 

[Madawc]

Try something like

ToText({Your.Date}, "yy-MM MMMM")

This would give 07-02 February for February this year, and so will sort correctly.

If that's too long, MMM will give a three-digit month name

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

Or in the chart expert select the on change of field->order->choose "Specified Order" and order the month names as you like.

-LB

 

[campia]

thanks a lot