Using 'Fill Colour'

[maeling]

I have a report that has a small square box on it.
I would like to use an if statement to fill the box (black) when a certain crieria is met Else don't fill and leave white. Does any body know the syntax ?

IF {blank square??} STARTSWITH "NIGHT" THEN {fill black} ELSE "

 

[kskid]

[ol][li]Insert an empty text object on the report canvas and resize it to fit your needs[/li]
[li]Right click on the text object and click on Borders and colors[/li]
[li]Under the color section click on the x+2 button that is associated with the Background and enter your formula[/li]

if {table.field} = "value" then
  crblack
else
  nocolor

[/ol]

Cheers,
-LW

 

[honeyraj]

Make sure that after you do the above and pull the empty text to the place when you need it, right click on the empty test and select move -> to back.

If you do not do this, alternate rows are colored but the data would not be visible.

-Raj