need to change the column heading associated with the Group we modified
earlier, so that it reflects Months, versus the previous grouping
criteria of Sales Territory Group.
the text box containing the column label (immediately above the two measure
values column labels) in the Layout tab (the text box currently
contains the expression =Fields!Sales_Territory_Group.Value).
from the context menu that appears, as depicted in Illustration 17.
Illustration 17: Modifying the Primary Column Label
expression in the upper portion of the Editor with the following:
that the intent is to label the column to reflect the nature of the Group we
have put in place: Months instead of Sales Territory Group.
Editor appears, with our modification, as shown in Illustration 18.
Illustration 18: The Expression Editor with Our Substitution in Place
to accept our modification, and to dismiss the Expression Editor.
column heading for which we have just changed the expression, if necessary, simply
to select the textbox.
Change the Font
Size, in the Format toolbar atop the design environment, from 12pt
to 10pt, to make the presentation more compact, as depicted in Illustration
Illustration 19: Change the Font to 10pt ...
remains to complete our preparatory steps is to remove the pre-existing Report
Parameter. Recall that one of our earlier steps was to remove the Product
entry from the Filter pane (the sample report from which our report was
cloned came equipped with a parameterized Product filter). This entry
had been established with the Parameter checkbox selected, a common way
to create a parameterized filter, as we have seen in various other
articles of the MSSQL Server Reporting Services series. Because
parameterization was selected for the Product filter, it follows that a Report
Parameter might well have been created at the time the entry was
made. We will now remove the remaining Report Parameter.
From the main
menu, select Report ->
as shown in Illustration 20.
Illustration 20: Select Report -> Report Parameters...
Parameters dialog opens, and we see a single Report Parameter
the ProductCategory Parameter is selected.
Click the Remove
button, as depicted in Illustration 21.
Illustration 21: Removing the Residual Report Parameter ...
to accept our modifications, and to dismiss the (now empty) Report
execute the report to ascertain that our modifications are complete, and that
we have a working report for the practice session that follows.
Click the Preview
tab, as shown in Illustration
Illustration 22: Click the Preview Tab to Execute the Report
is being generated message briefly appears, and then the report displays.
The modified report appears as partially depicted in Illustration 23.
Illustration 23: The Modified Report (Partial View)
that the fiscal months July 2001 through July 2004 appear (representing
a total of 37 months, the earliest of which are relatively sparse with
regard to data).
report is now ready for the practice exercise, which we will begin in the next