The word ???Total??? is simply a label in
a textbox and therefore can be changed.
The subtotal textbox itself can be formatted by changing the background color,
the font style and weight, and so forth, just like any other textbox. However, making
these changes does not in any way affect the display of the subtotal values when
they appear. Instead, to change the format for the subtotal cells, the developer must
click on the green triangle. Clicking this triangle opens the subtotal properties in the
properties window, and here the background color, font, numeric format, and other
properties can be changed. This is useful when the subtotals for reports should have
a shaded background or the fonts should appear bold or italicized.
Figure 10-8 shows the same report as Figure 10-7, but with subtotals added.
Subtotals were turned on for both rows and columns. The new textboxes had their
labels changed to Years Total and Country Total. The next textboxes had their
background colors set to a light grey color, and the subtotal backgrounds were also
set to the same light grey color by first clicking on their small green triangles to
access the subtotal properties. In addition, the column and row headers were given
a pale blue background to help distinguish them from the measure. It might appear
that the Format property of the subtotals was set to ???c??? (for currency.) In fact, that is
not the case. Because the cell containing the measure was set to a Format property of
???c,??? the subtotals pick this formatting up automatically.
Pages:
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417