blocks|key|2265425|text|啊，你遇到了臭名昭著的RS+bug，大多数人都没有注意到。没有解决方案，然而，您可以做的是显示所有x轴标签是缩短类别(或x轴值为3-4个字母一块，并显示一个键)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2265426|我的意思是，在您的SQL类别表中，为类别添加一个名为缩写的字段或其他字段，例如：|2265427|SQL+SERVER类别i|2265428|在acronym字段中设置为|2265429|SSCI|2265430|在您的报告中，不要使用category字段，而要使用一个短得多的值(+SSCI值)。现在，在您的报表对象旁边，只需创建一个矩阵/表对象，该对象显示类别及其缩写。您确实意识到，您可以在一个报告中使用多个对象，这些对象可能指向不同的数据集。|2265431|这样做将显示所有的X轴值，这都是因为类别的长度...|2265432|entityMap^0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|S|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|T|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|U|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|V|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|O|$]]

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...

blocks|key|5412074|text|似乎对我很管用。您是否可以尝试将报告导出为pdf+/+excel并检查结果。还有，我用的是RS2005，你用的是2008吗？|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5412075|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

Seems to be working for me. Can you try to export the report to pdf / excel and check the results. Also I am using RS 2005, are you using 2008?

blocks|key|3300837|text|我找到了问题所在。如果您转到图表中X轴的属性，然后转到>Interval+>+VariableAutoInterval，则默认情况下设置为false。将其设置为true，它现在就可以工作了。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3300838|然而，格式有一个问题，尽管标签看起来有点偏离实际条形图元素的中心。不过，这应该很容易解决。|3300839|谢谢你的帮忙!|3300840|URL=[http://img230.imageshack.us/i/rschart2.jpg/][IMG]http://img230.imageshack.us/img230/3958/rsc|offset|length|3300841|entityMap|0|LINK|mutability|MUTABLE|url|http://img230.imageshack.us/i/rschart2.jpg/][IMG]http://img230.imageshack.us/img230/3958/rsc^0|0|0|0|0|2P|0|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|S|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|T|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@$H|V|I|W|1|X]]|A|$]]|$1|J|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|Q]]]]

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=<a href="http://img230.imageshack.us/i/rschart2.jpg/][IMG]http://img230.imageshack.us/img230/3958/rsc" rel="nofollow noreferrer">http://img230.imageshack.us/i/rschart2.jpg/][IMG]http://img230.imageshack.us/img230/3958/rsc</a>

blocks|key|355897|text|"VariableAutoInterval“对我不起作用，它显示了所有其他的标签。然而，下面的方法是有效的：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|355898|在轴属性->间隔中，键入1:这将显示每个标签。如果您键入2，它将显示每个备用标签，依此类推。|355899|http://img223.imageshack.us/img223/3118/capturerk.png|offset|length|355900|参考:+msdn.microsoft.com/en-us/library/bb934393.aspx|355901|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|0|1H|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@$F|T|G|U|1|V]]|A|$]]|$1|H|3|I|5|6|7|W|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|K|$L|$5|M|N|O|A|$P|E]]]]

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.

<a href="http://img223.imageshack.us/img223/3118/capturerk.png" rel="noreferrer">http://img223.imageshack.us/img223/3118/capturerk.png</a>

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

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=<a href="http://img11.imageshack.us/i/rschart.jpg/][IMG]http://img11.imageshack.us/img11/7191/rschart" rel="nofollow noreferrer">http://img11.imageshack.us/i/rschart.jpg/][IMG]http://img11.imageshack.us/img11/7191/rschart</a>.

Reporting Services Chart - X-Axis name problem

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我使用一个存储过程创建了一个图表，该存储过程按名称列出总计。但是，当我创建图表时，名称只出现在每隔一次的元素中。我已经在一个表中测试了这一点，并且我正确地获得了每个名称。我的第一个想法是这是一个大小问题，所以我大大增加了我的图表的大小，但这并没有什么不同。有没有人知道是什么导致了这个问题？。

问Reporting Services图表-X轴名称问题
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问Reporting Services图表-X轴名称问题EN