that we have put the primary group, from which we will effect our default drill
down presentation, in place and labeled, we will turn to the control of
visibility in the next group level, BrandSales_Product_Department. We
will do so from the Matrix Properties dialog Group tab, to
which we will return once again.
From the Layout
view, once again, click at some point within the title textbox of the report
(containing the label Foodmart Sales), to make the row and column
headers of the matrix data region visible, as we did earlier.
the upper left corner of the matrix.
from the context menu that appears.
Properties dialog opens, defaulted to the General tab, once again.
Click the Groups
Click the BrandSales_Product_Department
group in the Rows list box to select it.
and Sorting Properties dialog for the group opens.
Click the Visibility
Visibility, click the radio button to the immediate left of the Expression
field, to select it.
following expression into the Expression field:
that the logic behind "visibility" seems reversed. It is as if we
have established a drilled down state based upon the return of a "false"
Boolean response. As we shall see, we receive a collapsed state for the Non-Consumable
Click the checkbox
the immediate left of the label "Visibility can be toggled by
another report item" below the Expression field.
checkmark appears in the checkbox, and the Report Item selector becomes
Select the Product_Family
item in the selector.
step allows ad hoc drilldown when the default state is collapsed (as will be
the case for the Non-Consumable family.).
tab - Grouping and Sorting Properties dialog appears as shown in Illustration
Illustration 31: The
Visibility Tab with our Input
Click OK to accept
changes and to return to the Groups tab of the Matrix Properties
Click OK to
accept modifications and close the Matrix Properties dialog.
let's modify the title of the report to represent its new use, with a caption
similar to the one that appeared in the draft presented at the conclusion of
business requirements gathering for the report. In addition, we will add a report
total underneath the rolled up "reconciling" line item for added
the textbox containing the report title FoodMart Sales.
from the context menu that appears, as we did in an earlier step for the Product
Properties dialog appears.
following into the Value box of the dialog:
FoodMart Consumables Analysis
Properties dialog appears, with new Value, as depicted in Illustration
Illustration 32: The
Textbox Properties Dialog for the Report Title
to accept changes and close the dialog.
the Product Family (leftmost) label textbox, once again.
from the context menu that appears, as shown in Illustration 33.
Illustration 33: Creating
a Subtotal for the Product Family Level and the Report Itself ...
We return again to the Layout
view in Report Designer, where we see the new Total in evidence. We are now ready to verify the
results of our work.