Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
krabople
Starting Member
17 Posts |
 Posted - 2008-06-06 : 10:26:18
|
| I have a report which lists sales figures by salesperson, and I need the report to highlight the maximum amount (ie. the person who got the highest sales figures). How can I do this? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-06-06 : 10:29:20
|
| You could bring a bit field along with your current result set like Highest_Val and set it 1 for top1 record ordered by sales figure desc. Then in report textbox writean expression for background color of cell as =IIF(val(Fields!Highest.Value)=1,"Red","White") |
 |
|
|
krabople
Starting Member
17 Posts |
Posted - 2008-06-06 : 10:41:40
|
| Thanks visakh I'll give it a go |
|
|
|
|
|
|
Highlighting max amount