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 SELECT SHIFTSYSTEMNAME, SHIFTNAME, AssemblyLineId, PERIODETYPE, Count(PERIODETYPE) AS [Count], SUM([LENGTH]) AS SUMTime, ( 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 WHERE 1=1 GROUP BY SHIFTSYSTEMNAME, SHIFTNAME, AssemblyLineId, PERIODETYPE HAVING SHIFTSYSTEMNAME IS NOT NULL ORDER BY SHIFTSYSTEMNAME ASC, SHIFTNAME ASC, AssemblyLineId ASC, PERIODETYPE ASC true SHIFTSYSTEMNAME System.String SHIFTNAME System.String PeriodeTypeNum System.String Count System.Int32 MachineId System.String SUMTime System.Int64 SUMSUMTime System.Int64 MachineName true SUMProdCount true SUMCycles true PeriodeTypeName true SUMTimeDT true 16.07988cm 2.66691cm 3.2174cm 3.05034cm 2.67992cm 0.62489cm true true Nyissa ki a részletekért! #384c70 2pt 2pt 2pt 2pt true true Idő #384c70 2pt 2pt 2pt 2pt true true Arány #384c70 2pt 2pt 2pt 2pt true true Táblák #384c70 2pt 2pt 2pt 2pt true true Korbácsok #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 =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") AssemblyLineId1 =(Parameters!UNFOLDALL.Value="false") SHIFTNAME1 =(Parameters!UNFOLDALL.Value="false") SHIFTSYSTEMNAME1 true DataSet1 Start 39.44222cm 0.25931cm 3.74934cm 27.69445cm true ListaMegnyitás2 =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTNAME.Value =Fields!AssemblyLineId.Value =Fields!PERIODETYPE.Value =Sum(Fields!SUMTime.Value) Műszakren > Műszak > Gyártó gép False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Idő százalékos eloszlása 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN TopCenter Default true Black Black Műszak-idő eloszlás a különböző periódus típusokon (%-os) BrightPastel No Data Available DataSet1 7.02846cm 0.18582cm 12.31975cm 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 Műszakren > Műszak > Gyártó gép False 0.5 NaN NaN NaN Axis Title False 0.5 NaN Opposite NaN NaN Idő (óra) 0.5 NaN NaN NaN Axis Title 0.5 NaN Opposite NaN NaN TopCenter true Black Black Műszak-idő eloszlás a különböző periódus típusokon BrightPastel No Data Available DataSet1 19.40112cm 0.18582cm 10.89833cm 27.7679cm 2 ÁbraMegnyitás1 WhiteSmoke None 4.61612cm 2.7185cm 3.26899cm 3.10193cm 2.73151cm 1.94937cm true true Periódus típus Textbox4 #333333 Middle 2pt 2pt 2pt 2pt true true Idő #333333 Middle 2pt 2pt 2pt 2pt true true Arány Textbox16 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Táblák Textbox14 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Korbácsok 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 Gyártó gép összesen: 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) 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 Gyártógép állásidő összesen: Textbox18 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)))+"%" Textbox27 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox33 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 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 Textbox47 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)))+"%" Textbox49 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox51 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox52 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox26 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 Textbox44 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 Textbox58 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 Textbox67 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox68 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox69 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox84 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 Textbox86 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 Textbox74 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 Textbox77 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox78 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox79 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 3.9295cm true true Műszakrend #333333 Middle 2pt 2pt 2pt 2pt 2.3212cm true true Műszak #333333 Middle 2pt 2pt 2pt 2pt 5.00668cm true true Gyártó gép #333333 Middle 2pt 2pt 2pt 2pt After true =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value 3.9295cm true true =Fields!SHIFTSYSTEMNAME.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value 2.3212cm 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.00668cm 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") =(Parameters!UNFOLDALL.Value="false") MachineTitle 5.00668cm true true Műszak összesen: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 5.00668cm true true Műszak állásidő összesen: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before =(Parameters!UNFOLDALL.Value="false") MűszakTitle 7.32788cm true true Műszakrend összesen: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 7.32788cm true true Állásidő összesen: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before MűszakrendTitle 11.25738cm true true RIPORT ÖSSZESEN: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 11.25738cm true true ÁLLÁSIDŐ ÖSSZESEN: Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before true DataSet1 Start 31.28322cm 0.19976cm 7.34937cm 27.69443cm 3 ListaMegnyitás1 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 Gyártó gép: 2pt 2pt 2pt 2pt true true Kattintson ide az összesített teljes lista megjelenítéséhez / eltüntetéséhez! 2pt 2pt 2pt 2pt true true Kattintson ide a böngészős lista megjelenítéséhez / eltüntetéséhez! 2pt 2pt 2pt 2pt true true Kattintson ide a grafikonok 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 431.9156mm WhiteSmoke 281.6534mm 13.95853mm true true true true Műszak-idő felhasználás riport (műszakra, majd szerelősorokra) Title ReportTitle 1.5875mm 0.0258cm 10.16mm 279.27925mm WhiteSmoke 2pt 2pt 2pt 2pt WhiteSmoke 17.62853mm true true true true Lekérdezés ideje: ExecutionTime 5.07992mm 1.85817mm 6.35mm 69.70191mm 2pt 2pt 2pt 2pt true true Oldalszám: PageNumber 5.07992mm 188.4699mm 6mm 58.44154mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 5.07992mm 251.6268mm 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 SQLTEXT String true true SITENAME Cm ca7aa9be-65e4-4d1c-8177-0ccdfbc36420