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!TeamIdList.Value true =Parameters!STARTFrom.Value true =Parameters!STARTTo.Value true =Parameters!PERIODETYPE.Value true =Parameters!DTR.Value true =Parameters!ENDFrom.Value true =Parameters!ENDTo.Value true SELECT Periods.SHIFTSYSTEMNAME, Periods.SHIFTNAME ,Periods.MachineId,Periods.MachineName ,Periods.PeriodeTypeNum,dbo.PeriodTypeName(Periods.PeriodeTypeNum,'@LCID@') AS PeriodeTypeName ,Periods.DTRidandname ,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 ,MIN(Periods.[LENGTH]) AS MINTime, MAX(Periods.[LENGTH]) AS MAXTime ,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 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, Periods.DTRidandname true SHIFTSYSTEMNAME System.String SHIFTNAME System.String PeriodeTypeNum System.Int32 Count System.Int32 TEAMID System.String DTRidandname System.String SUMTime System.Int32 SUMSUMTime System.Int32 MINTime System.Int32 MAXTime System.Int32 TEAMNAME true PeriodeTypeName true SUMTimeDT true SUMProdCount System.Int32 SUMCycles System.Int32 TEAMINFO true 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 Team: 2pt 2pt 2pt 2pt true true Click here to display report (grouping: Shift -> Team -> DTR)! 2pt 2pt 2pt 2pt true true Click here to display report (grouping: DTR -> Team -> Shift) with browse functions! 15.18091cm 0.25943cm 0.6cm 27.8384cm 7 2pt 2pt 2pt 2pt 5.94806cm 0.85684cm 4.75899cm 1.38874cm 1.61569cm 1.37756cm 1.94937cm true =Fields!SUMTime.Value true DTR code #333333 Middle 2pt 2pt 2pt 2pt true =Fields!Count.Value true PCS Textbox38 #333333 Middle 2pt 2pt 2pt 2pt true true Time Textbox5 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Ratio Textbox16 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Min Textbox4 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Max Textbox20 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!DTR.Value DTR1 WhiteSmoke 2pt 2pt 2pt 2pt true true =Fields!Count.Value Count1 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) & " (" & Fields!SUMTime.Value \ 60 & " min)" 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!MINTime.Value) \ 3600 & ":" & ((Fields!MINTime.Value) MOD 3600)\60 & ":" & ((Fields!MINTime.Value) MOD 60) MINTime2 Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt true true =(Fields!MAXTime.Value) \ 3600 & ":" & ((Fields!MAXTime.Value) MOD 3600)\60 & ":" & ((Fields!MAXTime.Value) MOD 60) MAXTime2 Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt 0.6cm true true Total for this periode Textbox54 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Textbox55 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(SUM(Fields!SUMTimeDT.Value)<0,"-","") & SUM(Fields!SUMTime.Value) \ 3600 & ":" & (SUM(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!SUMTime.Value) MOD 60) & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox18 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =Str(Round((SUM(Fields!SUMTime.Value)*100)/(Fields!SUMSUMTime.Value)))+"%" Textbox57 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 Textbox61 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true (for team) Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox21 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) & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox18 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true 100% Textbox24 Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox26 Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox28 Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true (for team) Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox23 LightGrey 2pt 2pt 2pt 2pt true true =IIF(ABS(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) & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox242 LightGrey 2pt 2pt 2pt 2pt true true =IIF(Fields!SUMTimeDT.Value<0,"-","") & Str(Round((ABS(SUM(Fields!SUMTimeDT.Value))*100)/(Fields!SUMSUMTime.Value)))+"%" Textbox30 Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox31 Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox32 LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox51 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox43 1pt 1pt 1pt 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) & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox18 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox25 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox15 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox6 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox37 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox39 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(ABS(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) & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox242 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(Fields!SUMTimeDT.Value < 0, "-", "") & Str(Round((ABS(Sum(Fields!SUMTimeDT.Value)) * 100) / Fields!SUMSUMTime.Value)) + "%" Textbox30 Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox48 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox49 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox52 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox154 1pt 1pt 1pt 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) & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox18 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox156 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox157 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox158 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox66 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox69 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(ABS(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) & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox242 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox196 Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox72 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox73 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox100 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox101 1pt 1pt 1pt 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) & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox18 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox104 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox105 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox106 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox80 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox81 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(ABS(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) & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox242 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox83 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox84 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox87 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 1.62882cm true true Shift system CHShiftSystem #333333 Middle 2pt 2pt 2pt 2pt 1.78314cm true true Shift #333333 Middle 2pt 2pt 2pt 2pt 5.17026cm true =Sum(Fields!SUMTimeDT.Value) Team true Team #333333 Middle 2pt 2pt 2pt 2pt 3.31041cm true =Sum(Fields!SUMTime.Value) PeriodeType true Period type #333333 Middle 2pt 2pt 2pt 2pt After true =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value 1.62882cm 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.78314cm true true =Fields!SHIFTNAME.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =Fields!TEAMID.Value =Fields!TEAMNAME.Value 5.17026cm true true =Fields!TEAMINFO.Value WhiteSmoke 2pt 2pt 2pt 2pt =Fields!PERIODETYPE.Value =Fields!SUMTime.Value 3.31041cm true true =Fields!PERIODETYPE.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =IIF((CountRows("PeriodeType") = 1) or (Parameters!UNFOLDALL.Value="false"), True,False) CHDTR Before =IIF((CountRows("Team") = 1) or (Parameters!UNFOLDALL.Value="false"), True,False) CHPeriods 3.31041cm true true Total prod.time Textbox50 LightGrey 2pt 2pt 2pt 2pt Before 3.31041cm true true Total downtime Textbox8 LightGrey 2pt 2pt 2pt 2pt Before =(Parameters!UNFOLDALL.Value="false") CHTeam 8.48067cm true true Total production time (for shift): 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt 8.48067cm true true Total downtime (for shift): LightGrey 2pt 2pt 2pt 2pt =(Parameters!UNFOLDALL.Value="false") CHShift 10.26381cm true true Total production time (for shift system): Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 10.26381cm true true Total downtime (for shift system): Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before CHShiftSystem 11.89263cm true true TOTAL PRODUCTION TIME (FOR REPORT) Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 11.89263cm true true TOTAL DOWNTTIME (FOR REPORT) Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before true DataSet1 =Fields!PERIODETYPE.Value NotEqual Production =Fields!PERIODETYPE.Value NotEqual Breaktime 6.87876cm 0.25938cm 7.94937cm 27.83851cm 8 Lista1Megnyitas Black 1pt Black 1pt Black 1pt Black 1pt 12.93981cm 3.72466cm 5.10227cm 2.77216cm 3.2996cm 1.27028cm true true Downtime grouped by DTR code then Team (Open the blocks for detail!) Textbox27 #384c70 Middle 2pt 2pt 2pt 2pt true true Number of occurences Textbox12 #384c70 Middle 2pt 2pt 2pt 2pt true true Total time Textbox13 #384c70 Middle 2pt 2pt 2pt 2pt true true Min length Textbox19 #384c70 Middle 2pt 2pt 2pt 2pt true true Max length Textbox22 #384c70 Middle 2pt 2pt 2pt 2pt 0.6cm true true =IIF(Fields!DTR.Value = "","No DTR code specified",Fields!DTR.Value ) #949a7e 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Textbox59 #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 & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox60 #949a7e 2pt 2pt 2pt 2pt true true Textbox92 #949a7e 2pt 2pt 2pt 2pt true true Textbox93 #949a7e 2pt 2pt 2pt 2pt 0.6cm true true =Fields!TEAMINFO.Value 1 #aab292 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Textbox67 #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 & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox68 #aab292 2pt 2pt 2pt 2pt true true Textbox94 #aab292 2pt 2pt 2pt 2pt true true Textbox95 #aab292 2pt 2pt 2pt 2pt 0.6cm true true =Fields!SHIFTSYSTEMNAME.Value 2 #b8c09e 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Textbox74 #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 & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox75 #b8c09e 2pt 2pt 2pt 2pt true true Textbox96 #b8c09e 2pt 2pt 2pt 2pt true true Textbox97 #b8c09e 2pt 2pt 2pt 2pt 0.6cm true true =Fields!SHIFTNAME.Value 3 #b8c09e 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Count WhiteSmoke 2pt 2pt 2pt 2pt true true =Fields!SUMTime.Value \ 3600 & ":" & (Fields!SUMTime.Value MOD 3600)\60 & ":" & Fields!SUMTime.Value MOD 60 & " (" & (Fields!SUMTime.Value) \ 60 & " min)" SUMTime WhiteSmoke 2pt 2pt 2pt 2pt true true =SUM(Fields!MINTime.Value) \ 3600 & ":" & (SUM(Fields!MINTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!MINTime.Value) MOD 60) MINTime WhiteSmoke 2pt 2pt 2pt 2pt true true =SUM(Fields!MAXTime.Value) \ 3600 & ":" & (SUM(Fields!MAXTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!MAXTime.Value) MOD 60) MAXTime WhiteSmoke 2pt 2pt 2pt 2pt 0.6cm true true Total #728586 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Textbox42 #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 & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox44 #728586 2pt 2pt 2pt 2pt true true Textbox98 #728586 2pt 2pt 2pt 2pt true true Textbox99 #728586 2pt 2pt 2pt 2pt =Fields!DTR.Value =Fields!DTR.Value =Fields!TEAMID.Value =Fields!TEAMID.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value After =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =(Parameters!UNFOLDALL.Value="false") SHIFTSYSTEMNAME =(Parameters!UNFOLDALL.Value="false") TeamId1 =(Parameters!UNFOLDALL.Value="false") DTR true DataSet1 =Fields!PERIODETYPE.Value NotEqual Production =Fields!PERIODETYPE.Value NotEqual Breaktime 15.84413cm 0.25938cm 4.27028cm 27.8385cm 9 true Lista2Megnyitas 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 true true Click here to display report (grouping: Team -> DTR -> Shift) with browse functions! 20.46719cm 0.25943cm 0.6cm 27.8384cm 13 2pt 2pt 2pt 2pt 12.93981cm 3.72466cm 5.1134cm 2.76104cm 3.2996cm 1.27028cm true true Downtime grouped by Team then DTR code (Open the blocks for detail!) Textbox27 #384c70 Middle 2pt 2pt 2pt 2pt true true Number of occurences Textbox12 #384c70 Middle 2pt 2pt 2pt 2pt true true Total time Textbox13 #384c70 Middle 2pt 2pt 2pt 2pt true true Min length Textbox19 #384c70 Middle 2pt 2pt 2pt 2pt true true Max length Textbox22 #384c70 Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!TEAMINFO.Value #949a7e 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Textbox59 #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 & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox60 #949a7e 2pt 2pt 2pt 2pt true true Textbox92 #949a7e 2pt 2pt 2pt 2pt true true Textbox93 #949a7e 2pt 2pt 2pt 2pt 0.6cm true true =IIF(Fields!DTR.Value = "", "No DTR code specified", Fields!DTR.Value) 1 #aab292 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Textbox67 #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 & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox68 #aab292 2pt 2pt 2pt 2pt true true Textbox94 #aab292 2pt 2pt 2pt 2pt true true Textbox95 #aab292 2pt 2pt 2pt 2pt 0.6cm true true =Fields!SHIFTSYSTEMNAME.Value 2 #b8c09e 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Textbox74 #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 & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox75 #b8c09e 2pt 2pt 2pt 2pt true true Textbox96 #b8c09e 2pt 2pt 2pt 2pt true true Textbox97 #b8c09e 2pt 2pt 2pt 2pt 0.6cm true true =Fields!SHIFTNAME.Value 3 #b8c09e 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Count WhiteSmoke 2pt 2pt 2pt 2pt true true =Fields!SUMTime.Value \ 3600 & ":" & (Fields!SUMTime.Value Mod 3600) \ 60 & ":" & Fields!SUMTime.Value Mod 60 & " (" & (Fields!SUMTime.Value) \ 60 & " min)" SUMTime WhiteSmoke 2pt 2pt 2pt 2pt true true =Sum(Fields!MINTime.Value) \ 3600 & ":" & (Sum(Fields!MINTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!MINTime.Value) Mod 60) MINTime WhiteSmoke 2pt 2pt 2pt 2pt true true =Sum(Fields!MAXTime.Value) \ 3600 & ":" & (Sum(Fields!MAXTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!MAXTime.Value) Mod 60) MAXTime WhiteSmoke 2pt 2pt 2pt 2pt 0.6cm true true Total #728586 2pt 2pt 2pt 2pt true true =Sum(Fields!Count.Value) Textbox42 #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 & " (" & Sum(Fields!SUMTime.Value) \ 60 & " min)" Textbox44 #728586 2pt 2pt 2pt 2pt true true Textbox98 #728586 2pt 2pt 2pt 2pt true true Textbox99 #728586 2pt 2pt 2pt 2pt =Fields!TEAMID.Value =Fields!TEAMID.Value =Fields!DTR.Value =Fields!DTR.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value After =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =(Parameters!UNFOLDALL.Value = "false") SHIFTSYSTEMNAME2 =(Parameters!UNFOLDALL.Value = "false") DTR3 =(Parameters!UNFOLDALL.Value = "false") TeamId3 true DataSet1 =Fields!PERIODETYPE.Value NotEqual Production =Fields!PERIODETYPE.Value NotEqual Breaktime 21.12477cm 0.25938cm 4.27028cm 27.83851cm 14 true Lista2Megnyitas2 254.47971mm WhiteSmoke 284.89741mm 20.57312mm true true true true Shift-time utilization and Downtime report (detailed per team per downtime reason) Title ReportTitle 1.41728mm 0.25938cm 18.89125mm 278.38473mm 2pt 2pt 2pt 2pt WhiteSmoke 9.525mm true true true true Execution time : ExecutionTime 3.175mm 2.59377mm 6.35mm 69.70191mm 2pt 2pt 2pt 2pt true true Number of pages: PageNumber 3.175mm 78.87425mm 6mm 60.82279mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 3.175mm 147.58741mm 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 TeamIdList String true true PERIODETYPE String true true DTR String true true ENDFrom String true true ENDTo String UNFOLDALL String true true SQLTEXT String SITENAME Cm ca7aa9be-65e4-4d1c-8177-0ccdfbc36420