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 SHIFTDATE true SHIFTNAME System.String PeriodeTypeName System.String ASSLINEINFO System.String DTRINFO System.String PERIODLENGTH System.Int64 PERIODSTART System.Int64 PERIODEND System.Int64 QTYproduced true Cycles 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 Assembly line: 2pt 2pt 2pt 2pt 1.48246cm 1.87004cm 1.16522cm 5.81066cm 2.84494cm 6.41857cm 1.67765cm 1.64024cm 1.67425cm 1.62582cm 2.38427cm 0.6cm true true Shift Textbox24 #4c68a2 2pt 2pt 2pt 2pt 3 true true #4c68a2 2pt 2pt 2pt 2pt true true Period information Textbox83 #4c68a2 2pt 2pt 2pt 2pt 7 1.31438cm true =Fields!SHIFTSYSTEMNAME.Value DataSet1 true Sys #4c68a2 2pt 2pt 2pt 2pt true =Fields!SHIFTDATE.Value DataSet1 true Date #4c68a2 2pt 2pt 2pt 2pt true =Fields!SHIFTNAME.Value DataSet1 true Shift #4c68a2 2pt 2pt 2pt 2pt true =Fields!ASSLINEINFO.Value DataSet1 true Assembly Line #4c68a2 2pt 2pt 2pt 2pt true =Fields!PERIODTYPEINFO.Value DataSet1 true Type #4c68a2 2pt 2pt 2pt 2pt true =Fields!DTRINFO.Value DataSet1 true DTR code #4c68a2 2pt 2pt 2pt 2pt true =Fields!PERIODSTART.Value DataSet1 true Start #4c68a2 2pt 2pt 2pt 2pt true =Fields!PERIODEND.Value DataSet1 true End #4c68a2 2pt 2pt 2pt 2pt true =Fields!PERIODLENGTH.Value true Length #4c68a2 2pt 2pt 2pt 2pt true =Fields!CYCLES.Value DataSet1 true Boards #4c68a2 2pt 2pt 2pt 2pt true =Fields!QTYproduced.Value DataSet1 true Harnesses #4c68a2 2pt 2pt 2pt 2pt 0.6cm true true Total CornflowerBlue 2pt 2pt 2pt 2pt true true CornflowerBlue 2pt 2pt 2pt 2pt true true CornflowerBlue 2pt 2pt 2pt 2pt true true Number of records: Textbox335 CornflowerBlue 2pt 2pt 2pt 2pt true true =CountRows() Textbox335 CornflowerBlue 2pt 2pt 2pt 2pt true true CornflowerBlue 2pt 2pt 2pt 2pt true true CornflowerBlue 2pt 2pt 2pt 2pt true true CornflowerBlue 2pt 2pt 2pt 2pt true true =Sum(Fields!PERIODLENGTH.Value) \ 3600 & ":" & (Sum(Fields!PERIODLENGTH.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!PERIODLENGTH.Value) Mod 60) Textbox448 CornflowerBlue 2pt 2pt 2pt 2pt true true =Sum(Fields!CYCLES.Value) CornflowerBlue 2pt 2pt 2pt 2pt true true =Sum(Fields!QTYproduced.Value) CornflowerBlue 2pt 2pt 2pt 2pt 0.6cm true true =Fields!SHIFTSYSTEMNAME.Value 2pt 2pt 2pt 2pt true true =Fields!SHIFTDATE.Value 2pt 2pt 2pt 2pt true true =Fields!SHIFTNAME.Value 2pt 2pt 2pt 2pt true true =Fields!ASSLINEINFO.Value 2pt 2pt 2pt 2pt true true =Fields!PERIODTYPEINFO.Value 2pt 2pt 2pt 2pt true true =Fields!DTRINFO.Value 2pt 2pt 2pt 2pt true true =Fields!PERIODSTART.Value 2pt 2pt 2pt 2pt true true =Fields!PERIODEND.Value 2pt 2pt 2pt 2pt true true =Fields!PERIODLENGTH.Value \ 3600 & ":" & (Fields!PERIODLENGTH.Value Mod 3600) \ 60 & ":" & (Fields!PERIODLENGTH.Value Mod 60) LENGTH 2pt 2pt 2pt 2pt true true =Fields!CYCLES.Value 2pt 2pt 2pt 2pt true true =Fields!QTYproduced.Value 2pt 2pt 2pt 2pt After =(Parameters!UNFOLDALL.Value="false") Textbox442 DataSet1 8.51092cm 0.3175cm 3.11438cm 28.59412cm 6 true true Periode type: =Parameters!PERIODETYPE.Value 2pt 2pt 2pt 2pt true true DTR code: =Parameters!DTR.Value 2pt 2pt 2pt 2pt true true HOW TO USE THIS REPORT! Yellow 2pt 2pt 2pt 2pt true true Click here to display / hide SQLTEXT! 2pt 2pt 2pt 2pt true true =Parameters!SQLTEXT.Value 2pt 2pt 2pt 2pt true true Gyár: 2pt 2pt 2pt 2pt 116.253mm WhiteSmoke 291.89112mm 12.9002mm true true true true Detailed periods report (with sorting) Title ReportTitle 1.5875mm 0.3175cm 9.71903mm 285.94112mm 2pt 2pt 2pt 2pt WhiteSmoke 6.35278mm true true true true Report execution time: ExecutionTime 0mm 3.96195mm 6.35mm 90.74437mm 2pt 2pt 2pt 2pt true true Num of pages: PageNumber 0mm 96.11743mm 6mm 60.82279mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 0.35278mm 164.83058mm 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