Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: highlight expert Post Reply Post New Topic
Author Message
kevsta
Newbie
Newbie


Joined: 06 Jun 2016
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote kevsta Replybullet Topic: highlight expert
    Posted: 15 Dec 2016 at 9:43pm
hi all
I have a report that shows jobs in our system and we have times that the jobs need to be set to. for example:#
'todays date' 13.00. I would like to highlight any jobs where the time doesn't match the 13.00. when I try this because the date is a range of dates then it shows an error.
thanks
kev
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 16 Dec 2016 at 3:16am
are you trying to apply this to a crosstab?
IP IP Logged
kevsta
Newbie
Newbie


Joined: 06 Jun 2016
Location: United Kingdom
Online Status: Offline
Posts: 3
Quote kevsta Replybullet Posted: 19 Dec 2016 at 12:12am
hi. no its not to a crosstab
the data is:
scheduled start 10.03 need to be brought to match 10.00 any that don't match 08.00, 10.00 or 13.00 need highlighting so they stand out in the list of times.
hopefully that makes sens.
kev
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 19 Dec 2016 at 3:12am
I think you mean you are having trouble comparing two values that are date time but you only want to compare the time portion of them.
you can use the time() function to strip the date off each.
example for the background color:
if time(table.StandardDateTimeField) <> time(table.UsedDatetimeField) then CrYellow else crNoColor
IP 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.