SQL Server Reporting Services:将图例限制为具有多个系列的图表的一个系列

时间:2022-06-17 08:17:14

I have a chart with these characteristics:

我有一个具有以下特征的图表:

  • chart type is XY (scatter )

    图表类型是XY(散点图)

  • all XY data have x-values that are integers; they are called "Update Cycle" numbers. This represents "score" data from a given program.

    所有XY数据的x值都是整数;它们被称为“更新周期”号码。这表示来自给定程序的“得分”数据。

  • in addition to the values that produce the XY data, I've added two other elements to the "Values:" list: one that is the average of the XY data for any Update Cycle (x-axis) value, and another that is the average of "similar programs" for any Update Cycle. These elements are plotted as lines ("trend lines") on the chart.

    除了产生XY数据的值之外,我还在“值:”列表中添加了两个其他元素:一个是任何更新周期(x轴)值的XY数据的平均值,另一个是任何更新周期的“类似程序”的平均值。这些元素在图表上绘制为线条(“趋势线”)。

  • Category Group is Update Cycle number

    类别组是更新周期号

  • Series Group are (1) PersonID and (2) ProgramID

    系列组是(1)PersonID和(2)ProgramID

It all plots fine, but here's my problem:

这一切都很好,但这是我的问题:

If I add a Legend, it wants to add Legend entries for each and every point for each and every person (because of SeriesGroup1) - I imagine it's also showing legend entries for the second series, but there are so many for the first series, I can't read anything.

如果我添加一个Legend,它想为每个人的每个点添加Legend条目(因为SeriesGroup1) - 我想它也会显示第二个系列的图例条目,但是第一个系列有很多,我看不懂任何东西。

Question: How do I supress legend entries for the first series and only display the two legend entries for the 2nd series?

问题:如何抑制第一个系列的图例条目,仅显示第二个系列的两个图例条目?

1 个解决方案

#1


I have the same problem, Is any solutions for the series text overlaping?, I found a solutions, but I cann't use, because divided the chart in various charts, by the way, heres is the link of the article:

我有同样的问题,系列文本的任何解决方案是否重叠?,我找到了解决方案,但我不能使用,因为在各种图表中划分图表,顺便说一下,继承人是文章的链接:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/841e1515-3519-4c4f-a76f-f6fcebd25dfd/

If somebody have another solutions, pleace post it.

如果有人有其他解决方案,请发布它。

Thanks and sorry, my English is a little poor.

谢谢,抱歉,我的英语有点差。

#1


I have the same problem, Is any solutions for the series text overlaping?, I found a solutions, but I cann't use, because divided the chart in various charts, by the way, heres is the link of the article:

我有同样的问题,系列文本的任何解决方案是否重叠?,我找到了解决方案,但我不能使用,因为在各种图表中划分图表,顺便说一下,继承人是文章的链接:

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/841e1515-3519-4c4f-a76f-f6fcebd25dfd/

If somebody have another solutions, pleace post it.

如果有人有其他解决方案,请发布它。

Thanks and sorry, my English is a little poor.

谢谢,抱歉,我的英语有点差。