Column visiblity is *always* disabled?

• cafescott

  SSCarpal Tunnel

  Points: 4724

  More actions

  October 30, 2014 at 8:42 am

  #300697

  Hello,

  I have an SSRS 2008 report that has to show a column if there is a value in a particular field. The column visibility expression I wish to set resembles this:

  =IIF(Fields!My_Field.Value = "",TRUE,FALSE)

  When I right-click on the column (in the tablix), the Column Visibility option is disabled. (Why???) I've done research on this, and people are saying that if I click on the group at the bottom, then turn on "advanced mode", then I will be able to set the Column Visibility in the Properties window.

  Well, I have turned on Advanced Mode. I click on the item in the Row groups pane, and the Visibility property is disabled. Then I click on the "Static" item in the Column Groups pane, and the Visibility property is still disabled.

  Why is the Column Visibility always disabled? What sorcery is required to be able to set an expression there?

  Thanks,