0 SQL Data Source=.\SQLExpress;Initial Catalog=LearALM Specify a user name and password for data source DataSource1: Windows 0b0b2666-4897-46e3-900b-847e2efc8416 DataSource1 =Parameters!SHIFTSYSTEMNAME.Value true =Parameters!SHIFTNAME.Value true =Parameters!STARTFrom.Value true =Parameters!STARTTo.Value true SELECT Periods.SHIFTSYSTEMNAME,Periods.SHIFTNAME ,PeriodeTypeNum,dbo.PeriodTypeName(Periods.PeriodeTypeNum,'en-US') AS PeriodeTypeName ,Count(*) AS [Count] ,SUM(Periods.[LENGTH]) AS SUMTime ,(CASE Periods.PeriodeTypeNum WHEN 4 THEN -1 WHEN 3 THEN 1 ELSE 0 END) * SUM(Periods.[LENGTH]) AS SUMTimeDT ,P1.SUMSUMTime ,SUM([QTYproduced]) AS SUMProdCount ,SUM([Cycles]) AS SUMCycles FROM Reports_Periods AS Periods INNER JOIN (SELECT P11.SHIFTSYSTEMNAME AS _SHIFTSYSTEMNAME ,P11.SHIFTNAME AS _SHIFTNAME ,SUM(P11.[LENGTH]) AS SUMSUMTime FROM Reports_Periods2 AS P11 WHERE 1=1 GROUP BY P11.SHIFTSYSTEMNAME, P11.SHIFTNAME) AS P1 ON P1._SHIFTSYSTEMNAME = Periods.SHIFTSYSTEMNAME AND P1._SHIFTNAME = Periods.SHIFTNAME WHERE (1=1) AND Periods.SHIFTSYSTEMNAME IS NOT NULL GROUP BY Periods.SHIFTSYSTEMNAME, Periods.SHIFTNAME, P1.SUMSUMTime, Periods.PeriodeTypeNum true SHIFTSYSTEMNAME System.String SHIFTNAME System.String SUMTime System.Int32 Count System.Int32 SUMSUMTime System.Int32 PeriodeTypeNum true ShiftStart true SUMProdCount true SUMCycles true PeriodeTypeName true SUMTimeDT true 13.66682cm 4.87441cm 3.92168cm 2.53018cm 2.6825cm 0.62987cm true true Open for details! #384c70 2pt 2pt 2pt 2pt true true Time #384c70 2pt 2pt 2pt 2pt true true Ratio #384c70 2pt 2pt 2pt 2pt true true Boards #384c70 2pt 2pt 2pt 2pt true true Harnesses #384c70 2pt 2pt 2pt 2pt 0.62987cm true true =Fields!PERIODETYPE.Value #949a7e 2pt 2pt 2pt 2pt true true =SUM(Fields!SUMTime.Value) \ 3600 & ":" & (SUM(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!SUMTime.Value) MOD 60) #949a7e 2pt 2pt 2pt 2pt true true #949a7e 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) #949a7e 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) #949a7e 2pt 2pt 2pt 2pt 0.62987cm true true =Fields!SHIFTSYSTEMNAME.Value 1 #aab292 2pt 2pt 2pt 2pt true true =SUM(Fields!SUMTime.Value) \ 3600 & ":" & (SUM(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!SUMTime.Value) MOD 60) #aab292 2pt 2pt 2pt 2pt true true 100% #aab292 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) #aab292 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) #aab292 2pt 2pt 2pt 2pt 0.62987cm true true =Fields!SHIFTNAME.Value 2 #b8c09e 2pt 2pt 2pt 2pt true true =(Fields!SUMTime.Value) \ 3600 & ":" & ((Fields!SUMTime.Value) MOD 3600)\60 & ":" & ((Fields!SUMTime.Value) MOD 60) 2pt 2pt 2pt 2pt true true =Str(Round((Fields!SUMTime.Value*100)/Sum(Fields!SUMSUMTime.Value)))+"%" 2pt 2pt 2pt 2pt true true =Fields!SUMCYCLES.Value 2pt 2pt 2pt 2pt true true =Fields!SUMPRODCOUNT.Value 2pt 2pt 2pt 2pt 0.62987cm true true Total #728586 2pt 2pt 2pt 2pt true true =SUM(Fields!SUMTime.Value) \ 3600 & ":" & (SUM(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!SUMTime.Value) MOD 60) #728586 2pt 2pt 2pt 2pt true true #728586 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) #728586 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) #728586 2pt 2pt 2pt 2pt =Fields!PERIODETYPE.Value =Fields!PERIODETYPE.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value After =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =(Parameters!UNFOLDALL.Value = "false") SHIFTSYSTEMNAME1 =(Parameters!UNFOLDALL.Value = "false") PERIODETYPE true DataSet1 39.13143cm 0.23876cm 3.14935cm 27.67559cm ListaMegnyitás2 =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!PERIODETYPE.Value =Fields!PERIODETYPE.Value =Sum(Fields!SUMTime.Value) Shiftsystem > Shift False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Utilization time distribution (%) 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN TopCenter true Black Black Shift-time distribution on periode types (in %) BrightPastel No Data Available DataSet1 7.07024cm 0.16002cm 12.30944cm 27.75431cm 1 GrafikonMegnyitás WhiteSmoke None =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!PERIODETYPE.Value =Fields!PERIODETYPE.Value =CLng(Sum(Fields!SUMTime.Value))/3600 Shiftsystem > Shift False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Time (hours) 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN TopCenter true Black Black Shift-time distribution on periode types (absolute) BrightPastel No Data Available DataSet1 19.69718cm 0.16002cm 11.39222cm 27.75431cm 2 GrafikonMegnyitás WhiteSmoke None 4.84373cm 4.82226cm 3.71721cm 2.63035cm 2.63035cm 1.94937cm true =Fields!PERIODETYPE.Value DataSet1 true Periode type #333333 Middle 2pt 2pt 2pt 2pt true =Fields!SUMTime.Value DataSet1 true Time Textbox5 #333333 Middle 2pt 2pt 2pt 2pt true true Ratio Textbox16 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Boards Textbox20 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Harnesses Textbox6 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!PERIODETYPE.Value PERIODETYPE2 WhiteSmoke 2pt 2pt 2pt 2pt true true =IIF(Fields!SUMTimeDT.Value<0,"-","") & Abs(Fields!SUMTime.Value) \ 3600 & ":" & (Abs(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (Abs(Fields!SUMTime.Value) MOD 60) SUMTime2 WhiteSmoke 2pt 2pt 2pt 2pt true true =IIF(Fields!SUMTimeDT.Value<0,"-","") & Str(Round((Fields!SUMTime.Value*100)/(Fields!SUMSUMTime.Value)))+"%" Textbox17 Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt true true =Fields!SUMCYCLES.Value SUMCYCLES Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt true true =Fields!SUMPRODCOUNT.Value SUMPRODCOUNT Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt 0.6cm true true Total for shift Textbox12 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =SUM(Fields!SUMTime.Value) \ 3600 & ":" & (SUM(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!SUMTime.Value) MOD 60) SUMSUMTime2 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true 100% Textbox18 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) SUMCYCLES1 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) SUMPRODCOUNT1 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Total downtime Textbox36 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(SUM(Fields!SUMTimeDT.Value)<0,"-","") & ABS(SUM(Fields!SUMTimeDT.Value)) \ 3600 & ":" & (ABS(SUM(Fields!SUMTimeDT.Value)) MOD 3600)\60 & ":" & (ABS(SUM(Fields!SUMTimeDT.Value)) MOD 60) Textbox38 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(SUM(Fields!SUMTimeDT.Value)<0,"-","") & Str(Round((ABS(SUM(Fields!SUMTimeDT.Value))*100)/(Fields!SUMSUMTime.Value)))+"%" Textbox39 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox40 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox41 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox19 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUMTime.Value) Mod 60) SUMSUMTime2 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox221 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) SUMCYCLES1 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) PRODCOUNT1 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox87 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(Sum(Fields!SUMTimeDT.Value) < 0, "-", "") & ABS(Sum(Fields!SUMTimeDT.Value)) \ 3600 & ":" & (ABS(Sum(Fields!SUMTimeDT.Value)) Mod 3600) \ 60 & ":" & (ABS(Sum(Fields!SUMTimeDT.Value)) Mod 60) Textbox38 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox222 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox90 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox91 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox96 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUMTime.Value) Mod 60) SUMSUMTime2 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox223 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) SUMCYCLES1 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) PRODCOUNT1 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox110 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(Sum(Fields!SUMTimeDT.Value) < 0, "-", "") & ABS(Sum(Fields!SUMTimeDT.Value)) \ 3600 & ":" & (ABS(Sum(Fields!SUMTimeDT.Value)) Mod 3600) \ 60 & ":" & (ABS(Sum(Fields!SUMTimeDT.Value)) Mod 60) Textbox38 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox224 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox90 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox91 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 4.70636cm true =Fields!SHIFTSYSTEMNAME.Value SHIFTSYSTEMNAMEGROUP DataSet1 true Shiftsystem #333333 Middle 2pt 2pt 2pt 2pt 4.40402cm true =Fields!SHIFTNAME.Value SHIFTNAMEGROUP DataSet1 true Shift #333333 Middle 2pt 2pt 2pt 2pt After true =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value 4.70636cm true true =Fields!SHIFTSYSTEMNAME.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =Fields!SHIFTNAME.Value Between =Fields!SHIFTNAME.Value 4.40402cm true true =Fields!SHIFTNAME.Value WhiteSmoke 2pt 2pt 2pt 2pt =(Parameters!UNFOLDALL.Value = "false") PeriodeCH =(Parameters!UNFOLDALL.Value = "false") ShiftCH 4.40402cm true true Total for Shiftsystem Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 4.40402cm true true Total downtime Textbox36 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before ShiftSystemCH 4.70636cm true true REPORT TOTAL Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 4.40402cm true true Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 4.70636cm true true DOWNTIME TOTAL Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 4.40402cm true true Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before true DataSet1 32.0069cm 0.16002cm 6.14937cm 27.75428cm 3 ListaMegnyitás1 Black 1pt Black 1pt Black 1pt Black 1pt true true Shift system: 2pt 2pt 2pt 2pt true true Shift: 2pt 2pt 2pt 2pt true true Start of shift: 2pt 2pt 2pt 2pt true true -- 2pt 2pt 2pt 2pt true true =Parameters!STARTTo.Value 2pt 2pt 2pt 2pt true true Click here to display / hide charts! 2pt 2pt 2pt 2pt true true Click here to display / hide report! 2pt 2pt 2pt 2pt true true Click here to display / hide report with browse functionality! 2pt 2pt 2pt 2pt true true Unfoldall: 2pt 2pt 2pt 2pt true true =Parameters!SQLTEXT.Value 2pt 2pt 2pt 2pt true true Click here to display / hide SQLTEXT! 2pt 2pt 2pt 2pt true true Site: 2pt 2pt 2pt 2pt 422.8078mm WhiteSmoke 281.69842mm 13.95853mm true true true true Shift-time utilization report (by shifts) Title ReportTitle 1.5875mm 10.16mm 279.1433mm 2pt 2pt 2pt 2pt WhiteSmoke 8.25492mm true true true true Time of execution of report: ExecutionTime 1.90492mm 1.6002mm 6.35mm 82.93108mm 2pt 2pt 2pt 2pt true true Page number: PageNumber 1.90492mm 86.61193mm 6mm 58.44154mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 1.90492mm 152.94383mm 6mm 25mm 2 2pt 2pt 2pt 2pt true true / 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 UNFOLDALL String true true SQLTEXT String true true SITENAME Cm ca7aa9be-65e4-4d1c-8177-0ccdfbc36420