You can add drill-down interactivity to your reports using the visibility properties of report items, groups, columns, or rows. Simply set the hidden property to true and set the toggle item to the name of another item in the report, usually a text box in the group containing the hidden item. At run time, this puts a plus sign next to the toggle item which the user can click to display the hidden data.

Tip: If you want detail information to collapse in a drill-down report, you must set the visibility properties of the entire data region, group, column, or row that you want to collapse. If you set it on a single text box, the adjacent text boxes will still be visible, and will prevent the row or column from collapsing.

Because you can use expressions in the Hidden property, you can also hide items based on the value of another report item.

Hidden Data in Exports

You can make your hidden data interactive in the report viewer, but when reports are exported, the various file formats handle hidden data differently.

See Also