Conditional Formatting no longer working on Crosstabq

[mercedes_green]

I had values in cells on a crosstab report formatted with background colours based on values. I've modified the crosstab fields and re-applied the conditional format but NONE of my fields with display with any background colours or font colours. It was literally working 2 hours ago and now noting works.

If I place the identical field in the detail section and apply the exact same conditional formula, the colours appear so something is wrong with the crosstab.

Is there some setting that disables ALL conditional formatting?

I'm using Crystal Reports Designer 2016

[abhilash_kumar · Accepted solution]

Hi Mercedes,

Please post the formatting formula here.

Also, if possible, could you also post a screenshot of the crosstab?

-Abhilash

[mercedes_green]

Fantastic that worked thank you!

[mercedes_green]

I spoke too soon. Now everything is green, even for the ones that don't equal that value. Attached clearly shows value Post yet it's showing value for Con.

if {@State}='PreCon' then crYellow else

if {@State}='Con' then crGreen else

if {@State}='Post' then crPurple

else crRed

[abhilash_kumar]

Use:

if CurrentFieldValue = 'PreCon' then crYellow else
if CurrentFieldValue = 'Con' then crGreen else
if CurrentFieldValue = 'Post' then crPurple
else crRed

-Abhilash

[mercedes_green]

Strange. I updated one value of one field in teh dtabase and now all of a sudden eveyrthing is working. Guess there was a null field somewhere.

[mercedes_green]

Formula 1 applied to Group 3 that should be Green if value is true else yellow. No colour at all

if {SG_ProjectStaffbyDate.JobStatus}='Open' then crGreen else crYellow

Formula 2 for detail cell background colours. Clearly shows values are Con yet nothing working anymore.

if {@State}='PreCon' then crYellow else if {@State}='Con' then crGreen else if {@State}='Post' then crPurple

Attached is screenshot.