0 SQL Data Source=.\SQLExpress;Initial Catalog=LearALM Set the username and password for the following datasource: DataSource1. Windows 0b0b2666-4897-46e3-900b-847e2efc8416 DataSource1 =Parameters!SHIFTSYSTEMNAME.Value true =Parameters!SHIFTNAME.Value true =Parameters!AssemblyLineId.Value true =Parameters!STARTFrom.Value true =Parameters!STARTTo.Value true SELECT Periods.SHIFTSYSTEMNAME,Periods.SHIFTNAME ,Periods.MachineId,Periods.MachineName ,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 ,P11.MachineId AS _MachineId ,SUM(P11.[LENGTH]) AS SUMSUMTime FROM Reports_Periods2 AS P11 WHERE 1=1 GROUP BY P11.SHIFTSYSTEMNAME, P11.SHIFTNAME, P11.MachineId) AS P1 ON P1._SHIFTSYSTEMNAME = Periods.SHIFTSYSTEMNAME AND P1._SHIFTNAME = Periods.SHIFTNAME AND P1._MachineId = Periods.MachineId WHERE (1=1) AND Periods.SHIFTSYSTEMNAME IS NOT NULL GROUP BY Periods.SHIFTSYSTEMNAME,Periods.SHIFTNAME,Periods.MachineId,Periods.MachineName,P1.SUMSUMTime, Periods.PeriodeTypeNum true SHIFTSYSTEMNAME System.String SHIFTNAME System.String PeriodeTypeNum System.Int32 Count System.Int32 MachineId System.String SUMTime System.Int32 SUMSUMTime System.Int32 MachineName true SUMProdCount true SUMCycles true PeriodeTypeName true SUMTimeDT true 15.63961cm 3.47971cm 3.2588cm 2.40382cm 2.91247cm 0.62489cm true true Open/Close 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.62489cm true true =Fields!SHIFTSYSTEMNAME.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.62489cm true true =Fields!SHIFTNAME.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 #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.62489cm true true =Fields!AssemblyLineId.Value + " ( " + Fields![MACHINENAME].Value + " )" 2 #b8c09e 2pt 2pt 2pt 2pt true true =SUM(Fields!SUMTime.Value) \ 3600 & ":" & (SUM(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!SUMTime.Value) MOD 60) #b8c09e 2pt 2pt 2pt 2pt true true 100% #b8c09e 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) #b8c09e 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) #b8c09e 2pt 2pt 2pt 2pt 0.62489cm true true =Fields!PERIODETYPE.Value 3 #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 =Sum(Fields!SUMPRODCOUNT.Value) 2pt 2pt 2pt 2pt 0.62489cm 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 =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 =Sum(Fields!SUMCYCLES.Value) #728586 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) #728586 2pt 2pt 2pt 2pt =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =Fields!AssemblyLineId.Value =Fields!AssemblyLineId.Value After =Fields!PERIODETYPE.Value =Fields!PERIODETYPE.Value =(Parameters!UNFOLDALL.Value="false") OPENCLOSE =(Parameters!UNFOLDALL.Value="false") SHIFTNAME1 =(Parameters!UNFOLDALL.Value="false") SHIFTSYSTEMNAME1 true DataSet1 39.4752cm 0.46075cm 3.74934cm 27.69441cm ListaMegnyitás2 =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTNAME.Value =Fields!AssemblyLineId.Value =Fields!PERIODETYPE.Value =Sum(Fields!SUMTime.Value) Shiftsystem > Shift > Assembly line 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 Default true Black Black Shift-time distribution on different periode types (in %) BrightPastel No Data Available DataSet1 7.4374cm 0.38728cm 11.89641cm 27.7679cm 1 ÁbraMegnyitás1 WhiteSmoke None =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTNAME.Value =Fields!AssemblyLineId.Value =Fields!PERIODETYPE.Value =CLng(Sum(Fields!SUMTime.Value))/3600 Shiftsystem > Shift > Assembly line False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Usage time (hours) 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN TopCenter true Black Black Shift-time distribution on different periode types (absolut time) BrightPastel No Data Available DataSet1 19.40437cm 0.38728cm 10.89833cm 27.7679cm 2 ÁbraMegnyitás1 WhiteSmoke None 5.74125cm 3.53289cm 3.31198cm 2.457cm 2.96565cm 1.94937cm true true Periode type #333333 Middle 2pt 2pt 2pt 2pt true true Time #333333 Middle 2pt 2pt 2pt 2pt true true Ratio Textbox16 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Boards Textbox14 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Harnesses Textbox22 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!PERIODETYPE.Value Textbox5 Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt true true =IIF(Fields!SUMTimeDT.Value<0,"-","" ) & Fields!SUMTime.Value \ 3600 & ":" & (Fields!SUMTime.Value MOD 3600)\60 & ":" & (Fields!SUMTime.Value) MOD 60 SUMTime2 Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt true true =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 assembly line: Textbox8 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) Textbox23 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true 100% Textbox24 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) Textbox18 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) Textbox27 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Total downtime for assembly line: Textbox26 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) Textbox33 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Str(Round((SUM(Fields!SUMTimeDT.Value)*100)/(Fields!SUMSUMTime.Value)))+"%" Textbox41 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox43 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox44 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox13 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) Textbox19 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox20 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) Textbox21 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) Textbox28 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox49 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) Textbox33 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Str(Round((SUM(Fields!SUMTimeDT.Value)*100)/(Fields!SUMSUMTime.Value)))+"%" Textbox52 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox53 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox55 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox56 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) Textbox19 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox58 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) Textbox21 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) Textbox28 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox70 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) Textbox33 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox72 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox73 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox74 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox86 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) Textbox19 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox88 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMCYCLES.Value) Textbox21 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!SUMPRODCOUNT.Value) Textbox28 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox78 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) Textbox33 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox80 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox81 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox82 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 2.57295cm true true Shiftsystem #333333 Middle 2pt 2pt 2pt 2pt 1.62206cm true true Shift #333333 Middle 2pt 2pt 2pt 2pt 5.49065cm true true Assembly line #333333 Middle 2pt 2pt 2pt 2pt After true =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value 2.57295cm true true =Fields!SHIFTSYSTEMNAME.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value 1.62206cm true true =Fields!SHIFTNAME.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =Fields!AssemblyLineId.Value =Fields!AssemblyLineId.Value 5.49065cm true true =Fields!AssemblyLineId.Value + " ( " & Fields![MACHINENAME].Value + " )" Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =(Parameters!UNFOLDALL.Value="false") PERIODTYPE_columnheader =(Parameters!UNFOLDALL.Value="false") ASSLINE_ColumnHeader 5.49065cm true true Total for shift: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 5.49065cm true true Total downtime for shift: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before =(Parameters!UNFOLDALL.Value="false") SHIFT_columnheader 7.11271cm true true Total for Shiftsystem Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 7.11271cm true true Total downtime for shift system Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before SHIFTSYSTEM_columnheader 9.68566cm true true TOTAL REPORT Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 9.68566cm true true TOTAL DOWNTIME FOR REPORT Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before true true DataSet1 31.07909cm 0.46075cm 7.34937cm 27.69443cm 3 ListaMegnyitás1 Black 1pt Black 1pt Black 1pt Black 1pt true true Shiftsystem: 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 Assembly line: 2pt 2pt 2pt 2pt true true Click here to display / hide complete totalled report! 2pt 2pt 2pt 2pt true true Click here to display / hide report with browse functionality! 2pt 2pt 2pt 2pt true true Click here to display / hide charts! 2pt 2pt 2pt 2pt 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 432.2454mm WhiteSmoke 283.99276mm 13.95853mm true true true true Shift-time utilization report (by shift, then by assembly line) Title ReportTitle 1.5875mm 0.2008cm 10.16mm 279.27925mm WhiteSmoke 2pt 2pt 2pt 2pt WhiteSmoke 7.0452mm true true true true Execution time of report: ExecutionTime 0mm 3.60821mm 6.35mm 77.90399mm 2pt 2pt 2pt 2pt true true Page numbers: PageNumber 0mm 82.26994mm 6mm 58.44154mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 0mm 145.42684mm 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 Other Key String UNFOLDALL String true true SQLTEXT String true true SITENAME Cm ca7aa9be-65e4-4d1c-8177-0ccdfbc36420