Skip to Content
avatar image
Former Member

Date displaying as 'MM yyyy' in Graph

Hi there

Does anyone know how to display a date in 'MM yyyy' format on a graph axis?

I am using Crystal Xi.

I can display this format when using the 'Date Axis Bar Chart ' in the Numeric Axis, however this is not the format which I require the graph to be in.

Any help???

Cheers

sophmon

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 06, 2009 at 03:12 PM

    If "yyyy MM" (switch month and year) is acceptable format, then you can chart on change of formula like the one below:

    Totext (year(),"0000") + " " + Totext (month(),"00")

    Add comment
    10|10000 characters needed characters exceeded

    • To make sure we are not missing anything, here is the workflow:

      1. Close Crystal Reports

      2. Go to Control Panel

      3. Select Regional and Language options

      4. Click Customize button on Regional Options tab

      5. Select Date tab

      6. Type "MM dd yyyy" for short date format

      7. Click Apply and OK

      8. Open your report in Crystal Reports

      9. Go to Chart Expert, Data tab

      10. Select your Date field in u201COn change ofu201D box

      11. Click Order button below

      12. Select "for each month" option

      13. Click OK to close Chart expert

      Let us know about results