Alerters - highlight a whole row?

[smooveb]

Hi,

I wanted to check if this functionality is possible: could an alerter be used to highlight a whole row (or format a whole row) that meets a certain criteria set?

Thanks everyone!
B

 

[dwivedys]

Hi,
just an off hand solution though i think it may not be very elegant.

example lets say you have two columns in ur report and u want the entire row to be highlighted when some condition becomes true for both columns simultaneously:

NAME, SALARY

Lets say you want an entire row to be highlighted if Name begins with S and Salary > 100

Declare a variable ROW_ALERTER on condition
<<<
if
name like 'S%' AND sal > 100 then (1) else (0) {***notice the AND}
>>>

and then use this variable in the alerter as following:

IF row_alerter = 1 then <desired condition>

Then apply row_alerter to both columns of your report.

The solution can (i think so) be extended to more than two columns.
However having said that i understand that this solution is not very effective if u have (as the case certainly would be) hundreds of columns in yr report

good luck

 

[ATP]

Create the required Alerter.

Highlight the row by Clicking in the left of the 1st column in the table (when the mouse pointer becomes a Black Right Arrow)

Select Format -> Alterters and check the alter box.

This will set the alerter to all columns.

This works fine for one alerter but if you need to alert on more than one column value then create the alterer on a dummy column (as above)