Date format in the chart axis

[hariomhari]

I am using crystal report with VS.Net 2003.

The version of the CrystalDecisions.Web dll included in the project is 9.1.5000.0.

I am displaying the date on x-axis and wish to format it to

style ex (Jan 06 0r Jan-06)

please suggest

 

[lbass]

I think the only possibility (until the charting becomes more sophisticated) is to use a formula:

monthname(month({table.date}),true)+" "+right(totext(year({table.date}),0,""),2)

...as your "on change of" field and then while it is highlighted->order->specified order and order the months correctly.

-LB

 

[hariomhari]

I don't see the option you suggested.

Can you please give me more detail

 

[lbass]

What option can't you see? Order? In the chart expert, with your month formula highlighted, click on "order" which is directly below. There you will see the formula->ascending order. Use the dropdown to choose specified order instead of ascending order. Then in the specified order tab, use the dropdown to select the months in order.

-LB

 

[hariomhari]

I got the option

Order --> I choosen "In specified order" option from the drop down.

Then it opens a new window asking group name.

What I am not geeting is where to write the formula

 

[lbass]

Create the month formula in the field explorer in the main report. Insert a group on the formula. Then in the chart, when you choose order, the specified order dropdown will be populated with all the groups in your main report. Otherwise you have to create them individually.

You don't have to display the group in the main report--it can be suppressed

-LB

 

[hariomhari]

Can you please tell me how to "Insert a group on the formula" please

 

[hariomhari]

I got it. But it is changing the whole graph.

Anyways, I will look into it.

Kindly be there if i face any problem, i can take your guidance

 

[hariomhari]

Thanks lbass