报告服务图表-硬编码系列-ReportingServicesChart-HardCodedSeries

作者：h619718610 | 来源：互联网 | 2023-05-18 07:44

IamdevelopinganSSRS2008reportwhichcontainsanumberofsimplecharts.OnthexaxisIhavet

I am developing an SSRS 2008 report which contains a number of simple charts. On the x axis I have the 12 months of this year - Jan 2009 thru December 2009. On the Y is an integer value ranging from 0 to 100 in increments of 10. I am plotting the number of times an issue occurred per month. So January could have a value of 10, February 30, etc. etc.

我正在开发一份SSRS 2008报告,其中包含许多简单的图表。在x轴上,我有今年的12个月 - 2009年1月至2009年12月.Y是一个整数值,范围从0到100,增量为10.我正在绘制每月发生一次问题的次数。所以1月的价值可能是10,2月30日等等。

I would like to have a horizontal line/series that is constant and shows the yearly average for 2008. So, say the average was 30 issues per month in 2008, I would like for that line to be shown in my chart. Basically, I want to draw a straight line across the chart for that value... I can see how to add more complex series, but this seemingly simple task is getting the better of me.

我希望有一个水平线/系列是恒定的,并显示2008年的年平均值。所以,说平均值是2008年每月30期,我希望该线显示在我的图表中。基本上,我想在图表上绘制一条直线来表示该值......我可以看到如何添加更复杂的系列,但这个看似简单的任务让我变得更好。

Doe anyone have any idea how this could be accomplished? Thanks in advance, Jason

Doe有谁知道如何实现这一目标?杰森先生,谢谢你

[Update] To add some further details, I am already pulling the average for each row in my dataset and have it set up as its own series. However, rather than plotting a line, this approach plots individual points for each month. While this is close to what I want, I need to join the dots so to speak. The chart is of the Error Bar (Range) variety.

[更新]为了添加更多细节,我已经在我的数据集中提取每行的平均值,并将其设置为自己的系列。然而,这种方法不是绘制一条线,而是绘制每个月的个别点。虽然这接近我想要的,但我需要加入这些点。该图表是错误栏(范围)种类。

3 个解决方案

#1

Can you use a column / line hybrid chart? If so then add a constant or dynamic target value to the chart:

你能使用柱/线混合图吗?如果是,则向图表添加常量或动态目标值:

Design the chart. On the Data tab in the Chart Properties dialog box, add a new data value (for example, Target). Set the target value (see the example in Figure 9 on link this uses a constant target value of 100000 across all categories but you can do it dynamically too). Make sure to use an expression starting with = (equals). Otherwise, the value is not interpreted as a numeric value.

设计图表。在“图表属性”对话框的“数据”选项卡上,添加新数据值(例如,“目标”)。设置目标值(参见图9中链接的示例,它在所有类别中使用100000的常量目标值,但您也可以动态地执行此操作)。确保使用以=(等于)开头的表达式。否则,该值不会被解释为数值。

See the example on the MS charts page at http://msdn.microsoft.com/en-us/library/aa964128.aspx

请参阅MS图表页面上的示例,网址为http://msdn.microsoft.com/en-us/library/aa964128.aspx

#2

Add the yearly average to each row in the underlying the query. Add data series on just that value.

将年平均值添加到查询底层的每一行。仅在该值上添加数据系列。

#3

I managed to solve this issue myself.

我自己设法解决了这个问题。

As I mentioned, I was using an Error Bar graph. Right-clicking on the series of interest, I was able to change the graph type for that particular series - essentially leaving me with a chart with multiple graphs in it...particularly simple if you know where to look - which i did not! Thanks everyone for your suggestions.

正如我所提到的,我使用的是错误条形图。右键单击感兴趣的系列,我能够更改该特定系列的图形类型 - 基本上留给我一个包含多个图形的图表...如果你知道在哪里看起来特别简单 - 我没有!谢谢大家的建议。