Mastering OLAP Reports: Parameters for Analysis Services Reporting, Pt. II - Page 4January 16, 2007 40. Click the Add button, as depicted in Illustration 19.
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.
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.
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.
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.
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.
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.
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.
|
|
|
The Network for Technology Professionals
Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers
