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?
Is it possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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
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
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.
ASKER
True... but I need a matrix for this report. So I guess you're agreeing with @mcv22?
Really need more details of what you are trying to do.