Summing matrix rows & columns -- sql server reporting services

sql server reporting services : Summing matrix rows & columns

Bill Youngman
3/9/2005 4:47:05 PM

I have the following matrix in my report -

* Fields!GroupItemName.Value is a matrix row and Fields!UserName.Value =
is a matrix column.
* Documents Processed (=3DFields!DocCount.Value)/Avg Time =
(=3DFields!AvgTime.Value)/Total Time (=3DFields!TotalTime.Value) are =
static rows

What I would like to do is this -

Where the Totals rows are the respective sums for each column.

Any suggestions - TIA,

Bill Youngman

Robert Bruckner [MSFT]
3/9/2005 9:28:27 PM

Maybe I'm missing something - but you can easily achieve that by just
right-clicking on the row with Fields!GroupItemName.Value and select
"Subtotal" from the popup menu. That's all you have to do.

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

[quoted text, click to view]
I have the following matrix in my report -

* Fields!GroupItemName.Value is a matrix row and Fields!UserName.Value is a
matrix column.
* Documents Processed (=Fields!DocCount.Value)/Avg Time
(=Fields!AvgTime.Value)/Total Time (=Fields!TotalTime.Value) are static rows

What I would like to do is this -

Where the Totals rows are the respective sums for each column.

Any suggestions - TIA,

Bill Youngman
Anexinet, Inc.

Bill Youngman
3/10/2005 9:11:07 AM

Robert,

I tried that and it is only returning the 1st record for each column and not
the sum of all of the records for that column.

Bill

[quoted text, click to view]

Robert Bruckner [MSFT]
3/10/2005 10:33:10 AM

You only get the first row because your cell expressions use field
references without aggregate function. Replace =Fields!DocCount.Value with
=Sum(Fields!DocCount.Value) and the subtotal cells will then also calculate
the Sum().

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

[quoted text, click to view]

Bill Youngman
3/10/2005 3:15:03 PM

Thanks Robert,

Right after I posted my last reply I decided to play around w/ the subtotal
field and did exactly what you said and it's working like a champ.

[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

home · blog · groups

Questions? Comments? Contact the dn