Microsoft® SQL Server® 2008 Reporting Services Step by Step

Chapter 6 Quick Reference

To	Do This
Enable interactive sort	Right-click a text box in a column or row header, select Text Box Properties, Interactive Sort, select the Enable Interactive Sort On This Text Box check box, select a Sort scope (detail rows or a group), and select a Sort By expression. If you want, select a group or data region to which the same sort definition should apply.
Add a fixed header	In the Grouping pane, select Advanced Mode. In either the Row Groups or Column Groups section, click the first Static group, and then, in the Properties window, in the FixedData drop-down list, select True.
Configure row or column visibility to toggle when the user clicks a text box	Right-click a row or column handle, select Row Visibility or Column ...