highlight expert

[aspnetuser]

is it possible to highlight the top n value of a set of grouped data.

cr 8.5
sql server 2000

jay 15
james 10
john 9

they are at the group 3 level and i am already using the topn all sort feature?

i just want to hightlight the first line?

 

[lbass]

Using the running total expert, create a running total {#cntwingrp} by choosing distinctcount of {table.name}, evaluate on change of group#3 (name group), reset on change of group#2.

Then go to the section expert->group#3 footer (if that's where the field is)->color tab->background->x+2 and enter:

if {#cntwingrp} = 1 then crYellow else crNoColor

-LB