0 SQL data source=.\SQLExpress;initial catalog=LearALM;user id=sa;password=Vrh@54321;multipleactiveresultsets=True 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!STARTFrom.Value true =Parameters!STARTTo.Value true SELECT SHIFTSYSTEMNAME, SHIFTNAME, 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) AS SUMSUMTime FROM Periods WHERE 1=1 GROUP BY SHIFTSYSTEMNAME, SHIFTNAME, PERIODETYPE HAVING SHIFTSYSTEMNAME IS NOT NULL ORDER BY SHIFTSYSTEMNAME ASC, SHIFTNAME ASC, PERIODETYPE ASC true SHIFTSYSTEMNAME System.String SHIFTNAME System.String SUMTime System.Int64 Count System.Int32 SUMSUMTime System.Int64 PeriodeTypeNum true SUMProdCount true SUMCycles true PeriodeTypeName true SUMTimeDT true =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!PERIODETYPE.Value =Fields!PERIODETYPE.Value =Sum(Fields!SUMTime.Value) Műszakrend > Műszak 1 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 true Black Black Műszak-idő eloszlás a különböző periódusokon (%-os) BrightPastel No Data Available DataSet1 Start 7.38774cm 0.16002cm 12.30944cm 28.19124cm GrafikonMegnyitás WhiteSmoke None =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!PERIODETYPE.Value =Fields!PERIODETYPE.Value =CLng(Sum(Fields!SUMTime.Value))/3600 Műszakrend > Műszak 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ódusokon BrightPastel No Data Available DataSet1 Start 19.69718cm 0.16002cm 11.39222cm 28.19124cm 1 GrafikonMegnyitás WhiteSmoke None 4.61983cm 4.25027cm 4.25589cm 2.67101cm 2.67101cm 1.94937cm true true Periódus típus 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Idő Textbox5 1pt 1pt 1pt 1pt #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 Textbox21 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt true true Korbácsok Textbox15 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt 0.6cm true true =Fields!PERIODETYPE.Value Textbox6 Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt true true =IIF(Fields!SUMTimeDT.Value < 0, "-", "") & Abs(Fields!SUMTime.Value) \ 3600 & ":" & (Abs(Fields!SUMTime.Value) Mod 3600) \ 60 & ":" & (Abs(Fields!SUMTime.Value) Mod 60) SUMTime2 Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt true true =IIF(Fields!SUMTimeDT.Value < 0, "-", "") & 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 Műszak összesen Textbox12 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) SUMSUMTime2 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true 100% Textbox18 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) PRODCOUNT1 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Állásidő összesen Textbox22 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) Textbox38 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true =IIF(Sum(Fields!SUMTimeDT.Value) < 0, "-", "") & Str(Round((ABS(Sum(Fields!SUMTimeDT.Value)) * 100) / Fields!SUMSUMTime.Value)) + "%" Textbox39 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox39 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox40 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox19 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) SUMSUMTime2 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox365 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) PRODCOUNT1 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox87 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) Textbox38 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox366 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox90 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox91 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox96 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) SUMSUMTime2 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox367 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) PRODCOUNT1 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 0.6cm true true Textbox110 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) Textbox38 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox368 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox90 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt true true Textbox91 Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 5.5343cm true true Műszakrend 1pt 1pt 1pt 1pt #333333 Middle 2pt 2pt 2pt 2pt 4.18891cm true true Műszak #333333 Middle 2pt 2pt 2pt 2pt After true =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value 5.5343cm true true =Fields!SHIFTSYSTEMNAME.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =Fields!SHIFTNAME.Value Between =Fields!SHIFTNAME.Value 4.18891cm true true =Fields!SHIFTNAME.Value Black 1pt Black 1pt Black 1pt Black 1pt WhiteSmoke 2pt 2pt 2pt 2pt =(Parameters!UNFOLDALL.Value="false") PeriodColumnHeader =(Parameters!UNFOLDALL.Value="false") MűszakColumnHeader 4.18891cm true true Műszakrend összesen Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 4.18891cm true true Állásidő összesen Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before MűszakrendColumnHeader 5.5343cm true true RIPORT ÖSSZESEN Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 4.18891cm true true Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before 5.5343cm true true ÁLLÁSIDŐ ÖSSZESEN Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt 4.18891cm true true Black 1pt Black 1pt Black 1pt Black 1pt LightGrey 2pt 2pt 2pt 2pt Before true DataSet1 Start 31.98546cm 0.16002cm 6.14937cm 28.19122cm 2 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 Kattintson ide a grafikonok megjelenítéséhez / eltüntetéséhez! 2pt 2pt 2pt 2pt true true Kattintson ide teljes tételes táblázat megjelenítéséhez / eltüntetéséhez! 2pt 2pt 2pt 2pt true true Kattintson ide a keresgélős táblázat megjelenítéséhez / eltüntetéséhez! 2pt 2pt 2pt 2pt 13.91194cm 4.13877cm 4.50422cm 2.73942cm 2.73942cm 0.62987cm true true Nyissa meg 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.62987cm true true =Fields!PERIODETYPE.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.62987cm true true =Fields!SHIFTSYSTEMNAME.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 100% #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.62987cm true true =Fields!SHIFTNAME.Value 2 #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.62987cm true true Összesen #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 #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!PERIODETYPE.Value =Fields!PERIODETYPE.Value =Fields!SHIFTSYSTEMNAME.Value =Fields!SHIFTSYSTEMNAME.Value After =Fields!SHIFTNAME.Value =Fields!SHIFTNAME.Value =(Parameters!UNFOLDALL.Value="false") SHIFTSYSTEMNAME1 =(Parameters!UNFOLDALL.Value="false") PERIODETYPE true DataSet1 Start 39.13143cm 0.3175cm 3.14935cm 28.03377cm 11 true ListaMegnyitás2 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 422.8078mm WhiteSmoke 285.61657mm 13.95853mm true true true true Műszak-idő felhasználás (műszakonként) Title ReportTitle 1.5875mm 10.16mm 283.51258mm 2pt 2pt 2pt 2pt WhiteSmoke 16.12922mm true true true true Lekérdezés ideje: ExecutionTime 5.07992mm 1.6002mm 6.35mm 69.70191mm 2pt 2pt 2pt 2pt true true Oldalszám: PageNumber 5.07992mm 175.51193mm 6mm 58.44154mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 5.07992mm 241.84383mm 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 AssemblyLineId String UNFOLDALL String SQLTEXT Cm ca7aa9be-65e4-4d1c-8177-0ccdfbc36420