SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Development Tools
 Reporting Services Development
 Hide row in matrix
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

huynhtl
Posting Yak Master

107 Posts

Posted - 09/15/2008 :  14:11:17  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 09/15/2008 :  14:14:56  Show Profile  Reply with Quote
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 - 09/15/2008 :  14:42:44  Show Profile  Reply with Quote
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 - 09/15/2008 :  14:45:01  Show Profile  Reply with Quote
Ok, never mind, I've figure it out.
Go to Top of Page

huynhtl
Posting Yak Master

107 Posts

Posted - 09/23/2008 :  17:11:41  Show Profile  Reply with Quote
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

Colombia
1 Posts

Posted - 05/06/2010 :  16:43:55  Show Profile  Reply with Quote
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

Italy
232 Posts

Posted - 03/08/2013 :  03:07:27  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 03/08/2013 :  05:36:55  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.14 seconds. Powered By: Snitz Forums 2000