Yes, this is a non-SharePoint post, but it’s about a bug in SSRS that really irritated me. In the project that I’m currently working on, I was asked to create some reports that measure the number of contributions of portal users in SharePoint lists and libraries.

I’ have chosen to use SSRS 2008 and since I’m counting the number of contributions, I have set the format for the captions on the value axis to Number with 0 decimal places since decimals do not make sense in my situation. The chart is parameterized to the values on the value axis vary from small numbers to large numbers according to the passed-in parameter value.

Issue :

As shown above, the integers on the value axis get repeated since SSRS decides that the axis should display 0, 0.5, 1, 1.5, 2, 2.5, 3,3.5,4. And since I have set the decimal places to zero, this ends up being displayed as 0, 1 , 1 , 1 , 2 , 2 , 3 , 3 , 4 , 4 .

Steps to reproduce :

1. Create a bar chart in SSRS.
2. Make sure that the passed-in parameter value leads to small values where the maximum is 4 as shown above.
3. Set the value axis number format to Number with zero decimal places as shown below.
4. View the chart using your browser or in Visual Studio.

Workaround :

1. Set the interval to be dynamic from the value axis properties.

2.Use the following expression :

Results :  

1. Each integer appears only once on the value axis.

Hope this helps:)