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 |
|
Ciupaz
Posting Yak Master
232 Posts |
 Posted - 2013-03-12 : 12:24:03
|
| 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
52326 Posts |
Posted - 2013-03-12 : 13:45:01
|
| hmm...not clear on that. can you post a screenshot? how can you show matrix as two tables?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2013-03-12 : 15:53:18
|
| How can I insert a screenshot? |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2013-03-12 : 15:54:45
|
| 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 |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2013-03-12 : 16:08:09
|
| Give view here:http://social.msdn.microsoft.com/Forums/it-IT/sqlserverit/thread/8bb631dc-f9e8-4fd2-89ec-f676530e6a77 |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-13 : 01:13:47
|
| did you try setting hidden property to true for cell?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2013-03-13 : 04:30:28
|
| Yes, I've set hidden the cell and also set "none" for the BorderStyle of the textbox. Thank you for the tip Visakh.Luigi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-13 : 04:45:02
|
| does it work now?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Ciupaz
Posting Yak Master
232 Posts |
Posted - 2013-03-13 : 05:24:11
|
| Yes it is.Luigi |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-03-13 : 06:41:37
|
| cool..------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Hide column in matrix