CHAPTER 6 BUILDING REPORTSFigure 6-13. Report sorted interactively to show the number of patients
Interactive sorting is a property of the textbox report item and is typically used on column headings
in a Table or Matrix data region. A single textbox can control sorting for one or more data regions as long
as they are within the same scope or grouping. For example, it is possible to sort multiple tables that are
nested within a List data region.
The EmployeeServiceCost_InteractiveSort.rdl report in the Pro_SSRS project includes interactive
sorting.
Hyperlink Actions
Having the ability to link one report item, such as the contents of a textbox, to another report or URL
adds another valuable level of interactivity in SSRS. By adding hyperlinks to an SSRS report, users can
work with the report as they would an application or a Web page, making their tasks more efficient. The
sections to follow show how to add several links or actions to your reports to aid users in linking to other
reports and locations, such as a company intranet site. You can associate three basic actions with values
in a report:
- Jumping to a bookmark
- Jumping to a URL
- Jumping to a report