• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 861
  • Last Modified:

SSRS 2005 How to set the Visibility on Matrix Data Column

I don't seem to be able to find a way to set the visibility on a data column in a matrix control. The only visibility I seem to be able to access is either the header textbox or the data textbox but not the column as a whole.

Is it possible?
0
Dale Burrell
Asked:
Dale Burrell
  • 2
  • 2
1 Solution
 
mcv22Commented:
Its not possible to do it with SSRS 2005. SSRS 2008 has an option though: http://msdn.microsoft.com/en-us/library/ms159830.aspx
0
 
planoczCommented:
If your column has one textbox or cell you can do visibity-hide on the sinlge item and this will work  on the whole column.
Really need more details of what you are trying to do.
0
 
Dale BurrellDirectorAuthor Commented:
I have a matrix control with 5 row groups, 1 column group and 7 data fields -  see screenshot.. I would like to make 1 of the 7 data fields hidden under certain circumstances.

I tried setting the visibility on the both the data item and its header textbox (Insurer) but it still gives me an empty white column.
securedownload.jpg
0
 
planoczCommented:
I think you will fine that if you use a table and not a matrix, you will be able to control each field and column easier.
0
 
Dale BurrellDirectorAuthor Commented:
True... but I need a matrix for this report. So I guess you're agreeing with @mcv22?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now