Reporting Services Diagram - X-Axis naming issue
I created a chart using a stored procedure that lists totals by name.
However, when I create the diagram, the names only show up for every second element. I checked this in the table and I got each name correctly.
My first thoughts were that it was a sizing issue, so I increased the size of my chart significantly, but that doesn't make any difference.
Does anyone know what might be causing the problem?
[URL = http : //img11.imageshack.us/img11/7191/rschart .
That "VariableAutoInterval" didn't work for me showed every alternate other label. However the following works:
In axis properties -> spacing enter 1: this will show each label. If you type 2 it will display every alternate label, etc.
http://img223.imageshack.us/img223/3118/capturerk.png
Link: msdn.microsoft.com/en-us/library/bb934393.aspx
source to share
I found the problem. If you go to X-Axis properties in your chart and go to> Interval> VariableAutoInterval and by default this value is false. Set this to true and now it works.
However, there is a formatting issue as even though the labels are displayed, they appear fainter from the center of the actual bar elements ... this should be easily fixed.
Thank you for your help!
[URL = http : //img230.imageshack.us/i/rschart2.jpg/where [IMG] http://img230.imageshack.us/img230/3958/rsc
Ah, you've run into the infamous RS bug that most people don't notice. There is no solution for this, however what you can do to display the ALL x axis labels is to cut the categories (or x axis values down to 3-4 letters per chunk and display the key).
What I mean is, in your category table, SQL adds a field called "Acronym" or "something" for the category, for example:
CATEGORY SQL SERVER I
In acronym field do this
SSCI
And in your report, instead of using the category field, use a much shorter value (SSCI value). Now, next to the report object, simply create a matrix / table object that displays the categories with their abbreviated abbreviations. You understand that you can use multiple objects in one report, which can point to different datasets.
Doing this will display all X-Axis values, this is all due to the category lengths ...
source to share