Row Total In Table -- sql server reporting services

Joe Delphi
7/19/2006 7:30:58 PM

Hi,

I have a table in my report (not a matrix) that displays 50 rows by
6 columns - fixed, no grouping requirements. The user wants to see the
total of both the vertical column (easy) and also the horizontal row - not
so easy.

First I tried this expression = SUM(Fields!Field1.Value +
Fields!Fields2.Value.....etc) but this did not give the correct number.

A co-worker told me that a horizontal row sum was "impossible" to do
with a table and that I had to swap my table for a matrix.

Can anyone tell me how to get the sum of a horizontal row of a
table?

JD

Amarnath
7/19/2006 11:11:02 PM

Just try this,
= SUM(Fields!Field1.Value +sum(Fields!Fields2.Value) + .....etc

Amarnath

[quoted text, click to view]

Amarnath
7/19/2006 11:13:01 PM

Sorry, Sending you again
Just try this
= SUM(Fields!Field1.Value) + SUM(Fields!Fields2.Value) + ........etc

Amarnath

[quoted text, click to view]

magendo_man
7/20/2006 2:41:01 AM

To get the horizontal row sume miss out the SUM(). Just use the expression
=Fields!Field1.Value+Fields!Field2.Value+...+Fields!Field6.Value

HTH,
Magendo_Man

[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 : Row Total In Table