Click the Edit
button to the right of the highlighted group.
The Grouping and Sorting Properties dialog - General tab appears.
contents of the Name box atop the tab, BrandSales_Brand_Name,
with the following:
In the Group
On: list, use the selector button to the right of the top line in the list,
to modify the existing expression, =Fields!Brand_Name.Value, to the
Illustration 26 depicts scrolling down on the selector to select the
and Sorting Properties dialog - General tab appears, as shown in Illustration 27.
Illustration 27: Grouping
and Sorting Properties Dialog - General Tab
returned to Matrix Properties dialog - Group tab, where we
note that the bottom row group now reflects the name change we made in the Grouping
and Sorting Properties dialog.
to accept modifications, and to close the dialog.
to close the Matrix Properties dialog.
to the Layout tab. We now need to make another modification to continue
with the drill-down-related changes requested by the information consumer
the textbox fourth column from the left / right (currently showing "=
Fields!Brand_Name.Value" in the Layout view.
from the context menu that appears.
Properties dialog appears.
in the Name box with the following:
following by clicking the selector for Value, just below Name, to
replace the current "= Fields!Brand_Name.Value" :
Properties dialog appears (modifications circled) as depicted in Illustration 28.
Illustration 28: Textbox
Properties Dialog - Modifications Circled
to close the Textbox Properties dialog.
to the Layout tab. We have one more modification to make to complete
the structural changes that the intended audience has requested: to remove the
capability to drill down from Year to Quarters.
Click the Quarter
textbox, containing the expression =Fields!Quarter.Value, which appears below the Year textbox
(containing expression =Fields!Year.Value), as shown in Illustration 29.
Illustration 29: Select
the Quarter Textbox
Press the Delete
textbox vanishes. This removes the capability to drill down to Quarters from
the Year, as requested by the information consumers for this report.
We are now
ready to test the report to preview the results of our layout changes.
31. Click the Preview tab.
from the parameter picklist
that appears atop the report on the Preview tab.
Click the View
Report button to execute the report.
report runs and returns the data associated with the Food Product Family
that resides in the MSAS Sales cube. We will drill down again, to
ascertain the effectiveness of our layout modifications.
Drill down on Baking
Goods (click the "+" sign to its left), which appears near
the top left of the report, to expose its underlying groups.
Drill down on the
Jams and Jellies level that appears to the right of Baking Goods.
Drill down on Jelly,
which appears to the right of Jams and Jellies.
this point we see the new lowest level of the row axis, Product Name,
appear. We note, too, the appearance of the nulls we identified earlier. A
portion of our view of the report at this stage appears in Illustration 30.
Illustration 30: The FoodMart Sales - Filtered Dataset.rdl Report (Partial
View) with Layout Modifications
we confirm that we have met the structural portion of the business requirements
of the intended audience. We now need to restrict the report to present only
those products with sales (or, in other words, to filter out any products whose
Sales values are null). We will concentrate upon the construction of
the filters to restrict the presentation as requested in the following section
- and then explore the effects of null fields on filtering in general, together
with approaches for overcoming those effects to deliver effective filters
within our reports.
-> Save All to save our work so far.