In the Report item drop-down box, the developer chooses the item that can show or
hide the quarters. In this case it would be the box named Calendar_Year.
Allowing users to expand from countries to the states or provinces that make
them up would follow a similar path. The developer right-clicks on a row or column
selector and then chooses Add Row Group. The expression for the Group On section
would be set to Fields!State_Province.Value. On the Visibility tab, the initial visibility
would be set to Hidden and the visibility would be toggled by the Country textbox.
Figure 10-12 shows how this report might look. The user has clicked the plus sign
next to Australia and Canada to expand them. In addition, the year 2001 has been
Figure 10-12 This is a report featuring a parameter and a matrix control that allows users
to expand members to lower levels of detail.
334 B u s i n e s s I n t e l l i g e n c e w i t h M i c r o s o f t O f f i c e P e r f o r m a n c e P o i n t S e r v e r 2 0 0 7
expanded to show the quarters under it (there are only two quarters of 2001 in the
data). Adding the capability for expanding members to lower levels of detail can be
used in conjunction with parameters, just as is being done in this image. Subtotals
can be turned on or off without affecting the functionality of the report.
Subtotals were added earlier, but they can be added for any group. This means
that while there are country and year totals, there can also be totals for state/
provinces and for quarters.
Pages:
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424