dcsimg

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

January 16, 2007

Now, only a few minor cleanup items remain in our preparation sequence.

63.  Right-click the value field underneath the column label Internet Orders. The value displayed in the box is =Sum(Fields!Internet_Order_Quantity.Value)”).

64.  Click Properties from the context menu that appears, as depicted in Illustration 27.


Illustration 27: Editing the Value Field Properties ...

65.  On the Textbox Properties dialog that next appears, click the Format tab.

66.  Replace the existing Format code setting (in the upper left corner of the Format tab) with the following string:

#,###

Here we are simply changing the existing format to one that is more appropriate for a count value. The Format code appears on the Format tab of the Textbox Properties dialog as shown in Illustration 28.


Illustration 28: Replacing the Existing Format Code ...

67.  Click OK to accept our modification, and to dismiss the Textbox Properties dialog.

Now let’s reset a couple of basic layout dimensions to make the report a bit more compact.

68.  Select all four row group columns, by clicking them, one after another, with the SHIFT key depressed.

69.  In the Properties pane, set the Width for the columns to 1.00, as depicted in Illustration 29.


Illustration 29: Modifying the Widths for the Four Selected Columns ...

70.  Click inside the report body to enact the new Width setting.

The selected columns immediately contract as expected.

71.  Click inside the Matrix, once again, to cause its handles to appear.

72.  Click the handles for the bottom two rows of the matrix, to highlight / select both rows.

73.  Set the Font Size (in the toolbar above the development environment) for the selected rows to 8pt, as shown in Illustration 30.


Illustration 30: Setting Font Size for the Bottom Two Rows of the Matrix ...

The font adjusts immediately within the affected rows.

74.  In a similar manner, click the handle for the row immediately above the bottom two rows we have just modified (and the second row from the top of the Matrix), to highlight / select it.

75.  Assign a Font Size of 10pt to the selected row.

76.  Click the top report heading, which bears the words “Adventure Works Cycles,” to select the textbox involved.

77.  Assign the textbox a Font Size of 12pt, as depicted in Illustration 31.


Illustration 31: Setting the Font Size for the Primary Report Heading

As a final piece of housekeeping, we will name the four textboxes reflecting the row groups we have added. We will then reference one of these names in our concluding preparatory step, where we set visibility for the Date column.

78.  Right-click the leftmost textbox of the Matrix value row (the textbox whose contents we modified to “=Fields!Calendar_Year.Value” in an earlier step of this section).

79.  Select Properties on the context menu that appears.

The Textbox Properties dialog opens, defaulting to the General tab, as we saw earlier.

80.  Replace the existing Name (“Sales_Reason_1”) in the upper portion of the Editor with the following:

 Calendar_Year

The Textbox Properties dialog appears, with our modification, as shown in Illustration 32.


Illustration 32: The Textbox Properties Dialog – General Tab, with Our Substitution in Place

81.  Click OK to accept our modification, and to dismiss the Textbox Properties dialog.

82.  Right-click the textbox to the immediate right of the one we have just renamed “Calendar_Year.”

83.  Select Properties on the context menu that appears.

84.  Replace the existing Name (“textbox4” or similar), atop the Textbox Properties dialog General tab that next appears, with the following:

Calendar_Quarter

85.  Click OK to accept our modification, and to dismiss the Textbox Properties dialog.

86.  Right-click the textbox to the immediate right of the one we have just renamed “Calendar_Quarter.”

87.  Select Properties on the context menu that appears.

88.  Replace the existing Name (“textbox5” or similar), atop the Textbox Properties dialog General tab that next appears, with the following:

Calendar_Month

89.  Click OK to accept our modification, and to dismiss the Textbox Properties dialog.

We will now return to the Matrix Properties dialog to make our last preparatory settings.

90.  Right-click the upper left-hand corner of the Matrix data region (the gray square), once again.

NOTE: If the handles for the Matrix data region are not visible, click somewhere within the region to cause them to appear, so as to enable the step above.

The gray column and row bars disappear, as the outline that we saw earlier forms around the Matrix data region.

91.  Select Properties on the context menu that appears, as we did earlier.

The Matrix Properties dialog appears, defaulted to the General tab, once again.

92.  Click the Groups tab.

93.  In the Rows section of the Groups tab (in the upper half of the tab), select the matrix1_Cal_Date entry (the bottom row group in the list).

94.  Click the Edit button, once again.

The Grouping and Sorting Properties dialog appears.

95.  Click the Visibility tab.

96.  On the Visibility tab, click the radio button labeled Hidden, to select Initial visibility of Hidden.

97.  Place a check in the checkbox labeled “Visibility can be toggled by another report item.”

98.  In the selector labeled Report item, which becomes enabled upon checking the above, select Calendar_Month, as depicted in Illustration 33.


Illustration 33: Select Calendar Month as the Toggle Point for Calendar Date

99.  Click OK to accept our modification, and to dismiss the Grouping and Sorting Properties dialog.

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

We are returned to the Layout tab. 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.

101.  Click the Preview tab, as shown in Illustration 34.


Illustration 34: Click the Preview Tab ...

The Report is being generated message briefly appears, and then the report displays.

102.  Click the “+” sign to the left of January 2002 (which is at the right of Q1 CY 2002, near the top of the report), to ascertain that the Visibility setting behaves as expected.

The modified report, complete with the sample expanded Calendar Month, appears as partially depicted in Illustration 35.


Illustration 35: The Modified Report (Partial View)

Our non-parameterized, non-filtered report is now ready for the practice session, which we will begin in the next section.








The Network for Technology Professionals

Search:

About Internet.com

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