Commented on another post, might be simpler to keep separate - report request please.  MSSQL 9.2  9227

Ultimately, I just want a report that shows for a given period:

Tickets Created in period = (Created Date in period)

Tickets Closed in period = (Completed date in period and any value for created date)

Current Workload / Backlog of requests = (Any Creation Date but Status not equal to Closed or Resolved)

And this data split by current support group.

Thanks in advance