highlight expert
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22180
Printed Date: 03 May 2024 at 1:40am
Topic: highlight expert
Posted By: kevsta
Subject: highlight expert
Date 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
|
Replies:
Posted By: DBlank
Date Posted: 16 Dec 2016 at 3:16am
|
are you trying to apply this to a crosstab?
|
Posted By: kevsta
Date 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
|
Posted By: DBlank
Date 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
|
|