Crystal Reports highlight string

Report Design

Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: highlight string

Post Reply

Post New Topic

Author	Message
jedder Newbie Joined: 19 Nov 2012 Online Status: Offline Posts: 6	Topic: highlight string Posted: 11 Jan 2013 at 7:39am
	have a string that if empty need to highlight yellow, else just keep default background(clear) Using many different scenarios and none are working... tried to use format editor, by asking if field blank :( used highlight expert not working newbie to this sw any help, much appreciated Jen
	Jennifer
	IP Logged


lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4374	Posted: 11 Jan 2013 at 10:04am
	I would try format the object, the font tab. click the x-1 button next to color I would do something like: if isnull({table.field}) or {table.field} = "" then crYellow else crWhite the color names may be wrong, but the idea is there, and CR will give a list of the valid colors. HTH
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 14 Jan 2013 at 4:19am
	if the field is null you will likely have the same issue. since the value is null there is nothing to highlight. You will likely need to create a formula field to convert NULL values to a single space then conditionally format that as lockwelle suggests. if isnull(field) then " " else field
	IP Logged

Printable version

Printable version

Forum Jump

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum