Displaying Series Group Total for a RS 2005 Chart

Hi there,

I'm trying to create a chart in RS 2005 that will split one set of
data into two separate lines while at the same time, creating a line
that will also display the average of all records. Some background
may be useful:

TABLE

Student_IdAttended_Meeting_CountTest_ScoreTest_ID11090125851315011109522580231652

What I would like to do is create 1 line that shows the average test score for all students with the test id as the x-axis value, 1 line that shows the average test score for all students who attended at least 5 meetings, and 1 line that does the same for all students who attended less than 5 meetings. In the Values box, I am using "=cint(AVG(Fields!Test_Score.Value))", and I have set a series group with the group on expression as "=Fields!Attended_Meetings_Count.Value > 5". This works great for splitting the line representing all values into the two lines I want, however, the test_score for all students line goes away. Anyone have any ideas on how to generate this line again? I've tried adding it as another value, but the series group then applies itself to the new values line as well and I end up with 4 lines.

Help!
-Rich

Hi,

From your description, it seems that you want to show three average values in three different conditions, right?

Why don't you calculate these three values separately? See the following sample:

=CINT(AVG(IIF(Fields!Attended_Meetings_Count.Value > 5, Fields!Test_Score.Value,0)))

=CINT(AVG(IIF(Fields!Attended_Meetings_Count.Value < 5, Fields!Test_Score.Value,0)))

=CINT(AVG(Fields!Test_Score.Value,0))

Thanks.

|||

Hi there,

Thanks for the reply. I did try the values you had suggested above, however, I get the following error when trying to view the preview:

The Value expression for the chart 'chart1' has a scope parameter that is not valid for an aggregate function. The scope parameter must be set to a string constant that is equal to either the name of a containing group, the name of a containing data region, or the name of a data set.

Any other suggestions?

Thanks again!

Rich

Displaying detail and summary in same bar chart

I have a bar chart that displays quality averages for all plants by
year.
Category = Plant
Series = Year
Detail = average
I would like to add a bar for the total company. Is there an easy way
to do this?
I am using VS 2005.
Thanks.Hello Heather,
You could not do this in the Chart setting.
The only thing you could do is that add a column in the dataset to include
the total data.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I thought that might be the answer. I wanted to make sure. Thanks.

Displaying a trend line (in line chart) in SSRS

We have a line graph which plots the actual data points (x,y), everything is working fine with this graph. Now we need to add a trend line to this existing graph after going thro. the articles we came to know that there is no direct option in SSRS to draw a trend line. So we need to calculate the trend values ourselves which we need to plot as atrend line. This trend line is similar to the trend line which comes in Excel chart, do anyone know how to calculate the trend values from the actual data points. We got through several formulas, but were not clear, have anyone tried out exactly the same, if so please help us out by providing an example to calculate the trend values.

The default functionality of Reporting Services does not support trend lines. There are some additional tools you can purchase to achieve this though, which is talked about in the first link below.

You can take a look at this post: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1148970&SiteID=1
and this one: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=322398&SiteID=1

Jarret

Displaying a Message if no chart data present

Hi, I currently have a report that displays a chart among other things. If
the report is called but no data is available for the chart i get a big
block of white space. Is it at all possible to display something in it's
place rather than just nothing at all if there is no data for the chart to
display?
Thanks, SimonYes. The chart has a "NoRows" property in the properties window. If the
chart's dataset has no rows and the NoRows property is set, a textbox with
the NoRows message will be shown instead of the chart.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Simon Dingley" <me@.example.com> wrote in message
news:OmWqrRrYFHA.3320@.TK2MSFTNGP12.phx.gbl...
> Hi, I currently have a report that displays a chart among other things.
> If
> the report is called but no data is available for the chart i get a big
> block of white space. Is it at all possible to display something in it's
> place rather than just nothing at all if there is no data for the chart to
> display?
> Thanks, Simon
>

Displaying 0 value on Y-axis

I have a column chart that has y-axis values that range between -100%
and 100%. I'd like the y-axis to autoscale at both the maximum and
minimum end, but always be sure that 0 will appear on the graph. So,
basically I'd like my minimum to autoscale anywhere between 0 and -1,
and my maximum to autoscale anywhere between 0 and 1. Does anyone know
if this is possible?
Thanks.This is possible with RS 2005. Min/Max values can be expressions in RS 2005.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Precisionbk" <bkeffer@.precisioncorp.net> wrote in message
news:1128027217.652074.312130@.g43g2000cwa.googlegroups.com...
>I have a column chart that has y-axis values that range between -100%
> and 100%. I'd like the y-axis to autoscale at both the maximum and
> minimum end, but always be sure that 0 will appear on the graph. So,
> basically I'd like my minimum to autoscale anywhere between 0 and -1,
> and my maximum to autoscale anywhere between 0 and 1. Does anyone know
> if this is possible?
> Thanks.
>

Display data in pie charts.

Is there a way to display the actual numeric values on the pie chart for each
part?
Thanks,
Leon.Yes
right click on the pie chart, select properties, Data Tab, in the Values
click one select editm point labels tab, show point labels, stick an
expression in if you like. repeat for all values.
Greg
"Leon Chuck Gosslin" <LeonChuckGosslin@.discussions.microsoft.com> wrote in
message news:B6B349E1-4623-4DF6-9A91-6628187DFF2A@.microsoft.com...
> Is there a way to display the actual numeric values on the pie chart for
> each
> part?
> Thanks,
> Leon.