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.
| 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. |
 |
|
|
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 InformationName$$ 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 |
|
|
|
huynhtl
Posting Yak Master
107 Posts |
Posted - 2008-09-15 : 14:45:01
|
| Ok, never mind, I've figure it out. |
|
|
|
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. |
|
|
|
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 |
|
|
|
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 |
|
|
|
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
yepwrite 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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
|
|
Hide row in matrix