Procedure: Add Support for Interactive Sorting in a Relational
could, of course, be added to our report via the method we undertook in Black Belt Components: Ad Hoc Sorting with Parameters, However, as we have already
noted, our specific focus in
this section will be the addition of support for interactive sorting through
leveraging new properties settings.
Let's open our new report in Layout view and make the
necessary settings to support the interactive sorting capabilities
requested by the information consumers.
Sort.rdl in the Solution Explorer.
from the context menu that appears, as shown in Illustration 17.
Illustration 17: Opening
the New Report ...
Sort.rdl opens in
Layout view, and appears as depicted in Illustration 18.
preview the report, so as to get a feel for its general operation prior to
performing our enhancements.
Click the Preview
tab to execute RS024_Interactive Sort.
begins (the report initially executes with the default parameter setting).
report executes, and appears as shown in Illustration 19.
The Report Appears Default Parameter Selection ...
now positioned to enable the report to support interactive sorting. To
do so, we will return to Layout view, and then access the properties
settings for the Item Number textbox.
Click the Layout
the textbox containing the label Item Number (the heading for the Item
Number column in the report).
from the context menu that appears, as depicted in Illustration 20.
20: Accessing the Properties for the Item Number Column Heading ...
Properties dialog opens.
Select the Interactive
Sort tab of the dialog.
check box atop the tab labeled Add an interactive sort action to this
checkmark appears in the check box, indicating that interactive sort is
In the Sort
expression box that appears immediately underneath the check box, select
the following from the options that appear within the selector:
In the section
just below the Sort expression box, labeled Data region or grouping
to sort, click the radio button labeled Choose data region or grouping.
selector just below the radio button, select the following item:
radio button to the left of Detail scope, in the section labeled Evaluate
sort expression in this scope, at the default, selected setting.
leave the Detail scope selection in place as we intend only to sort the
repeating rows of the data region we have selected. Had the need arisen, we might
have specified another data region or group upon which to enact our sorts.
Sort tab of the Textbox Properties dialog appears as shown in Illustration
Illustration 21: The Interactive Sort tab...
to save our settings and to dismiss the Textbox Properties dialog.
to the Layout tab, where we are now ready to verify the effectiveness of