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
- Click the title of the column or row that you want to show or hide.
- If the data container is a crosstab, click the Show properties icon , click the Visible property and click Yes or No.
- If the data container is a list, click the Show properties icon and double-click the Column Visibility property.
- To make the list column visible when the report is viewed, click the Visible radio button.
- To hide the list column when the report is viewed, click the Hidden radio button.
- To make the list column visible based on a condition, click the Visible based
on condition radio button, click the edit condition button , 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.