Hello everyone...
I have rather unique shall I say question... I am familiar with suppressing rows that are empty or the same but now i am working with a report that is pretty much well build with few minor exceptions... the report is separated into groups of different machines/workcenters... It does show plenty of details but I need it to actually be more simple...
Here is the question: Can you suppress data withing the groups?
This is what the report looks like:
| ASY1 |
LOCKER ASSY/PACK |
|
|
|
|
|
|
|
|
|
| 2/11/2013 |
386213 |
000 |
002400 |
|
00017 |
0 |
0 |
0.00 |
0.32 |
.0 |
| 2/11/2013 |
386213 |
000 |
002400 |
|
00017 |
1 |
0 |
1.44 |
1.24 |
123.6 |
| 2/11/2013 |
416011 |
000 |
001500 |
|
00017 |
0 |
0 |
0.00 |
0.35 |
.0 |
| 2/11/2013 |
416011 |
000 |
001500 |
|
00017 |
1 |
0 |
1.13 |
0.54 |
135.6 |
| 2/11/2013 |
416021 |
000 |
000600 |
|
00017 |
1 |
0 |
0.10 |
0.04 |
242.9 |
| 2/11/2013 |
416031 |
000 |
000500 |
|
00127 |
0 |
0 |
0.00 |
0.00 |
.0 |
| 2/11/2013 |
416031 |
000 |
000500 |
|
00017 |
2 |
0 |
0.14 |
0.09 |
153.3 |
| 2/11/2013 |
416311 |
000 |
001100 |
|
00017 |
1 |
0 |
1.55 |
1.37 |
118.5 |
| 2/11/2013 |
417102 |
000 |
000300 |
|
00102 |
0 |
0 |
0.00 |
0.07 |
.0 |
| 2/11/2013 |
417102 |
000 |
000300 |
|
00102 |
0 |
0 |
0.00 |
1.52 |
.0 |
| 2/11/2013 |
417102 |
000 |
000300 |
|
00168 |
5 |
0 |
0.25 |
2.14 |
18.8 |
| 2/11/2013 |
417102 |
000 |
000300 |
|
#ASY1 |
0 |
0 |
0.00 |
2.10 |
.0 |
| 2/11/2013 |
417102 |
000 |
000300 |
|
00014 |
0 |
0 |
0.00 |
1.29 |
.0 |
| 2/11/2013 |
417131 |
000 |
000800 |
|
00102 |
0 |
0 |
0.00 |
0.31 |
.0 |
| 2/11/2013 |
417131 |
000 |
000800 |
|
00168 |
5 |
0 |
0.55 |
1.17 |
71.9 |
| 2/11/2013 |
417141 |
000 |
000800 |
|
00102 |
0 |
0 |
0.00 |
0.44 |
.0 |
| 2/11/2013 |
417141 |
000 |
000800 |
|
00168 |
6 |
0 |
1.17 |
0.00 |
128.0 |
|
|
|
|
Work Center Totals |
|
22 |
0 |
7.53 |
15.39 |
50.4 |
|
|
|
|
(Hours In Decimal) |
|
0 |
0 |
7.88 |
15.65 |
50.4 |
| CHWE |
CHUTE WELDING |
|
|
|
|
|
|
|
|
|
| 2/11/2013 |
531509 |
000 |
000300 |
|
00056 |
0 |
0 |
0.00 |
1.30 |
.0 |
| 2/11/2013 |
531509 |
000 |
000300 |
|
00056 |
0 |
0 |
0.00 |
1.37 |
.0 |
| 2/11/2013 |
531509 |
000 |
000300 |
|
00056 |
0 |
0 |
0.00 |
0.40 |
.0 |
| 2/11/2013 |
531509 |
000 |
000300 |
|
00056 |
0 |
0 |
0.00 |
2.36 |
.0 |
| 2/11/2013 |
531509 |
000 |
000300 |
|
00056 |
8 |
0 |
8.48 |
0.30 |
1760.0 |
|
|
|
|
Work Center Totals |
|
8 |
0 |
8.48 |
6.53 |
127.9 |
|
|
|
|
(Hours In Decimal) |
|
0 |
0 |
8.80 |
6.88 |
127.9 |
| CUW1 |
CUSTOM WELD 1 |
|
|
|
|
|
|
|
|
|
| 2/11/2013 |
531490 |
000 |
000100 |
|
00070 |
0 |
0 |
0.00 |
7.37 |
.0 |
| 2/11/2013 |
531490 |
000 |
000100 |
|
00220 |
6 |
0 |
7.48 |
0.13 |
3545.5 |
| 2/11/2013 |
531490 |
000 |
000100 |
|
00220 |
0 |
0 |
0.00 |
4.28 |
.0 |
| 2/11/2013 |
531490 |
000 |
000100 |
|
00220 |
0 |
0 |
0.00 |
1.08 |
.0 |
| 2/11/2013 |
531490 |
000 |
000100 |
|
00220 |
0 |
0 |
0.00 |
1.15 |
.0 |
| 2/11/2013 |
531529 |
000 |
000100 |
|
00049 |
15 |
0 |
0.56 |
0.59 |
94.9 |
| 2/11/2013 |
531771 |
000 |
000100 |
|
00077 |
3 |
0 |
0.11 |
0.10 |
105.9 |
| 2/11/2013 |
531775 |
000 |
998500 |
|
00082 |
0 |
0 |
0.00 |
0.30 |
.0 |
| 2/11/2013 |
531775 |
000 |
998500 |
|
00082 |
0 |
0 |
0.00 |
0.20 |
.0 |
| 2/11/2013 |
531818 |
000 |
000100 |
|
00049 |
82 |
0 |
4.55 |
5.02 |
97.8 |
|
|
|
|
Work Center Totals |
|
106 |
0 |
13.50 |
21.42 |
63.7 |
|
|
|
|
(Hours In Decimal) |
|
0 |
0 |
13.83 |
21.70 |
63.7
|
Basically What I am trying to do is eliminate all the lines with the work center and leave the report look like this:
| ASY1 |
LOCKER ASSY/PACK |
|
|
|
|
|
|
|
|
|
|
|
|
|
Work Center Totals |
|
22 |
0 |
7.53 |
15.39 |
50.4 |
|
|
|
|
(Hours In Decimal) |
|
0 |
0 |
7.88 |
15.65 |
50.4 |
| CHWE |
CHUTE WELDING |
|
|
|
|
|
|
|
|
|
|
|
|
|
Work Center Totals |
|
8 |
0 |
8.48 |
6.53 |
127.9 |
|
|
|
|
(Hours In Decimal) |
|
0 |
0 |
8.80 |
6.88 |
127.9 |
| CUW1 |
CUSTOM WELD 1 |
|
|
|
|
|
|
|
|
|
|
|
|
|
Work Center Totals |
|
106 |
0 |
13.50 |
21.42 |
63.7 |
|
|
|
|
(Hours In Decimal) |
|
0 |
0 |
13.83 |
21.70 |
63.7 |
Thanks for all the help in advance...
IP Logged
