Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Overlap Time

Status
Not open for further replies.

Memento

MIS
Jun 19, 2005
46
US
I have versions 8.5(currently using), but I also have 9,10,11.

I'm trying to find the best way to find overlaps in time.
Example,

TimeSheet
Start End
8:15:00AM 8:30:00AM
8:45:00AM 9:15:00AM
9:00:00AM 9:45:00AM <==Overlaps the previous time
10:00:00AM 11:00:00AM

I'm currently using the following Forumla:
@Flag
if {eventstb.e_start} < previous({@EndTime})
then 1 else 0

Only, I'm wondering if there is a better way to find these overlap problems. The current method makes for a harrowing Hiding and Suppressing nightmare. I'm having to use the "Unable to insert summaries or subtotals on certain formulas" Crystal Article number c2007015 to get things to sort of work.
 
That's the only obvious way to identify overlap. What is it you want to hide/suppress?

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top