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 SHIFTSYSTEMSHIFTINFO true NUMOFRECORDS true 10.82817cm 2.92725cm 3.48287cm 3.45642cm 3.40666cm 3.53579cm 0.6cm true true Dátum - Műszakrend és műszak - Szerelősor és csapat - GPN 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!DATEINFO.Value 5pt #949a7e Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!QTYcycles.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) / Sum(Fields!SDLHPLANEXP1.Value) 5pt #949a7e Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!SHIFTSYSTEMSHIFTINFO.Value 1 5pt #aab292 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!QTYcycles.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) / 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 =Sum(Fields!QTYcycles.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) / 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 =Sum(Fields!QTYcycles.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) / 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 =Fields!QTYcycles.Value 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) / (Fields!SDLHPLANEXP1.Value) 5pt Middle 2pt 2pt 2pt 2pt 0.6cm true true Total 5pt #728586 Middle 2pt 2pt 2pt 2pt true true =Sum(Fields!QTYcycles.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) / Sum(Fields!SDLHPLANEXP1.Value) 5pt #728586 Middle 2pt 2pt 2pt 2pt =Fields!DATEINFO.Value =Fields!DATEINFO.Value =Fields!SHIFTSYSTEMSHIFTINFO.Value =Fields!SHIFTSYSTEMSHIFTINFO.Value =Fields!ASSLINETEAMINFO.Value =Fields!ASSLINETEAMINFO.Value After =Fields!GPNINFO.Value =Fields!GPNINFO.Value After =(Parameters!UNFOLDALL.Value="false") GPNINFO =(Parameters!UNFOLDALL.Value="false") ASSLINEPLUSTEAMINFO =(Parameters!UNFOLDALL.Value="false") SHIFTSYSTEMSHIFTINFO =(Parameters!UNFOLDALL.Value="false") DATEINFO DataSet1 6.38639cm 0.32604cm 4.8cm 27.63716cm 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.14762cm 17.74608cm 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 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)&" !!!!", "")) =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.14762cm 22.53825cm 2.08222cm 5.46666cm 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 111.8639mm WhiteSmoke 283.49037mm 24.80645mm true true true true Termelési mennyiségek (szerelősor és team, majd GPN rendezésben) Title ReportTitle 2.03464mm 0.32604cm 21.00792mm 276.37155mm 2pt 2pt 2pt 2pt WhiteSmoke 8.25492mm true true true true Riport futási ideje: ExecutionTime 1.90488mm 3.61316mm 6.35mm 82.89003mm 2pt 2pt 2pt 2pt true true Lapszám: PageNumber 1.76385mm 87.9143mm 6mm 58.44154mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 1.76385mm 154.2462mm 6mm 25mm 2 2pt 2pt 2pt 2pt true true / Textbox7 1.76385mm 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