Help with Time Overlaps

[MISdad]

I'm working on a report to show staff time overlaps based on a SQL table that contains scheduling info. The table has start time, stop time, and duration. Any ideas as to the best way to get the info I'm looking for are greatly appreciated.

Example:
Staff puts a 15 minute appointment on the schedule to start at 8:00. Another 15 minute appointment gets scheduled for that same staff to start at 8:10. These overlap and would need to show on the report.

 

[lbass]

You could probably use a formula something like the following to suppress records that don't meet the criteria. Go to the section expert->detail->suppress->x+2 and enter it there:

not(
datediff("n",previous({table.stop}),{table.start}) < 15 or
datediff("n",{table.stop},next({table.start})) < 15
)

-LB