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
 Development Tools
 Reporting Services Development
 Hide row in matrix

Author  Topic 

huynhtl
Posting Yak Master

107 Posts

Posted - 2008-09-15 : 14:11:17
Hi,
Does anyone know how to hide a row in matrix, but still show data?

i.e I have a matrix that have 1 row (name), but in that (name), there are 6 different person, and $$ in the data. I don't want the $$ to sum those 6 different person when I hide the row. I want those 6 ($$) to show, but the (name) to hide.

Hope this is not too confusing.

Please help,

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-09-15 : 14:14:56
it really is confusing. can you illustrate what you want please? cant get much idea from above explanation.
Go to Top of Page

huynhtl
Posting Yak Master

107 Posts

Posted - 2008-09-15 : 14:42:44
I went to row property, select hidden in visibility tab, but when I preview the report, the row is hidden, but the data is all sum up.
Is there a way to hide the row, and still have each of the data visible.
So if the row have let say : red is the title, green is the one I want to hide, everything else show.

Total Information
Name
$$
age

Julie
45.00
15

Jack
66.00
55

Mike
75.00
25

Lily
105.00
35

Tracy
111.00
60

Lola
500.00
16


Hopefully this help


Go to Top of Page

huynhtl
Posting Yak Master

107 Posts

Posted - 2008-09-15 : 14:45:01
Ok, never mind, I've figure it out.
Go to Top of Page

huynhtl
Posting Yak Master

107 Posts

Posted - 2008-09-23 : 17:11:41
In case someone might use this in future, right click in the row itself and click property, invisibility,hidden.
Go to Top of Page

foluis
Starting Member

1 Post

Posted - 2010-05-06 : 16:43:55
quote:
Originally posted by huynhtl

In case someone might use this in future, right click in the row itself and click property, invisibility,hidden.



right click in the row column itself and then click edit group. After that click visibility tab ,hidden.

Luisfer
Go to Top of Page

Ciupaz
Posting Yak Master

232 Posts

Posted - 2013-03-08 : 03:07:27
Hello, is there a way to hidden a Matrix rox based on the value of the report parameter?

Luigi
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-03-08 : 05:36:55
quote:
Originally posted by Ciupaz

Hello, is there a way to hidden a Matrix rox based on the value of the report parameter?

Luigi


yep

write an expression for hidden property under visbility like

=IIF(Parameters!YourParam.value ="test",True,False)

thsi will hide column when parameter value passed is test and make it visible otherwise

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -