Conditional Formatting of fields in reports

[christoff]

Hi,

I had a look thru the topics to see if this had been covered and didn't find anything.

I want to either create a PDF or print a report and have a certain field which would normally be in black text (eg SalesTaxPaid) turn [color:red]RED if it equals $0.00 and I was wondering if this was possible. I have tried to work it out and havent succeeded, possibly due to poor brain power.

[Vaughan]

FMP 8.5 does not support conditional formatting, it was introcuded in FMP 9.0.

However you could make a calc field that does the work:

Case( 



SalesTaxPaid <= 0 ; TextColor( SalesTaxPaid ; RGB( 255 ; 0 ; 0 ) ) ; 



SalesTaxPaid 



)

[christoff]

Hi Vaughan,

Thanks heaps for replying. I tried it and the zero GST went red but the others disappeared. Can you please tell me the calculation for

if GST = 0 then red, otherwise black

cheers mate

[christoff]

I worked it out, I was missing a bracket - just wondering, did u intend yours to be a CASE or an IF

[mr_vodka]

You can use Case or IF in this "case"... ;p

I tend to use case almost all time over If just because it is easier to add more conditions later if need be.