Report Builder - Professional SQL Server 2005 Reporting Services - page 388

Figure 9-21
You can repeat the same process to set the Subcategory font to 10 pt. This should allow you to more eas-
ily distinguish the different levels.
The second formatting feature you'll explore is how to set the background color for a set of items. In
this scenario, you want to format the Product Name items. You will set the background color to Light
Turquoise. To set the background color, select the Product Name, Sales Amount, and Order Quantity
detail lines by clicking on the text boxes directly under the column headers and holding down the Shift
key. Once you have highlighted the desired cells, use the Fill Color button in the toolbar to select Light
Turquoise. Figure 9-22 illustrates setting the background color.
There are a number of formatting features that you can add to your reports. Now that you have given
your report a nice look, you need to clean up the data a little. One thing you might have noticed in your
report is that a number of rows come back with no data. There is also no distinct sort order defined in
the report. In the next section, you look at how to filter out those empty rows and how to update the sort
order.