Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Alerters - highlight a whole row?

Alerters - highlight a whole row?

Alerters - highlight a whole row?


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!

RE: Alerters - highlight a whole row?

 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:


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
  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

RE: Alerters - highlight a whole row?

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)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close