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
12.19761cm
2.72458cm
3.20931cm
3.19028cm
3.00271cm
3.36558cm
0.6cm
true
true
Csapat - Műszakrend és műszak - Műszak óra - Dátum
Textbox265
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Táblák
Textbox2112
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Terv mennyiségek
Textbox26
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Tény mennyiségek
Textbox6
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Hatékonyság
Textbox8
5pt
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Dolgozószám
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
(súlyozott)
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
Összesen
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.38639cm
0.51105cm
4.8cm
27.69007cm
true
true
Műszakrend:
=Parameters!SHIFTSYSTEMNAME.Value
Textbox1
0.29045cm
0.51105cm
0.6cm
10.755cm
1
2pt
2pt
2pt
2pt
true
true
Műszak:
=Parameters!SHIFTNAME.Value
Textbox1
1.00483cm
11.34133cm
0.6cm
10.755cm
2
2pt
2pt
2pt
2pt
true
true
=Parameters!STARTTo.Value
Textbox1
0.29045cm
18.21922cm
0.6cm
3.87711cm
3
2pt
2pt
2pt
2pt
true
true
Műszak kezdete:
=Parameters!STARTFrom.Value
Textbox1
0.29045cm
11.34133cm
0.6cm
6.38615cm
4
2pt
2pt
2pt
2pt
true
true
-
Textbox134
0.29045cm
17.72748cm
0.6cm
0.31535cm
5
Middle
2pt
2pt
2pt
2pt
true
true
Szerelősor :
=Parameters!AssemblyLine.Value
Textbox1
0.99628cm
0.50251cm
0.6cm
10.755cm
6
2pt
2pt
2pt
2pt
true
true
Csapat:
=Parameters!Team.Value
Textbox1
1.77267cm
0.51105cm
0.6cm
10.755cm
7
2pt
2pt
2pt
2pt
true
true
Mérőszámokat a következő műveletre kalkulálja:
=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.80144cm
11.34133cm
0.6cm
10.755cm
8
2pt
2pt
2pt
2pt
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.31778cm
22.54945cm
2.08222cm
5.46666cm
9
true
true
Kattintson ide az SQLTEXT megnyitásához / eltűntetéséhez!
2.50583cm
0.32604cm
0.6cm
10.755cm
10
2pt
2pt
2pt
2pt
true
true
=Parameters!SQLTEXT.Value
Textbox1
3.28222cm
0.32607cm
2.92778cm
27.87505cm
11
true
SQLTEXTMegnyitás
2pt
2pt
2pt
2pt
true
true
Gyár:
=Parameters!SITENAME.Value
Textbox223
2.50727cm
11.34133cm
0.6cm
5.59562cm
12
2pt
2pt
2pt
2pt
111.8639mm
WhiteSmoke
284.94546mm
22.24881mm
true
true
true
true
Termelési mennyiségek
(Csapat, műszak, műszak óra, dátum, szerelősor rendezésben)
Title
ReportTitle
2.03464mm
0.32604cm
20.21417mm
276.90072mm
2pt
2pt
2pt
2pt
WhiteSmoke
8.25492mm
true
true
true
true
Riport futási ideje:
=Globals!ExecutionTime
ExecutionTime
1.02298mm
2.79788mm
6.35mm
82.89003mm
2pt
2pt
2pt
2pt
true
true
Lapszám:
=Globals!PageNumber
PageNumber
0.88195mm
87.09902mm
6mm
58.44154mm
1
2pt
2pt
2pt
2pt
true
true
=Globals!TotalPages
TotalPages
0.88195mm
153.43092mm
6mm
25mm
2
2pt
2pt
2pt
2pt
true
true
/
Textbox7
0.88195mm
147.30453mm
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
SQLTEXT
String
true
true
SITENAME
Cm
ca7aa9be-65e4-4d1c-8177-0ccdfbc36420