Collapse

How to hide columns in Table ReportItem using the report parameters

To hide a column in a Table report item based on a report parameter in the Bold Reports® Standalone Report Designer, set the visibility property of the column to an expression that uses the parameter value. Follow these steps:

  1. Open the report in the Standalone Report Designer.

  2. Add a boolean parameter to the report to change the visibility of the column of the Table ReportItem based on the parameter values.

  3. Select the Table ReportItem and enable the advanced items in the Grouping panel as shown in the following image,

    Grouping panel advanced

  4. Select the required Static column for which the visibility needs to be changed based on the parameter value as shown in the following image.

    Select column

  5. Open the property panel and drill through the visibility property to open the expression window as shown in the following image,

    Column visibility property

  6. Set the expression for the visibility of the column with the parameter value as shown in the following image,

    Column visibility expression

  7. Now, the visibility of the column of the table will be changed based on the parameter value as shown in the following images,

    When the parameter value is true:

    Report with column

    When the parameter value is false:

    Report without column

If you hide the column of Table ReportItem using the column selection, then the column content will only get hidden and not the column itself, as shown in the following image.

Report without column content

See Also

Add report parameter to the report