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
dbo.Periods.SHIFTSYSTEMNAME, dbo.Periods.SHIFTSTART, dbo.Periods.SHIFTNAME, dbo.Periods.AssemblyLineId, dbo.ProductionLines.Name AS MACHINENAME,
SUM(CASE dbo.Periods.PERIODETYPE WHEN 'Downtime' THEN [Length] ELSE 0 END) AS DOWNTIME,
SUM(CASE dbo.Periods.PERIODETYPE WHEN 'Production' THEN [Length] ELSE 0 END) AS PRODUCTIONTIME,
SUM(CASE dbo.Periods.PERIODETYPE WHEN 'Overproduction' THEN [Length] ELSE 0 END) AS OVERPRODUCTIONTIME,
SUM(CASE dbo.Periods.PERIODETYPE WHEN 'Breaktime' THEN [Length] ELSE 0 END) AS BREAKTIME
FROM dbo.Periods INNER JOIN dbo.ProductionLines ON dbo.Periods.AssemblyLineId = dbo.ProductionLines.[Key]
WHERE (1 = 1)
GROUP BY dbo.Periods.SHIFTSYSTEMNAME, dbo.Periods.SHIFTNAME, dbo.ProductionLines.Name, dbo.Periods.AssemblyLineId , dbo.ProductionLines.Name, dbo.Periods.SHIFTSTART
HAVING (dbo.Periods.SHIFTSYSTEMNAME IS NOT NULL)
ORDER BY dbo.Periods.SHIFTSYSTEMNAME, dbo.Periods.SHIFTSTART DESC, dbo.Periods.SHIFTNAME, dbo.Periods.AssemblyLineId
true
SHIFTSYSTEMNAME
System.String
SHIFTDATE
true
SHIFTNAME
System.String
MachineId
System.String
MachineName
true
DOWNTIME
true
PRODUCTIONTIME
true
BREAKTIME
true
OVERPRODUCTIONTIME
true
SUMProdCount
true
SUMCycles
true
SUSPENDEDTIME
true
7.25292cm
2.16698cm
2.22842cm
2.31561cm
3.89936cm
1.96478cm
3.4419cm
1.99671cm
2.71287cm
1.12916cm
true
true
Műszakrend-Dátum-Műszak-Szerelősor
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Állásidő
Textbox525
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
...és aránya
Textbox116
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Termelés
Textbox4
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Szünet/Termelés
Textbox16
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Szünet
Textbox23
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Felfüggesztve
Textbox26
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Táblák
Textbox6
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Korbácsok
Textbox68
#4c68a2
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTSYSTEMNAME.Value
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox117
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
SUMCYCLES
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
SUMPRODCOUNT
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTDATE.Value
1
true
SHIFTSYSTEMNAME11
#c6daf8
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox118
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox47
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox70
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTNAME.Value
2
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox119
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox65
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox71
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!MACHINENAME.Value & " (" & Fields!AssemblyLineId.Value & ")"
3
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox120
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox66
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox72
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
Összesen
Textbox536
#7292cc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox121
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox67
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox73
#e6eefc
2pt
2pt
2pt
2pt
=Fields!SHIFTSYSTEMNAME.Value
=Fields!SHIFTSYSTEMNAME.Value
=Fields!SHIFTDATE.Value
=Fields!SHIFTDATE.Value
=Fields!SHIFTNAME.Value
=Fields!SHIFTNAME.Value
After
=Fields!AssemblyLineId.Value
=Fields!MACHINENAME.Value
=(Parameters!UNFOLDALL.Value="false")
SHIFTNAME11
=(Parameters!UNFOLDALL.Value="false")
SHIFTSTART11
=(Parameters!UNFOLDALL.Value="false")
SHIFTSYSTEMNAME11
Tablix1Fejléc
true
DataSet1
6.92679cm
0.16002cm
4.12916cm
27.97955cm
true
true
Műszakrend:
=Parameters!SHIFTSYSTEMNAME.Value
Textbox1
0.28901cm
0.16002cm
0.6cm
10.755cm
1
2pt
2pt
2pt
2pt
true
true
Műszak:
=Parameters!SHIFTNAME.Value
Textbox1
0.28901cm
11.39918cm
0.6cm
10.755cm
2
2pt
2pt
2pt
2pt
true
true
Műszak kezdete:
=Parameters!STARTFrom.Value
Textbox1
1.79797cm
0.16002cm
0.6cm
10.755cm
3
2pt
2pt
2pt
2pt
true
true
--
Textbox10
1.79797cm
10.97174cm
0.6cm
0.35688cm
4
2pt
2pt
2pt
2pt
true
true
=Parameters!STARTTo.Value
Textbox1
1.79797cm
11.39918cm
0.6cm
10.755cm
5
2pt
2pt
2pt
2pt
true
true
Szerelősor:
=Parameters!AssemblyLineId.Value
Textbox1
1.02158cm
0.16002cm
0.6cm
10.755cm
6
2pt
2pt
2pt
2pt
7.31254cm
2.10722cm
2.1663cm
2.37004cm
3.89762cm
1.95557cm
3.42604cm
2.26048cm
2.48375cm
1.12916cm
true
true
Dátum -Szerelősor-Műszakrend-Műszak
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Állásidő
Textbox525
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
...és aránya
Textbox116
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Termelés
Textbox4
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Szünet/Termelés
Textbox16
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Szünet
Textbox23
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Felfüggesztve
Textbox26
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Táblák
Textbox74
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Korbácsok
Textbox80
#4c68a2
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTDATE.Value
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox123
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox75
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox81
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!MACHINENAME.Value & " (" & Fields!AssemblyLineId.Value & ")"
1
#c6daf8
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox124
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox76
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox82
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTSYSTEMNAME.Value
2
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox125
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox77
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox83
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTNAME.Value
3
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox126
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox78
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox84
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
Összesen
Textbox536
#7292cc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox127
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox79
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox85
#e6eefc
2pt
2pt
2pt
2pt
=Fields!SHIFTDATE.Value
=Fields!SHIFTDATE.Value
=Fields!AssemblyLineId.Value
=Fields!MACHINENAME.Value
=Fields!SHIFTSYSTEMNAME.Value
=Fields!SHIFTSYSTEMNAME.Value
After
=Fields!SHIFTNAME.Value
=Fields!SHIFTNAME.Value
=(Parameters!UNFOLDALL.Value="false")
SHIFTSYSTEMNAME22
=(Parameters!UNFOLDALL.Value="false")
ASLINE22
=(Parameters!UNFOLDALL.Value="false")
SHIFTSTART22
Tablix2Fejléc
true
DataSet1
11.33652cm
0.16002cm
4.12916cm
27.97955cm
7
7.34152cm
2.08737cm
2.15716cm
2.40394cm
3.89676cm
1.96218cm
3.38639cm
2.26048cm
2.48375cm
1.12916cm
true
true
Szerelősor-Dátum-Műszakrend-Műszak
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Állásidő
Textbox525
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
...és aránya
Textbox116
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Termelés
Textbox4
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Szünet/Termelés
Textbox16
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Szünet
Textbox23
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Felfüggesztve
Textbox26
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Táblák
Textbox86
#4c68a2
Middle
2pt
2pt
2pt
2pt
true
true
Korbácsok
Textbox92
#4c68a2
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!MACHINENAME.Value & " (" & Fields!AssemblyLineId.Value & ")"
#9eb6e4
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox129
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox87
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox93
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTDATE.Value
1
#c6daf8
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox130
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox88
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox94
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTSYSTEMNAME.Value
2
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox131
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox89
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox95
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTNAME.Value
3
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox132
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox90
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox96
#e6eefc
2pt
2pt
2pt
2pt
0.6cm
true
true
Összesen
Textbox536
#7292cc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DOWNTIME.Value) \ 3600 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!DOWNTIME.Value) MOD 60)
Textbox559
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Str(100*Round(SUM(Fields!DOWNTIME.Value)/(SUM(Fields!PRODUCTIONTIME.Value) +SUM(Fields!OVERPRODUCTIONTIME.Value) +SUM(Fields!BREAKTIME.Value) +SUM(Fields!DOWNTIME.Value)),2)) & " %"
Textbox133
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!PRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!PRODUCTIONTIME.Value) MOD 60)
Textbox12
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!OVERPRODUCTIONTIME.Value) \ 3600 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!OVERPRODUCTIONTIME.Value) MOD 60)
Textbox20
#e6eefc
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!BREAKTIME.Value) \ 3600 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 3600)\60 & ":" & (SUM(Fields!BREAKTIME.Value) MOD 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUSPENDEDTIME.Value) \ 3600 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUSPENDEDTIME.Value) Mod 60)
Textbox27
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMCYCLES.Value)
Textbox91
#e6eefc
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMPRODCOUNT.Value)
Textbox97
#e6eefc
2pt
2pt
2pt
2pt
=Fields!AssemblyLineId.Value
=Fields!MACHINENAME.Value
=Fields!SHIFTDATE.Value
=Fields!SHIFTDATE.Value
=Fields!SHIFTSYSTEMNAME.Value
=Fields!SHIFTSYSTEMNAME.Value
After
=Fields!SHIFTNAME.Value
=Fields!SHIFTNAME.Value
=(Parameters!UNFOLDALL.Value="false")
SHIFTSYSTEMNAME33
=(Parameters!UNFOLDALL.Value="false")
SHIFTSTART33
=(Parameters!UNFOLDALL.Value="false")
ASLINE33
Tablix3Fejléc
true
DataSet1
15.70214cm
0.16002cm
4.12916cm
27.97955cm
8
true
true
Kattintson ide az SQLTEXT megnyitásához / eltűntetéséhez!
2.57436cm
0.16002cm
0.6cm
27.97955cm
9
2pt
2pt
2pt
2pt
true
true
=Parameters!SQLTEXT.Value
Textbox1
3.35075cm
0.16005cm
3.39965cm
27.97952cm
10
true
SQLTEXTMegnyitás
2pt
2pt
2pt
2pt
true
true
Gyár:
=Parameters!SITENAME.Value
Textbox223
0.28901cm
22.75562cm
0.6cm
5.38395cm
11
2pt
2pt
2pt
2pt
198.313mm
WhiteSmoke
283.8416mm
13.95853mm
true
true
true
true
Műszak-idő felhasználás riport
Title
ReportTitle
1.5875mm
0.16002cm
10.16mm
279.79553mm
2pt
2pt
2pt
2pt
WhiteSmoke
14.71848mm
true
true
true
true
Riport futási ideje:
=Globals!ExecutionTime
ExecutionTime
1.76389mm
1.6002mm
6.35mm
105.9193mm
2pt
2pt
2pt
2pt
true
true
Lapok száma:
=Globals!PageNumber
PageNumber
1.76389mm
172.8661mm
6mm
61.08737mm
1
2pt
2pt
2pt
2pt
true
true
=Globals!TotalPages
TotalPages
2.11387mm
241.84383mm
6mm
25mm
2
2pt
2pt
2pt
2pt
true
true
/
Textbox7
2.11387mm
235.71744mm
6mm
4.3625mm
3
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
Cm
ca7aa9be-65e4-4d1c-8177-0ccdfbc36420