change backcolor in a crosstab cell

[signorin]

I need to change the back color in a crosstab cell if the content is a negative number.

it's possible with Ireport??

thank you very much.

[kkelleher]

I've got a report that does this. Essentially, you'd create a style that specifies the color for cells whose value is less than 0, and create a conditional expression (by clicking Add under the Style conditions list on the Add/Modify style window.

 

Here's my expression (it turns a cell red when the cell's value is less than 500):

Code:

$V{OpportunityLineItem1_UnitPrice_Sum}.doubleValue() < 500.0 ? Boolean.TRUE : Boolean.FALSE

I do believe that's it, but I didn't create my report in iReport, so there may be something else you'd need to do.

 

Thanks,

 

Kristen