1) I have a report that is grouped by building.
2) The report also has
a
grouped #1 sum
, which calculates the total minutes worked
on job
s (grouped by building)
which appears along side the grouped building
name.
Question:Is there a method to sort the report, so
that the data is sorted
by the highest
number of minutes
(then descending), as
opposed to the current format which sorts the report by building name in
alphabetical order?
In the example below the data would sort, as opposed to what is shown:
461.02
308.01
72.00
16
Bloomsbury Street |
|
|
Total minutes |
72.00 |
|
|
|
40,348 |
|
16 Bloomsbury Street : Gents toilet blocked. |
|
Minutes |
|
27.00 |
16 Bloomsbury Street |
|
|
41,045 |
|
16 bloomsbury street: toilet blocked |
|
Minutes |
|
25.00 |
16 Bloomsbury Street |
|
|
50,864 |
|
6 Bloomsbury Street : Gents toilet blocked. |
|
Minutes |
|
20.00 |
16 Bloomsbury Street |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
178 Eastern Road |
|
|
Total minutes |
308.01 |
|
|
|
970 |
|
Toilet blocked. |
|
Minutes |
|
45.00 |
178 Eastern Road |
|
|
4,235 |
|
178 Eastern Road : Both toilets blocked. |
|
Minutes |
|
30.00 |
178 Eastern Road |
|
|
4,672 |
|
Kitchen: door handle is loose |
|
Minutes |
|
30.00 |
178 Eastern Road |
|
|
9,944 |
|
GF WC: broken toilet seat in |
|
Minutes |
|
45.00 |
178 Eastern Road |
|
|
34,047 |
|
178 Eastern Road : Kitchen drawer front needs
putting back on and also side panel on work surface. |
|
Minutes |
|
25.00 |
178 Eastern Road |
|
|
34,047 |
|
178 Eastern Road : Kitchen drawer front needs
putting back on and also side panel on work surface. |
|
Minutes |
|
43.00 |
178 Eastern Road |
|
|
42,105 |
|
178 Eastern Road : Tv aerial point broken. |
|
Minutes |
|
32.00 |
178 Eastern Road |
|
|
45,902 |
|
178 Eastern Road : Put plug on television as other
one is broken. |
|
Minutes |
|
58.00 |
178 Eastern Road |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
180 Eastern Road |
|
|
Total minutes |
461.02 |
|
|
|
4,342 |
|
180 Eastern Road : Toilet downstairs blocked. |
|
Minutes |
|
45.00 |
180 Eastern Road |
|
|
14,799 |
|
180 Eastern Road : Poor reception from tv. |
|
Minutes |
|
2.00 |
180 Eastern Road |
|
|
23,859 |
|
Re-paint the front door in black gloss |
|
Minutes |
|
66.00 |
180 Eastern Road |
|
|
23,859 |
|
Re-paint the front door in black gloss |
|
Minutes |
|
112.00 |
180 Eastern Road |
|
|
23,859 |
|
Re-paint the front door in black gloss |
|
Minutes |
|
84.00 |
180 Eastern Road |
|
|
23,859 |
|
Re-paint the front door in black gloss |
|
Minutes |
|
64.00 |
180 Eastern Road |
|
|
36,365 |
|
180 Eastern Road : Letter box needs attention as
doctors can put their hands through and open door. |
|
Minutes |
|
58.00 |
180 Eastern Road |
|
|
72,704 |
|
WATER LEAK THROUGH KITCHEN CEILING THAT HAS BROUGHT
PART OF THE TILES DOWN |
|
Minutes |
|
30.00 |
180 Eastern Road |
Edited by Iain CD - 08 Feb 2012 at 1:26am