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 Date - Shiftsystem and shift - Assembly line and team - GPN 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 Textbox8 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 QTYcycles 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!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.46498cm 4.8cm 27.63716cm 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 17.99891cm 0.6cm 0.31535cm 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 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.35306cm 22.63548cm 2.08222cm 5.46666cm 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 284.4198mm 24.80645mm true true true true Production volume report (detailed cycle report by date - shift - assembly line and team - GPN) Title ReportTitle 2.03464mm 0.46498cm 21.00792mm 276.37155mm 2pt 2pt 2pt 2pt WhiteSmoke 8.25492mm true true true true Execution time of report: ExecutionTime 1.90492mm 4.6498mm 6.35mm 82.89003mm 2pt 2pt 2pt 2pt true true Page number: PageNumber 1.76389mm 89.30372mm 6mm 58.44154mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 1.76389mm 155.63562mm 6mm 25mm 2 2pt 2pt 2pt 2pt true true / Textbox7 1.76389mm 149.50923mm 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