Example: Placing Emphasis on Certain Values


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")

7.
Preview the report.



Microsoft SQL Server 2005 Reporting Services
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net