Reporting Services Chart - X-Axis name problem

Question

I have created a chart using a stored procedure which lists totals by name.

However when I create the chart the names only appear for every second element. I have tested this in a table and I get each name correctly.

My first thoughts were that it was a sizing issue, so I considerably increased the size of my chart, but this doesn't make a difference.

Does anyone know what could be causing the problem?

[URL=http://img11.imageshack.us/i/rschart.jpg/%5D%5BIMG%5Dhttp%3A//img11.imageshack.us/img11/7191/rschart.

Answer 1

Ahh you have run into the notorious RS bug that most everyone doesn't notice. No solution to this, however what you can do to display ALL x axis labels is to shorten the categories (or x-axis values to 3-4 letters a piece and display a key).

What I mean about this is in your SQL table of categories add a field called Acronym or something an for a category such as :

SQL SERVER CATEGORY I

In the acronym field make it

SSCI

And in your report instead of using the category field use a much shorter value (the SSCI value). Now next to your report object just create a matrix / table object that displays categories with their acronyms. You do realize that you can use multiple objects in one report that may point to different data sets.

Doing this will display all the X-Axis values, it is all because of the lengths of the categories...

Answer 2

I have found the problem. If you go to the properties of the X-Axis in your chart and go to >Interval > VariableAutoInterval and by default this is set to false. Set this to true and it now works.

However there is a problem with formatting as although the labels appear they are displayed slighter off centre of the actual bar elements... this should easily be fixed though.

Thanks for your help!

[URL=http://img230.imageshack.us/i/rschart2.jpg/%5D%5BIMG%5Dhttp%3A//img230.imageshack.us/img230/3958/rsc

Answer 3

Hi philsellars,

That "VariableAutoInterval" did not work for me, it showed every alternate other label. However the following worked:

In the Axis Properties -> Interval, type 1 : This will show every label. If you type 2, it will show every alternate label and so on.

http://img223.imageshack.us/img223/3118/capturerk.png

Reference : msdn.microsoft.com/en-us/library/bb934393.aspx