• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 856
  • 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

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

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