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

sql server reporting services : Conditional totals for matrix report


Carl Henthorn
7/14/2006 12:19:02 PM
I have a matrix report that has the value of one (1) in the row field when my
row header has that value.

agent air hotel cruise
------- ---- ------ ----------
bob 1 1
jim 1
jane 1 1

What I want is a total at the bottom of the report counting the numbe of
ones in the column. I am very new to SSRS as a whole, so please help!!
venkat.oar NO[at]SPAM gmail.com
7/14/2006 12:26:36 PM
Carl,

Right click on the data row cell and click on "subtotals". Thats it you
have column totals.

--Venkat
[quoted text, click to view]
Carl Henthorn
7/14/2006 1:18:01 PM
Thank you for responding. I have tried the right click method, but the cell
that I need the subtotals on does not have "Subtotal" on the menu. Is there
some other way?
Thanks!


[quoted text, click to view]
venkat.oar NO[at]SPAM gmail.com
7/14/2006 1:53:45 PM
If possible pls send me the rdl file.. i will work on it and send it to
u back..


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