how to change the data labels in a chart

[Dmarious]

Hi,

I have a chart on my report which shows files size (numbers) as a function of time. I want to show in the chart that if the file size is over 1000 (doesn't have to be 1024) bytes, than the chart would show k.
Example : if my file size is 74,015 bytes than it would show 74k.
If there is a way to do it with KB and MB than it's even better, but if not then simply k would be OK.

Thanks

DMarious

 

[kenhamady]

What version of CR?

Is this a group chart on the Data tab of chart expert, or an Advanced/Detail chart? Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[Dmarious]

I'm using version 8.0

This isn't an advanced/detail chart.

Thanks
DMarious

 

[kenhamady]

Then, write formula to use as your group field. Something like:

If {size} > 1000000 then ToText({size},0) + " MB" else
If {size} > 1000 then ToText({size},0) + " KB" else
ToText({size},0) Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.