Joined: 19 Feb 2010
Location: United Kingdom
Online Status: Offline
Posts: 15
Topic: How to highlight a duplication? Posted: 24 Oct 2011 at 5:32am
I have a list of about 200 members of staff login records for the last 3 months sorted into date order under the each staffs name.
e.g.
John Smith
01/04/2011 09:00AM
02/04/2011 09:00AM
04/04/2011 09:00AM
04/04/2011 13:00PM
05/04/2011 09:00AM
06/04/2011 10:00AM
09/04/2011 09:00AM
09/04/2011 09:30AM
to make easier to faster to find the duplications on the dates is their anyway you can highlight them? tried using the highlight expert but its not technical enough and google isnt much help.
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Posted: 24 Oct 2011 at 5:54am
i doubt this is what you will like as it highlights a lot of rows and grouping on the date set to day would likely get you more what you want but if you just want the field highlighted then...
right click on the field
select format field
select border tab
select bakground formula box (x-2) and add your highlight formula here
if datediff('d',previous({table.DATE}),{table.DATE})=0 then cryellow else crnocolor
Edited: as an FYI i opted to use the datediff() function here because you appear to have a datetime field and you wanted to highlight when the day changes regardless of the time.
Joined: 22 May 2009
Online Status: Offline
Posts: 347
Posted: 24 Oct 2011 at 6:00am
Right-click on the field and click Format Field. In the Border tab check the Background box and click the Formula Editor for the Background (X-2). The formula should be something like: if {field.date}=previous({field.date}) then crRed else crNoColor
Joined: 19 Feb 2010
Location: United Kingdom
Online Status: Offline
Posts: 15
Posted: 24 Oct 2011 at 10:50pm
Cheers for this, I tried the code but I get prompt with this error message when trying to run the report "The keyword 'Then' is missing."(probably something daft) any ideas?
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