0SQLData Source=.\SQLExpress;Initial Catalog=LearALMSpecify a user name and password for data source DataSource1:Windows0b0b2666-4897-46e3-900b-847e2efc8416DataSource1=Parameters!SHIFTSYSTEMNAME.Valuetrue=Parameters!SHIFTNAME.Valuetrue=Parameters!AssemblyLineId.Valuetrue=Parameters!STARTFrom.Valuetrue=Parameters!STARTTo.Valuetrue=Parameters!PERIODETYPE.Valuetrue=Parameters!DTR.Valuetrue=Parameters!ENDFrom.Valuetrue=Parameters!ENDTo.ValuetrueSELECT
Periods.SHIFTSYSTEMNAME, Periods.SHIFTNAME
,Periods.MachineId,Periods.MachineName
,Periods.PeriodeTypeNum,dbo.PeriodTypeName(Periods.PeriodeTypeNum,'@LCID@') AS PeriodeTypeName
,Periods.DTRidandname
,Count(*) AS [Count]
,SUM(Periods.[LENGTH]) AS SUMTime
,(CASE Periods.PeriodeTypeNum WHEN 4 THEN -1 WHEN 3 THEN 1 ELSE 0 END) * SUM(Periods.[LENGTH]) AS SUMTimeDT
,MIN(Periods.[LENGTH]) AS MINTime, MAX(Periods.[LENGTH]) AS MAXTime
,P1.SUMSUMTime
,SUM([QTYproduced]) AS SUMProdCount
,SUM([Cycles]) AS SUMCycles
FROM Reports_Periods AS Periods
INNER JOIN (SELECT P11.SHIFTSYSTEMNAME AS _SHIFTSYSTEMNAME
,P11.SHIFTNAME AS _SHIFTNAME
,P11.MachineId AS _MachineId
,SUM(P11.[LENGTH]) AS SUMSUMTime
FROM Reports_Periods2 AS P11
GROUP BY P11.SHIFTSYSTEMNAME, P11.SHIFTNAME, P11.MachineId) AS P1
ON P1._SHIFTSYSTEMNAME = Periods.SHIFTSYSTEMNAME AND P1._SHIFTNAME = Periods.SHIFTNAME AND P1._MachineId = Periods.MachineId
WHERE (1=1) AND Periods.SHIFTSYSTEMNAME IS NOT NULL
GROUP BY Periods.SHIFTSYSTEMNAME, Periods.SHIFTNAME, Periods.MachineId, Periods.MachineName, P1.SUMSUMTime, Periods.PeriodeTypeNum, Periods.DTRidandnametrueSHIFTSYSTEMNAMESystem.StringSHIFTNAMESystem.StringPeriodeTypeNumSystem.Int32CountSystem.Int32MachineIdSystem.StringDTRidandnameSystem.StringSUMTimeSystem.Int32SUMSUMTimeSystem.Int32MINTimeSystem.Int32MAXTimeSystem.Int32MachineNametruePeriodeTypeNametrueSUMTimeDTtrueSUMProdCountSystem.Int32SUMCyclesSystem.Int32truetrueShiftsystem:=Parameters!SHIFTSYSTEMNAME.ValueTextbox10.28901cm0.25938cm0.6cm10.755cm2pt2pt2pt2pttruetrueShift:=Parameters!SHIFTNAME.ValueTextbox10.28901cm11.68938cm0.6cm10.755cm12pt2pt2pt2pttruetrueStart of shift:=Parameters!STARTFrom.ValueTextbox11.66568cm0.25938cm0.6cm10.755cm22pt2pt2pt2pttruetrue--Textbox101.66568cm11.0711cm0.6cm0.35688cm32pt2pt2pt2pttruetrue=Parameters!STARTTo.ValueTextbox11.66568cm11.53381cm0.6cm10.755cm42pt2pt2pt2pttruetrueAssembly line:=Parameters!AssemblyLineId.ValueTextbox10.92429cm0.25938cm0.6cm10.755cm52pt2pt2pt2pttruetrueClick here to display report!36.2341cm0.25938cm0.6cm27.83847cm62pt2pt2pt2pttruetrueClick here to display report with browse functions!45.02591cm0.25938cm0.6cm27.83847cm72pt2pt2pt2pt5.94806cm1.05176cm2.60788cm1.38874cm1.61569cm1.37756cm1.94937cmtrue=Fields!SUMTime.ValuetrueDTR code#333333Middle2pt2pt2pt2pttrue=Fields!Count.ValuetruePCSTextbox38#333333Middle2pt2pt2pt2pttruetrueTimeTextbox51pt1pt1pt1pt#333333Middle2pt2pt2pt2pttruetrueRatioTextbox161pt1pt1pt1pt#333333Middle2pt2pt2pt2pttruetrueMinTextbox41pt1pt1pt1pt#333333Middle2pt2pt2pt2pttruetrueMaxTextbox201pt1pt1pt1pt#333333Middle2pt2pt2pt2pt0.6cmtruetrue=Fields!DTR.ValueDTR1WhiteSmoke2pt2pt2pt2pttruetrue=Fields!Count.ValueCount1Black1ptBlack1ptBlack1ptBlack1ptWhiteSmoke2pt2pt2pt2pttruetrue=IIF(Fields!SUMTimeDT.Value<0,"-","") & Fields!SUMTime.Value \ 3600 & ":" & (Fields!SUMTime.Value MOD 3600)\60 & ":" & (Fields!SUMTime.Value MOD 60)SUMTime2Black1ptBlack1ptBlack1ptBlack1ptWhiteSmoke2pt2pt2pt2pttruetrue=Str(Round((Fields!SUMTime.Value*100)/(Fields!SUMSUMTime.Value)))+"%"Textbox17Black1ptBlack1ptBlack1ptBlack1ptWhiteSmoke2pt2pt2pt2pttruetrue=(Fields!MINTime.Value) \ 3600 & ":" & ((Fields!MINTime.Value) MOD 3600)\60 & ":" & ((Fields!MINTime.Value) MOD 60)MINTime2Black1ptBlack1ptBlack1ptBlack1ptWhiteSmoke2pt2pt2pt2pttruetrue=(Fields!MAXTime.Value) \ 3600 & ":" & ((Fields!MAXTime.Value) MOD 3600)\60 & ":" & ((Fields!MAXTime.Value) MOD 60)MAXTime2Black1ptBlack1ptBlack1ptBlack1ptWhiteSmoke2pt2pt2pt2pt0.6cmtruetrueTotal for this periodeTextbox54Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrue=Sum(Fields!Count.Value)Textbox55Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrue=IIF(SUM(Fields!SUMTimeDT.Value)<0,"-","") & SUM(Fields!SUMTime.Value) \ 3600 & ":" & (SUM(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!SUMTime.Value) MOD 60)Textbox18Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrue=Str(Round((SUM(Fields!SUMTime.Value)*100)/(Fields!SUMSUMTime.Value)))+"%"Textbox57Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox58Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox61Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pt0.6cmtruetrue(for assembly line)Textbox160Black1ptLightGrey2pt2pt2pt2pttruetrueTextbox21Black1ptLightGrey2pt2pt2pt2pttruetrue=SUM(Fields!SUMTime.Value) \ 3600 & ":" & (SUM(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!SUMTime.Value) MOD 60)Textbox18Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrue100%Textbox24Black1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox26Black1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox28Black1ptLightGrey2pt2pt2pt2pt0.6cmtruetrue(for assembly line)Textbox160Black1ptLightGrey2pt2pt2pt2pttruetrueTextbox23LightGrey2pt2pt2pt2pttruetrue=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)Textbox242LightGrey2pt2pt2pt2pttruetrue=IIF(Fields!SUMTimeDT.Value<0,"-","") & Str(Round((ABS(SUM(Fields!SUMTimeDT.Value))*100)/(Fields!SUMSUMTime.Value)))+"%"Textbox30Black1ptLightGrey2pt2pt2pt2pttruetrueTextbox31Black1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox32LightGrey2pt2pt2pt2pt0.6cmtruetrueTextbox511pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox431pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrue=Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUMTime.Value) Mod 60)Textbox18Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox251pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox151pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox61pt1pt1pt1ptLightGrey2pt2pt2pt2pt0.6cmtruetrueTextbox371pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox391pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrue=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)Textbox242Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrue=IIF(Fields!SUMTimeDT.Value < 0, "-", "") & Str(Round((ABS(Sum(Fields!SUMTimeDT.Value)) * 100) / Fields!SUMSUMTime.Value)) + "%"Textbox30Black1ptLightGrey2pt2pt2pt2pttruetrueTextbox481pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox491pt1pt1pt1ptLightGrey2pt2pt2pt2pt0.6cmtruetrueTextbox521pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox1541pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrue=Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUMTime.Value) Mod 60)Textbox18Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox1561pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox1571pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox1581pt1pt1pt1ptLightGrey2pt2pt2pt2pt0.6cmtruetrueTextbox661pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox691pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrue=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)Textbox242Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox196Black1ptLightGrey2pt2pt2pt2pttruetrueTextbox721pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox731pt1pt1pt1ptLightGrey2pt2pt2pt2pt0.6cmtruetrueTextbox1001pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox1011pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrue=Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUMTime.Value) Mod 60)Textbox18Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox104Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox105Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox106Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pt0.6cmtruetrueTextbox801pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrueTextbox811pt1pt1pt1ptLightGrey2pt2pt2pt2pttruetrue=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)Textbox242Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox83Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox84Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pttruetrueTextbox87Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2pt2.94058cmtruetrueShift systemCHShiftSystem#333333Middle2pt2pt2pt2pt1.78314cmtruetrueShift#333333Middle2pt2pt2pt2pt5.81468cmtrue=Sum(Fields!SUMTimeDT.Value)AssemblyLinetrueAssembly line#333333Middle2pt2pt2pt2pt3.31041cmtrue=Sum(Fields!SUMTime.Value)PeriodeTypetruePeriod type#333333Middle2pt2pt2pt2ptAftertrue=Fields!SHIFTSYSTEMNAME.Value=Fields!SHIFTSYSTEMNAME.Value2.94058cmtruetrue=Fields!SHIFTSYSTEMNAME.ValueGroup1Black1ptBlack1ptBlack1ptBlack1ptWhiteSmoke2pt2pt2pt2pt=Fields!SHIFTNAME.Value=Fields!SHIFTNAME.Value1.78314cmtruetrue=Fields!SHIFTNAME.ValueGroup2Black1ptBlack1ptBlack1ptBlack1ptWhiteSmoke2pt2pt2pt2pt=Fields!AssemblyLineId.Value=Fields!MACHINENAME.Value5.81468cmtruetrue=Fields!AssemblyLineId.Value + " ( " & Fields!MACHINENAME.Value + " )"AssemblyLineIdBlack1ptBlack1ptBlack1ptBlack1ptWhiteSmoke2pt2pt2pt2pt=Fields!PERIODETYPE.Value=Fields!SUMTime.Value3.31041cmtruetrue=Fields!PERIODETYPE.ValueGroup4Black1ptBlack1ptBlack1ptBlack1ptWhiteSmoke2pt2pt2pt2pt=IIF((CountRows("PeriodeType") = 1) or (Parameters!UNFOLDALL.Value="false"), True,False)CHDTRBefore=IIF((CountRows("AssemblyLine") = 1) or (Parameters!UNFOLDALL.Value="false"), True,False)CHPeriods3.31041cmtruetrueTotal prod.timeTextbox50LightGrey2pt2pt2pt2ptBefore3.31041cmtruetrueTotal downtimeTextbox8LightGrey2pt2pt2pt2ptBefore=(Parameters!UNFOLDALL.Value="false")CHAssemblyLine9.12509cmtruetrueTotal production time (for shift):Textbox451pt1pt1pt1ptLightGrey2pt2pt2pt2pt9.12509cmtruetrueTotal downtime (for shift):Textbox34LightGrey2pt2pt2pt2pt=(Parameters!UNFOLDALL.Value="false")CHShift10.90823cmtruetrueTotal production time (for shift system):Textbox150Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2ptBefore10.90823cmtruetrueTotal downtime (for shift system):DTR2Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2ptBeforeCHShiftSystem13.84881cmtruetrueTOTAL PRODUCTION TIME (FOR REPORT)Textbox88Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2ptBefore13.84881cmtruetrueTOTAL DOWNTTIME (FOR REPORT)Textbox76Black1ptBlack1ptBlack1ptBlack1ptLightGrey2pt2pt2pt2ptBeforetrueDataSet1=Fields!PERIODETYPE.ValueNotEqualProduction=Fields!PERIODETYPE.ValueNotEqualBreaktime37.04126cm0.25938cm7.94937cm27.8385cm8Lista1MegnyitasBlack1ptBlack1ptBlack1ptBlack1pt12.93981cm3.72466cm3.72466cm3.72466cm3.72466cm1.27028cmtruetrueOpen for details!Textbox27#384c70Middle2pt2pt2pt2pttruetrueNumber of occurencesTextbox12#384c70Middle2pt2pt2pt2pttruetrueTotal timeTextbox13#384c70Middle2pt2pt2pt2pttruetrueMin lengthTextbox19#384c70Middle2pt2pt2pt2pttruetrueMax lengthTextbox22#384c70Middle2pt2pt2pt2pt0.6cmtruetrue=IIF(Fields!DTR.Value = "","No DTR code specified",Fields!DTR.Value )DTR#949a7e2pt2pt2pt2pttruetrue=Sum(Fields!Count.Value)Textbox59#949a7e2pt2pt2pt2pttruetrue=Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (Sum(Fields!SUMTime.Value)) MOD 60Textbox60#949a7e2pt2pt2pt2pttruetrueTextbox92#949a7e2pt2pt2pt2pttruetrueTextbox93#949a7e2pt2pt2pt2pt0.6cmtruetrue=Fields!AssemblyLineId.Value + " ( " + Fields!MACHINENAME.Value + " )"1AssemblyLineId1#aab2922pt2pt2pt2pttruetrue=Sum(Fields!Count.Value)Textbox67#aab2922pt2pt2pt2pttruetrue=Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) MOD 3600)\60 & ":" & (Sum(Fields!SUMTime.Value)) MOD 60Textbox68#aab2922pt2pt2pt2pttruetrueTextbox94#aab2922pt2pt2pt2pttruetrueTextbox95#aab2922pt2pt2pt2pt0.6cmtruetrue=Fields!SHIFTSYSTEMNAME.Value2SHIFTSYSTEMNAME#b8c09e2pt2pt2pt2pttruetrue=Sum(Fields!Count.Value)Textbox74#b8c09e2pt2pt2pt2pttruetrue=Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) MOD 3600)\60 & ":" & Sum(Fields!SUMTime.Value) MOD 60Textbox75#b8c09e2pt2pt2pt2pttruetrueTextbox96#b8c09e2pt2pt2pt2pttruetrueTextbox97#b8c09e2pt2pt2pt2pt0.6cmtruetrue=Fields!SHIFTNAME.Value3SHIFTNAME#b8c09e2pt2pt2pt2pttruetrue=Sum(Fields!Count.Value)CountWhiteSmoke2pt2pt2pt2pttruetrue=Fields!SUMTime.Value \ 3600 & ":" & (Fields!SUMTime.Value MOD 3600)\60 & ":" & Fields!SUMTime.Value MOD 60SUMTimeWhiteSmoke2pt2pt2pt2pttruetrue=SUM(Fields!MINTime.Value) \ 3600 & ":" & (SUM(Fields!MINTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!MINTime.Value) MOD 60)MINTimeWhiteSmoke2pt2pt2pt2pttruetrue=SUM(Fields!MAXTime.Value) \ 3600 & ":" & (SUM(Fields!MAXTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!MAXTime.Value) MOD 60)MAXTimeWhiteSmoke2pt2pt2pt2pt0.6cmtruetrueTotalTextbox35#7285862pt2pt2pt2pttruetrue=Sum(Fields!Count.Value)Textbox42#7285862pt2pt2pt2pttruetrue=Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) MOD 3600)\60 & ":" & Sum(Fields!SUMTime.Value) MOD 60Textbox44#7285862pt2pt2pt2pttruetrueTextbox98#7285862pt2pt2pt2pttruetrueTextbox99#7285862pt2pt2pt2pt=Fields!DTR.Value=Fields!DTR.Value=Fields!AssemblyLineId.Value=Fields!AssemblyLineId.Value=Fields!SHIFTSYSTEMNAME.Value=Fields!SHIFTSYSTEMNAME.ValueAfter=Fields!SHIFTNAME.Value=Fields!SHIFTNAME.Value=(Parameters!UNFOLDALL.Value="false")SHIFTSYSTEMNAME=(Parameters!UNFOLDALL.Value="false")AssemblyLineId1=(Parameters!UNFOLDALL.Value="false")DTRtrueDataSet1=Fields!PERIODETYPE.ValueNotEqualProduction=Fields!PERIODETYPE.ValueNotEqualBreaktime45.68913cm0.25938cm4.27028cm27.83845cm9trueLista2Megnyitas=Fields!PERIODETYPE.Value=Sum(Fields!SUMTime.Value)Descending=Round(Sum(Fields!SUMTime.Value)/3600,2)trueOutputStackedtruePrimaryPrimaryBlack0pt
Periode types
1False0.5NaNNaNNaN
Axis Title
False0.5NaNOppositeNaNNaN
Time (in hours)
True0.5NaNtrueNaNNaN
Axis Title
0.5NaNOppositeNaNNaNtrueLeftTopColumnDefaulttrue
BlackBlack
Shift-time utilization
BrightPastel
No Data Available
DataSet16.89082cm0.25935cm12.0317cm27.62381cm10Grafikon1MegnyitásWhiteSmokeNonetruetrueClick here to show/hide shift-utilization chart!6.22026cm0.25935cm0.6cm27.62381cm112pt2pt2pt2pt=Fields!PERIODETYPE.Value=Fields!PERIODETYPE.Value=Fields!DTR.Value=Sum(Fields!SUMTime.Value)Descending=Round(Sum(Fields!SUMTime.Value) / 3600, 2)trueOutputStackedPrimaryPrimaryBlack0pt
DTR codes (downtime reason codes)
1False0.5NaNNaNNaN
Axis Title
False0.5NaNOppositeNaNNaN
Time (in hours)
True0.5NaNtrueNaNNaN2
Axis Title
0.5NaNOppositeNaNNaNtrue
Down time distribution on DTR codes
BrightPastel
No Data Available
DataSet1=(Fields!PERIODETYPENUM.Value = 3) Or (Fields!PERIODETYPENUM.Value = 4)Equaltrue19.94585cm0.3175cm16.00602cm27.83847cm12Grafikon2MegnyitásWhiteSmokeNonetruetrueClick here to show/hide chart of downtime distribution on DTR codes!19.2753cm0.25943cm0.6cm27.62381cm132pt2pt2pt2pttruetrueClick here to display / hide SQLTEXT!2.37391cm0.25935cm0.6cm13.17332cm142pt2pt2pt2pttruetrue=Parameters!SQLTEXT.ValueTextbox13.07974cm0.25943cm2.78774cm27.83845cm15trueSQLTEXTMegnyitás2pt2pt2pt2pttruetrueSite:=Parameters!SITENAME.ValueTextbox2230.28901cm22.58549cm0.6cm5.51239cm162pt2pt2pt2pt499.5941mmWhiteSmoke284.89741mm20.57312mmtruetruetruetrueShift-time utilization and Downtime report (detailed per assembly line per downtime reason)TitleReportTitle1.41728mm0.25938cm18.89125mm278.38473mm2pt2pt2pt2ptWhiteSmoke7.72574mmtruetruetruetrueExecution time :=Globals!ExecutionTimeExecutionTime0mm2.59377mm6.35mm69.70191mm2pt2pt2pt2pttruetrueNumber of pages: =Globals!PageNumberPageNumber0mm78.87425mm6mm60.82279mm12pt2pt2pt2pttruetrue=Globals!TotalPagesTotalPages0mm147.58741mm6mm25mm22pt2pt2pt2pttruetrue/Textbox70mm141.46102mm6mm4.3625mm32pt2pt2pt2ptWhiteSmoke21cm29.7cm0.5cm0.5cm0.5cm0.5cmBlackBlackBlackBlackStringtruetrueSHIFTSYSTEMNAMEStringtruetrueSHIFTNAMEStringtruetrueSTARTFromStringtruetrueSTARTToStringtruetrueOther KeyStringtruetruePERIODETYPEStringtruetrueDTRStringtruetrueENDFromStringtruetrueENDToStringUNFOLDALLStringtruetrueSQLTEXTStringSITENAMECmca7aa9be-65e4-4d1c-8177-0ccdfbc36420