all groups > sql server reporting services > august 2005 >
You're in the

sql server reporting services

group:

Matrix SubTotals Visibility


Matrix SubTotals Visibility Noah
8/15/2005 10:49:37 AM
sql server reporting services:
I am creating a report using a matrix, and matrix subtotals.
I give the user the option of including the reporting hierarchy in their
reports. If they want to include it, I would like to hide the subtotal,
completely.
The reason for this is because if I include a hierarchy within a single
field of a report, the subtotals don't sum properly.
Is there any way to hide the entire subtotal field within a matrix report?
I have tried modifying the Hidden field (using an expression) of the
SubTotal textbox, but that only seems to hide the textbox itself, not
the subtotal fields.

Thanks,

Re: Matrix SubTotals Visibility Noah
8/15/2005 1:54:27 PM
Nevermind. Figured it out using InScope().

Noah

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