Hide column in a matrix in reporting services

Question

Post reply

Hide column in a matrix in reporting services

meghna.bhargav

SSCrazy

Points: 2634
More actions
July 29, 2008 at 12:28 am

#190374

Hi
How to hide column in a matrix in reporting services?
Any help will be highly appreciated
-Meghna

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Sandip Shinde SSCrazy Points: 2068 More actions · Answer 1

Meghna,

You can use column visiblity with your expression(condition) to hide columns in SSRS Reports.

I hope this will suit your requirement.

Let me know if you have any queries.

wish u all the best

Sandip Shinde

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 2

In matrix , there is no property like visibility in repoerting sevrices 2003.

try it and let me knw

thanks

Sandip Shinde SSCrazy Points: 2068 More actions · Answer 3

I know only three versions or SSRS i.e. 2000, 2005 & 2008

I don't how how you are working on SSRS 2003.

Let me know the correct version which you are working on.

Sandip

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 4

Yes am working on Microsoft visual studio 2003 reporting services.

Sandip Shinde SSCrazy Points: 2068 More actions · Answer 5

Ok VS 2003 is your development environment. Let me know which SQL Server you are using..?

Any ways I just checked with my project & in my Matrix table.

Right Click on your Column >> Select Column Visibility >> Select "Show or Hide Based on an Expression" Option Button >> Write you expression (Condition)

Hope this will work.

Sandip Shinde

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 6

Hi sandeep ,

Please refer the screenshot , here m not seeing ny such property!

Please can u guide me further:-)

Thanks

Sandip Shinde SSCrazy Points: 2068 More actions · Answer 7

Don't go to properties...

As per my instructions.. RIGHT CLICK on Column Header. & got to Column Visibility.

meghna.bhargav SSCrazy Points: 2634 More actions · Answer 8

meghna.bhargav

SSCrazy

Points: 2634

July 29, 2008 at 10:22 pm

#850249

Thanks for your help!

mwarr SSC Rookie Points: 35 More actions · Answer 9

I do not have this option with 2005 version . is there any other way ?

Fausto Gonzalez SSC-Addicted Points: 441 More actions · Answer 10

Actually, for RS 2005, you don't click on the matrix column. You'll have to select the matrix itself (ie. matrix1 Matrix), right click to select properties. Matrix Properties box shows up. Go to Groups tab. Select your column and click Edit. The Grouping and Sorting Properties box shows up. Go to Visibility tab. Select Expression and place your expression for the column you'd like to hide. For example, =IIF(IsNothing(Fields!ColumnName.Value), True, False)

Luis Forero Newbie Points: 3 More actions · Answer 11

I think that if you edit the group (not the text) you could accomplish what you want

In the group properties you could use the visibility property

Right click the group that you want to hide and then select Edit Group

Raunak Jhawar SSCoach Points: 15701 More actions · Answer 12

Thant is even better and also one can toggle the visibility options using the appropriate crietria that suits one's requirement

Raunak J

myjobsinus SSC Eights! Points: 964 More actions · Answer 13

Let’s say my report(SSRS 2005) have 5 columns. And I want to show/ hide columns based on a parameter(multi select with all 5 column names) selected by user. do as following

1)Create a parameter of type string (ColumnVisibility is name of my parameter) with desired column names in labels for the 5 columns and INT number(01,02,03,04,05) respectively in the values in “Available Values” section of the parameter wizard.

2) Then Go to column Properties on design . Go to “visibility” and paste following

=iif(instr(Join(Parameters!ColumnVisibility.Value,","),"01")>0,false,true)

3) repeat same for all the columns, by increasing the int value by 1..see following for example

2nd column -

=iif(instr(Join(Parameters!ColumnVisibility.Value,","),"02")>0,false,true)

3rd column

=iif(instr(Join(Parameters!ColumnVisibility.Value,","),"03")>0,false,true)

And so on.

for SSRS 2008, when you right click on the column you can see "Column Visibility" option. paste the code in "show or hide based on an expression" section for each column.

Hope this helps.

Arvind