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.
|Export Type||Filename Extension||Effect on Hidden Data|
|Web Archive||.mhtml||Hidden data is not shown unless it is in an expanded state when the report is exported.|
|Acrobat||Hidden data is not shown unless it is in an expanded state when the report is exported.|
|Image||.bmp, .emf, .gif, .jpeg, .tiff, .png||Hidden data is not shown unless it is in an expanded state when the report is exported.|
|Extensible Markup Language||.xml||All hidden data is shown.|