Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. II - Page 4

January 16, 2007

40.  Click the Add button, as depicted in Illustration 19.


Illustration 19: Adding a New Row Group

The Grouping and Sorting Properties dialog reappears, defaulted to its General tab, as before.

41.  Atop the General tab, change the default Name to the following:

matrix1_Cal_Qtr

42.  Click the row containing the Expression value (currently the expression is blank) within the Group on list, to enable the selector.

43.  Select =Fields!Calendar_Quarter.Value within the selector.

The Grouping and Sorting Properties dialog appears, with our input, as shown in Illustration 20.


Illustration 20: The Grouping and Sorting Properties Dialog with Our Input

44.  Click OK, to accept our modifications, and to close the Grouping and Sorting Properties dialog.

45.  Click the Add button, once again.

The Grouping and Sorting Properties dialog appears, once again.

46.  Atop the General tab, change the default Name to the following:

matrix1_Cal_Month

47.  Click the row containing the Expression value (currently the expression is blank) within the Group on list, to enable the selector.

48.  Select =Fields!Month.Value within the selector.

The Grouping and Sorting Properties dialog appears, with our input, as depicted in Illustration 21.


Illustration 21: The Grouping and Sorting Properties Dialog with Our Input

49.  Click OK, to accept our modifications, and to close the Grouping and Sorting Properties dialog.

50.  Click the Add button, once again.

The Grouping and Sorting Properties dialog reappears.

51.  Atop the General tab, change the default Name to the following:

matrix1_Cal_Date

52.  Click the row containing the Expression value (currently the expression is blank) within the Group on list, as before, to enable the selector.

53.  Select =Fields!Date.Value within the selector.

The Grouping and Sorting Properties dialog appears, with our input, as shown in Illustration 22.


Illustration 22: The Grouping and Sorting Properties Dialog with Our Input

54.  Click OK, to accept our modifications, and to close the Grouping and Sorting Properties dialog.

The Group tab reappears, with our input, as depicted in Illustration 23.


Illustration 23: The Grouping Tab with the New Groups

55.  Click OK on the Groups tab, to close the Matrix Properties dialog.

We are returned to the Layout view.

56.  Once again on the Layout view, right-click the leftmost textbox of the Matrix value row (which currently contains the “=Fields!Sales_Reason.Value”).

57.  Select Expression ... on the context menu that appears, as shown in Illustration 24.


Illustration 24: Editing the Existing Value Expression ...

The Expression Editor opens.

58.  Replace the expression in the upper portion of the Editor with the following:

=Fields!Calendar_Year.Value

The intent is to label the column to reflect the nature of the Group we have put in place: Years instead of Sales Reasons.

59.  The Expression Editor appears, with our modification, as depicted in Illustration 25.


Illustration 25: The Expression Editor with Our Substitution in Place

60.  Click OK to accept our modification, and to dismiss the Expression Editor.

Since the report no longer deals with Sales Reasons, we will eliminate the Sales Reason heading label.

61.  Right-click the textbox (containing the title Sales Reason), immediately above the box for which we changed the expression to “=Fields!Calendar_Year.Value.”

62.  Select Delete on the context menu that appears, as shown in Illustration 26.


Illustration 26: Deleting the Unwanted Label ...








The Network for Technology Professionals

Search:

About Internet.com

Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers