changing subtotal expression

Hello,

I'm using a matrix report to display scores for certain items on certain criteria.
The items are on the left and the criteria at the top.

Now I would like to have some sort of subtotal row at the end of each group of items that displays the average value of all the scores for that group and not simply adds up the scores.
The built-in subtotal just adds up the scores, where I want the average value to be displayed.

Isn't there an easy way to change the subtotal expression and make it calculate the average value instead of the sum?

Thank you for your time,

Kenny

Yes this can be done through the InScope function. Please read this related thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=276213&SiteID=1

-- Robert

Changing Report's Datasource

I have one report that I want to have the ability to use different stored
procedures...depending on the the user's criteria they want to see. Is there
an RS method that I can use to change the stored procedure that a report is
using at runtime, or is there a better way to do what I want to do?ALthough I have never tried this,,, you could create a single SP which calls
the other SPs based on the user... OR
in the data set you can put the T-SQL IF statement to choose the SP..
I suspect that the SPs need to return the same result sets however...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Mike Collins" wrote:
> I have one report that I want to have the ability to use different stored
> procedures...depending on the the user's criteria they want to see. Is there
> an RS method that I can use to change the stored procedure that a report is
> using at runtime, or is there a better way to do what I want to do?