Is summary row in a Query Report possible?
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.