I have 5 fields in a heading line. By default, I want these fields to be bold and backcolor yellow. (This is HTML output). I do this with:

 TYPE=HEADING,
      LINE=9,
      OBJECT=FIELD,
      STYLE=BOLD,
      BACKCOLOR=YELLOW,
$

However, if the last field, is >= 2000, I want it to be bold, color yellow, backcolor red. I tried this:

 TYPE=HEADING,
      LINE=9,
      OBJECT=FIELD,
      ITEM=5,
      STYLE=BOLD,
      COLOR=YELLOW,
      BACKCOLOR=RED,
      WHEN=TB_BEG_BAL GE 2000,
$

I don't get an error, but it seems to ignore the WHEN clause. Can one use WHEN with Headings?

This message has been edited. Last edited by: kerry,

Try playing with the Item number...it may not really be 5.

I figured it out. As this report is a free-form report with nothing but heading, I just had a BY phrase that will be used for bursting. I had to add a SUM TB_BEG_BAL NOPRINT, then the formatting took. It appears that for WHEN to work, the field has to be part of a PRINT, SUM, COUNT, etc. command.

Also make sure the field you are using the the WHEN statement is included on your report. It can be there with a NOPRINT. It just needs to be there whether or not you show it as a column.

WHEN=TB_BEG_BAL GE 2000

You got it before I could post. Good job.