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
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Hide column in matrix		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Ciupaz
Posting Yak Master

Italy
180 Posts
Posted - 03/12/2013 :  12:24:03  Show Profile  Reply with Quote
Hello all,
how can I hide a column in a matrix, so I can see it like 2 separated tables in my Excel export?

Thanks in advance.

Luigi

visakh16
Very Important crosS Applying yaK Herder

India
48012 Posts
Posted - 03/12/2013 :  13:45:01  Show Profile  Reply with Quote
hmm...not clear on that. can you post a screenshot? how can you show matrix as two tables?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

Ciupaz
Posting Yak Master

Italy
180 Posts
Posted - 03/12/2013 :  15:53:18  Show Profile  Reply with Quote
How can I insert a screenshot?
Go to Top of Page

Ciupaz
Posting Yak Master

Italy
180 Posts
Posted - 03/12/2013 :  15:54:45  Show Profile  Reply with Quote
Simply I have a Matrix that shows some values grouped and summed. I need to hide a column (empty) inside this Matrix so in the report appear like 2 separated tables.

Luigi
Go to Top of Page

Ciupaz
Posting Yak Master

Italy
180 Posts
Posted - 03/12/2013 :  16:08:09  Show Profile  Reply with Quote
Give view here:

http://social.msdn.microsoft.com/Forums/it-IT/sqlserverit/thread/8bb631dc-f9e8-4fd2-89ec-f676530e6a77
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
48012 Posts
Posted - 03/13/2013 :  01:13:47  Show Profile  Reply with Quote
did you try setting hidden property to true for cell?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

Ciupaz
Posting Yak Master

Italy
180 Posts
Posted - 03/13/2013 :  04:30:28  Show Profile  Reply with Quote
Yes, I've set hidden the cell and also set "none" for the BorderStyle of the textbox.
Thank you for the tip Visakh.

Luigi
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
48012 Posts
Posted - 03/13/2013 :  04:45:02  Show Profile  Reply with Quote
does it work now?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
Go to Top of Page

Ciupaz
Posting Yak Master

Italy
180 Posts
Posted - 03/13/2013 :  05:24:11  Show Profile  Reply with Quote
Yes it is.

Luigi
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
48012 Posts
Posted - 03/13/2013 :  06:41:37  Show Profile  Reply with Quote
cool..

------------------------------------------------------------------------------------------------------
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.09 seconds. Powered By: Snitz Forums 2000