Y axis display integers only

[espltd]

Hi I am using crystal reports that comes with VS 2005 and was wondering if there is a way to have the y axis display integer values on the y axis of a chart? For example a chart that might show the count of items and it seems to default the y axis increments to values less than 1 to provide greater resolution but I would like to force the y axis increments to be whole numbers, 1,2,3 ect.
Thanks.

 

[Madawc]

You could try a rounded version of the value.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[espltd]

Hi thanks for the response. Do you mean to use a rounded formula, also not quite sure where to set the rounded attribute?

 

[Madawc]

Yes, something like

Round({your.field})

This would return a whole number. If you wanted two decimal places you'd do

Round({your.field}, 2)

It's even possible to make the value -1 and round to the nearest ten, etc.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[espltd]

thanks for the additional information. So to try this I will create the round formula and then chart the formula data. I did find a grid chart setting but was not able to get integers only on the y axis segments.