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 EnergyUsageAuto
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
0.599722cm true TextBox8 true =First(Fields!YearName.Value) true TextBox13 =Sum(Fields!D1.Value) true TextBox16 true TextBox19 true TextBox22 true TextBox25 true TextBox28 true TextBox31 true TextBox34 true TextBox37 true TextBox40 true TextBox43 true TextBox46 true TextBox10 true
=Fields!PriceTypeId.Value 56 Equal 1.799166cm0.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.64882cm1
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
Left <상수도>
0.55 0.55 0.55 None 4pt None 2pt Plot1 <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> X true None 4pt None 2pt Fields!MaxValue.Value 0 Plot1 <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> Y false false None 4pt None 2pt Plot2 <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> X false false true None 4pt None 2pt 50000 0 Plot2 Far <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> Y <Style> <FontSize>8pt</FontSize> </Style> Bottom Color <Style> <FontSize>8pt</FontSize> </Style> Bottom Shape <Style> <FontSize>8pt</FontSize> </Style> Bottom Size <Style> <FontSize>8pt</FontSize> </Style> 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
Left <하수도>
0.55 0.55 0.55 None 4pt None 2pt Plot1 <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> X true None 4pt None 2pt Fields!MaxValue.Value 0 Plot1 <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> Y false false None 4pt None 2pt Plot2 <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> X false false true None 4pt None 2pt 50000 0 Plot2 Far <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> Y <Style> <FontSize>8pt</FontSize> </Style> Bottom Color <Style> <FontSize>8pt</FontSize> </Style> Bottom Shape <Style> <FontSize>8pt</FontSize> </Style> Bottom Size <Style> <FontSize>8pt</FontSize> </Style> 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
Table511EnergyCostAuto
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
0.599444cm true true true true TextBox13 =Sum(Fields!D1.Value) true TextBox16 true TextBox19 true TextBox22 true TextBox25 true TextBox28 true TextBox31 true TextBox34 true TextBox37 true TextBox40 true TextBox43 true TextBox46 true TextBox10 true
1.818888cm0.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.8cm17.9cm12
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 EnergyUsageAuto
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.299722cm0.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
0.5cm 15 true TextBox133
=Fields!PriceTypeId.Value Ascending =Fields!PriceTypeId.Value true
0.6cm17.6cm2
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