Control Charting??

I have a need to provide a control-chart-like appearance to the user
community.
Basically I need to track costs over a period of months against a
previous year (or some historical range) and show where the current
costs are tracking above/below the corresponding historical values.
I was thinking about using a standard line chart and somehow
incorporate two horizontazl lines (one high/one low) within the chart
area (don't know if this is possible with SRS). So, far I'm still
trying to figure out the SQL Query...
Has anyone tried to do a control-chart (simulate) or... is there a
better approach?
Thanks
GlennIf you just want constant values for the high/low horizontal lines, you can
easily achieve it by just adding a new "value" in the chart properties
dialog / "Data" tab. You would use e.g. =100 as value expression for this
new series value.
If you have historical data from a query, you would add e.g. a series
grouping based on the date values, e.g. =Year(Fields!SomeDateField.Value).
Therefore your values will be automatically grouped per year and shown as
independent series in the chart.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Glenn Owens" <gowens@.nixonpeabody.com> wrote in message
news:bc4291aa.0408131137.7653fdb5@.posting.google.com...
> I have a need to provide a control-chart-like appearance to the user
> community.
> Basically I need to track costs over a period of months against a
> previous year (or some historical range) and show where the current
> costs are tracking above/below the corresponding historical values.
> I was thinking about using a standard line chart and somehow
> incorporate two horizontazl lines (one high/one low) within the chart
> area (don't know if this is possible with SRS). So, far I'm still
> trying to figure out the SQL Query...
> Has anyone tried to do a control-chart (simulate) or... is there a
> better approach?
> Thanks
> Glenn