Add Column Values To the Bottom Of the Row By Condition -- sql server reporting services

vamsi
5/31/2006 4:02:06 PM

Hi
I am getting some results from stored procedure.

Name Value1 Value2 Value3 Total

North 1 2 3 6
North 4 5 6 15
South 5 6 7 18

Footer (North) 5 7 9 21
Footer(South) 5 6 7 18

I displaying footer for each group and i want to display Total value of
the column for that respective group Name.Is therea way to add all
column value depending up on the condition.

For North add only 2 rows.

Can any one help on this issue.

Thanks

Amarnath
6/1/2006 9:22:01 PM

try sum in the group

=Sum(field!abc.value, "group1") you can have scope in the sum.

Amarnath

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Add Column Values To the Bottom Of the Row By Condition