Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Highlighting Expert Post Reply Post New Topic
Author Message
aristeff
Newbie
Newbie


Joined: 09 Feb 2011
Online Status: Offline
Posts: 6
Quote aristeff Replybullet Topic: Highlighting Expert
     Posted: 09 Feb 2011 at 4:12am
I would like to setup a highlighting expert that highlights a field if the date of the another field is greater than the number on another field.  An example would be I would like the PO to highlight red if the PO Date is created than the last leadtime date.
 
PO Date           PO              Last Leadtime
2/1/11              80000         2
 
So if the report would run today I would want it to highlight the PO on this because the last time this PO created it was delivered in two days and now it is last two days.
 
Is this something that could happen.
 
Thanks
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Feb 2011 at 4:03am
do you mean that you want to highlight PO if POdate + lead time days is < today?
Right click on the PO field
select format field
select border tab
select the background formula button
add your formula here, something like
 
if currentdate>dateadd('d',{table.lastleadtime},{table.podate}) then cryellow else crnocolor
IP IP Logged
aristeff
Newbie
Newbie


Joined: 09 Feb 2011
Online Status: Offline
Posts: 6
Quote aristeff Replybullet Posted: 15 Feb 2011 at 6:48am
Thanks, this worked great.
IP 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