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 IPPMstarted true IPPMproduced true IPPMpacked true IPPMclosed true SPPQTYpercentINFO true SPPQTYpercentSHIFTINFO true SPPQTYstartedPLAN true SPPQTYproducedPLAN true SPPQTYpackedPLAN true SPPQTYclosedPLAN true SPPQTYstartedPLANSHIFT true SPPQTYproducedPLANSHIFT true SPPQTYpackedPLANSHIFT true SPPQTYclosedPLANSHIFT true ASSLINETEAMINFO true DATESHIFTSYSTEMINFO true NUMOFRECORDS true 9.15738cm 7.17583cm 1.25646cm 1.81208cm 1.78563cm 1.6679cm 2.05021cm 1.97083cm 1.73271cm 1.30938cm 1.97083cm 1.865cm 0.6cm true true Textbox15 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Textbox15 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Táblák Textbox2112 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Mennyiségek Textbox26 5pt #384c70 Middle 2pt 2pt 2pt 2pt 3 true true SDLH Textbox1383 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt 3 true true Javít. Textbox33 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true IPPM Textbox26 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Dolgozók Textbox1958 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt 1.04979cm true true 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Terv és tény mennyiségek az óránkénti tervből Textbox16 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Textbox2113 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Terv 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 Haték. Textbox28 5pt 5pt 5pt #384c70 Middle 2pt 2pt 2pt 2pt true true Terv 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 Haték. 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!SPPQTYpercentSHIFTINFO.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!SPPQTYpercentINFO.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 =Fields!CYCLEINFO.Value 5pt Middle 2pt 2pt 2pt 2pt true true 5pt Middle 2pt 2pt 2pt 2pt true true 5pt Middle 2pt 2pt 2pt 2pt true true 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)))) 5pt Middle 2pt 2pt 2pt 2pt true true 5pt Middle 2pt 2pt 2pt 2pt true true =Fields!SDLHPLANEXP.Value 5pt Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Fields!SDLHSTARTED.Value, IIF(Parameters!OPERATION.Value = 1, Fields!SDLHPRODUCED.Value, IIF(Parameters!OPERATION.Value = 2, Fields!SDLHPACKED.Value, IIF(Parameters!OPERATION.Value = 3, Fields!SDLHCLOSED.Value, 0)))) 5pt Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, (Fields!SDLHSTARTED.Value), IIF(Parameters!OPERATION.Value = 1, (Fields!SDLHPRODUCED.Value), IIF(Parameters!OPERATION.Value = 2, (Fields!SDLHPACKED.Value), IIF(Parameters!OPERATION.Value = 3, (Fields!SDLHCLOSED.Value), 0)))) / Sum(Fields!SDLHPLANEXP.Value) 5pt Middle 2pt 2pt 2pt 2pt true true =Fields!REPAIRED.Value 5pt 5pt Middle 2pt 2pt 2pt 2pt true true =IIF(Parameters!OPERATION.Value = 0, Fields!IPPMstarted.Value, IIF(Parameters!OPERATION.Value = 1, Fields!IPPMproduced.Value, IIF(Parameters!OPERATION.Value = 2, Fields!IPPMpacked.Value, IIF(Parameters!OPERATION.Value = 3, Fields!IPPMclosed.Value, 0)))) 5pt Middle 2pt 2pt 2pt 2pt true true 5pt 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 After =(Parameters!UNFOLDALL.Value="false") GPNINFO =(Parameters!UNFOLDALL.Value="false") SPPINFO =(Parameters!UNFOLDALL.Value="false") ASSLINEPLUSTEAMINFO =(Parameters!UNFOLDALL.Value="false") SHIFTINFO =(Parameters!UNFOLDALL.Value="false") DATESHIFTSYSTEMINFO DataSet1 6.06889cm 0.32604cm 5.84979cm 33.75424cm true true Műszakrend: 2pt 2pt 2pt 2pt true true Műszak: 2pt 2pt 2pt 2pt true true =Parameters!STARTTo.Value 2pt 2pt 2pt 2pt true true Műszak kezdete: 2pt 2pt 2pt 2pt true true - Textbox134 0.28901cm 18.81247cm 0.6cm 0.31535cm 5 Middle 2pt 2pt 2pt 2pt true true Szerelősor : 2pt 2pt 2pt 2pt true true Csapat: 2pt 2pt 2pt 2pt true true Mérőszámokat a következő műveletre kalkulálja: 2pt 2pt 2pt 2pt 10.03283cm 0.43656cm 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.43656cm true true 2pt 2pt 2pt 2pt After true DataSet1 0.28901cm 24.04745cm 0.87312cm 10.03283cm 9 true true Kattintson ide az SQLTEXT megnyitásához / eltűntetéséhez! 2pt 2pt 2pt 2pt true true =Parameters!SQLTEXT.Value 2pt 2pt 2pt 2pt true true Gyár: 2pt 2pt 2pt 2pt 119.1868mm WhiteSmoke 343.08522mm 25.33561mm true true true true Termelési mennyiségek és hatékonyság mutatók riportja (részletes ciklus riport,műszakrend,műszak,szerelősor+csapat,műszak óra,majd GPN) Title ReportTitle 2.03464mm 0.32604cm 19.94958mm 337.54238mm 2pt 2pt 2pt 2pt WhiteSmoke 8.25492mm true true true true Riport végrehajtási ideje: ExecutionTime 1.90492mm 3.26038mm 6.35mm 82.89003mm 2pt 2pt 2pt 2pt true true Lapszám: 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 SQLTEXT String true true SITENAME Cm ca7aa9be-65e4-4d1c-8177-0ccdfbc36420