report request
Hi guys,
I need some help with a report I would like to have a report for MSSQL that looks like below. I think the bigest problem is the fact that I want to use the resolved time and NOT the closed time to generate this report.
-------------------------------------------------------------------------------------------------------------------------------------------------------
| Resolved requests per month per level | |||||||
|
|
jan |
feb |
total |
||||
| prio 1 | 5 |
10 | 15 | ||||
| prio 1 < 4h | 2 | 6 | 8 | ||||
| prio 1 < 8h | 4 | 9 | 13 | ||||
| prio 2 | 10 |
20 | 30 | ||||
| prio 2 < 24h | 5 | 4 | 9 | ||||
| prio 2 < 48h | 7 | 18 | 25 | ||||
| prio 3 | 15 | 30 | 45 | ||||
| prio 1 < 4h | level = prio 1 and time from opened till resolved is less then 4 hours | ||||||
| prio 1 < 8h | level = prio 1 and time from opened till resolved is less then 8 hours | ||||||
| prio 2 < 24h | level = prio 2 and time from opened till resolved is less then 24 hours | ||||||
| prio 2 < 48h | level = prio 2 and time from opened till resolved is less then 48 hours | ||||||
| jan | date >= 1-1-2010 and < 1-2-2010 | ||||||
| feb | date >= 1-2-2010 and < 1-3-2010 | ||||||
I do understand SQL so I can make changes to existing code but the sql I've seen in this forum is very complicated, filled with joins between different tables and a lot of subselects. Any help would be greatly appreciated.
Kr,
Ronald