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!TeamIdList.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
SHIFTNAME
System.String
PeriodeTypeNum
System.String
Count
System.Int32
TEAMID
System.String
DTRidandname
System.String
SUMTime
System.Int64
SUMSUMTime
System.Int64
MINTime
System.Int64
MAXTime
System.Int64
TEAMNAME
true
PeriodeTypeName
true
SUMTimeDT
true
TEAMINFO
true
5.94249cm
0.74025cm
3.63424cm
1.38317cm
1.61012cm
1.37199cm
1.94937cm
true
=Fields!SUMTime.Value
true
Állásidő kód
#333333
Middle
2pt
2pt
2pt
2pt
true
=Fields!Count.Value
true
DB
Textbox38
#333333
Middle
2pt
2pt
2pt
2pt
true
true
Time
Textbox5
1pt
1pt
1pt
1pt
#333333
Middle
2pt
2pt
2pt
2pt
true
true
Ratio
Textbox16
1pt
1pt
1pt
1pt
#333333
Middle
2pt
2pt
2pt
2pt
true
true
Min
Textbox4
1pt
1pt
1pt
1pt
#333333
Middle
2pt
2pt
2pt
2pt
true
true
Max
Textbox20
1pt
1pt
1pt
1pt
#333333
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!DTR.Value
DTR1
Black
1pt
Black
1pt
Black
1pt
Black
1pt
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=Fields!Count.Value
Count1
Black
1pt
Black
1pt
Black
1pt
Black
1pt
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=IIF(Fields!SUMTimeDT.Value < 0, "-", "") & Fields!SUMTime.Value \ 3600 & ":" & (Fields!SUMTime.Value Mod 3600) \ 60 & ":" & (Fields!SUMTime.Value Mod 60)
SUMTime2
Black
1pt
Black
1pt
Black
1pt
Black
1pt
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=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!MINTime.Value) \ 3600 & ":" & ((Fields!MINTime.Value) MOD 3600)\60 & ":" & ((Fields!MINTime.Value) MOD 60)
MINTime2
Black
1pt
Black
1pt
Black
1pt
Black
1pt
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=(Fields!MAXTime.Value) \ 3600 & ":" & ((Fields!MAXTime.Value) MOD 3600)\60 & ":" & ((Fields!MAXTime.Value) MOD 60)
MAXTime2
Black
1pt
Black
1pt
Black
1pt
Black
1pt
WhiteSmoke
2pt
2pt
2pt
2pt
0.6cm
true
true
Periódus összesen
Textbox54
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Textbox55
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
=IIF(Sum(Fields!SUMTimeDT.Value) < 0, "-", "") & Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!SUMTime.Value) Mod 60)
Textbox18
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
=Str(Round((Sum(Fields!SUMTime.Value) * 100) / Fields!SUMSUMTime.Value)) + "%"
Textbox57
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox58
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox61
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
0.6cm
true
true
szerelősor műszak-idő:
Textbox160
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox21
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)
Textbox18
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
100%
Textbox24
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox26
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox28
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
0.6cm
true
true
szerelősor állásidő:
Textbox18
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox23
LightGrey
2pt
2pt
2pt
2pt
true
true
=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)
Textbox242
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
=IIF(Fields!SUMTimeDT.Value < 0, "-", "") & Str(Round((ABS(Sum(Fields!SUMTimeDT.Value)) * 100) / Fields!SUMSUMTime.Value)) + "%"
Textbox30
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox31
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox32
LightGrey
2pt
2pt
2pt
2pt
0.6cm
true
true
Textbox51
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox43
1pt
1pt
1pt
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)
Textbox18
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox25
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox15
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox6
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
0.6cm
true
true
Textbox37
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox39
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
=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)
Textbox242
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
=IIF(Fields!SUMTimeDT.Value < 0, "-", "") & Str(Round((ABS(Sum(Fields!SUMTimeDT.Value)) * 100) / Fields!SUMSUMTime.Value)) + "%"
Textbox30
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox48
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox49
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
0.6cm
true
true
Textbox52
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox154
1pt
1pt
1pt
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)
Textbox18
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox156
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox157
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox158
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
0.6cm
true
true
Textbox66
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox69
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
=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)
Textbox242
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
=IIF(Fields!SUMTimeDT.Value < 0, "-", "") & Str(Round((ABS(Sum(Fields!SUMTimeDT.Value)) * 100) / Fields!SUMSUMTime.Value)) + "%"
Textbox30
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox72
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
true
true
Textbox73
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
2.62808cm
true
true
Műszak-rend
#333333
Middle
2pt
2pt
2pt
2pt
1.77757cm
true
true
Műszak
#333333
Middle
2pt
2pt
2pt
2pt
5.39cm
true
=Sum(Fields!SUMTimeDT.Value)
Team
true
Csapat
#333333
Middle
2pt
2pt
2pt
2pt
3.30484cm
true
=Sum(Fields!SUMTime.Value)
PeriodeType
true
Periódus típusa
#333333
Middle
2pt
2pt
2pt
2pt
After
true
=Fields!SHIFTSYSTEMNAME.Value
=Fields!SHIFTSYSTEMNAME.Value
2.62808cm
true
true
=Fields!SHIFTSYSTEMNAME.Value
Group1
Black
1pt
Black
1pt
Black
1pt
Black
1pt
WhiteSmoke
2pt
2pt
2pt
2pt
=Fields!SHIFTNAME.Value
=Fields!SHIFTNAME.Value
1.77757cm
true
true
=Fields!SHIFTNAME.Value
Group2
Black
1pt
Black
1pt
Black
1pt
Black
1pt
WhiteSmoke
2pt
2pt
2pt
2pt
=Fields!TEAMID.Value
=Fields!TEAMID.Value
5.39cm
true
true
=Fields!TEAMINFO.Value
WhiteSmoke
2pt
2pt
2pt
2pt
=Fields!PERIODETYPE.Value
=Fields!SUMTime.Value
3.30484cm
true
true
=Fields!PERIODETYPE.Value
Group4
Black
1pt
Black
1pt
Black
1pt
Black
1pt
WhiteSmoke
2pt
2pt
2pt
2pt
=Fields!SUMTime.Value
Descending
=IIF((CountRows("PeriodeType") = 1) or (Parameters!UNFOLDALL.Value="false"), True,False)
CHÁllásidő
Before
=(Parameters!UNFOLDALL.Value="false")
CHPeriódus
3.30484cm
true
true
Összesen
Textbox50
LightGrey
2pt
2pt
2pt
2pt
Before
3.30484cm
true
true
Összesen
Textbox8
LightGrey
2pt
2pt
2pt
2pt
Before
=(Parameters!UNFOLDALL.Value="false")
CHTeam
8.69484cm
true
true
Összesen műszak műszak-idő:
Textbox45
1pt
1pt
1pt
1pt
LightGrey
2pt
2pt
2pt
2pt
8.69484cm
true
true
Összesen műszak állásidő:
Textbox34
LightGrey
2pt
2pt
2pt
2pt
=(Parameters!UNFOLDALL.Value="false")
CHMűszak
10.47241cm
true
true
Összesen műszakrend műszak-idő:
Textbox150
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
Before
10.47241cm
true
true
Összesen műszakrend állásidő:
DTR2
Black
1pt
Black
1pt
Black
1pt
Black
1pt
LightGrey
2pt
2pt
2pt
2pt
Before
CHMuszakrend
true
DataSet1
Start
=Fields!PERIODETYPE.Value
NotEqual
Production
=Fields!PERIODETYPE.Value
NotEqual
Breaktime
6.985cm
0.19162cm
6.74937cm
27.78275cm
Lista1Megnyitas
Black
1pt
Black
1pt
Black
1pt
Black
1pt
true
true
Műszakrend:
=Parameters!SHIFTSYSTEMNAME.Value
Textbox1
0.28901cm
0.19162cm
0.6cm
10.755cm
1
2pt
2pt
2pt
2pt
true
true
Műszak:
=Parameters!SHIFTNAME.Value
Textbox1
0.28901cm
11.62162cm
0.6cm
10.755cm
2
2pt
2pt
2pt
2pt
true
true
Műszak kezdete:
=Parameters!STARTFrom.Value
Textbox1
1.98318cm
0.19162cm
0.6cm
10.755cm
3
2pt
2pt
2pt
2pt
true
true
--
Textbox10
1.98318cm
11.00334cm
0.6cm
0.35688cm
4
2pt
2pt
2pt
2pt
true
true
=Parameters!STARTTo.Value
Textbox1
1.98318cm
11.46605cm
0.6cm
10.755cm
5
2pt
2pt
2pt
2pt
true
true
Csapat:
=Parameters!TeamIdList.Value
Textbox1
1.17151cm
0.19162cm
0.6cm
10.755cm
6
2pt
2pt
2pt
2pt
true
true
Kattintson ide a tételes lista (csoportosítás: műszak -> csapat -> állásidő kód) megjelenítéséhez!
6.0325cm
0.19165cm
0.6cm
27.78274cm
7
2pt
2pt
2pt
2pt
true
true
Kattintson ide a keresgélős lista (csoportosítás: állásidő kód -> csapat -> műszak) megjelenítéséhez!
14.08879cm
0.19165cm
0.6cm
27.78274cm
8
2pt
2pt
2pt
2pt
12.92867cm
3.71352cm
5.74335cm
2.53041cm
2.86685cm
1.27028cm
true
true
Nyissa meg a részletekért!
Textbox27
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Hányszor fordult elő
Textbox12
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Időtartam
Textbox13
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Min hossz
Textbox19
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Max hossz
Textbox22
#384c70
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=IIF(Fields!DTR.Value = "","Nem adtak meg kódot",Fields!DTR.Value )
DTR
#949a7e
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Textbox59
#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
Textbox60
#949a7e
2pt
2pt
2pt
2pt
true
true
Textbox92
#949a7e
2pt
2pt
2pt
2pt
true
true
Textbox93
#949a7e
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!TEAMINFO.Value
1
#aab292
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Textbox67
#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
Textbox68
#aab292
2pt
2pt
2pt
2pt
true
true
Textbox94
#aab292
2pt
2pt
2pt
2pt
true
true
Textbox95
#aab292
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTSYSTEMNAME.Value
2
SHIFTSYSTEMNAME
#b8c09e
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Textbox74
#b8c09e
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) Mod 3600) \ 60 & ":" & Sum(Fields!SUMTime.Value) Mod 60
Textbox75
#b8c09e
2pt
2pt
2pt
2pt
true
true
Textbox96
#b8c09e
2pt
2pt
2pt
2pt
true
true
Textbox97
#b8c09e
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTNAME.Value
3
SHIFTNAME
#b8c09e
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Count
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=Fields!SUMTime.Value \ 3600 & ":" & (Fields!SUMTime.Value Mod 3600) \ 60 & ":" & Fields!SUMTime.Value Mod 60
SUMTime
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!MINTime.Value) \ 3600 & ":" & (Sum(Fields!MINTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!MINTime.Value) Mod 60)
MINTime
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!MAXTime.Value) \ 3600 & ":" & (SUM(Fields!MAXTime.Value) MOD 3600)\60 & ":" & (SUM(Fields!MAXTime.Value) MOD 60)
MAXTime
WhiteSmoke
2pt
2pt
2pt
2pt
0.6cm
true
true
Total
Textbox35
#728586
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Textbox42
#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
Textbox44
#728586
2pt
2pt
2pt
2pt
true
true
Textbox98
#728586
2pt
2pt
2pt
2pt
true
true
Textbox99
#728586
2pt
2pt
2pt
2pt
=Fields!DTR.Value
=Fields!DTR.Value
=Fields!TEAMID.Value
=Fields!TEAMID.Value
=Fields!SHIFTSYSTEMNAME.Value
=Fields!SHIFTSYSTEMNAME.Value
After
=Fields!SHIFTNAME.Value
=Fields!SHIFTNAME.Value
=(Parameters!UNFOLDALL.Value="false")
SHIFTSYSTEMNAME
=(Parameters!UNFOLDALL.Value="false")
TeamId1
=(Parameters!UNFOLDALL.Value="false")
DTR
true
DataSet1
Start
=Fields!PERIODETYPE.Value
NotEqual
Production
=Fields!PERIODETYPE.Value
NotEqual
Breaktime
14.86518cm
0.19162cm
4.27028cm
27.7828cm
9
true
Lista2Megnyitas
true
true
Kattintson ide az SQLTEXT megnyitásához / eltűntetéséhez!
2.74273cm
0.19162cm
0.6cm
27.78275cm
10
2pt
2pt
2pt
2pt
true
true
=Parameters!SQLTEXT.Value
Textbox1
3.51912cm
0.19165cm
2.22194cm
27.78277cm
11
true
SQLTEXTMegnyitás
2pt
2pt
2pt
2pt
true
true
Gyár:
=Parameters!SITENAME.Value
Textbox223
0.28901cm
22.57555cm
0.6cm
5.39882cm
12
2pt
2pt
2pt
2pt
true
true
Kattintson ide a keresgélős lista (csoportosítás: csapat -> állásidő kód -> műszak) megjelenítéséhez!
19.50394cm
0.19165cm
0.6cm
27.78272cm
13
2pt
2pt
2pt
2pt
12.93981cm
3.72466cm
5.74642cm
2.53041cm
2.8668cm
1.27028cm
true
true
Nyissa meg a részletekért!
Textbox27
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Number of occurences
Textbox12
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Időtartam
Textbox13
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Min hossz
Textbox19
#384c70
Middle
2pt
2pt
2pt
2pt
true
true
Max hossz
Textbox22
#384c70
Middle
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!TEAMINFO.Value
#949a7e
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Textbox59
#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
Textbox60
#949a7e
2pt
2pt
2pt
2pt
true
true
Textbox92
#949a7e
2pt
2pt
2pt
2pt
true
true
Textbox93
#949a7e
2pt
2pt
2pt
2pt
0.6cm
true
true
=IIF(Fields!DTR.Value = "", "Nem adtak meg kódot", Fields!DTR.Value)
1
#aab292
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Textbox67
#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
Textbox68
#aab292
2pt
2pt
2pt
2pt
true
true
Textbox94
#aab292
2pt
2pt
2pt
2pt
true
true
Textbox95
#aab292
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTSYSTEMNAME.Value
2
SHIFTSYSTEMNAME
#b8c09e
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Textbox74
#b8c09e
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!SUMTime.Value) \ 3600 & ":" & (Sum(Fields!SUMTime.Value) Mod 3600) \ 60 & ":" & Sum(Fields!SUMTime.Value) Mod 60
Textbox75
#b8c09e
2pt
2pt
2pt
2pt
true
true
Textbox96
#b8c09e
2pt
2pt
2pt
2pt
true
true
Textbox97
#b8c09e
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!SHIFTNAME.Value
3
SHIFTNAME
#b8c09e
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Count
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=Fields!SUMTime.Value \ 3600 & ":" & (Fields!SUMTime.Value Mod 3600) \ 60 & ":" & Fields!SUMTime.Value Mod 60
SUMTime
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!MINTime.Value) \ 3600 & ":" & (Sum(Fields!MINTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!MINTime.Value) Mod 60)
MINTime
WhiteSmoke
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!MAXTime.Value) \ 3600 & ":" & (Sum(Fields!MAXTime.Value) Mod 3600) \ 60 & ":" & (Sum(Fields!MAXTime.Value) Mod 60)
MAXTime
WhiteSmoke
2pt
2pt
2pt
2pt
0.6cm
true
true
Total
Textbox35
#728586
2pt
2pt
2pt
2pt
true
true
=Sum(Fields!Count.Value)
Textbox42
#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
Textbox44
#728586
2pt
2pt
2pt
2pt
true
true
Textbox98
#728586
2pt
2pt
2pt
2pt
true
true
Textbox99
#728586
2pt
2pt
2pt
2pt
=Fields!TEAMID.Value
=Fields!TEAMID.Value
=Fields!DTR.Value
=Fields!DTR.Value
=Fields!SHIFTSYSTEMNAME.Value
=Fields!SHIFTSYSTEMNAME.Value
After
=Fields!SHIFTNAME.Value
=Fields!SHIFTNAME.Value
=(Parameters!UNFOLDALL.Value = "false")
SHIFTSYSTEMNAME2
=(Parameters!UNFOLDALL.Value = "false")
DTR3
=(Parameters!UNFOLDALL.Value = "false")
TeamId3
true
DataSet1
=Fields!PERIODETYPE.Value
NotEqual
Production
=Fields!PERIODETYPE.Value
NotEqual
Breaktime
20.31145cm
0.16627cm
4.27028cm
27.8081cm
14
true
Lista2Megnyitas2
245.81731mm
WhiteSmoke
281.47938mm
23.48353mm
true
true
true
true
Műszak-idő felhasználás és Állásidő lekérdezés
(teamre majd állásidő okra részletezve)
Title
ReportTitle
1.5875mm
0.3491cm
20.13215mm
276.25287mm
2pt
2pt
2pt
2pt
WhiteSmoke
14.60491mm
true
true
true
true
Riport futási idő :
=Globals!ExecutionTime
ExecutionTime
5.07987mm
1.91616mm
6.35mm
69.70191mm
2pt
2pt
2pt
2pt
true
true
Lapok száma:
=Globals!PageNumber
PageNumber
5.07987mm
182.97164mm
6mm
60.82279mm
1
2pt
2pt
2pt
2pt
true
true
=Globals!TotalPages
TotalPages
5.07987mm
251.68479mm
6mm
25mm
2
2pt
2pt
2pt
2pt
true
true
/
Textbox7
5.07987mm
255.0834mm
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
TeamIdList
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