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 =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 SHIFTSYSTEMNAME, SHIFTNAME, AssemblyLineId, ProductionLines.Name AS MACHINENAME, PERIODETYPE, Periods.DTR + ' - ' + DownTimeReasons.Name AS DTR, Count(DTR) AS [Count], SUM([LENGTH]) AS SUMTime, MIN([LENGTH]) AS MINTime, MAX([LENGTH]) AS MAXTime, (SELECT SUM([LENGTH]) AS SUMTime FROM Periods AS P1 WHERE P1.SHIFTSYSTEMNAME = Periods.SHIFTSYSTEMNAME AND P1.SHIFTNAME = Periods.SHIFTNAME AND P1.AssemblyLineId = Periods.AssemblyLineId) AS SUMSUMTime FROM Periods LEFT JOIN DownTimeReasons ON Periods.DTR = DownTimeReasons.Code INNER JOIN ProductionLines ON Periods.AssemblyLineId = ProductionLines.[Key] WHERE 1=1 GROUP BY SHIFTSYSTEMNAME, SHIFTNAME, AssemblyLineId, ProductionLines.Name , PERIODETYPE, Periods.DTR + ' - ' + DownTimeReasons.Name HAVING SHIFTSYSTEMNAME IS NOT NULL ORDER BY SHIFTSYSTEMNAME ASC, SHIFTNAME ASC, AssemblyLineId ASC, PERIODETYPE ASC, DTR ASC true SHIFTSYSTEMNAME System.String SHIFTNAME System.String PeriodeTypeNum System.String Count System.Int32 TEAMID System.String DTRidandname System.String SUMTime System.Int64 SUMSUMTime System.Int64 MINTime System.Int64 MAXTime System.Int64 TEAMNAME true PeriodeTypeName true SUMTimeDT true TEAMINFO true 5.94249cm 0.74025cm 3.63424cm 1.38317cm 1.61012cm 1.37199cm 1.94937cm true =Fields!SUMTime.Value true Állásidő kód #333333 Middle 2pt 2pt 2pt 2pt true =Fields!Count.Value true DB 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 Black 1pt Black 1pt Black 1pt Black 1pt 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) 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 Periódus összesen 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) 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 szerelősor műszak-idő: 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) 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 szerelősor állásidő: 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) 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 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) 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) 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) 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) 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 Textbox72 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox73 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt 2.62808cm true true Műszak-rend #333333 Middle 2pt 2pt 2pt 2pt 1.77757cm true true Műszak #333333 Middle 2pt 2pt 2pt 2pt 5.39cm true =Sum(Fields!SUMTimeDT.Value) Team true Csapat #333333 Middle 2pt 2pt 2pt 2pt 3.30484cm true =Sum(Fields!SUMTime.Value) PeriodeType true Periódus típusa #333333 Middle 2pt 2pt 2pt 2pt After true =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value 2.62808cm 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.77757cm true true =Fields!SHIFTNAME.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =Fields!TEAMID.Value =Fields!TEAMID.Value 5.39cm true true =Fields!TEAMINFO.Value WhiteSmoke 2pt 2pt 2pt 2pt =Fields!PERIODETYPE.Value =Fields!SUMTime.Value 3.30484cm true true =Fields!PERIODETYPE.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =Fields!SUMTime.Value Descending =IIF((CountRows("PeriodeType") = 1) or (Parameters!UNFOLDALL.Value="false"), True,False) CHÁllásidő Before =(Parameters!UNFOLDALL.Value="false") CHPeriódus 3.30484cm true true Összesen Textbox50 LightGrey 2pt 2pt 2pt 2pt Before 3.30484cm true true Összesen Textbox8 LightGrey 2pt 2pt 2pt 2pt Before =(Parameters!UNFOLDALL.Value="false") CHTeam 8.69484cm true true Összesen műszak műszak-idő: 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt 8.69484cm true true Összesen műszak állásidő: LightGrey 2pt 2pt 2pt 2pt =(Parameters!UNFOLDALL.Value="false") CHMűszak 10.47241cm true true Összesen műszakrend műszak-idő: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 10.47241cm true true Összesen műszakrend állásidő: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before CHMuszakrend true DataSet1 Start =Fields!PERIODETYPE.Value NotEqual Production =Fields!PERIODETYPE.Value NotEqual Breaktime 6.985cm 0.19162cm 6.74937cm 27.78275cm Lista1Megnyitas Black 1pt Black 1pt Black 1pt Black 1pt true true Műszakrend: 2pt 2pt 2pt 2pt true true Műszak: 2pt 2pt 2pt 2pt true true Műszak kezdete: 2pt 2pt 2pt 2pt true true -- 2pt 2pt 2pt 2pt true true =Parameters!STARTTo.Value 2pt 2pt 2pt 2pt true true Csapat: 2pt 2pt 2pt 2pt true true Kattintson ide a tételes lista (csoportosítás: műszak -> csapat -> állásidő kód) megjelenítéséhez! 2pt 2pt 2pt 2pt true true Kattintson ide a keresgélős lista (csoportosítás: állásidő kód -> csapat -> műszak) megjelenítéséhez! 2pt 2pt 2pt 2pt 12.92867cm 3.71352cm 5.74335cm 2.53041cm 2.86685cm 1.27028cm true true Nyissa meg a részletekért! Textbox27 #384c70 Middle 2pt 2pt 2pt 2pt true true Hányszor fordult elő Textbox12 #384c70 Middle 2pt 2pt 2pt 2pt true true Időtartam Textbox13 #384c70 Middle 2pt 2pt 2pt 2pt true true Min hossz Textbox19 #384c70 Middle 2pt 2pt 2pt 2pt true true Max hossz Textbox22 #384c70 Middle 2pt 2pt 2pt 2pt 0.6cm true true =IIF(Fields!DTR.Value = "","Nem adtak meg kódot",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 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 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 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 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 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 Start =Fields!PERIODETYPE.Value NotEqual Production =Fields!PERIODETYPE.Value NotEqual Breaktime 14.86518cm 0.19162cm 4.27028cm 27.7828cm 9 true Lista2Megnyitas 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 true true Kattintson ide a keresgélős lista (csoportosítás: csapat -> állásidő kód -> műszak) megjelenítéséhez! 19.50394cm 0.19165cm 0.6cm 27.78272cm 13 2pt 2pt 2pt 2pt 12.93981cm 3.72466cm 5.74642cm 2.53041cm 2.8668cm 1.27028cm true true Nyissa meg a részletekért! Textbox27 #384c70 Middle 2pt 2pt 2pt 2pt true true Number of occurences Textbox12 #384c70 Middle 2pt 2pt 2pt 2pt true true Időtartam Textbox13 #384c70 Middle 2pt 2pt 2pt 2pt true true Min hossz Textbox19 #384c70 Middle 2pt 2pt 2pt 2pt true true Max hossz 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 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 = "", "Nem adtak meg kódot", 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 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 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 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 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 20.31145cm 0.16627cm 4.27028cm 27.8081cm 14 true Lista2Megnyitas2 245.81731mm WhiteSmoke 281.47938mm 23.48353mm true true true true Műszak-idő felhasználás és Állásidő lekérdezés (teamre majd állásidő okra részletezve) Title ReportTitle 1.5875mm 0.3491cm 20.13215mm 276.25287mm 2pt 2pt 2pt 2pt WhiteSmoke 14.60491mm true true true true Riport futási idő : ExecutionTime 5.07987mm 1.91616mm 6.35mm 69.70191mm 2pt 2pt 2pt 2pt true true Lapok száma: PageNumber 5.07987mm 182.97164mm 6mm 60.82279mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 5.07987mm 251.68479mm 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 SQLTEXT String true true SITENAME Cm ca7aa9be-65e4-4d1c-8177-0ccdfbc36420