Is summary row in a Query Report possible?
I have a Query Report that gives statistics by technician. Is there a way to add a summary line at the bottom, like this:
Task Hours |
Request Hours |
Total Hours |
Response SLA Met % |
Resolution SLA Met % |
Number of Requests Last Resolved Last Week |
Cher |
1 |
11 |
12 |
77 |
77 |
13 |
Sting |
16 |
5 |
21 |
90 |
95 |
20 |
Teller |
1 |
8 |
10 |
75 |
88 |
32 |
SUMMARY |
18 |
24 |
43 |
79 |
87 |
65 |
I'm using MSSQL. I think I could use a UNION (with a name such that is it sorted to the bottom) but is there a better way?
Thanks,
Tom.
New to ADSelfService Plus?