Groups | Blog | Home
all groups > sql server reporting services > july 2005 >

sql server reporting services : sum a row help...


trint
7/20/2005 1:10:07 PM
I need one of my column titles to be "transfers". In that column, 8 of
the other columns must be tottaled per row.
Does someone have an example expression please?
Thanks,
Trint
Bassist695
7/21/2005 5:17:22 AM
Are you just looking for a column that contains the sum of 8 other
values in the same row, like this?

col1 col2 col3 col4 col5 col6 col7 col8 Transfers
1 7 6 5 4 3 2 2 30

Therefore, the expression would just be:

=(Fields!col1.Value + Fields! col2.Value + Fields! col3.Value + Fields!
col4.Value + Fields! col5.Value + Fields! col6.Value + Fields!
col7.Value + Fields! col8.Value)

Would that work?

Mike
trint
7/21/2005 9:15:12 AM
Mike,
Thanks! That was it.
Trint

[quoted text, click to view]
AddThis Social Bookmark Button