The challenge is how these new subtotals are displayed,
and it will ultimately be a business decision about whether or not to show them
and how to format them if they are shown. Recall from previous discussion that the
subtotals were given a light grey background. If subtotals are added to state/province
and quarters and given the same light grey background, the entire grid will start out
as grey when no members are expanded. That??™s because the total for a particular
year is the sum of the quarters, so the number being shown will be counted as the
subtotal and formatted accordingly. Figure 10-13 shows the results of the report if
subtotals are added for both the quarters and the state/province, and the subtotals
Figure 10-13 Adding subtotals at multiple levels may lead to a more confusing format,
especially if the formatting of subtotals is different from standard cells.
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 335
were formatted to have a light grey background. The figure shows what the report
looks like after expanding the year 2001 and Australia.
Accessing Relational Data
Most people think of Reporting Services as a reporting tool for relational reports,
and there??™s no question this is how it is used the majority of the time. The flexibility
of laying out reports goes well beyond the standard banded report writers that are
familiar to many IT professionals, and the various output options, scheduling, and so
forth make Reporting Services a strong contender for enterprise reporting needs.
Pages:
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425