Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Dynamic Field Visibility

Author  Topic 

the_justin
Starting Member

19 Posts

Posted - 2009-09-03 : 21:34:58
Hi all,
is there a way to set a field visibility based on other field's state of visibility ?
I have a matrix and it has 2 column groups and a subtotal for one of the column group.
The initial state is all columns (except for the subtotal) are hidden.
Now I want to hide the subtotal only if the column groups are visible.

anyone knows of how to do this ?

thanks in advance

savior faire
Posting Yak Master

194 Posts

Posted - 2009-09-06 : 10:38:49
You can make columns or rows toggle-able(is that a word) by bring up it's property page, and setting it's visibility property, the also specifying if the field can be toggled by another field on the report.

Talk sense to a fool and he calls you foolish.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2009-09-06 : 14:03:33
you need to write an expression for visibility property of column. b/w are you using standard subtotal column?
Go to Top of Page
   

- Advertisement -