Specifications

CHAPTER 24 DataWindow Expression and InfoMaker Functions
Users Guide 637
• An expression for the Background.Color property of the salary column:
Case(salary WHEN IS >60000 THEN RGB(192,192,192)
WHEN IS >40000 THEN RGB(0,255,0) ELSE
RGB(255,255,255))
The expression causes a salary above $40,000 to display in green, a salary
above $60,000 to display in gray, and all other salaries to display in white.
What you get
Here is what the design of the report looks like:
Here is what the data looks like with the second row current.
Notice that the number of the current row is 2; the first row and the third row
are "Not current" (and therefore display no bitmap); and the second row, which
is the current row, displays the arrow row indicator.
On your screen, the salary in the first row has a green background because it is
more than $40,000; the salary in the second row has a gray background because
it is more than $60,000; and the salary in the third row has a white background,
which matches the background of the report.