The Data
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 Column 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
23. Click
the OK button at the bottom of the Edit Chart Value dialog,
to dismiss the dialog with our settings.
We are
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 optional, and are displayed as bars
or groups of bars on the Y-axis. Multiple groups are nested, as
we shall see within our current practice example.
24. 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.
The Grouping
and Sorting Properties dialog appears, defaulted to the General tab.
25. Type (or
cut and paste) the following into the Name box, atop the General
tab:
chart1_Cat1_Year
26. 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.
27. Select =Fields!Calendar_Year.Value
from the options that appear, as depicted in Illustration 26.
Illustration 26: Select
=Fields!Calendar_Year.Value in the Top Row of the Expression List ...
As we
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 Calendar Years will sort in numerical order), we will
accept our input at this stage.
The Grouping
and Sorting Properties dialog appears, with our modifications, as shown in Illustration
27.
Illustration 27: The
Grouping and Sorting Properties Dialog with Our Modifications
28. Click
the OK button at the bottom of the Grouping and Sorting
Properties dialog, to save our settings and to dismiss the dialog.
We are
returned to the Data tab of the Chart Properties dialog. Next we
will add another Category group to our report.
29. Click
the Add... button to the right of the Category groups
list box, just as we did before.
The Grouping
and Sorting Properties dialog appears, once again, defaulted to the General
tab.
30. Type
the following into the Name box, atop the General tab:
chart1_Cat2_Territory
31. Click
the top row of the Expression box within the Group on
section, once again, to enable the selector button (the downward-pointing
arrow) on the right side of the box.
32. Select =Fields!Sales_Territory_Group.Value
from the options that appear, as depicted in Illustration 28.
Illustration 28: Select
=Fields!Sales_Territory_Group.Value in the Top Row of the Expression List ...
The Grouping
and Sorting Properties dialog appears, with our modifications, as shown in Illustration
29.
Illustration 29: The
Grouping and Sorting Properties Dialog with Our Modifications
As we
have no input for the Filters or Data Output tabs 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 Territory
Groups will sort in alphabetical order), we will accept our input at this
stage, just as we did with the previously added Category group, chart1_Cat1_Year.
33. Click
the OK button at the bottom of the Grouping and Sorting
Properties dialog, to save our settings and to dismiss the dialog.
We are
returned to the Data tab of the Chart Properties dialog, once
again. Our next step will be to add another group – this time an optional Series
group. Series are displayed as individual bars in the chart.
Each series is also displayed in the chart legend. At this
point, we will add a Series group to contain the Sales Reason (Manufacturer,
On Promotion, Price, etc.) that is associated with the grouped Internet
Sales totals that the report will present.
34. Click
the Add... button to the right of the Series groups
list box, just as we did in making our two Category groups entries
earlier.
The Grouping
and Sorting Properties dialog appears, once again, defaulted to the General
tab.
35. Type (or
cut and paste) the following into the Name box, atop the General
tab:
chart1_Series1_Reason
36. Click
the top row of the Expression box within the Group on
section, yet again, to enable the selector button (the downward-pointing
arrow) on the right side of the box.
37. Select =Fields!Sales_Reason.Value
from the options that appear, as depicted in Illustration 30.
Illustration 30: Select =Fields!Sales_Reason.Value in the Top Row of the Expression List ...
The Grouping
and Sorting Properties dialog appears, with our modifications, as shown in Illustration
31.
Illustration 31: The
Grouping and Sorting Properties Dialog with Our Modifications
Because
we again have no input for the Filters or Data Output tabs 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 in alphabetical order), we will accept our input at this stage, just
as we did with the previously added Category groups, chart1_Cat1_Year
and chart1_Cat2_Territory.
38. Click
the OK button at the bottom of the Grouping and Sorting
Properties dialog, to save our settings and to dismiss the dialog.
39. We
return to the Data tab, once again, which appears, with our Values,
Category groups, and Series groups settings, as depicted in Illustration
32.
Illustration 32: Chart
Properties Dialog Box – Data Tab with Our Settings
We will
move to the X Axis tab in the subsection that follows.
» 
Comment and Contribute
