x
login about faq Site discussion (meta-askssc)

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 '12 at 07:18 AM in Default

kasunsm.kt gravatar image

kasunsm.kt
0 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 '12 at 08:13 AM

Fatherjack gravatar image

Fatherjack ♦♦
38.8k 55 69 104

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 '12 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 '12 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 '12 at 02:36 PM kasunsm.kt

@Fatherjack I am unable to see any image :(

Jul 18 '12 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

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x95

asked: Jul 18 '12 at 07:18 AM

Seen: 304 times

Last Updated: Jul 19 '12 at 06:06 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.