Mastering OLAP Reports: Parameterizing Number of "Top" Items with the MDX TopCount() Function, Part I - Page 5
July 29, 2008
We next 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.
37. Right-click 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).
38. Select Expression... from the context menu that appears, as depicted in Illustration 17.
The Expression Editor opens.
Recall 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.
40. The Expression Editor appears, with our modification, as shown in Illustration 18.
41. Click OK to accept our modification, and to dismiss the Expression Editor.
42. Click the column heading for which we have just changed the expression, if necessary, simply to select the textbox.
43. 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 19.
All that 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.
44. From the main menu, select Report -> Report Parameters..., as shown in Illustration 20.
The Report Parameters dialog opens, and we see a single Report Parameter listed.
45. Ensure that the ProductCategory Parameter is selected.
46. Click the Remove button, as depicted in Illustration 21.
47. Click OK to accept our modifications, and to dismiss the (now empty) Report Parameters dialog.
We will execute the report to ascertain that our modifications are complete, and that we have a working report for the practice session that follows.
48. Click the Preview tab, as shown in Illustration 22.
The Report is being generated message briefly appears, and then the report displays. The modified report appears as partially depicted in Illustration 23.
We note 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).
Our report is now ready for the practice exercise, which we will begin in the next section.