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 QTYcycles true START System.Int64 END System.Int64 GPNINFO true NUMOFWORKERS true SHIFTSTART true SHIFTEND true EXPPERF true ASSLINEINFO true SHIFTINFO true TEAMINFO true DATEINFO 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 CYCLEINFO true SPPINFO true SPPQTYplanINFO true SPPQTYfactINFO true SPPQTYplanSHIFTINFO true SPPQTYfactSHIFTINFO true SPPQTYeffINFO true SPPQTYeffSHIFTINFO 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 ASSLINETEAMINFO true DATESHIFTSYSTEMINFO true NUMOFRECORDS true 9.64912cm 6.60447cm 1.25646cm 1.46812cm 1.78563cm 1.6679cm 2.05021cm 1.97083cm 1.67979cm 1.30938cm 1.97083cm 1.865cm 0.6cm true true Shift system - shift - assembly line and team - shift hour - GPN Textbox15 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Textbox15 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Boards Textbox2112 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Quantity Textbox57 5pt #384c70 Middle 2pt 2pt 2pt 2pt 3 true true SDLH Textbox1383 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt 3 true true Repairs Textbox33 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true IPPM Textbox26 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Headcount Textbox1958 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt 0.6cm true true 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Plan/Fact summary Textbox16 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Textbox2113 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Plan Textbox8 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 true true Efficiency Textbox53 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Plan Textbox154 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", "")))) Textbox27 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Efficiency Textbox28 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Textbox255 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", "")))) Textbox27 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true (weighted) Textbox1959 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!DATESHIFTSYSTEMINFO.Value 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!BOARDS.Value) 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true 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)))) 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) / Sum(Fields!SDLHPLANEXP.Value) 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!REPAIRED.Value) 5pt 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!IPPMstarted.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!IPPMproduced.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!IPPMpacked.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!IPPMclosed.Value), 0)))) 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value) 5pt #949a7e Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!SHIFTINFO.Value 1 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!BOARDS.Value) 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true 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)))) 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) / Sum(Fields!SDLHPLANEXP.Value) 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!REPAIRED.Value) 5pt 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!IPPMstarted.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!IPPMproduced.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!IPPMpacked.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!IPPMclosed.Value), 0)))) 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value) 5pt #aab292 Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!ASSLINETEAMINFO.Value 2 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Fields!SPPQTYplanSHIFTINFO.Value + vbCrLf + Fields!SPPQTYfactSHIFTINFO.Value + vbCrLf + Fields!SPPQTYeffSHIFTINFO.Value Textbox19 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!BOARDS.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, (Fields!SPPQTYstartedPLANSHIFT.Value), IIF(Parameters!OPERATION.Value = 1, (Fields!SPPQTYproducedPLANSHIFT.Value), IIF(Parameters!OPERATION.Value = 2, (Fields!SPPQTYpackedPLANSHIFT.Value), IIF(Parameters!OPERATION.Value = 3, (Fields!SPPQTYclosedPLANSHIFT.Value),0)))) 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)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true = IIF(Parameters!OPERATION.Value = 0,Sum(Fields!STARTED.Value)/Fields!SPPQTYstartedPLANSHIFT.Value, IIF(Parameters!OPERATION.Value = 1,Sum(Fields!PRODUCED.Value)/Fields!SPPQTYproducedPLANSHIFT.Value, IF(Parameters!OPERATION.Value = 2,Sum(Fields!PACKED.Value)/Fields!SPPQTYpackedPLANSHIFT.Value, IIF(Parameters!OPERATION.Value = 3,Sum(Fields!CLOSED.Value)/Fields!SPPQTYclosedPLANSHIFT.Value,0)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) / Sum(Fields!SDLHPLANEXP.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!REPAIRED.Value) 5pt 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!IPPMstarted.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!IPPMproduced.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!IPPMpacked.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!IPPMclosed.Value), 0)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!SPPINFO.Value 3 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Fields!SPPQTYplanINFO.Value + vbCrLf + Fields!SPPQTYfactINFO.Value + vbCrLf + Fields!SPPQTYeffINFO.Value 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!BOARDS.Value) 5pt #b8c09e 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),990)))) 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)))) 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)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) / Sum(Fields!SDLHPLANEXP.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!REPAIRED.Value) 5pt 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!IPPMstarted.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!IPPMproduced.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!IPPMpacked.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!IPPMclosed.Value), 0)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!GPNINFO.Value 4 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!BOARDS.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true 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)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) / Sum(Fields!SDLHPLANEXP.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!REPAIRED.Value) 5pt 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!IPPMstarted.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!IPPMproduced.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!IPPMpacked.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!IPPMclosed.Value), 0)))) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value) 5pt #b8c09e Middle 2pt 2pt 2pt 2pt 0.6cm true true Total 5pt #728586 Middle 2pt 2pt 2pt 2pt true true 5pt #728586 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!BOARDS.Value) 5pt #728586 Middle 2pt 2pt 2pt 2pt true true 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)))) 5pt #728586 Middle 2pt 2pt 2pt 2pt true true 5pt #728586 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) 5pt #728586 Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) 5pt #728586 Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!SDLHCLOSED.Value), 0)))) / Sum(Fields!SDLHPLANEXP.Value) 5pt #728586 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!REPAIRED.Value) 5pt 5pt #728586 Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Sum(Fields!IPPMstarted.Value), IIF(Parameters!OPERATION.Value = 1, Sum(Fields!IPPMproduced.Value), IIF(Parameters!OPERATION.Value = 2, Sum(Fields!IPPMpacked.Value), IIF(Parameters!OPERATION.Value = 3, Sum(Fields!IPPMclosed.Value), 0)))) 5pt #728586 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!SDLHPLANEXP.Value) / Sum(Fields!SDLHPLANEXP1.Value) 5pt #728586 Middle 2pt 2pt 2pt 2pt =Fields!DATESHIFTSYSTEMINFO.Value =Fields!DATESHIFTSYSTEMINFO.Value =Fields!SHIFTINFO.Value =Fields!SHIFTINFO.Value =Fields!ASSLINETEAMINFO.Value =Fields!ASSLINETEAMINFO.Value After =Fields!SPPINFO.Value =Fields!SPPINFO.Value After =Fields!GPNINFO.Value =Fields!GPNINFO.Value =(Parameters!UNFOLDALL.Value="false") SPPINFO =(Parameters!UNFOLDALL.Value="false") ASSLINEPLUSTEAMINFO =(Parameters!UNFOLDALL.Value="false") SHIFTINFO =(Parameters!UNFOLDALL.Value="false") DATESHIFTSYSTEMINFO DataSet1 6.38639cm 0.32604cm 4.8cm 33.27774cm true true Shift system: 2pt 2pt 2pt 2pt true true Shift: 2pt 2pt 2pt 2pt true true =Parameters!STARTTo.Value 2pt 2pt 2pt 2pt true true Start of shift: 2pt 2pt 2pt 2pt true true - Textbox134 0.28901cm 18.81247cm 0.6cm 0.49174cm 5 Middle 2pt 2pt 2pt 2pt true true Assembly Line: 2pt 2pt 2pt 2pt true true Team: 2pt 2pt 2pt 2pt true true Metrics are calculated for operation: 2pt 2pt 2pt 2pt 9.72165cm 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) & " !!!!", "")) =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 2pt 2pt 2pt 2pt After true DataSet1 0.28901cm 23.96175cm 2.08222cm 9.72165cm 9 true true Click here to display / hide SQLTEXT! 2pt 2pt 2pt 2pt true true =Parameters!SQLTEXT.Value 2pt 2pt 2pt 2pt true true Site: 2pt 2pt 2pt 2pt 111.8639mm WhiteSmoke 339.55695mm 24.80645mm true true true true Production volume & efficiency report ( Shift system - shift - assembly line and team - shift hour - GPN ) Title ReportTitle 2.03464mm 0.32604cm 19.42042mm 333.5736mm 2pt 2pt 2pt 2pt WhiteSmoke 8.25492mm true true true true Execution time of report: ExecutionTime 1.90492mm 3.26038mm 6.35mm 82.89003mm 2pt 2pt 2pt 2pt true true Page number: PageNumber 1.76389mm 87.9143mm 6mm 58.44154mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 1.76389mm 154.2462mm 6mm 25mm 2 2pt 2pt 2pt 2pt true true / Textbox7 1.76389mm 148.11981mm 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