问题描述
我目前正在为我们的图表从PQ系统Chartrunner在转换为SSRS 2008图表。我目前在SSRS 2008年折线图工作，想获得背景颜色更改不同西格玛。我能够计算和绘制的标准偏差sigma线，但我一直无法改变线路之间的背景颜色。
I am currently trying to convert our charts over from PQ Systems Chartrunner to SSRS 2008 charts. I am currently working with a line chart in SSRS 2008 and am trying to get the background color to change for the different sigmas. I am able to calculate and chart the standard deviation sigma lines, but I have not been able to change the color of the background between the lines.
我有什么至今在SSRS：
What I have so far in SSRS:
在Chartrunner图，红/黄/绿区：
In the Chartrunner chart, the Red/Yellow/Green zones:
有没有办法在2008年SSRS做到这一点？
Is there a way to do this in SSRS 2008?
推荐答案
是的，你需要看看使用的带线在您的报告：
Yes, you need to look at using Strip Lines in your report:
轴带线。
由于您可以根据这些前pression，乐队可以在运行时确定。它应该在你的工作的情况下，你总是有乐队的一组数字，只是不同的价值观，当您运行报告。
Because you can make these expression based, the bands can be determined at run time. It should work in your case as you always have a set number of bands, just different values when you run the report.
下面是一个简单的例子，基于该数据如下：
Here's a simple example, based off the following dataset:
要注意的最重要的事情是，我已经包含行的的限制最大的中期和分的数据集中;这使得在带线更容易地创建。
Most important thing to note is that I've included the limit rows max, mid, and min in the dataset; these makes the Strip Lines easier to create.
创建一个简单的图：
选择在Y 图表坐标轴并展开带状线系列：
Select the Y Chart Axis and expand the StripLines collection:
您可以看到，我已经将 IntervalOffset 和 StripWidth 的基础上，我的数据集的字段。最终结果是：
You can see that I've set IntervalOffset and StripWidth, based on the fields in my dataset. End result:
所以，你可以看到它的尽可能的需要动态地做到这一点。这是一个简单的例子，但这个概念很容易转让;你应该能够使其适应您的要求。
So you can see it's possible to do this dynamically as required. It's a simplified example but the concept is readily transferable; you should be able to adapt it to your requirements.
这篇关于在折线图有条件的背景颜色的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！