Formatting Charts

[jchewsmith]

My chart is based on month and year. These fields are numeric fields. The year displays with comma's and decimals on the chart. How can I change to display with no comma's?

 

[NiceArms]

Can you give me an example of what you see?

Just to be noisey: why are the date fields of a data type "Numeric" and not "Date"?

Without seeing the data im thinking that you could maybe create a formula and use somthing like:

replace(replace({mydate},',',''),'.','')

and reference this in the chart.

/Nice

 

[jchewsmith]

My fields are numeric in the software that I am using, can't change them. I actually have two fields, one for month (xx) and one for year (xxxx). The month displays fine, but the year shows on the chart as 2,010.00

I changed the options to display numeric without commas or decimals and the chart displays fine on my computer, but when another users opens it up on the network it shows the 2,010.00

Thanks for your help.

 

[NiceArms]

I have never come across this before. So here are a few suggestion I think may help.

Is it just the one user that is having the issue?

Are they running the report via crystal reports or a crystal reportviewer from VB for example?

If the user is running via crystal reports try formatting the field from there PC, maybe the software is just being "fussy"

 

[fisheromacse]

Where did you change the options?
on the field itself?
OR
Under the File Menu -> Report Options... -> Fields Tab -> Number?

 

[NiceArms]

using Crystal report 9 here so it may differ... place the field onto the report and select "format field" under the Number tab select the relevant option

Doing it the way you mention changes the local settings, my way should change the body of the report and the end user should get the result you want.... i hope ;p

 

[IanWaterman]

YOu could also change chart design to group on a text year/ month formula.

@Month
totext(yearfield, 0,"")&"/"&totext(monthfield,"00", 0,"")

This will result in July being displayed

2010/07

And will sort correctly for other months and years.

Ian

 

[lbass]

You should be able to select the axis label->right click->edit axis label and remove the comma and decimals.

-LB

 

[jchewsmith]

I am using a viewer for the other users, they do not have crystal on their pc's so I can't change the settings. I am still on crystal 8.5 so I do not have the options on the charts that the new versions do. If I change my year and month to text then my summaries/formulas don't work properly. I changed the field options on my PC on the File/Options/Fields/Number as I can't format the fields for the legend and grid on the charts.

The chart looks like this (a line for every year) so the 07/2010 doesn't work.

10,000 Legend
5,000 2,008.00
2,500 2,009.00
1,000 2,010.00
Month 1.0 2.0 3.0 4.0 5.0 6.0 ....