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.