Weekly KPI Report

Weekly KPI Report

Hi

I need to provide weekly KPI's to my boss and need a single summary reports that gives me the following:

Requests Opened
Requests Closed
Requests closed within SLA
Requests Violating SLA
Number of open Requests rolling over

I can get some of this through existing reports but not sure how to get the ones that relate to SLA's.
I would be greatfull if someone could provide me with the query that will generate this in a single report.

Thanks.

Fred.