定义 SSRS 2008 图表控件中分类轴的顺序
我正在尝试使用 SSRS 2008 中的图表控件制作一个非常简单的图表，当然，微软希望让事情变得尽可能困难。 x 轴包含装配线上的工位，y 轴包含一些与问题无关的数值。我正在返回一个数据集，其中包含扫描站，按照它们在装配线上的存在顺序排列。但是，当我将数据集绑定到图表控件时，电台会按字母顺序排列！我不希望 x 轴上的类别按字母顺序排列。我希望它们按照数据集中返回的顺序显示。我想我可以按照我想要的顺序对电台进行编号，但我宁愿不这样做。提前致谢。
I'm trying to make a VERY simple graph with the chart control in SSRS 2008 and, of course, Microsoft wants to make things as difficult as possible. The x-axis contains stations on an assembly line and the y-axis contains some numerical value that is irrelevant to the issue. I'm returning a dataset with the scanning stations in the order that they exist on the assembly line. However, when I bind the dataset to a chart control the stations are put in alphabetical order! I don't want the categories on the x-axis to be in alphabetical order. I want them to display in the order that they are returned in the dataset. I suppose I could number the stations in the order that I want but I would rather not do that. Thanks in advance.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
当您将类别组添加到图表时，图表控件默认添加排序标准。
要删除此行为，您可以右键单击“类别组”，转到“排序”选项卡，然后删除其中的条目。再次预览报告，电台应该按照您想要的顺序排列。
希望这有帮助。
When you add a Category Group to a chart, the Chart control adds a Sort criterion by default.
To remove this behavior, you can right-click on the Category Group, go to Sorting tab, and delete the entry there. Preview the report again and the stations should be in the order you want.
Hope this helps.