EnergyUsageGasWater3.rdlx
1cm
27cm
true
1.2cm
0.2cm
="현대해상 " & First(Fields!Name.Value) & "사옥"
0.2cm
17.4cm
true
TextBox10
0.6cm
0.2cm
5.2 도시가스 및 상하수도 사용량 및 단가 분석
2.394905cm
10.2cm
8
BandedList
13.2cm
0.2cm
17.8cm
2.7438cm
7
true
TextBox511
0.47cm
14.46739cm
(단위:t)
0.07cm
3.1794cm
10
true
TextBox510
0.4cm
0.067388cm
▶상하수도 사용량
0.07cm
4.8cm
10
EnergyUsage
Auto
0.599722cm
2
true
TextBox2
구 분
true
TextBox11
1월
true
TextBox14
2월
true
TextBox17
3월
true
TextBox20
4월
true
TextBox23
5월
true
TextBox26
6월
true
TextBox29
7월
true
TextBox32
8월
true
TextBox35
9월
true
TextBox38
10월
true
TextBox41
11월
true
TextBox44
12월
true
TextBox4
계
0.599722cm
True
Always
TextBox5
=IIF(Fields!PriceCodeName.Value = "상수도사용량", "상수도", "하수도")
true
=Fields!YearName.Value
true
TextBox12
=Fields!D1.Value
true
TextBox15
=Fields!D2.Value
true
TextBox18
=Fields!D3.Value
true
TextBox21
=Fields!D4.Value
true
TextBox24
=Fields!D5.Value
true
=Fields!D6.Value
true
TextBox30
=Fields!D7.Value
true
TextBox33
=Fields!D8.Value
true
TextBox36
=Fields!D9.Value
true
TextBox39
=Fields!D10.Value
true
TextBox42
=Fields!D11.Value
true
TextBox45
=Fields!D12.Value
true
TextBox7
=Fields!Total.Value
=Fields!PriceTypeId.Value
56
Equal
1.799166cm
0.046786cm
0.6cm
1.8cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
1.172986cm
17.64882cm
1
EnergyUsage
0.6cm
1.93998cm
0.203852cm
True
BandedList
16cm
0.2cm
6.8cm
6.626cm
11
true
TextBox512
0.47cm
<상수도>
0.05669643cm
4.8cm
1
EnergyUsageGraph2
1
5.3562cm
false
0.12cm
0.55
0.55
0.55
None
4pt
None
2pt
Plot1
X
true
None
4pt
None
2pt
Fields!MaxValue.Value
0
Plot1
Y
false
false
None
4pt
None
2pt
Plot2
X
false
false
true
None
4pt
None
2pt
50000
0
Plot2
Far
Y
Office
Line
Plot1
Line
Spline
true
=ToInt32 (Fields!Value.Value)
=Fields!Day.Value
=""
=Fields!LineName.Value
List
None
None
Line
Plot2
Line
Spline
true
=ToInt32(Fields!LastValue.Value)
=Fields!Day.Value
=""
=Fields!LineLastName.Value
List
None
None
0.2218999cm
6.56cm
1
EnergyUsageGraph
0.591277cm
True
5.8cm
0.234699cm
True
BandedList
16cm
7.353451cm
6.8cm
6.6146cm
11
true
TextBox512
0.47cm
<하수도>
0.05669643cm
4.8cm
1
EnergyUsageGraph3
1
5.3562cm
false
0.12cm
0.55
0.55
0.55
None
4pt
None
2pt
Plot1
X
true
None
4pt
None
2pt
Fields!MaxValue.Value
0
Plot1
Y
false
false
None
4pt
None
2pt
Plot2
X
false
false
true
None
4pt
None
2pt
50000
0
Plot2
Far
Y
Office
Line
Plot1
Line
Spline
true
=ToInt32 (Fields!Value.Value)
=Fields!Day.Value
=""
=Fields!LineName.Value
List
None
None
Line
Plot2
Line
Spline
true
=ToInt32(Fields!LastValue.Value)
=Fields!Day.Value
=""
=Fields!LineLastName.Value
List
None
None
0.214545cm
6.56cm
1
EnergyUsageGraph
0.593652cm
True
5.78529cm
0.235642cm
True
Table511
EnergyCost
Auto
0.599444cm
3
true
구분
true
TextBox11
1월
true
TextBox14
2월
true
TextBox17
3월
true
TextBox20
4월
true
TextBox23
5월
true
TextBox26
6월
true
TextBox29
7월
true
TextBox32
8월
true
TextBox35
9월
true
TextBox38
10월
true
TextBox41
11월
true
TextBox44
12월
true
TextBox4
평균
0.62cm
True
Restricted
=Fields!PriceTypeName.Value
True
Restricted
=Fields!PriceCodeName.Value
true
=Fields!YearName.Value
true
TextBox12
=Fields!D1.Value
true
TextBox15
=Fields!D2.Value
true
TextBox18
=Fields!D3.Value
true
TextBox21
=Fields!D4.Value
true
TextBox24
=Fields!D5.Value
true
TextBox27
=Fields!D6.Value
true
TextBox30
=Fields!D7.Value
true
TextBox33
=Fields!D8.Value
true
TextBox36
=Fields!D9.Value
true
TextBox39
=Fields!D10.Value
true
TextBox42
=Fields!D11.Value
true
TextBox45
=Fields!D12.Value
true
TextBox7
=Fields!Total.Value
1.818888cm
0.2cm
0.700481cm
0.700481cm
1.50103cm
1.15079cm
1.15079cm
1.15079cm
1.15079cm
1.15079cm
1.15079cm
1.15079cm
1.15079cm
1.15079cm
1.15079cm
1.15079cm
1.15079cm
1.200824cm
23.8cm
17.9cm
12
true
TextBox51
0.47cm
0.191088cm
▶단가변동현황
23.2cm
4.8cm
13
true
TextBox511
0.47cm
14.66218cm
(단위:KW)
23.2cm
3.1794cm
14
BandedList
3.2cm
0.2116667cm
17.8cm
9.4cm
16
EnergyUsage
=Fields!FuelTypeId.Value
3
NotEqual
=Fields!FuelTypeId.Value
true
TextBox6
0.4cm
0.046786cm
=IIF( Fields!FuelTypeId.Value = 4, "▶ 등유 사용량", IIF( Fields!FuelTypeId.Value = 5, "▶ LPG 사용량", IIF( Fields!FuelTypeId.Value = 6, "▶ 중온수 사용량", "▶ 도시가스 사용량")
0.1322917cm
4.8cm
1
EnergyUsage
Auto
0.599722cm
2
true
TextBox58
=Fields!YearName.Value
true
TextBox60
=Fields!D1.Value
true
TextBox61
=Fields!D2.Value
true
TextBox62
=Fields!D3.Value
true
TextBox63
=Fields!D4.Value
true
TextBox64
=Fields!D5.Value
true
TextBox65
=Fields!D6.Value
true
TextBox66
=Fields!D7.Value
true
TextBox67
=Fields!D8.Value
true
TextBox68
=Fields!D9.Value
true
TextBox69
=Fields!D10.Value
true
TextBox70
=Fields!D11.Value
true
TextBox71
=Fields!D12.Value
true
TextBox73
=Fields!Total.Value
=Fields!FuelTypeId.Value
=Fields!FuelTypeId.Value
Equal
2.299722cm
0.046786cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
1.173333cm
0.6cm
15
true
TextBox110
=First(Fields!PriceTypeName.Value)
0.6cm
2
true
TextBox72
구분
true
TextBox74
1월
true
TextBox75
2월
true
TextBox76
3월
true
TextBox77
4월
true
TextBox78
5월
true
TextBox79
6월
true
TextBox80
7월
true
TextBox81
8월
true
TextBox82
9월
true
TextBox83
10월
true
TextBox84
11월
true
TextBox85
12월
true
TextBox89
계
=Fields!PriceTypeId.Value
Ascending
=Fields!PriceTypeId.Value
true
0.6cm
17.6cm
2
BandedList
3.2cm
17.8cm
5.8657cm
3
EnergyUsage
=Fields!FuelTypeId.Value
=Fields!FuelTypeId.Value
Equal
=Fields!Sort.Value
1
Equal
5.6cm
0.04678601cm
=Parameters!SiteId.Value
=Parameters!Year.Value
=Parameters!Month.Value
=Parameters!ApiUrl.Value
=Fields!PriceTypeId.Value
EnergyUsageGasWaterGraph.rdlx
0.05cm
17.6cm
1
0cm
false
True
0cm
True
5.865663cm
0cm
True
0cm
True
9.4cm
false
0cm
True
False
0cm
True
2.5cm
1.5cm
29.7cm
21cm
1cm
2.5cm
23.30551cm
String
SiteId
115
String
Month
7
String
Year
2020
String
ApiUrl
http://api.ezwork.kr/api
="jsondoc=" & Parameters!ApiUrl.Value & "/app/MonthlyReport/GetJson?siteId=" & Parameters!SiteId.Value & "&month=" & Parameters!Month.Value & "&year=" & Parameters!Year.Value & "&tabName=Building"
JSON
="jsondoc=" & Parameters!ApiUrl.Value & "/app/MonthlyReport/GetJson?siteId=" & Parameters!SiteId.Value & "&month=" & Parameters!Month.Value & "&year=" & Parameters!Year.Value & "&tabName=EnergyUsageGasWater"
JSON
SiteId
Name
PhoneNo
AddressZip1
CompletionDate
Address1
BuildingSize
GrossArea
BuildingArea
FloorAreaRatio
BuildingCoverageRatio
MainUse
Standard
Url
ImageFile.FileId
ImageFile.Name
ImageFile.FileCategoryId
ImageFile.FileSize
ImageFile.ContentType
ImageFile.Path
ImageFile.Url
DesignSupervision
ConstructionCompany
ConstructionPeriod
Structure
LobbyFloor
OfficeFloor
ToiletFloor
EVHall
ParkingLot
ParkingFacilities
OuterWall
LandArea
LandscapingArea
BuildingFloors
BuildingHeight
ConversionRate
AuditoriumFacilities
$.Building.SiteInfo
FMS
Type
FuelTypeId
PriceTypeId
YearName
PriceTypeName
PriceCode
PriceCodeName
IsTypeFirst
Sort
Total
D1
D2
D3
D4
D5
D6
D7
D8
D9
D10
D11
D12
$.EnergyUsageGasWater.EnergyUsage[*]
EnergyUsageGasWater
FuelTypeId
Title
TitleId
PriceCode
TabType
LineName
LineLastName
Day
Value
LastValue
MaxValue
MinValue
$.EnergyUsageGasWater.EnergyUsageGraph[*]
EnergyUsageGasWater
Type
FuelTypeId
PriceTypeId
YearName
PriceTypeName
PriceCode
PriceCodeName
IsTypeFirst
Sort
Total
D1
D2
D3
D4
D5
D6
D7
D8
D9
D10
D11
D12
$.EnergyUsageGasWater.EnergyCost[*]
EnergyUsageGasWater
FuelTypeId
Title
TitleId
PriceCode
TabType
LineName
LineLastName
Day
Value
LastValue
MaxValue
MinValue
=Fields!PriceCode.Value
W007
Equal
$.EnergyUsageGasWater.EnergyUsageGraph[*]
EnergyUsageGasWater
FuelTypeId
Title
TitleId
PriceCode
TabType
LineName
LineLastName
Day
Value
LastValue
MaxValue
MinValue
=Fields!PriceCode.Value
W007
Equal
$.EnergyUsageGasWater.EnergyUsageGraph[*]
EnergyUsageGasWater
FuelTypeId
Title
TitleId
PriceCode
TabType
LineName
LineLastName
Day
Value
LastValue
MaxValue
MinValue
=Fields!PriceCode.Value
W008
Equal
$.EnergyUsageGasWater.EnergyUsageGraph[*]
EnergyUsageGasWater