Conditional Highlighting 2

[maddyyikes]

Hi!
I have generated the following report using CR 8.5 The database used is P4 (proprietary) and ODBC drivers are used for interfacing purposes. The report that I have generated is as follows:

Cat_SubCat_ProbType Total

S/W_Outlook_How To: 400

Security_Novell_Access Denied 200

H/W_Printer_Jamming in printer 150

......(about 20000 records)

The records have already been sorted in descending order of the no. of problem types. I now need to highlight the top ten records (both cols. in report) in a different color (yellow), in order to account for the top 10 problems encountered by the concerned dept. I did try some formulae but they did not work , neither did the top N expert as it requires me to provide an exact limiting value for which the highlighting must be done. As the values in the "Total" col. vary greatly, it is not possible to define an exact limiting value. Hence I would appreciate if you could provide me with the exact formula for the same. Thanx in advance !!!

 

[lbass]

If these are groups that have been sorted in descending order using topN, try going to the section expert (format->section)->group header (or footer--wherever these are)->color->background->x+2 and enter:

if groupnumber <= 10 then cryellow else crnocolor

-LB