Highlight Group of records

[mcyrulik]

Hey everybody.

I have a list of employee records. Because of the way that our payroll system is set up, each employee has 9 records in this table. The table consists of the Employee ID, their name, an earnings code(that is used by our payroll system), and a number(the amount of time in this earnings code) - to name a few.

When looking at this list, it is sorted so that all the records associated with an employee are grouped together. What I would like to do is color the groups of records, similar to alternating the backgrounds of a portal row or list view.

I can color them no problem, but what I can't figure out is how to tell my calculation that the last group was green, so this group should be red - then green, then red, and so on.

Any thought?

[VICH]

assign each employeeID its own color...that way regaurdless of the order the colors are always different

just a thought though B)

[comment]

If it's always 9 records in a group, you could use:

Mod ( Div ( Get ( RecordNumber ) - 1 ; 9 ) ; 2 )

[mcyrulik]

VICH: thanks, I toyed with that, but with 260 employees, that would suck for me..

Comment: Thanks! Works perfectly.