Print Page | Close Window

How to make sql if formula for highlight

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13542
Printed Date: 06 May 2024 at 1:59pm


Topic: How to make sql if formula for highlight
Posted By: Almir.Plancic
Subject: How to make sql if formula for highlight
Date 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!


Replies:
Posted By: lockwelle
Date 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

Posted By: Almir.Plancic
Date Posted: 21 Jun 2011 at 7:50pm
Thanks!

Posted By: praveeng
Date 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


Print Page | Close Window