Date displaying as 'MM yyyy' in Graph

[Former Member]

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

[vitaly_izmaylov · Accepted solution]

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")

[Former Member · Accepted solution]

Hi Vitaly

Thanks for the suggestion - that is an idea but I'm not sure that the Clients are going to be happy with the 'yyyy MM' format unfortunately.

It is annoying that you can get the format using the Numeric Axis but no way using the normal graph?!!

Cheers

sophmon

[vitaly_izmaylov · Accepted solution]

I did not say there is no way

You can change/customize Date format for the whole computer in Regional/Language settings and Crystal Report will pick it up for the chart.

I just tested it for Bar chart - it works. Would it be acceptable solution for your Clients?

[Former Member · Accepted solution]

Thanks again Vitaly.

I have tried this but it is still showing as 'yyyy MM' even though my PC is showing short dates as 'dd/MM/yyyy' format in the Regional & Language tab. Is this the right place?

[vitaly_izmaylov · Accepted solution]

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