How to hide a colum in a matrix(actually its a row group)

alt text

I have a matrix like this."Amount" and "Name" column are built dynamically.What I want is hide the Group1 column according to a expression. help me

capture.png (8.7 kB)
more ▼

asked Jul 18, 2012 at 07:18 AM in Default

avatar image

0 1 1 1

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

I would expect that you could place an expression that results in True or False in the Visibility property of the Group1 group to do what you need

The propeties can be set by right clicking:
alt text

and then editing
alt text

more ▼

answered Jul 18, 2012 at 08:13 AM

avatar image

Fatherjack ♦♦
43.8k 79 101 118

Hi Jonathan, But there is no option for "Column Visibility" in matrix.but in a table,we can right click on the whole column and make the "Column Visibility" property to 'Hide'.But in matrix ,that optiion is not active.

Jul 18, 2012 at 09:26 AM kasunsm.kt

@kasunsm.kt I do not understand what is the reason behind using a matrix and then try to hide the Row Group column? It would have make sense to show or hide the Row Group (a row) entirely.

But If you still want that, then Showing Or Hiding the textbox of Row Group could only be the option you have (Text Box Properties -> Visibility -> Show Or Hide). This will leave the column space in there but would not show the Row Group.

Jul 18, 2012 at 01:55 PM Usman Butt

Hi, 'Amount','Name' columns are added dynamically...there can be more...thats why I used a matrix...

I want to hide the 'Group1' column.because when client view the report,someone don't need that column to be shown...then I should give them the ability to hide that column.First of all I have to check whether it can be done or not...thats why I'm trying to hide that column as a example...

Jul 18, 2012 at 02:36 PM kasunsm.kt

@Fatherjack I am unable to see any image :(

Jul 18, 2012 at 01:56 PM Usman Butt
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 18, 2012 at 07:18 AM

Seen: 828 times

Last Updated: Jul 19, 2012 at 06:06 AM

Copyright 2018 Redgate Software. Privacy Policy