format number on chart axis

[krysna]

I have a chart in my report that shows data on change of month number. The field is a number. In the preview mode, it shows the way I want it to (i.e. 1 2 3, etc). However, when I view it on the web, served up with the ReportRenderer in java, the months display as 1.00 2.00 3.00, etc. I can't find anyplace where I can format this axis. Does anyone know where I can do this?

 

[Dan3D]

In the Crystal Designer you should be able to click on the y-axis label and bring up the Grids/scales dialog and then change the formatting to something more to your liking.

Dan Weingart
OEM Technical Manager
Three D Graphics, Inc.

http://www.threedgraphics.com

 

[krysna]

It is actually the X-axis that I am trying to format. The Y-axis has a tab for number that you can edit the number format, but the X-axis does not.

I ended up making a formula that converts it to a string with 0 decimals and used that with a specified order instead of using the number. If anyone has a better way of doing this, let me know.