Show or Hide a Column or Row

You can show or hide a column in a list or a column or row in a crosstab when the report is viewed.

Procedure

  1. Click the title of the column or row that you want to show or hide.
  2. If the data container is a crosstab, click the Show properties icon Show properties icon, click the Visible property and click Yes or No.
  3. If the data container is a list, click the Show properties icon Show properties icon and double-click the Column Visibility property.
  4. To make the list column visible when the report is viewed, click the Visible radio button.
  5. To hide the list column when the report is viewed, click the Hidden radio button.
  6. To make the list column visible based on a condition, click the Visible based on condition radio button, click the edit condition button New button icon., and specify the condition.
    • If you want to specify a value to use for the condition, click the Value radio button, type the value, and in the Data Type drop-down list, select the value’s data type.
    • If you want to use null as the value for the condition, click the Empty Variable radio button instead.
    • Click the Operator drop-down list and select the operator that you want to use for the condition.
    • In the Active Report Variable drop-down list, select the active report variable that you want to use for the condition.
    • If you want to apply the condition when no item is selected in a control that is connected to the list, clear the Drop this condition if the variable is empty check box.