Click the Data
downward pointing arrow on the right side of the Dataset name box atop the Data
tab, display and select the ProductData dataset, as shown in Illustration 17.
Illustration 17: Select the ProductData Dataset ...
Click the Add...
button to the right of the Values list box, found immediately underneath the
Dataset name selector we populated above.
The values in a Value series determine the size of the slice
in the Doughnut. Multiple Value series appear as separate slices. If we have
multiple Category or Series groups, the group labels are displayed in the chart
Chart Value dialog appears, defaulted to the Values tab.
following into the Series label box, atop the Values tab:
function (fx) button to the right of the Value box, depicted within a
circle in Illustration 18.
Illustration 18: Click the Function Button for the Value Box ...
Click the Fields
(ProductData) option in the bottom left corner pane of the Expression Editor.
values of the ProductData dataset appear within the pane in the bottom right corner
of the Expression Editor.
to place this selection into the main pane atop the Expression Editor.
Expression Editor appears, with our input, as shown in Illustration 19.
Illustration 19: The Expression Editor with Our Input ...
Click OK to
accept our input and to dismiss the Expression Editor.
returned to the Edit Chart Value dialog, which appears with our input as
depicted in Illustration 20.
Illustration 20: The Edit Chart Value Dialog, with Our Input...
Appearance tab on the Edit Chart Value dialog.
Series Style... button in the lower left corner of the Appearance tab.
tabbed Style Properties dialog appears again, just as it did for the Chart
Area Style... and Plot Area Style... buttons we examined earlier. We see the same
Border and Line and Fill tabs, which we will leave at default at this point.
Click OK to
dismiss the Style Properties dialog, and to return to the Appearance tab of the
Edit Chart Value dialog.
Point Labels tab on the Edit Chart Value dialog.
check box to the immediate left of Show point labels atop the Point Labels tab.
downward pointing arrow to the right of the Data label box to display data
=Fields!Internet_Sales_Amount.Value from the options, as shown in Illustration 21.
Illustration 21: Select =Fields!Internet_Sales_Amount.Value as the Data Label ...
Within the Format
code box (just underneath the Data label selector) type the following character
Auto checkbox to the right of the Format code box.
result in the point labels being displayed outside the Doughnut, at an angle to
a connecting line, making the chart more compact and, in this case, making the
labels themselves somewhat easier to read.
Label Style ... button immediately underneath the Angle setting.
The Style Properties dialog box appears.
settings, listed in Table 2 below, within the Style Properties dialog box:
Table 2: Style Properties Dialog
Properties dialog appears, with our settings, as depicted in Illustration 22.
Illustration 22: Style Properties Dialog Box with Settings
Click OK to
Properties box closes. We return to the Edit Chart Value dialog box, which now
appears as shown in Illustration 23.
Illustration 23: The Edit Chart Value Dialog Box, with Our Input
Action tab of the Edit Chart Value dialog.
can define Hyperlink actions, including Jump to report, Jump to bookmark, or
Jump to URL. We will not be working with a drillthrough scenario in this
practice session, and so will leave undisturbed the default setting of None, as
depicted in Illustration 24.
Illustration 24: The Action Tab of the Edit Chart Value Dialog Box
Click the Data
Output tab of the Edit Chart Value dialog.
Output tab affords us a means of defining XML data output options for the
values in the chart. We will not leverage these capabilities within this
introduction to Simple Doughnut charts, and will therefore leave the settings
of the Data Output tab at their defaults, as shown in Illustration 25.
Illustration 25: The Data Output Tab with Default Settings
Click the OK
button at the bottom of the Edit Chart Value dialog, to dismiss the dialog with
returned to the Data tab of the Chart Properties dialog. Next we will work
with the Category groups area of the tab, just under the Values area. Categories
are displayed as individual slices in the Doughnut. Each Category is displayed
in the chart legend, when the legend is selected for use.
Click the Add...
button to the right of the Category groups list box, found immediately
underneath the Values list box with which we worked above.
Grouping and Sorting Properties dialog appears, defaulted to the General tab.
Type (or cut
and paste) the following into the Name box, atop the General tab:
Click the top
row of the Expression box within the Group on section that appears just
underneath the Name box, to enable the selector button (the downward-pointing
arrow) on the right side of the box.
from the options that appear, as depicted in Illustration 26.
Illustration 26: Select =Fields!Sales_Reason.Value in the Top Row of the Expression List ...
have no input for the Filters or Data Output tabs (which resemble their
counterparts in other areas of the Report Designer, as we have, and shall,
see), within the context of this newly added group, and as we intend to leave
the Sorting at the settings naturally found within the cube structure (the Sales
Reasons will sort, where appropriate, in alphabetical order), we will accept
our input at this stage.