Different background color for top customers

Hi,
This is probably a very 101 question :-)
I have a query that returns customer records. These records are sorted by
region and name. Now I have a requirement to highlight the top 10 customers
(the 10 highest $$$ amounts), without changing the order of the customers.
Is there a way to do this like
iif(max(10), "red", "white")
or something similar'
Any help very much appreciated.
Cheers,
DomYou can solve it in your source query. Just do a LEFT OUTER JOIN to a
SELECT TOP 10. You don't display the results of the left join on the
report, but can use the values returned to color the rows.
--
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"dbuschi" <dbuschi@.discussions.microsoft.com> wrote in message
news:2EA400D4-9630-40FD-9330-15A235DC749C@.microsoft.com...
> Hi,
> This is probably a very 101 question :-)
> I have a query that returns customer records. These records are sorted by
> region and name. Now I have a requirement to highlight the top 10
> customers
> (the 10 highest $$$ amounts), without changing the order of the customers.
> Is there a way to do this like
> iif(max(10), "red", "white")
> or something similar'
> Any help very much appreciated.
> Cheers,
> Dom