Print Page | Close Window

change font color if then else

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21132
Printed Date: 04 May 2024 at 9:05pm


Topic: change font color if then else
Posted By: cbaldwin
Subject: change font color if then else
Date Posted: 24 Oct 2014 at 4:34am
I have the following statement:

if ({COMPONENT_INVENTORY.ABO_CD}="ab"and Count({COMPONENT_INVENTORY.UNIT_NO},{COMPONENT_INVENTORY.ABO_CD})- {?Adequate AB FFP/FP24}>0)then Count({COMPONENT_INVENTORY.UNIT_NO},{COMPONENT_INVENTORY.ABO_CD})- {?Adequate AB FFP/FP24} else 0

I would like to force the else answer to have a black font and the then answer to have a lime font.

Suggestions.


Replies:
Posted By: DBlank
Date Posted: 24 Oct 2014 at 7:23am
if currentfieldvalue=0 then crblack else crlime
 
unless you want to make sure that even if answer the the IF = 0 it is lime...

Posted By: cbaldwin
Date Posted: 24 Oct 2014 at 8:26am
worked like a charm... thanks.


Print Page | Close Window