Crystal Reports How to make sql if formula for highlight

Tips and Tricks
Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks

Topic: How to make sql if formula for highlight

Author	Message
Almir.Plancic Newbie Joined: 26 May 2011 Location: Bosnia Hercegovina Online Status: Offline Posts: 6	Topic: How to make sql if formula for highlight Posted: 19 Jun 2011 at 11:15pm
	Hello Can somebody help me please? I want create report in which I will highlight On_Order when I do not have enogh quantity on stock and when Is_Commited is higher then On_Order. Please can somone help me? Thanks!
	IP Logged

lockwelle Moderator Joined: 21 Dec 2007 Online Status: Offline Posts: 4372	Posted: 21 Jun 2011 at 3:53am
	format field, border tab, background x-2 button if {table.Is_Committed} > {table.On_Order} then crRed else crNoColor
	IP Logged

Almir.Plancic Newbie Joined: 26 May 2011 Location: Bosnia Hercegovina Online Status: Offline Posts: 6	Posted: 21 Jun 2011 at 7:50pm
	Thanks!
	IP Logged

praveeng Senior Member Joined: 11 Jul 2011 Online Status: Offline Posts: 165	Posted: 13 Jul 2011 at 7:11am
	hi Almir, There is another way to highlight ON-Order values follow these steps to highlight your values * Select that filed and right click on it and select Format field. * In that select Font tab. * Select Color-> x-2( formula editor) * It will opens a formula editor, in that write follwing code if {table.Is_Committed} > {table.On_Order} then crRed else crNoColor thanks, Praveen G
	Praveen Guntuka, praveen_guntuka@yahoo.com
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.031 seconds.