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.
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.