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 2008 Forums
 Analysis Server and Reporting Services (2008)
 hide conditionally a row group in a group hierarch

Author  Topic 

buraktuf
Starting Member

13 Posts

Posted - 2010-07-19 : 09:44:27
hi,
i'm using ssrs 2008 and have a row group hierarchy in my matrix.
my hierarchy looks like
a
-b
--c
---d
and the resulting matrix looks like

a1 b1 c1 d1 data
c1 d2 data
b2 c2 d1 data
b2 c3 d3 data
a2 b3 c2 d3 data
b4 c1 d5 data ..........

i just wanna hide a row group say "d" according a condition. but when i right click on this group and write on visibility properties an expression like IIF(condition,true,false); the expression properly works but when the row group is hidden all other parent row groups ("a","b","c") are not shown accordingly.
anyone knows how can i hide one row group in this situation?
thanks for any reply.
   

- Advertisement -