all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

Perform aggregate against group value


Perform aggregate against group value SevDer
10/26/2005 4:36:13 PM
sql server reporting services:
Is there a way that I can perform my aggregate function agains the value in
group row instead of details row?
Because I do not show numeric values in the details but group row.

--

SevDer
http://www.sevder.com
A new .NET Source For .NET Developers


Re: Perform aggregate against group value Robert Bruckner [MSFT]
10/26/2005 7:57:11 PM
Did you try the Previous aggregate function? Just place it into the group
header like =Previous(Fields!Country.Value) and it should work. Note: the
previous function has only one argument.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Re: Perform aggregate against group value SevDer
10/27/2005 10:45:44 AM
Hi Robert,

I tried Previous as you suggested but this time I endup with empty
datacell..
However, please excuse me that I was not clear enough previously, I want to
perform this aggregate against the group in the footer. So I tried to use
the full previous function as described in the help "Previous(Expression,
AggFunction, PreviousScope, AggScope)" but it basically fails as you've
mentioned.

Anyway, do you have a solution for me?
I would like to sum my group values in the footer.

--

SevDer
http://www.sevder.com
A new .NET Source For .NET Developers


[quoted text, click to view]

Re: Perform aggregate against group value Robert Bruckner [MSFT]
10/30/2005 3:23:28 PM
[quoted text, click to view]
Maybe I'm missing something, but assuming you group on
=Fields!FieldName.Value, just adding an expression like
=Sum(Fields!FieldName.Value) in the table footer should sum the group
values.

-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.



[quoted text, click to view]

AddThis Social Bookmark Button