Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Hide an Item (Report Builder and SSRS)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

Set the visibility of a report item when you want to conditionally hide an item based on a report parameter or some other expression that you specify.

You can also design a report to allow the user to toggle the visibility of report items based on clicking text boxes in the report, for example, for a drilldown report. For more information, see Add an Expand/Collapse Action to an Item (Report Builder and SSRS).

The following procedures describe how to show or hide a report item in a rendered report based on a constant or an expression.

Note Note

You can create and modify report definitions (.rdl) in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder (SSRS) on the Web at microsoft.com.

To hide a report item

  1. In report design view, right-click the report item and open its Properties page.

    Note Note

    To select an entire table or matrix data region, click in the data region to select it, right-click a row, column, or corner handle, and then click Tablix Properties.

  2. Click Visibility.

  3. In When the report is initially run, specify whether to hide the item when you first view the report:

    • To display the item, click Show.

    • To hide the item, click Hide.

    • To specify an expression that is evaluated at run-time, click Show or hide based on an expression. Type the expression or click the expression (fx) button to create the expression in the Expression dialog box.

      Note Note

      When you specify an expression for visibility, you are setting the Hidden property of the report item, as shown in the following image. The evaluated expression shows the report item when the value is False, and hides the report item when the value is True.

      Properties_Visibility dialog and Hidden property

  4. Click OK twice.

To hide static rows in a table, matrix, or list

  1. In report design view, click the table, matrix, or list to display the row and column handles.

  2. Right-click the row handle, and then click Row Visibility. The Row Visibility dialog box opens.

  3. To set the visibility, follow steps 3 and 4 in the first procedure.

To hide static columns in a table, matrix, or list

  1. In Design view, select the table, matrix, or list to display the row and column handles.

  2. Right-click the column handle, and then click Column Visibility.

  3. In the Column Visibility dialog box, follow steps 3 and 4 in the first procedure.

Community Additions

© 2015 Microsoft