In this example, years are the column headers. In order to also add the quarters to
the columns, the developer right-clicks on a row or column selector and then chooses
Add Column Group. This opens the Grouping and Sorting Properties dialog box.
The General tab contains a section named Group on and it asks for an expression.
Dropping the list down shows all of the fields available in the dataset. In this case,
the report needs to include the quarters, so the developer picks the Fields!Calendar_
Quarter.Value option. There are more steps that need to be performed, but if the
developer closes the dialog box at this point, a new text box is added below the old
Years textbox. If the report is viewed, the end result looks like that in Figure 10-11,
with all the quarters displayed by default.
Figure 10-11 The report now has multiple levels of the Date.Calendar hierarchy, but they
are not yet interactive.
C h a p t e r 1 0 : S Q L S e r v e r R e p o r t i n g S e r v i c e s 333
In order to make this interactive, the developer has more to modify on the
Grouping and Sorting Properties dialog box. Right-clicking on the textbox with
the quarters in it and then choosing Edit Group reopens the dialog box. On the
Visibility tab are the options needed to make the report more interactive. First, the
initial visibility should be set to Hidden, which means quarters will not be shown by
default. However, users should be able to view the quarters as necessary, so the next
step is to check the box labeled Visibility Can Be Toggled By Another Report Item.
Pages:
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423