0
SQL
Data Source=.\SQLExpress;Initial Catalog=LearDTM
Adja meg a következő adatforráshoz tartozó felhasználónevet és jelszót: DataSource1.
DataBase
0b0b2666-4897-46e3-900b-847e2efc8416
DataSource1
SELECT * FROM [LearALM].[dbo].[Reports_MetricsCycles]
WHERE 1=1 @kSHIFTSYSTEMNAME@ @kSHIFTNAME@ @kSTARTFrom@ @kSTARTTo@
HAVING SHIFTSYSTEMNAME IS NOT NULL
ORDER BY SHIFTSYSTEMNAME ASC, SHIFTNAME ASC
MachineId
true
TEAMNAME
true
QTYcycles
true
SHIFTSTART
true
SHIFTEND
true
EXPPERF
true
CycleTimeSTD
true
CycleTimeNET
true
CycleTimeGROSS
true
QTYstarted
true
QTYproduced
true
QTYpacked
true
QTYclosed
true
QTYwaste
true
SPPQTYstartedPLAN
true
SPPQTYproducedPLAN
true
SPPQTYpackedPLAN
true
SPPQTYclosedPLAN
true
SPPQTYwastePLAN
true
SPPQTYstartedPLANSHIFT
true
SPPQTYproducedPLANSHIFT
true
SPPQTYpackedPLANSHIFT
true
SPPQTYclosedPLANSHIFT
true
SPPQTYwastePLANSHIFT
true
SDLHstarted_Act
true
SDLHproduced_Act
true
SDLHpacked_Act
true
SDLHclosed_Act
true
SDLH_PlanExpNOW
true
SDLH_PlanExp1
true
IPPMstarted
true
IPPMproduced
true
IPPMpacked
true
IPPMclosed
true
SPPQTYstartedPLAN
true
SPPQTYproducedPLAN
true
SPPQTYpackedPLAN
true
SPPQTYclosedPLAN
true
SPPQTYstartedPLANSHIFT
true
SPPQTYproducedPLANSHIFT
true
SPPQTYpackedPLANSHIFT
true
SPPQTYclosedPLANSHIFT
true
DATEINFO
true
DATESHIFTSYSTEMINFO
true
SHIFTSYSTEMSHIFTINFO
true
SHIFTINFO
true
SPPINFO
true
ASSLINEINFO
true
ASSLINETEAMINFO
true
TEAMINFO
true
SPPQTYplanINFO
true
SPPQTYfactINFO
true
SPPQTYpercentINFO
true
SPPQTYfactSHIFTINFO
true
SPPQTYpercentSHIFTINFO
true
SPPQTYplanSHIFTINFO
true
DATETEAMINFO
true
NUMOFRECORDS
true
true
true
Shift system:
=Parameters!SHIFTSYSTEMNAME.Value
Textbox1
0.28901cm
0.48166cm
0.6cm
10.755cm
2pt
2pt
2pt
2pt
true
true
Shift:
=Parameters!SHIFTNAME.Value
Textbox1
1.00339cm
11.62944cm
0.6cm
10.755cm
1
2pt
2pt
2pt
2pt
true
true
=Parameters!STARTTo.Value
Textbox1
0.28901cm
18.50733cm
0.6cm
3.87711cm
2
2pt
2pt
2pt
2pt
true
true
Start of shift:
=Parameters!STARTFrom.Value
Textbox1
0.28901cm
11.62944cm
0.6cm
6.38615cm
3
2pt
2pt
2pt
2pt
true
true
-
Textbox134
0.28901cm
18.01559cm
0.6cm
0.31535cm
4
Middle
2pt
2pt
2pt
2pt
true
true
Assembly Line:
=Parameters!AssemblyLine.Value
Textbox1
0.99484cm
0.47312cm
0.6cm
10.755cm
5
2pt
2pt
2pt
2pt
true
true
Team:
=Parameters!Team.Value
Textbox1
1.77123cm
0.48166cm
0.6cm
10.755cm
6
2pt
2pt
2pt
2pt
true
true
Metrics are calculated for operation:
=IIF(Parameters!OPERATION.Value = 0, "Start production (on STR)", IIF(Parameters!OPERATION.Value = 1, "Finish production (on PRD)", IIF(Parameters!OPERATION.Value = 2, "Packaging (on PCK)", IIF(Parameters!OPERATION.Value = 3, "Close shipping unit (on CLS)",""))))
Textbox1
1.8cm
11.62944cm
0.6cm
10.755cm
7
2pt
2pt
2pt
2pt
12.19761cm
2.72458cm
3.20931cm
3.19028cm
3.00271cm
3.36558cm
0.6cm
true
true
Team - Shiftsystem and shift - Shift hour - Date
Textbox265
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Boards
Textbox2112
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Qty PLAN
Textbox26
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Quantity
Textbox6
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Efficiency
Textbox27
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Headcount
Textbox1958
5pt
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
Textbox15
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Textbox2113
5pt
5pt
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, "on STR", IIF(Parameters!OPERATION.Value = 1, "on PRD", IIF(Parameters!OPERATION.Value = 2, "on PCK", IIF(Parameters!OPERATION.Value = 3, "on CLS", ""))))
Textbox8
5pt
5pt
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
3
true
true
(weighted)
Textbox1959
5pt
5pt
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!TEAMINFO.Value
5pt
#949a7e
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!QTYcycles.Value)
Textbox2114
5pt
#949a7e
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SPPQTYstartedPLAN.Value),
IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SPPQTYproducedPLAN.Value),
IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SPPQTYpackedPLAN.Value),
IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SPPQTYclosedPLAN.Value),0))))
Textbox351
5pt
#949a7e
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!STARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!PRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!PACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!CLOSED.Value), 0))))
Textbox11
5pt
#949a7e
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!STARTED.Value)/Sum(Fields!SPPQTYstartedPLAN.Value),
IIF(Parameters!OPERATION.Value = 1, Sum(Fields!PRODUCED.Value)/Sum(Fields!SPPQTYproducedPLAN.Value),
IIF(Parameters!OPERATION.Value = 2, Sum(Fields!PACKED.Value)/Sum(Fields!SPPQTYpackedPLAN.Value),
IIF(Parameters!OPERATION.Value = 3, Sum(Fields!CLOSED.Value)/Sum(Fields!SPPQTYclosedPLAN.Value),0))))
Textbox29
5pt
#949a7e
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value)
Textbox199
5pt
#949a7e
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTSYSTEMSHIFTINFO.Value
1
SHIFTSYSTEMSHIFTINFO
5pt
#aab292
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!QTYcycles.Value)
Textbox2115
5pt
#aab292
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SPPQTYstartedPLAN.Value),
IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SPPQTYproducedPLAN.Value),
IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SPPQTYpackedPLAN.Value),
IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SPPQTYclosedPLAN.Value),0))))
Textbox352
5pt
#aab292
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!STARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!PRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!PACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!CLOSED.Value), 0))))
Textbox12
5pt
#aab292
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!STARTED.Value)/Sum(Fields!SPPQTYstartedPLAN.Value),
IIF(Parameters!OPERATION.Value = 1, Sum(Fields!PRODUCED.Value)/Sum(Fields!SPPQTYproducedPLAN.Value),
IIF(Parameters!OPERATION.Value = 2, Sum(Fields!PACKED.Value)/Sum(Fields!SPPQTYpackedPLAN.Value),
IIF(Parameters!OPERATION.Value = 3, Sum(Fields!CLOSED.Value)/Sum(Fields!SPPQTYclosedPLAN.Value),0))))
Textbox31
5pt
#aab292
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value)
Textbox214
5pt
#aab292
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SPPINFO.Value
2
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!QTYcycles.Value)
Textbox2116
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SPPQTYstartedPLAN.Value),
IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SPPQTYproducedPLAN.Value),
IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SPPQTYpackedPLAN.Value),
IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SPPQTYclosedPLAN.Value),0))))
Textbox36
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!STARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!PRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!PACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!CLOSED.Value), 0))))
Textbox13
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!STARTED.Value)/Sum(Fields!SPPQTYstartedPLAN.Value),
IIF(Parameters!OPERATION.Value = 1, Sum(Fields!PRODUCED.Value)/Sum(Fields!SPPQTYproducedPLAN.Value),
IIF(Parameters!OPERATION.Value = 2, Sum(Fields!PACKED.Value)/Sum(Fields!SPPQTYpackedPLAN.Value),
IIF(Parameters!OPERATION.Value = 3, Sum(Fields!CLOSED.Value)/Sum(Fields!SPPQTYclosedPLAN.Value),0))))
Textbox37
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value)
Textbox228
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!DATEINFO.Value
3
DATEINFO
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!QTYcycles.Value)
Textbox2117
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SPPQTYstartedPLAN.Value),
IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SPPQTYproducedPLAN.Value),
IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SPPQTYpackedPLAN.Value),
IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SPPQTYclosedPLAN.Value),0))))
Textbox14
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!STARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!PRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!PACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!CLOSED.Value), 0))))
Textbox14
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!STARTED.Value) / Fields!SPPQTYstartedPLAN.Value, IIF(Parameters!OPERATION.Value = 1, Sum(Fields!PRODUCED.Value) / Fields!SPPQTYproducedPLAN.Value, IIF(Parameters!OPERATION.Value = 2, Sum(Fields!PACKED.Value) / Fields!SPPQTYpackedPLAN.Value, IIF(Parameters!OPERATION.Value = 3, Sum(Fields!CLOSED.Value) / Fields!SPPQTYclosedPLAN.Value, 0))))
Textbox14
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value)
Textbox241
5pt
#b8c09e
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!ASSLINEINFO.Value
ASSLINEINFO1
5pt
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!QTYcycles.Value)
Textbox2121
5pt
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, (Fields!SPPQTYstartedPLAN.Value),
IIF(Parameters!OPERATION.Value = 1, (Fields!SPPQTYproducedPLAN.Value),
IIF(Parameters!OPERATION.Value = 2, (Fields!SPPQTYpackedPLAN.Value),
IIF(Parameters!OPERATION.Value = 3, (Fields!SPPQTYclosedPLAN.Value),0))))
Textbox334
5pt
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Fields!STARTED.Value, IIF(Parameters!OPERATION.Value = 1, Fields!PRODUCED.Value, IIF(Parameters!OPERATION.Value = 2, Fields!PACKED.Value, IIF(Parameters!OPERATION.Value = 3, Fields!CLOSED.Value, 0))))
Textbox24
5pt
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, (Fields!STARTED.Value)/(Fields!SPPQTYstartedPLAN.Value),
IIF(Parameters!OPERATION.Value = 1, (Fields!PRODUCED.Value)/(Fields!SPPQTYproducedPLAN.Value),
IIF(Parameters!OPERATION.Value = 2, (Fields!PACKED.Value)/(Fields!SPPQTYpackedPLAN.Value),
IIF(Parameters!OPERATION.Value = 3, (Fields!CLOSED.Value)/(Fields!SPPQTYclosedPLAN.Value),0))))
Textbox38
5pt
Middle
2pt
2pt
2pt
2pt
true
true
=(Fields!SDLHPLANEXP.Value) / (Fields!SDLHPLANEXP1.Value)
Textbox2111
5pt
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
Total
Textbox168
5pt
#728586
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!QTYcycles.Value)
Textbox2120
5pt
#728586
Middle
2pt
2pt
2pt
2pt
true
true
Textbox354
5pt
#728586
Middle
2pt
2pt
2pt
2pt
true
true
=IIF(Parameters!OPERATION.Value = 0, Sum(Fields!STARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!PRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!PACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!CLOSED.Value), 0))))
Textbox25
5pt
#728586
Middle
2pt
2pt
2pt
2pt
true
true
Textbox39
5pt
#728586
Middle
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value)
Textbox183
5pt
#728586
Middle
2pt
2pt
2pt
2pt
=Fields!TEAMINFO.Value
=Fields!TEAMINFO.Value
=Fields!SHIFTSYSTEMSHIFTINFO.Value
=Fields!SHIFTSYSTEMSHIFTINFO.Value
=Fields!SPPINFO.Value
=Fields!SPPINFO.Value
After
=Fields!DATEINFO.Value
=Fields!DATEINFO.Value
After
=(Parameters!UNFOLDALL.Value="false")
DATEINFO
=(Parameters!UNFOLDALL.Value="false")
SPPINFO3
=(Parameters!UNFOLDALL.Value="false")
SHIFTSYSTEMSHIFTINFO3
=(Parameters!UNFOLDALL.Value="false")
TEAMINFO3
DataSet1
6.35762cm
0.48166cm
4.8cm
27.69007cm
8
5.46666cm
1.84627cm
true
true
=IIF(Parameters!RECORDCOUNTLIMIT.Value = 0, "", IIF(Parameters!RECORDCOUNTLIMIT.Value = Sum(Fields!NUMOFRECORDS.Value), "Number of records in report is limited to " & FormatNumber(Parameters!RECORDCOUNTLIMIT.Value, 0) & " !!!!", ""))
Textbox23
=IIF(Parameters!RECORDCOUNTLIMIT.Value = 0, "#384c70", IIF(Parameters!RECORDCOUNTLIMIT.Value = Sum(Fields!NUMOFRECORDS.Value), "Red", "#384c70"))
Middle
2pt
2pt
2pt
2pt
0.23595cm
true
true
Textbox23
true
2pt
2pt
2pt
2pt
After
true
DataSet1
0.28901cm
22.70507cm
2.08222cm
5.46666cm
9
true
true
Click here to display / hide SQLTEXT!
2.50583cm
0.47309cm
0.6cm
10.76357cm
10
2pt
2pt
2pt
2pt
true
true
=Parameters!SQLTEXT.Value
Textbox1
3.28222cm
0.47312cm
2.89357cm
27.69861cm
11
true
SQLTEXTMegnyitás
2pt
2pt
2pt
2pt
true
true
Site:
=Parameters!SITENAME.Value
Textbox223
2.54111cm
11.62944cm
0.6cm
5.59562cm
12
2pt
2pt
2pt
2pt
111.5762mm
WhiteSmoke
284.58658mm
22.24881mm
true
true
true
true
Production volume reports
(by team - shift - shift hours - date - assembly line)
Title
ReportTitle
2.03464mm
0.48166cm
20.21417mm
276.90072mm
2pt
2pt
2pt
2pt
WhiteSmoke
8.25492mm
true
true
true
true
Execution time of report:
=Globals!ExecutionTime
ExecutionTime
1.90491mm
4.81653mm
6.35mm
82.89003mm
2pt
2pt
2pt
2pt
true
true
Page number:
=Globals!PageNumber
PageNumber
1.76388mm
89.47045mm
6mm
58.44154mm
1
2pt
2pt
2pt
2pt
true
true
=Globals!TotalPages
TotalPages
1.76388mm
155.80235mm
6mm
25mm
2
2pt
2pt
2pt
2pt
true
true
/
Textbox7
1.76388mm
149.67596mm
6mm
4.3625mm
3
2pt
2pt
2pt
2pt
WhiteSmoke
21cm
29.7cm
0.5cm
0.5cm
0.5cm
0.5cm
Black
Black
Black
Black
String
true
true
SHIFTSYSTEMNAME
String
true
true
SHIFTNAME
String
true
true
STARTFrom
String
true
true
STARTTo
String
true
true
AssemblyLineId
String
true
true
Team
String
true
true
GPN
String
OPERATION
String
UNFOLDALL
Integer
true
RECORDCOUNTLIMIT
String
ReportParameter1
String
true
true
SITENAME
Cm
ca7aa9be-65e4-4d1c-8177-0ccdfbc36420