Matrix help

Hi all. Trying something that seems like it shoulb be simple.
Important Data:
StudentID (ex. 1, 2, 3)
Class (ex. Math, English)
Response (-10 to 10)
Here is what I'm trying to get
Student 1 Student 2 Average
Math -7 3 -2
English -1 9 4
Science 10 4 7
================================================== (sum) 2 16 9
So, here is where I am now. I've added two rows to the matrix,
one that is aggregated by MAX (or FIRST or whatever, since I
know I'll only get one StudenID per class), and one that is AVG.
That way, I can get a row that has AVG, and a column that has sum.
Is this possible? Thanks.Yes, you can use this expression in the matrix cell:
==IIF(InScope(<ClassGroupName>) And InScope(<StudentIDGroupName>),
Max(Fields!Response.Value), IIF(InScope(<ClassGroupName>),
Avg(Fields!Response.Value), Sum(Fields!Response.Value)))
Fang Wang (MSFT)
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Will" <groups@.willwyatt.com> wrote in message
news:28d5f694.0407181851.2376aecf@.posting.google.com...
> Hi all. Trying something that seems like it shoulb be simple.
> Important Data:
> StudentID (ex. 1, 2, 3)
> Class (ex. Math, English)
> Response (-10 to 10)
> Here is what I'm trying to get
> Student 1 Student 2 Average
> Math -7 3 -2
> English -1 9 4
> Science 10 4 7
> ==================================================> (sum) 2 16 9
>
> So, here is where I am now. I've added two rows to the matrix,
> one that is aggregated by MAX (or FIRST or whatever, since I
> know I'll only get one StudenID per class), and one that is AVG.
> That way, I can get a row that has AVG, and a column that has sum.
> Is this possible? Thanks.

master.dbo.spt_values

Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regards
I don't think spt_values is officially documented in any of
Microsoft's documentation. It's mentioned in some articles
and books - you can find some information in this article:
http://www.winnetmag.com/SQLServer/A...8415/8415.html
and this FAQ post:
http://www.mssqlserver.com/faq/general-sptvalues.asp
It's essentially just a large lookup table used by SQL
Server functions, stored procedures, etc.
-Sue
On Tue, 6 Jul 2004 05:37:05 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:

>Hello,
>Can anybody explain me this table or can send one link
>where i can get this information. This table look likes
>very important but i cant find a good explanation of it.
>Best regards
|||This is an undocumented table, for SQL Server's internal use. What is it
that you are after? You can look at the code of system sps that use this
table.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2739701c46355$f1f742a0$a401280a@.phx.gbl...
Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regards

master.dbo.spt_values

Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regardsI don't think spt_values is officially documented in any of
Microsoft's documentation. It's mentioned in some articles
and books - you can find some information in this article:
http://www.winnetmag.com/SQLServer/.../8415/8415.html
and this FAQ post:
http://www.mssqlserver.com/faq/general-sptvalues.asp
It's essentially just a large lookup table used by SQL
Server functions, stored procedures, etc.
-Sue
On Tue, 6 Jul 2004 05:37:05 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:

>Hello,
>Can anybody explain me this table or can send one link
>where i can get this information. This table look likes
>very important but i cant find a good explanation of it.
>Best regards|||This is an undocumented table, for SQL Server's internal use. What is it
that you are after? You can look at the code of system sps that use this
table.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2739701c46355$f1f742a0$a401280a@.phx
.gbl...
Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regards

master.dbo.spt_values

Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regardsI don't think spt_values is officially documented in any of
Microsoft's documentation. It's mentioned in some articles
and books - you can find some information in this article:
http://www.winnetmag.com/SQLServer/Article/ArticleID/8415/8415.html
and this FAQ post:
http://www.mssqlserver.com/faq/general-sptvalues.asp
It's essentially just a large lookup table used by SQL
Server functions, stored procedures, etc.
-Sue
On Tue, 6 Jul 2004 05:37:05 -0700, "CC&JM"
<anonymous@.discussions.microsoft.com> wrote:
>Hello,
>Can anybody explain me this table or can send one link
>where i can get this information. This table look likes
>very important but i cant find a good explanation of it.
>Best regards|||This is an undocumented table, for SQL Server's internal use. What is it
that you are after? You can look at the code of system sps that use this
table.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"CC&JM" <anonymous@.discussions.microsoft.com> wrote in message
news:2739701c46355$f1f742a0$a401280a@.phx.gbl...
Hello,
Can anybody explain me this table or can send one link
where i can get this information. This table look likes
very important but i cant find a good explanation of it.
Best regards