0
SQL
Data Source=.\SQLExpress;Initial Catalog=LearALM
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!STARTFrom.Value
true
=Parameters!STARTTo.Value
true
true
RequestActive
true
RequestInfoEN
true
RequestTimeStamp
true
ClearInfoEN
true
ClearTimeStamp
true
DurationSEC
true
ProductionLineInfo
true
WorkStation
true
ShiftSystemName
true
ShiftName
true
ShiftDate
true
ShiftStart
true
ShiftEnd
true
TeamName
true
SupervisorInfo
true
RequestCode
true
ClearCode
true
10.23807cm
2.75204cm
3.87196cm
2.88311cm
0.6cm
true
true
="Shift system: "&Fields!ShiftSystemName.Value
ShiftSystemName1
#949a7e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox320
#949a7e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox352
#949a7e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox344
#949a7e
2pt
2pt
2pt
2pt
0.6cm
true
true
="Shift date: "&Fields!ShiftDate.Value
1
ShiftDate1
#aab292
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox326
#aab292
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox353
#aab292
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox345
#aab292
2pt
2pt
2pt
2pt
0.6cm
true
true
="Shift name: "&Fields!ShiftName.Value
2
ShiftName1
#b8c09e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox331
#b8c09e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox354
#b8c09e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox346
#b8c09e
2pt
2pt
2pt
2pt
0.6cm
true
true
=Fields!ProductionLineInfo.Value
3
ProductionLineInfo1
#b8c09e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox335
#b8c09e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox355
#b8c09e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox347
#b8c09e
2pt
2pt
2pt
2pt
0.6cm
true
true
="workplace #" & Fields!WorkStation.Value
4
WorkStation1
#b8c09e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
DurationSEC
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox356
#949a7e
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox348
#728586
2pt
2pt
2pt
2pt
0.6cm
true
true
Grand total
Textbox307
#728586
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox313
#728586
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox357
#728586
2pt
2pt
2pt
2pt
true
true
=SUM(Fields!DurationSEC.Value) \ 3600 & ":" & (SUM(Fields!DurationSEC.Value) MOD 3600)\60 & ":" & (SUM(Fields!DurationSEC.Value) MOD 60)
Textbox349
#728586
2pt
2pt
2pt
2pt
2.28479cm
true
true
Click on the + sign to open the blocks!
Textbox289
SlateGray
2pt
2pt
2pt
2pt
=Fields!RequestInfo.Value
=Fields!RequestInfo.Value
1.10271cm
true
true
=Fields!RequestInfo.Value
RequestInfo1
#949a7e
2pt
2pt
2pt
2pt
=Fields!ClearInfo.Value
=Fields!ClearInfo.Value
1.18208cm
true
true
=Fields!ClearInfo.Value
ClearInfo1
#aab292
2pt
2pt
2pt
2pt
true
RequestInfo1
1.18208cm
true
true
Total
Textbox351
#949a7e
2pt
2pt
2pt
2pt
RequestTotalCH
1.10271cm
true
true
Request
total
#728586
2pt
2pt
2pt
2pt
1.18208cm
true
true
Textbox343
#728586
2pt
2pt
2pt
2pt
=Fields!ShiftSystemName.Value
=Fields!ShiftSystemName.Value
=Fields!ShiftDate.Value
=Fields!ShiftDate.Value
=Fields!ShiftName.Value
=Fields!ShiftName.Value
=Fields!ProductionLineInfo.Value
=Fields!ProductionLineInfo.Value
After
=Fields!WorkStation.Value
=Fields!WorkStation.Value
=(Parameters!UNFOLDALL.Value="false")
ProductionLineInfo1
=(Parameters!UNFOLDALL.Value="false")
ShiftName1
=(Parameters!UNFOLDALL.Value="false")
ShiftDate1
=(Parameters!UNFOLDALL.Value="false")
ShiftSystemName1
DataSet1
7.32896cm
0.37697cm
5.88479cm
19.74518cm
true
true
Shiftsystem:
=Parameters!SHIFTSYSTEMNAME.Value
Textbox1
0.28901cm
0.37697cm
0.6cm
9.40563cm
1
2pt
2pt
2pt
2pt
true
true
Shift:
=Parameters!SHIFTNAME.Value
Textbox1
0.28901cm
10.34612cm
0.6cm
9.77604cm
2
2pt
2pt
2pt
2pt
true
true
Start of shift:
=Parameters!STARTFrom.Value
Textbox1
1.0654cm
0.37697cm
0.6cm
9.40563cm
3
2pt
2pt
2pt
2pt
true
true
--
Textbox10
1.0654cm
9.95396cm
0.6cm
0.39216cm
4
2pt
2pt
2pt
2pt
true
true
=Parameters!STARTTo.Value
Textbox1
1.0654cm
10.34612cm
0.6cm
9.77604cm
5
2pt
2pt
2pt
2pt
true
true
Assembly line:
=Parameters!PRODUCTIONLINE.Value
Textbox1
1.84179cm
0.37697cm
0.6cm
9.40563cm
6
2pt
2pt
2pt
2pt
true
true
Workplace:
=Parameters!WORKPLACE.Value
Textbox1
1.84179cm
10.34612cm
0.6cm
9.77604cm
7
2pt
2pt
2pt
2pt
true
true
Request:
=Parameters!REQUESTCODE.Value
Textbox1
2.61818cm
0.37697cm
0.6cm
9.40563cm
8
2pt
2pt
2pt
2pt
true
true
Clear:
=Parameters!CLEARCODE.Value
Textbox1
2.61818cm
10.34612cm
0.6cm
9.77604cm
9
2pt
2pt
2pt
2pt
true
true
Click here to display / hide SQLTEXT!
3.39457cm
0.37697cm
0.6cm
13.17332cm
10
2pt
2pt
2pt
2pt
true
true
=Parameters!SQLTEXT.Value
Textbox1
4.17096cm
0.377cm
2.89357cm
19.74516cm
11
true
SQLTEXTMegnyitás
2pt
2pt
2pt
2pt
true
true
Site:
=Parameters!SITENAME.Value
Textbox223
3.32401cm
14.47362cm
0.6cm
5.59562cm
12
2pt
2pt
2pt
2pt
132.1375mm
WhiteSmoke
203.45662mm
13.95853mm
true
true
true
true
Andon Log report (only cleared issues)
Title
ReportTitle
1.5875mm
0.3175cm
10.16mm
199.05212mm
2pt
2pt
2pt
2pt
WhiteSmoke
11.42992mm
true
true
true
true
Report time:
=Globals!ExecutionTime
ExecutionTime
5.07992mm
0mm
6.35mm
69.70191mm
2pt
2pt
2pt
2pt
true
true
Pages:
=Globals!PageNumber
PageNumber
5.42992mm
75.22929mm
6mm
58.44154mm
1
2pt
2pt
2pt
2pt
true
true
=Globals!TotalPages
TotalPages
5.07992mm
144.73619mm
6mm
25mm
2
2pt
2pt
2pt
2pt
true
true
/
Textbox7
5.42992mm
138.6098mm
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
PRODUCTIONLINE
String
true
true
WORKPLACE
String
true
true
REQUESTCODE
String
true
true
CLEARCODE
String
true
true
REQUESTACTIVE
String
UNFOLDALL
String
ReportParameter1
String
true
true
SITENAME
Cm
ca7aa9be-65e4-4d1c-8177-0ccdfbc36420