Hiding Report Items

You can hide any report item, including groups, columns, or rows in a table or matrix. You can hide them from view when the report is rendered in HTML, cause a report item to toggle between visible and hidden when the user clicks on another report item, or hide them based on the contents of other report items.

The primary use of hidden items is to provide a report that shows summary data but also provides a way for the user to drill down into detail data. To create this drilldown effect, select the group, column, or row to hide, set its hidden state to True, and then set the toggle item to the name of a text box in a containing group. When the report is rendered, the user can click the text box to expand and collapse the detail data.

Note

When you create a drilldown report, the visibility information must be set on the group, column, or row that you want to hide, not a single text box in the row or column. If you set these options on just the text box, the rows or columns will not collapse.

To view instructions about hiding report items, see:

Rendering Extension Support for Hidden Report Items

Some rendering extensions display hidden items.

  • XML rendering extension displays all report items, regardless of whether they are hidden.
  • Excel rendering extension displays and expands hidden matrix data regions. All rows and columns are visible.
  • HTML rendering extension does not display hidden items; hidden items are not visible even in the HTML source.

The show-and-hide toggle on report items is supported only by rendering extensions that support user interactivity, such as the HTML rendering extension.

See Also

Concepts

Designing the Report Layout
Adding Interactive Features

Help and Information

Getting SQL Server 2005 Assistance