Smart questions
Smart answers
Smart people
Join Tek-Tips Forums
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • 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!

Join Tek-Tips
*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.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

smooveb (IS/IT--Management) (OP)
9 Nov 01 9:01
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 (Programmer)
9 Nov 01 21:32
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 (Programmer)
12 Nov 01 9:55
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)

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