83b56307-458a-4db0-8be3-7d493a8a2b32
SQL
Data Source=uspgh-scdb-p1;Initial Catalog=TRANS
true
11in
true
8.5in
true
1in
1in
1in
121fae6b-3e56-4018-b2f5-b6a133310554
segment
System.String
group
System.String
division
System.String
division_city
System.String
inv_year_id
System.Double
company name
System.String
carrier_type
System.String
entry_type
System.String
1
System.Decimal
2
System.Decimal
3
System.Decimal
4
System.Decimal
5
System.Decimal
6
System.Decimal
7
System.Decimal
8
System.Decimal
9
System.Decimal
10
System.Decimal
11
System.Decimal
12
System.Decimal
TRANS
SELECT *
FROM ttg_ssrs_reporting_vw2
pivot
(
sum([charges])
for [inv_month_id] in (
[1],[2],[3],[4],[5],[6],[7],[8],[9],[10],[11],[12]
)
) pvttbl
where division = 'lcd' and inv_year_id = '2010'
true
division
System.String
location
System.String
year
System.String
COGS
System.Decimal
Trans Billing Amt
System.Decimal
JAN
System.Decimal
FEB
System.Decimal
MAR
System.Decimal
APR
System.Decimal
MAY
System.Decimal
JUN
System.Decimal
JUL
System.Decimal
AUG
System.Decimal
SEP
System.Decimal
OCT
System.Decimal
NOV
System.Decimal
DEC
System.Decimal
TRANS
select *
from ttg_monthly_revenue_salespvt_vw
where year = 2010 and division = 'lcd'
true
division
System.String
location
System.String
year
System.String
Sales
System.Decimal
COGS
System.Decimal
JAN
System.Decimal
FEB
System.Decimal
MAR
System.Decimal
APR
System.Decimal
MAY
System.Decimal
JUN
System.Decimal
JUL
System.Decimal
AUG
System.Decimal
SEP
System.Decimal
OCT
System.Decimal
NOV
System.Decimal
DEC
System.Decimal
TRANS
select *
from ttg_monthly_revenue_TRNbillingpvt_vw
where year = 2010 and division = 'lcd'
true
20in
textbox1
1
true
0.36in
LCD ScoreCard 2010 YTD
TRANS
0.36in
=Fields!division_city.Value
4
division_city
439
true
=Fields!division_city.Value
438
true
=sum(Fields!ID1.Value)
437
true
=sum(Fields!ID2.Value)
436
true
=sum(Fields!ID3.Value)
435
true
=sum(Fields!ID4.Value)
434
true
=sum(Fields!ID5.Value)
433
true
=sum(Fields!ID6.Value)
432
true
=sum(Fields!ID7.Value)
431
true
=sum(Fields!ID8.Value)
430
true
=sum(Fields!ID9.Value)
429
true
=sum(Fields!ID10.Value)
428
true
=sum(Fields!ID11.Value)
427
true
=sum(Fields!ID12.Value)
textbox151
426
true
=sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value)
0.25in
true
division_city
textbox387
425
true
textbox283
424
true
textbox282
423
true
textbox281
422
true
textbox391
421
true
textbox392
420
true
textbox393
419
true
textbox394
418
true
textbox395
417
true
textbox396
416
true
textbox397
415
true
textbox398
414
true
textbox399
413
true
textbox400
412
true
textbox401
411
true
textbox402
410
true
textbox403
409
true
0.25in
true
division_city
textbox370
408
true
407
true
406
true
405
true
404
true
=Fields!ID1.Value
JAN
403
true
FEB
402
true
MAR
401
true
APR
400
true
MAY
399
true
JUN
398
true
JUL
397
true
AUG
396
true
SEP
395
true
OCT
394
true
NOV
393
true
DEC
392
true
2010 YTD
0.25in
true
division_city
textbox353
391
true
390
true
389
true
388
true
Grand Total
387
true
=sum(Fields!ID1.Value)
386
true
=sum(Fields!ID2.Value)
385
true
=sum(Fields!ID3.Value)
384
true
=sum(Fields!ID4.Value)
383
true
=sum(Fields!ID5.Value)
382
true
=sum(Fields!ID6.Value)
381
true
=sum(Fields!ID7.Value)
380
true
=sum(Fields!ID8.Value)
379
true
=sum(Fields!ID9.Value)
378
true
=sum(Fields!ID10.Value)
377
true
=sum(Fields!ID11.Value)
376
true
=sum(Fields!ID12.Value)
375
true
=sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value)
0.25in
true
division_city
textbox336
374
true
373
true
372
true
371
true
Sales
370
true
=Sum(Fields!JAN.Value, "DataSet1")
369
true
=Sum(Fields!FEB.Value, "DataSet1")
368
true
=Sum(Fields!MAR.Value, "DataSet1")
367
true
=Sum(Fields!APR.Value, "DataSet1")
366
true
=Sum(Fields!MAY.Value, "DataSet1")
365
true
=Sum(Fields!JUN.Value, "DataSet1")
364
true
=Sum(Fields!JUL.Value, "DataSet1")
363
true
=Sum(Fields!AUG.Value, "DataSet1")
362
true
=Sum(Fields!SEP.Value, "DataSet1")
361
true
=Sum(Fields!OCT.Value, "DataSet1")
360
true
=Sum(Fields!NOV.Value, "DataSet1")
359
true
=Sum(Fields!DEC.Value, "DataSet1")
358
true
=Sum(Fields!JAN.Value, "DataSet1")+
Sum(Fields!FEB.Value, "DataSet1")+
Sum(Fields!MAR.Value, "DataSet1")+
Sum(Fields!APR.Value, "DataSet1")+
Sum(Fields!MAY.Value, "DataSet1")+
Sum(Fields!JUN.Value, "DataSet1")+
Sum(Fields!JUL.Value, "DataSet1")+
Sum(Fields!AUG.Value, "DataSet1")+
Sum(Fields!SEP.Value, "DataSet1")+
Sum(Fields!OCT.Value, "DataSet1")+
Sum(Fields!NOV.Value, "DataSet1")+
Sum(Fields!DEC.Value, "DataSet1")
0.25in
true
division_city
textbox319
357
true
356
true
355
true
354
true
Trans Billing
353
true
=Sum(Fields!JAN.Value, "trnbilling")
352
true
=Sum(Fields!FEB.Value, "trnbilling")
351
true
=Sum(Fields!MAR.Value, "trnbilling")
350
true
=Sum(Fields!APR.Value, "trnbilling")
349
true
=Sum(Fields!MAY.Value, "trnbilling")
348
true
=Sum(Fields!JUN.Value, "trnbilling")
347
true
=Sum(Fields!JUL.Value, "trnbilling")
346
true
=Sum(Fields!AUG.Value, "trnbilling")
345
true
=Sum(Fields!SEP.Value, "trnbilling")
344
true
=Sum(Fields!OCT.Value, "trnbilling")
343
true
=Sum(Fields!NOV.Value, "trnbilling")
342
true
=Sum(Fields!DEC.Value, "trnbilling")
341
true
=Sum(Fields!JAN.Value, "trnbilling")+
Sum(Fields!FEB.Value, "trnbilling")+
Sum(Fields!MAR.Value, "trnbilling")+
Sum(Fields!APR.Value, "trnbilling")+
Sum(Fields!MAY.Value, "trnbilling")+
Sum(Fields!JUN.Value, "trnbilling")+
Sum(Fields!JUL.Value, "trnbilling")+
Sum(Fields!AUG.Value, "trnbilling")+
Sum(Fields!SEP.Value, "trnbilling")+
Sum(Fields!OCT.Value, "trnbilling")+
Sum(Fields!NOV.Value, "trnbilling")+
Sum(Fields!DEC.Value, "trnbilling")
0.25in
true
division_city
textbox302
340
true
339
true
338
true
337
true
336
true
335
true
334
true
333
true
332
true
331
true
330
true
329
true
328
true
327
true
326
true
325
true
324
true
0.25in
true
division_city
textbox285
323
true
3
322
true
Gross Cost as % to Sales
321
true
=Sum(Fields!ID1.Value, "TRANS")/Sum(Fields!JAN.Value, "DataSet1")
320
true
=Sum(Fields!ID2.Value, "TRANS")/Sum(Fields!FEB.Value, "DataSet1")
319
true
=Sum(Fields!ID3.Value, "TRANS")/Sum(Fields!MAR.Value, "DataSet1")
318
true
=Sum(Fields!ID4.Value, "TRANS")/Sum(Fields!APR.Value, "DataSet1")
317
true
=Sum(Fields!ID5.Value, "TRANS")/Sum(Fields!MAY.Value, "DataSet1")
316
true
=Sum(Fields!ID6.Value, "TRANS")/Sum(Fields!JUN.Value, "DataSet1")
315
true
=Sum(Fields!ID7.Value, "TRANS")/Sum(Fields!JUL.Value, "DataSet1")
314
true
=Sum(Fields!ID8.Value, "TRANS")/Sum(Fields!AUG.Value, "DataSet1")
313
true
=Sum(Fields!ID9.Value, "TRANS")/Sum(Fields!SEP.Value, "DataSet1")
312
true
=Sum(Fields!ID10.Value, "TRANS")/Sum(Fields!OCT.Value, "DataSet1")
311
true
=Sum(Fields!ID11.Value, "TRANS")/Sum(Fields!NOV.Value, "DataSet1")
310
true
=Sum(Fields!ID12.Value, "TRANS")/Sum(Fields!DEC.Value, "DataSet1")
309
true
=(sum(Fields!ID1.Value)+
sum(Fields!ID2.Value)+
sum(Fields!ID3.Value)+
sum(Fields!ID4.Value)+
sum(Fields!ID5.Value)+
sum(Fields!ID6.Value)+
sum(Fields!ID7.Value)+
sum(Fields!ID8.Value)+
sum(Fields!ID9.Value)+
sum(Fields!ID10.Value)+
sum(Fields!ID11.Value)+
sum(Fields!ID12.Value))/
(Sum(Fields!JAN.Value, "DataSet1")+
Sum(Fields!FEB.Value, "DataSet1")+
Sum(Fields!MAR.Value, "DataSet1")+
Sum(Fields!APR.Value, "DataSet1")+
Sum(Fields!MAY.Value, "DataSet1")+
Sum(Fields!JUN.Value, "DataSet1")+
Sum(Fields!JUL.Value, "DataSet1")+
Sum(Fields!AUG.Value, "DataSet1")+
Sum(Fields!SEP.Value, "DataSet1")+
Sum(Fields!OCT.Value, "DataSet1")+
Sum(Fields!NOV.Value, "DataSet1")+
Sum(Fields!DEC.Value, "DataSet1"))
0.25in
true
division_city
textbox191
308
true
3
307
true
Net Cost as % to Sales
306
true
=(Sum(Fields!ID1.Value, "TRANS")-Sum(Fields!JAN.Value, "trnbilling"))/Sum(Fields!JAN.Value, "DataSet1")
305
true
=(Sum(Fields!ID2.Value, "TRANS")-Sum(Fields!FEB.Value, "trnbilling"))/Sum(Fields!FEB.Value, "DataSet1")
304
true
=(Sum(Fields!ID3.Value, "TRANS")-Sum(Fields!MAR.Value, "trnbilling"))/Sum(Fields!MAR.Value, "DataSet1")
303
true
=(Sum(Fields!ID4.Value, "TRANS")-Sum(Fields!APR.Value, "trnbilling"))/Sum(Fields!APR.Value, "DataSet1")
302
true
=(Sum(Fields!ID5.Value, "TRANS")-Sum(Fields!MAY.Value, "trnbilling"))/Sum(Fields!MAY.Value, "DataSet1")
301
true
=(Sum(Fields!ID6.Value, "TRANS")-Sum(Fields!JUN.Value, "trnbilling"))/Sum(Fields!JUN.Value, "DataSet1")
300
true
=(Sum(Fields!ID7.Value, "TRANS")-Sum(Fields!JUL.Value, "trnbilling"))/Sum(Fields!JUL.Value, "DataSet1")
299
true
=(Sum(Fields!ID8.Value, "TRANS")-Sum(Fields!AUG.Value, "trnbilling"))/Sum(Fields!AUG.Value, "DataSet1")
298
true
=(Sum(Fields!ID9.Value, "TRANS")-Sum(Fields!SEP.Value, "trnbilling"))/Sum(Fields!SEP.Value, "DataSet1")
297
true
=(Sum(Fields!ID10.Value, "TRANS")-Sum(Fields!OCT.Value, "trnbilling"))/Sum(Fields!OCT.Value, "DataSet1")
296
true
=(Sum(Fields!ID11.Value, "TRANS")-Sum(Fields!NOV.Value, "trnbilling"))/Sum(Fields!NOV.Value, "DataSet1")
295
true
=(Sum(Fields!ID12.Value, "TRANS")-Sum(Fields!DEC.Value, "trnbilling"))/Sum(Fields!DEC.Value, "DataSet1")
294
true
=((sum(Fields!ID1.Value)+
sum(Fields!ID2.Value)+
sum(Fields!ID3.Value)+
sum(Fields!ID4.Value)+
sum(Fields!ID5.Value)+
sum(Fields!ID6.Value)+
sum(Fields!ID7.Value)+
sum(Fields!ID8.Value)+
sum(Fields!ID9.Value)+
sum(Fields!ID10.Value)+
sum(Fields!ID11.Value)+
sum(Fields!ID12.Value))-
(Sum(Fields!JAN.Value, "trnbilling")+
Sum(Fields!FEB.Value, "trnbilling")+
Sum(Fields!MAR.Value, "trnbilling")+
Sum(Fields!APR.Value, "trnbilling")+
Sum(Fields!MAY.Value, "trnbilling")+
Sum(Fields!JUN.Value, "trnbilling")+
Sum(Fields!JUL.Value, "trnbilling")+
Sum(Fields!AUG.Value, "trnbilling")+
Sum(Fields!SEP.Value, "trnbilling")+
Sum(Fields!OCT.Value, "trnbilling")+
Sum(Fields!NOV.Value, "trnbilling")+
Sum(Fields!DEC.Value, "trnbilling")))/
(Sum(Fields!JAN.Value, "DataSet1")+
Sum(Fields!FEB.Value, "DataSet1")+
Sum(Fields!MAR.Value, "DataSet1")+
Sum(Fields!APR.Value, "DataSet1")+
Sum(Fields!MAY.Value, "DataSet1")+
Sum(Fields!JUN.Value, "DataSet1")+
Sum(Fields!JUL.Value, "DataSet1")+
Sum(Fields!AUG.Value, "DataSet1")+
Sum(Fields!SEP.Value, "DataSet1")+
Sum(Fields!OCT.Value, "DataSet1")+
Sum(Fields!NOV.Value, "DataSet1")+
Sum(Fields!DEC.Value, "DataSet1"))
0.25in
true
division_city
textbox231
293
true
textbox232
292
true
textbox233
291
true
textbox234
290
true
textbox235
289
true
textbox236
288
true
textbox275
287
true
textbox276
286
true
textbox277
285
true
textbox278
284
true
textbox279
283
true
textbox280
282
true
textbox286
281
true
textbox287
280
true
textbox288
279
true
textbox289
278
true
textbox290
277
true
0.25in
true
division_city
textbox27
276
true
3
textbox8
275
true
Mode
textbox54
274
true
textbox55
273
true
textbox56
272
true
textbox57
271
true
textbox58
270
true
textbox59
269
true
textbox60
268
true
textbox61
267
true
textbox62
266
true
textbox63
265
true
textbox64
264
true
textbox65
263
true
textbox152
262
true
0.25in
true
division_city
textbox30
65
true
textbox31
64
true
textbox32
63
true
textbox33
62
true
textbox34
61
true
textbox35
60
true
textbox36
59
true
textbox37
58
true
textbox38
57
true
textbox39
56
true
textbox40
55
true
textbox41
54
true
textbox114
53
true
textbox115
52
true
textbox116
51
true
textbox117
50
true
textbox160
49
true
0.25in
=Fields!carrier_type.Value
true
division_city
textbox3
261
true
3
carrier_type
260
true
=Fields!carrier_type.Value
259
true
=sum(Fields!ID1.Value)
258
true
=sum(Fields!ID2.Value)
257
true
=sum(Fields!ID3.Value)
256
true
=sum(Fields!ID4.Value)
255
true
=sum(Fields!ID5.Value)
254
true
=sum(Fields!ID6.Value)
253
true
=sum(Fields!ID7.Value)
252
true
=sum(Fields!ID8.Value)
251
true
=sum(Fields!ID9.Value)
250
true
=sum(Fields!ID10.Value)
249
true
=sum(Fields!ID11.Value)
248
true
=sum(Fields!ID12.Value)
textbox153
247
true
=sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value)
0.25in
true
carrier_type
textbox51
246
true
textbox67
245
true
2
textbox9
244
true
Entry Type
textbox70
243
true
textbox71
242
true
textbox72
241
true
textbox73
240
true
textbox74
239
true
textbox75
238
true
textbox76
237
true
textbox77
236
true
textbox78
235
true
textbox79
234
true
textbox80
233
true
textbox81
232
true
textbox154
231
true
0.25in
true
carrier_type
textbox118
48
true
textbox119
47
true
textbox120
46
true
textbox121
45
true
textbox122
44
true
textbox123
43
true
textbox124
42
true
textbox125
41
true
textbox126
40
true
textbox127
39
true
textbox128
38
true
textbox129
37
true
textbox130
36
true
textbox131
35
true
textbox132
34
true
textbox133
33
true
textbox159
32
true
0.25in
=iif(fields!entry_type.value="CRED" or fields!entry_type.value="FRT", "FRT",Fields!entry_type.value)
true
carrier_type
textbox68
230
true
textbox83
229
true
2
entry_type
228
true
=First(Fields!entry_type.Value)
227
true
=sum(Fields!ID1.Value)
226
true
=sum(Fields!ID2.Value)
225
true
=sum(Fields!ID3.Value)
224
true
=sum(Fields!ID4.Value)
223
true
=sum(Fields!ID5.Value)
222
true
=sum(Fields!ID6.Value)
221
true
=sum(Fields!ID7.Value)
220
true
=sum(Fields!ID8.Value)
219
true
=sum(Fields!ID9.Value)
218
true
=sum(Fields!ID10.Value)
217
true
=sum(Fields!ID11.Value)
216
true
=sum(Fields!ID12.Value)
textbox155
215
true
=sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value)
0.25in
true
entry_type
textbox6
214
true
textbox99
213
true
textbox100
212
true
textbox7
211
true
Carrier
textbox86
210
true
textbox22
209
true
textbox28
208
true
textbox29
207
true
textbox50
206
true
textbox52
205
true
textbox53
204
true
textbox66
203
true
textbox69
202
true
textbox82
201
true
textbox85
200
true
textbox87
199
true
textbox156
198
true
0.25in
true
entry_type
textbox134
31
true
textbox135
30
true
textbox136
29
true
textbox137
28
true
textbox138
27
true
textbox139
26
true
textbox140
25
true
textbox141
24
true
textbox142
23
true
textbox143
22
true
textbox144
21
true
textbox145
20
true
textbox146
19
true
textbox147
18
true
textbox148
17
true
textbox149
16
true
textbox158
15
true
0.25in
18.25in
true
entry_type
textbox2
14
true
3
textbox4
13
true
=Fields!company_name.Value
ID1
12
true
=Fields!ID1.Value
ID2
11
true
=Fields!ID2.Value
ID3
10
true
=Fields!ID3.Value
ID4
9
true
=Fields!ID4.Value
ID5
8
true
=Fields!ID5.Value
ID6
7
true
=Fields!ID6.Value
ID7
6
true
=Fields!ID7.Value
ID8
5
true
=Fields!ID8.Value
ID9
4
true
=Fields!ID9.Value
ID10
3
true
=Fields!ID10.Value
ID11
2
true
=Fields!ID11.Value
ID12
1
true
=Fields!ID12.Value
textbox157
true
=sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value)
0.21in
4
textbox5
453
true
=sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value)
table1_Group1
table1
Location
textbox10
452
true
JAN
textbox11
451
true
FEB
textbox12
450
true
MAR
textbox13
449
true
APR
textbox14
448
true
MAY
textbox15
447
true
JUN
textbox16
446
true
JUL
textbox17
445
true
AUG
textbox18
444
true
SEP
textbox19
443
true
OCT
textbox20
442
true
NOV
textbox21
441
true
DEC
textbox150
440
true
2010 YTD
0.22in
true
1in
1in
1in
1in
2.25in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
1in
6.93in
textbox174
82
true
textbox175
81
true
textbox176
80
true
textbox177
79
true
textbox192
78
true
textbox193
77
true
textbox195
76
true
textbox196
75
true
textbox197
74
true
textbox223
73
true
textbox226
72
true
textbox198
71
true
textbox227
70
true
textbox225
69
true
textbox228
68
true
textbox229
67
true
textbox230
66
true
0.25in
textbox84
99
true
textbox169
98
true
textbox170
97
true
textbox171
96
true
95
true
=Fields!ID1.Value
JAN
94
true
FEB
93
true
MAR
92
true
APR
91
true
MAY
90
true
JUN
89
true
JUL
88
true
AUG
87
true
SEP
86
true
OCT
85
true
NOV
84
true
DEC
83
true
2010 YTD
0.25in
textbox161
116
true
textbox162
115
true
textbox163
114
true
textbox164
113
true
Grand Total
112
true
=sum(Fields!ID1.Value)
111
true
=sum(Fields!ID2.Value)
110
true
=sum(Fields!ID3.Value)
109
true
=sum(Fields!ID4.Value)
108
true
=sum(Fields!ID5.Value)
107
true
=sum(Fields!ID6.Value)
106
true
=sum(Fields!ID7.Value)
105
true
=sum(Fields!ID8.Value)
104
true
=sum(Fields!ID9.Value)
103
true
=sum(Fields!ID10.Value)
102
true
=sum(Fields!ID11.Value)
101
true
=sum(Fields!ID12.Value)
100
true
=sum(Fields!ID1.Value)+sum(Fields!ID2.Value)+sum(Fields!ID3.Value)+sum(Fields!ID4.Value)+sum(Fields!ID5.Value)+sum(Fields!ID6.Value)+sum(Fields!ID7.Value)+sum(Fields!ID8.Value)+sum(Fields!ID9.Value)+sum(Fields!ID10.Value)+sum(Fields!ID11.Value)+sum(Fields!ID12.Value)
0.25in
textbox165
133
true
textbox166
132
true
textbox167
131
true
textbox168
130
true
Sales
JAN
129
true
=Sum(Fields!JAN.Value, "DataSet1")
FEB
128
true
=Sum(Fields!FEB.Value, "DataSet1")
MAR
127
true
=Sum(Fields!MAR.Value, "DataSet1")
APR
126
true
=Sum(Fields!APR.Value, "DataSet1")
MAY
125
true
=Sum(Fields!MAY.Value, "DataSet1")
JUN
124
true
=Sum(Fields!JUN.Value, "DataSet1")
JUL
123
true
=Sum(Fields!JUL.Value, "DataSet1")
AUG
122
true
=Sum(Fields!AUG.Value, "DataSet1")
SEP
121
true
=Sum(Fields!SEP.Value, "DataSet1")
OCT
120
true
=Sum(Fields!OCT.Value, "DataSet1")
NOV
119
true
=Sum(Fields!NOV.Value, "DataSet1")
DEC
118
true
=Sum(Fields!DEC.Value, "DataSet1")
textbox194
117
true
=Sum(Fields!JAN.Value, "DataSet1")+
Sum(Fields!FEB.Value, "DataSet1")+
Sum(Fields!MAR.Value, "DataSet1")+
Sum(Fields!APR.Value, "DataSet1")+
Sum(Fields!MAY.Value, "DataSet1")+
Sum(Fields!JUN.Value, "DataSet1")+
Sum(Fields!JUL.Value, "DataSet1")+
Sum(Fields!AUG.Value, "DataSet1")+
Sum(Fields!SEP.Value, "DataSet1")+
Sum(Fields!OCT.Value, "DataSet1")+
Sum(Fields!NOV.Value, "DataSet1")+
Sum(Fields!DEC.Value, "DataSet1")
0.25in
textbox199
150
true
textbox200
149
true
textbox201
148
true
textbox202
147
true
Trans Billing
JAN_1
146
true
=Sum(Fields!JAN.Value, "trnbilling")
FEB_1
145
true
=Sum(Fields!FEB.Value, "trnbilling")
MAR_1
144
true
=Sum(Fields!MAR.Value, "trnbilling")
APR_1
143
true
=Sum(Fields!APR.Value, "trnbilling")
MAY_1
142
true
=Sum(Fields!MAY.Value, "trnbilling")
JUN_1
141
true
=Sum(Fields!JUN.Value, "trnbilling")
JUL_1
140
true
=Sum(Fields!JUL.Value, "trnbilling")
AUG_1
139
true
=Sum(Fields!AUG.Value, "trnbilling")
SEP_1
138
true
=Sum(Fields!SEP.Value, "trnbilling")
OCT_1
137
true
=Sum(Fields!OCT.Value, "trnbilling")
NOV_1
136
true
=Sum(Fields!NOV.Value, "trnbilling")
DEC_1
135
true
=Sum(Fields!DEC.Value, "trnbilling")
textbox215
134
true
=Sum(Fields!JAN.Value, "trnbilling")+
Sum(Fields!FEB.Value, "trnbilling")+
Sum(Fields!MAR.Value, "trnbilling")+
Sum(Fields!APR.Value, "trnbilling")+
Sum(Fields!MAY.Value, "trnbilling")+
Sum(Fields!JUN.Value, "trnbilling")+
Sum(Fields!JUL.Value, "trnbilling")+
Sum(Fields!AUG.Value, "trnbilling")+
Sum(Fields!SEP.Value, "trnbilling")+
Sum(Fields!OCT.Value, "trnbilling")+
Sum(Fields!NOV.Value, "trnbilling")+
Sum(Fields!DEC.Value, "trnbilling")
0.25in
textbox203
167
true
textbox204
166
true
textbox205
165
true
textbox206
164
true
textbox220
163
true
textbox219
162
true
textbox218
161
true
textbox217
160
true
textbox216
159
true
textbox214
158
true
textbox213
157
true
textbox212
156
true
textbox211
155
true
textbox210
154
true
textbox207
153
true
textbox208
152
true
textbox209
151
true
0.25in
textbox238
182
true
3
textbox239
181
true
Gross Cost as % to Sales
textbox242
180
true
=Sum(Fields!ID1.Value, "TRANS")/Sum(Fields!JAN.Value, "DataSet1")
179
true
=Sum(Fields!ID2.Value, "TRANS")/Sum(Fields!FEB.Value, "DataSet1")
textbox244
178
true
=Sum(Fields!ID3.Value, "TRANS")/Sum(Fields!MAR.Value, "DataSet1")
textbox245
177
true
=Sum(Fields!ID4.Value, "TRANS")/Sum(Fields!APR.Value, "DataSet1")
textbox246
176
true
=Sum(Fields!ID5.Value, "TRANS")/Sum(Fields!MAY.Value, "DataSet1")
textbox247
175
true
=Sum(Fields!ID6.Value, "TRANS")/Sum(Fields!JUN.Value, "DataSet1")
textbox248
174
true
=Sum(Fields!ID7.Value, "TRANS")/Sum(Fields!JUL.Value, "DataSet1")
textbox249
173
true
=Sum(Fields!ID8.Value, "TRANS")/Sum(Fields!AUG.Value, "DataSet1")
textbox250
172
true
=Sum(Fields!ID9.Value, "TRANS")/Sum(Fields!SEP.Value, "DataSet1")
textbox251
171
true
=Sum(Fields!ID10.Value, "TRANS")/Sum(Fields!OCT.Value, "DataSet1")
textbox252
170
true
=Sum(Fields!ID11.Value, "TRANS")/Sum(Fields!NOV.Value, "DataSet1")
textbox253
169
true
=Sum(Fields!ID12.Value, "TRANS")/Sum(Fields!DEC.Value, "DataSet1")
textbox173
168
true
=(sum(Fields!ID1.Value)+
sum(Fields!ID2.Value)+
sum(Fields!ID3.Value)+
sum(Fields!ID4.Value)+
sum(Fields!ID5.Value)+
sum(Fields!ID6.Value)+
sum(Fields!ID7.Value)+
sum(Fields!ID8.Value)+
sum(Fields!ID9.Value)+
sum(Fields!ID10.Value)+
sum(Fields!ID11.Value)+
sum(Fields!ID12.Value))/
(Sum(Fields!JAN.Value, "DataSet1")+
Sum(Fields!FEB.Value, "DataSet1")+
Sum(Fields!MAR.Value, "DataSet1")+
Sum(Fields!APR.Value, "DataSet1")+
Sum(Fields!MAY.Value, "DataSet1")+
Sum(Fields!JUN.Value, "DataSet1")+
Sum(Fields!JUL.Value, "DataSet1")+
Sum(Fields!AUG.Value, "DataSet1")+
Sum(Fields!SEP.Value, "DataSet1")+
Sum(Fields!OCT.Value, "DataSet1")+
Sum(Fields!NOV.Value, "DataSet1")+
Sum(Fields!DEC.Value, "DataSet1"))
0.25in
textbox221
197
true
3
textbox222
196
true
Net Cost as % to Sales
195
true
=(Sum(Fields!ID1.Value, "TRANS")-Sum(Fields!JAN.Value, "trnbilling"))/Sum(Fields!JAN.Value, "DataSet1")
194
true
=(Sum(Fields!ID2.Value, "TRANS")-Sum(Fields!FEB.Value, "trnbilling"))/Sum(Fields!FEB.Value, "DataSet1")
193
true
=(Sum(Fields!ID3.Value, "TRANS")-Sum(Fields!MAR.Value, "trnbilling"))/Sum(Fields!MAR.Value, "DataSet1")
192
true
=(Sum(Fields!ID4.Value, "TRANS")-Sum(Fields!APR.Value, "trnbilling"))/Sum(Fields!APR.Value, "DataSet1")
191
true
=(Sum(Fields!ID5.Value, "TRANS")-Sum(Fields!MAY.Value, "trnbilling"))/Sum(Fields!MAY.Value, "DataSet1")
190
true
=(Sum(Fields!ID6.Value, "TRANS")-Sum(Fields!JUN.Value, "trnbilling"))/Sum(Fields!JUN.Value, "DataSet1")
189
true
=(Sum(Fields!ID7.Value, "TRANS")-Sum(Fields!JUL.Value, "trnbilling"))/Sum(Fields!JUL.Value, "DataSet1")
188
true
=(Sum(Fields!ID8.Value, "TRANS")-Sum(Fields!AUG.Value, "trnbilling"))/Sum(Fields!AUG.Value, "DataSet1")
187
true
=(Sum(Fields!ID9.Value, "TRANS")-Sum(Fields!SEP.Value, "trnbilling"))/Sum(Fields!SEP.Value, "DataSet1")
186
true
=(Sum(Fields!ID10.Value, "TRANS")-Sum(Fields!OCT.Value, "trnbilling"))/Sum(Fields!OCT.Value, "DataSet1")
185
true
=(Sum(Fields!ID11.Value, "TRANS")-Sum(Fields!NOV.Value, "trnbilling"))/Sum(Fields!NOV.Value, "DataSet1")
184
true
=(Sum(Fields!ID12.Value, "TRANS")-Sum(Fields!DEC.Value, "trnbilling"))/Sum(Fields!DEC.Value, "DataSet1")
textbox172
183
true
=((sum(Fields!ID1.Value)+
sum(Fields!ID2.Value)+
sum(Fields!ID3.Value)+
sum(Fields!ID4.Value)+
sum(Fields!ID5.Value)+
sum(Fields!ID6.Value)+
sum(Fields!ID7.Value)+
sum(Fields!ID8.Value)+
sum(Fields!ID9.Value)+
sum(Fields!ID10.Value)+
sum(Fields!ID11.Value)+
sum(Fields!ID12.Value))-
(Sum(Fields!JAN.Value, "trnbilling")+
Sum(Fields!FEB.Value, "trnbilling")+
Sum(Fields!MAR.Value, "trnbilling")+
Sum(Fields!APR.Value, "trnbilling")+
Sum(Fields!MAY.Value, "trnbilling")+
Sum(Fields!JUN.Value, "trnbilling")+
Sum(Fields!JUL.Value, "trnbilling")+
Sum(Fields!AUG.Value, "trnbilling")+
Sum(Fields!SEP.Value, "trnbilling")+
Sum(Fields!OCT.Value, "trnbilling")+
Sum(Fields!NOV.Value, "trnbilling")+
Sum(Fields!DEC.Value, "trnbilling")))/
(Sum(Fields!JAN.Value, "DataSet1")+
Sum(Fields!FEB.Value, "DataSet1")+
Sum(Fields!MAR.Value, "DataSet1")+
Sum(Fields!APR.Value, "DataSet1")+
Sum(Fields!MAY.Value, "DataSet1")+
Sum(Fields!JUN.Value, "DataSet1")+
Sum(Fields!JUL.Value, "DataSet1")+
Sum(Fields!AUG.Value, "DataSet1")+
Sum(Fields!SEP.Value, "DataSet1")+
Sum(Fields!OCT.Value, "DataSet1")+
Sum(Fields!NOV.Value, "DataSet1")+
Sum(Fields!DEC.Value, "DataSet1"))
0.25in
9.625in
en-US
1in