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 Műszakrend: 2pt 2pt 2pt 2pt true true Műszak: 2pt 2pt 2pt 2pt true true Műszak dátuma (tól): 2pt 2pt 2pt 2pt true true -- 2pt 2pt 2pt 2pt true true (ig): =Parameters!STARTTo.Value 2pt 2pt 2pt 2pt true true Szerelősor: 2pt 2pt 2pt 2pt 1.48246cm 1.87004cm 1.40334cm 5.81066cm 2.84494cm 6.18044cm 1.67765cm 1.64024cm 1.67425cm 1.62582cm 2.38427cm 0.6cm true true Műszak Textbox24 #4c68a2 2pt 2pt 2pt 2pt 3 true true #4c68a2 2pt 2pt 2pt 2pt true true Periódus adatok Textbox83 #4c68a2 2pt 2pt 2pt 2pt 7 1.31438cm true =Fields!SHIFTSYSTEMNAME.Value DataSet1 true rend #4c68a2 2pt 2pt 2pt 2pt true =Fields!SHIFTDATE.Value DataSet1 true dátum #4c68a2 2pt 2pt 2pt 2pt true =Fields!SHIFTNAME.Value DataSet1 true műsz. #4c68a2 2pt 2pt 2pt 2pt true =Fields!ASSLINEINFO.Value DataSet1 true Szerelősor #4c68a2 2pt 2pt 2pt 2pt true =Fields!PERIODTYPEINFO.Value DataSet1 true típus #4c68a2 2pt 2pt 2pt 2pt true =Fields!DTRINFO.Value DataSet1 true Állásidő kód (DTR) #4c68a2 2pt 2pt 2pt 2pt true =Fields!PERIODSTART.Value DataSet1 true Kezd #4c68a2 2pt 2pt 2pt 2pt true =Fields!PERIODEND.Value DataSet1 true Vég #4c68a2 2pt 2pt 2pt 2pt true =Fields!PERIODLENGTH.Value true Hossz #4c68a2 2pt 2pt 2pt 2pt true =Fields!CYCLES.Value DataSet1 true Táblák #4c68a2 2pt 2pt 2pt 2pt true =Fields!QTYproduced.Value DataSet1 true Korbácsok #4c68a2 2pt 2pt 2pt 2pt 0.6cm true true Össz: CornflowerBlue 2pt 2pt 2pt 2pt true true CornflowerBlue 2pt 2pt 2pt 2pt true true CornflowerBlue 2pt 2pt 2pt 2pt true true Rekordok száma: 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 9.78092cm 0.3175cm 3.11438cm 28.59411cm 6 true true Periódus típusa: =Parameters!PERIODETYPE.Value 2pt 2pt 2pt 2pt true true Állásidő kód: =Parameters!DTR.Value 2pt 2pt 2pt 2pt true true HOGY KELL A RIPORTOT KEZELNI! Yellow 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 Site: 2pt 2pt 2pt 2pt 130.01133mm WhiteSmoke 294.00779mm 12.9002mm true true true true Részletes periódus riport (tételes) Title ReportTitle 1.5875mm 0.3175cm 9.71903mm 285.94112mm 2pt 2pt 2pt 2pt WhiteSmoke 9.52778mm true true true true Riport végrehajtása ekkor: ExecutionTime 3.175mm 4.31473mm 6.35mm 90.74437mm 2pt 2pt 2pt 2pt true true Lapok száma: PageNumber 3.175mm 96.11743mm 6mm 60.82279mm 1 2pt 2pt 2pt 2pt true true =Globals!TotalPages TotalPages 3.52778mm 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