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!AssemblyLineId.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 MachineId System.String DTRidandname System.String SUMTime System.Int64 SUMSUMTime System.Int64 MINTime System.Int64 MAXTime System.Int64 MachineName true PeriodeTypeName true SUMTimeDT true 5.94249cm 1.04619cm 2.60231cm 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.93501cm true true Műszakrend #333333 Middle 2pt 2pt 2pt 2pt 1.77757cm true true Műszak #333333 Middle 2pt 2pt 2pt 2pt 5.80911cm true =Sum(Fields!SUMTimeDT.Value) AssemblyLine true Szerelősor #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.93501cm 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!AssemblyLineId.Value Csoport3 5.80911cm true true =Fields!AssemblyLineId.Value + " ( " & Fields!MACHINENAME.Value + " )" Black 1pt Black 1pt Black 1pt Black 1pt 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") CHSzerelősor 9.11395cm true true Összesen műszak műszak-idő: 1pt 1pt 1pt 1pt LightGrey 2pt 2pt 2pt 2pt 9.11395cm true true Összesen műszak állásidő: LightGrey 2pt 2pt 2pt 2pt =(Parameters!UNFOLDALL.Value="false") CHMűszak 10.89152cm true true Összesen műszakrend műszak-idő: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 10.89152cm 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 37.4379cm 0.19162cm 6.74937cm 27.7828cm 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 Szerelősor: 2pt 2pt 2pt 2pt true true Kattintson ide a tételes lista megjelenítéséhez! 2pt 2pt 2pt 2pt true true Kattintson ide a keresgélős lista megjelenítéséhez! 2pt 2pt 2pt 2pt 12.92867cm 3.71352cm 3.71352cm 3.71352cm 3.71352cm 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!AssemblyLineId.Value + " ( " + Fields!MACHINENAME.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!AssemblyLineId.Value =Fields!AssemblyLineId.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value After =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =(Parameters!UNFOLDALL.Value="false") SHIFTSYSTEMNAME =(Parameters!UNFOLDALL.Value="false") AssemblyLineId1 =(Parameters!UNFOLDALL.Value="false") DTR true DataSet1 Start =Fields!PERIODETYPE.Value NotEqual Production =Fields!PERIODETYPE.Value NotEqual Breaktime 41.85268cm 0.19162cm 4.27028cm 27.78275cm 9 true Lista2Megnyitas =Fields!PERIODETYPE.Value =Sum(Fields!SUMTime.Value) Descending =Fields!PERIODETYPE.Value SUMTime =Round(Sum(Fields!SUMTime.Value)/3600,2) #VALY{N1} hours\n(#PERCENT{P1}) true Periódus típusok 1 False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Idő (óra) True 0.5 NaN true NaN NaN Axis Title 0.5 NaN Opposite NaN NaN LeftTop Column Default true Black Black Műszak-idő kihasználás grafikon BrightPastel No Data Available DataSet1 6.58801cm 0.19162cm 11.97879cm 27.78277cm 10 Grafikon1Megnyitás WhiteSmoke None true true Kattintson ide a műszak-idő felhasználás grafikon megjelenítéséhez / eltüntetéséhez! 2pt 2pt 2pt 2pt =Fields!PERIODETYPE.Value =Fields!PERIODETYPE.Value =Fields!DTR.Value =Sum(Fields!SUMTime.Value) Descending =Fields!DTR.Value =Fields!PERIODETYPE.Value SUMTime =Round(Sum(Fields!SUMTime.Value) / 3600, 2) #VALY{N1} hours\n(#PERCENT{P1}) true Állásidő okok 1 False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Idő (óra) True 0.5 NaN true NaN NaN 2 Axis Title 0.5 NaN Opposite NaN NaN Állásidő eloszlás állásidő okonként BrightPastel No Data Available DataSet1 =Fields!PERIODETYPENUM.Value Equal =3 19.96027cm 0.1916cm 16.79977cm 27.78279cm 12 Grafikon2Megnyitás WhiteSmoke None true true Kattintson ide az állásidő eloszlás grafikon megjelenítéséhez / eltüntetéséhez! 2pt 2pt 2pt 2pt 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 461.2296mm WhiteSmoke 281.71169mm 23.48353mm true true true true Műszak-idő felhasználás és Állásidő lekérdezés (szerelősorra 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 Other Key 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