Now suppose that you want to recognize salespeople with over $250,000 in sales. First, you need to sort the data. Next, you need to put emphasis on the people by changing the font color . The following steps allow you to do these things:
1.
Select the table, right-click on it, and select Properties.
2.
On the Sorting tab, place the following expression =Fields!SaleAmount.Value in the list box labeled "Sort On" underneath the Expression heading.
3.
In the same list box, select Descending as the sort direction underneath the Direction heading.
4.
Click OK.
5.
Select the detail row on the table.
6.
On the Color properties of the selected table row, place the following expressions =IIf(Fields!SaleAmount.Value>=250000000,"Green","Black")