# <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style>

EnergyUsageGasWater3.rdlx
<ColumnSpacing>1cm</ColumnSpacing> <Height>27cm</Height> <ReportItems> <CanGrow>true</CanGrow> <Height>1.2cm</Height> <Left>0.2cm</Left> <Value>="현대해상 " & First(Fields!Name.Value) & "사옥"</Value>
<Top>0.2cm</Top> <Width>17.4cm</Width> <CanGrow>true</CanGrow> <DataElementName>TextBox10</DataElementName> <Height>0.6cm</Height> <Left>0.2cm</Left> <Value>5.2 도시가스 및 상하수도 사용량 및 단가 분석</Value>
<Top>2.394905cm</Top> <Width>10.2cm</Width> <ZIndex>8</ZIndex> <Type>BandedList</Type> <Top>13.2cm</Top> <Left>0.2cm</Left> <Width>17.8cm</Width> <Height>2.7438cm</Height> <ZIndex>7</ZIndex> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox511</DataElementName> <Height>0.47cm</Height> <Left>14.46739cm</Left> <Value>(단위:t)</Value>
<Top>0.07cm</Top> <Width>3.1794cm</Width> <ZIndex>10</ZIndex> <CanGrow>true</CanGrow> <DataElementName>TextBox510</DataElementName> <Height>0.4cm</Height> <Left>0.067388cm</Left> <Value>▶상하수도 사용량</Value>
<Top>0.07cm</Top> <Width>4.8cm</Width> <ZIndex>10</ZIndex>

<DataSetName>EnergyUsage</DataSetName> <DetailDataElementOutput>Auto</DetailDataElementOutput>
<TableRows> <TableRow> <Height>0.599722cm</Height> <TableCells> <TableCell> True Always <ReportItems> <DataElementName>TextBox5</DataElementName> <Value>=IIF(Fields!PriceCodeName.Value = "상수도사용량", "상수도", "하수도")</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!YearName.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox12</DataElementName> <Value>=Fields!D1.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox15</DataElementName> <Value>=Fields!D2.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox18</DataElementName> <Value>=Fields!D3.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox21</DataElementName> <Value>=Fields!D4.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox24</DataElementName> <Value>=Fields!D5.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!D6.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox30</DataElementName> <Value>=Fields!D7.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox33</DataElementName> <Value>=Fields!D8.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox36</DataElementName> <Value>=Fields!D9.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox39</DataElementName> <Value>=Fields!D10.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox42</DataElementName> <Value>=Fields!D11.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox45</DataElementName> <Value>=Fields!D12.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox7</DataElementName> <Value>=Fields!Total.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> </TableRows>
<Filters> <Filter> <FilterExpression>=Fields!PriceTypeId.Value</FilterExpression> <FilterValues> <FilterValue>56</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> </Filters> <Height>1.799166cm</Height> <Left>0.046786cm</Left>
<TableColumns> <TableColumn> <Width>0.6cm</Width> </TableColumn> <TableColumn> <Width>1.8cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> <TableColumn> <Width>1.172986cm</Width> </TableColumn> </TableColumns> <Width>17.64882cm</Width> <ZIndex>1</ZIndex>

</ReportItems> <CustomData> <DataSetName>EnergyUsage</DataSetName> <DataRowGroupings> <DataGroupings> <DataGrouping /> </DataGroupings> </DataRowGroupings> </CustomData> <HeaderBand> <Height>0.6cm</Height> <ReportItems> </ReportItems>
</HeaderBand> <FooterBand> <Height>1.93998cm</Height> <ReportItems> </ReportItems>
</FooterBand> <Groups />
<Height>0.203852cm</Height>
<Visibility> <Hidden>True</Hidden> </Visibility>
<Type>BandedList</Type> <Top>16cm</Top> <Left>0.2cm</Left> <Width>6.8cm</Width> <Height>6.626cm</Height> <ZIndex>11</ZIndex> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox512</DataElementName> <Height>0.47cm</Height> <Value><상수도></Value>
<Top>0.05669643cm</Top> <Width>4.8cm</Width> <ZIndex>1</ZIndex> <DataSetName>EnergyUsageGraph2</DataSetName> <Value>1</Value> <Height>5.3562cm</Height> <DisplayTypeSelector>false</DisplayTypeSelector> <Left>0.12cm</Left>
<Bar> <TopWidth>0.55</TopWidth> <BottomWidth>0.55</BottomWidth> <Width>0.55</Width> </Bar> <PlotArea>
<Axes> <Axis> <AxisLine>
</AxisLine> <Labels>
</Labels> <MajorGrid>
</MajorGrid> <MinorGrid>
</MinorGrid> <MajorTicks>
<TickMark>None</TickMark> <Size>4pt</Size> </MajorTicks> <MinorTicks>
<TickMark>None</TickMark> <Size>2pt</Size> </MinorTicks> <Plots> <Plot>Plot1</Plot> </Plots>
<Text>
</Text> <Type>X</Type> </Axis> <Axis> <AxisLine>
</AxisLine> <Labels>
</Labels> <MajorGrid>
<Visible>true</Visible> </MajorGrid> <MinorGrid>
</MinorGrid> <MajorTicks>
<TickMark>None</TickMark> <Size>4pt</Size> </MajorTicks> <MinorTicks>
<TickMark>None</TickMark> <Size>2pt</Size> </MinorTicks> <Max>Fields!MaxValue.Value</Max> <Min>0</Min> <Plots> <Plot>Plot1</Plot> </Plots>
<Text>
</Text> <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Type>Y</Type> </Axis> <Axis> <AxisLine>
<Visible>false</Visible> </AxisLine> <Labels>
<Visible>false</Visible> </Labels> <MajorGrid>
</MajorGrid> <MinorGrid>
</MinorGrid> <MajorTicks>
<TickMark>None</TickMark> <Size>4pt</Size> </MajorTicks> <MinorTicks>
<TickMark>None</TickMark> <Size>2pt</Size> </MinorTicks> <Plots> <Plot>Plot2</Plot> </Plots>
<Text>
</Text> <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Type>X</Type> </Axis> <Axis> <AxisLine>
<Visible>false</Visible> </AxisLine> <Labels>
<Visible>false</Visible> </Labels> <MajorGrid>
<Visible>true</Visible> </MajorGrid> <MinorGrid>
</MinorGrid> <MajorTicks>
<TickMark>None</TickMark> <Size>4pt</Size> </MajorTicks> <MinorTicks>
<TickMark>None</TickMark> <Size>2pt</Size> </MinorTicks> <Max>50000</Max> <Min>0</Min> <Plots> <Plot>Plot2</Plot> </Plots> <Position>Far</Position>
<Text>
</Text> <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Type>Y</Type> </Axis> </Axes> <Legends>
<Style> <FontSize>8pt</FontSize> </Style> <Text>
</Text> <Position>Bottom</Position> <Type>Color</Type>
<Style> <FontSize>8pt</FontSize> </Style> <Text>
</Text> <Position>Bottom</Position> <Type>Shape</Type>
<Style> <FontSize>8pt</FontSize> </Style> <Text>
</Text> <Position>Bottom</Position> <Type>Size</Type> </Legends> </PlotArea>
<Text>
</Text> <Style> <FontSize>8pt</FontSize> </Style> <Palette>Office</Palette> <Plots> <Plot> <Type>Line</Type> <Name>Plot1</Name> <PlotChartType>Line</PlotChartType> <Config> <LineAspect>Spline</LineAspect>
<Symbols>
<Visible>true</Visible> </Symbols> <Text> <ConnectingLine>
</ConnectingLine>
</Text> <Tooltip /> </Config> <Encodings> <Values> <Value> <Value> <FieldItem>=ToInt32 (Fields!Value.Value)</FieldItem> </Value> </Value> </Values> <Category> <Field> <Value> <FieldItem>=Fields!Day.Value</FieldItem> </Value> <SortingField>=""</SortingField> </Category> <Color> <Field> <Value> <FieldItem>=Fields!LineName.Value</FieldItem> </Value> <Aggregate>List</Aggregate> </Color> <Shape> <Field> <Value /> <Aggregate>None</Aggregate> </Shape> <Size> <Field> <Value /> <Aggregate>None</Aggregate> </Size> </Encodings> </Plot> <Plot> <Type>Line</Type> <Name>Plot2</Name> <PlotChartType>Line</PlotChartType> <Config> <LineAspect>Spline</LineAspect>
<Symbols>
<Visible>true</Visible> </Symbols> <Text> <ConnectingLine>
</ConnectingLine>
</Text> <Tooltip /> </Config> <Encodings> <Values> <Value> <Value> <FieldItem>=ToInt32(Fields!LastValue.Value)</FieldItem> </Value> </Value> </Values> <Category> <Field> <Value> <FieldItem>=Fields!Day.Value</FieldItem> </Value> <SortingField>=""</SortingField> </Category> <Color> <Field> <Value> <FieldItem>=Fields!LineLastName.Value</FieldItem> </Value> <Aggregate>List</Aggregate> </Color> <Shape> <Field> <Value /> <Aggregate>None</Aggregate> </Shape> <Size> <Field> <Value /> <Aggregate>None</Aggregate> </Size> </Encodings> </Plot> </Plots> <Top>0.2218999cm</Top> <Width>6.56cm</Width> <ZIndex>1</ZIndex> </ReportItems> <CustomData> <DataSetName>EnergyUsageGraph</DataSetName> <DataRowGroupings> <DataGroupings> <DataGrouping /> </DataGroupings> </DataRowGroupings> </CustomData> <HeaderBand> <Height>0.591277cm</Height> <ReportItems> </ReportItems>
<Visibility> <Hidden>True</Hidden> </Visibility> </HeaderBand> <FooterBand> <Height>5.8cm</Height> <ReportItems> </ReportItems>
</FooterBand> <Groups />
<Height>0.234699cm</Height>
<Visibility> <Hidden>True</Hidden> </Visibility>
<Type>BandedList</Type> <Top>16cm</Top> <Left>7.353451cm</Left> <Width>6.8cm</Width> <Height>6.6146cm</Height> <ZIndex>11</ZIndex> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox512</DataElementName> <Height>0.47cm</Height> <Value><하수도></Value>
<Top>0.05669643cm</Top> <Width>4.8cm</Width> <ZIndex>1</ZIndex> <DataSetName>EnergyUsageGraph3</DataSetName> <Value>1</Value> <Height>5.3562cm</Height> <DisplayTypeSelector>false</DisplayTypeSelector> <Left>0.12cm</Left>
<Bar> <TopWidth>0.55</TopWidth> <BottomWidth>0.55</BottomWidth> <Width>0.55</Width> </Bar> <PlotArea>
<Axes> <Axis> <AxisLine>
</AxisLine> <Labels>
</Labels> <MajorGrid>
</MajorGrid> <MinorGrid>
</MinorGrid> <MajorTicks>
<TickMark>None</TickMark> <Size>4pt</Size> </MajorTicks> <MinorTicks>
<TickMark>None</TickMark> <Size>2pt</Size> </MinorTicks> <Plots> <Plot>Plot1</Plot> </Plots>
<Text>
</Text> <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Type>X</Type> </Axis> <Axis> <AxisLine>
</AxisLine> <Labels>
</Labels> <MajorGrid>
<Visible>true</Visible> </MajorGrid> <MinorGrid>
</MinorGrid> <MajorTicks>
<TickMark>None</TickMark> <Size>4pt</Size> </MajorTicks> <MinorTicks>
<TickMark>None</TickMark> <Size>2pt</Size> </MinorTicks> <Max>Fields!MaxValue.Value</Max> <Min>0</Min> <Plots> <Plot>Plot1</Plot> </Plots>
<Text>
</Text> <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Type>Y</Type> </Axis> <Axis> <AxisLine>
<Visible>false</Visible> </AxisLine> <Labels>
<Visible>false</Visible> </Labels> <MajorGrid>
</MajorGrid> <MinorGrid>
</MinorGrid> <MajorTicks>
<TickMark>None</TickMark> <Size>4pt</Size> </MajorTicks> <MinorTicks>
<TickMark>None</TickMark> <Size>2pt</Size> </MinorTicks> <Plots> <Plot>Plot2</Plot> </Plots>
<Text>
</Text> <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Type>X</Type> </Axis> <Axis> <AxisLine>
<Visible>false</Visible> </AxisLine> <Labels>
<Visible>false</Visible> </Labels> <MajorGrid>
<Visible>true</Visible> </MajorGrid> <MinorGrid>
</MinorGrid> <MajorTicks>
<TickMark>None</TickMark> <Size>4pt</Size> </MajorTicks> <MinorTicks>
<TickMark>None</TickMark> <Size>2pt</Size> </MinorTicks> <Max>50000</Max> <Min>0</Min> <Plots> <Plot>Plot2</Plot> </Plots> <Position>Far</Position>
<Text>
</Text> <Style> <FontSize>8pt</FontSize> <PaddingBottom>2pt</PaddingBottom> <PaddingLeft>2pt</PaddingLeft> <PaddingRight>2pt</PaddingRight> <PaddingTop>2pt</PaddingTop> </Style> <Type>Y</Type> </Axis> </Axes> <Legends>
<Style> <FontSize>8pt</FontSize> </Style> <Text>
</Text> <Position>Bottom</Position> <Type>Color</Type>
<Style> <FontSize>8pt</FontSize> </Style> <Text>
</Text> <Position>Bottom</Position> <Type>Shape</Type>
<Style> <FontSize>8pt</FontSize> </Style> <Text>
</Text> <Position>Bottom</Position> <Type>Size</Type> </Legends> </PlotArea>
<Text>
</Text> <Style> <FontSize>8pt</FontSize> </Style> <Palette>Office</Palette> <Plots> <Plot> <Type>Line</Type> <Name>Plot1</Name> <PlotChartType>Line</PlotChartType> <Config> <LineAspect>Spline</LineAspect>
<Symbols>
<Visible>true</Visible> </Symbols> <Text> <ConnectingLine>
</ConnectingLine>
</Text> <Tooltip /> </Config> <Encodings> <Values> <Value> <Value> <FieldItem>=ToInt32 (Fields!Value.Value)</FieldItem> </Value> </Value> </Values> <Category> <Field> <Value> <FieldItem>=Fields!Day.Value</FieldItem> </Value> <SortingField>=""</SortingField> </Category> <Color> <Field> <Value> <FieldItem>=Fields!LineName.Value</FieldItem> </Value> <Aggregate>List</Aggregate> </Color> <Shape> <Field> <Value /> <Aggregate>None</Aggregate> </Shape> <Size> <Field> <Value /> <Aggregate>None</Aggregate> </Size> </Encodings> </Plot> <Plot> <Type>Line</Type> <Name>Plot2</Name> <PlotChartType>Line</PlotChartType> <Config> <LineAspect>Spline</LineAspect>
<Symbols>
<Visible>true</Visible> </Symbols> <Text> <ConnectingLine>
</ConnectingLine>
</Text> <Tooltip /> </Config> <Encodings> <Values> <Value> <Value> <FieldItem>=ToInt32(Fields!LastValue.Value)</FieldItem> </Value> </Value> </Values> <Category> <Field> <Value> <FieldItem>=Fields!Day.Value</FieldItem> </Value> <SortingField>=""</SortingField> </Category> <Color> <Field> <Value> <FieldItem>=Fields!LineLastName.Value</FieldItem> </Value> <Aggregate>List</Aggregate> </Color> <Shape> <Field> <Value /> <Aggregate>None</Aggregate> </Shape> <Size> <Field> <Value /> <Aggregate>None</Aggregate> </Size> </Encodings> </Plot> </Plots> <Top>0.214545cm</Top> <Width>6.56cm</Width> <ZIndex>1</ZIndex> </ReportItems> <CustomData> <DataSetName>EnergyUsageGraph</DataSetName> <DataRowGroupings> <DataGroupings> <DataGrouping /> </DataGroupings> </DataRowGroupings> </CustomData> <HeaderBand> <Height>0.593652cm</Height> <ReportItems> </ReportItems>
<Visibility> <Hidden>True</Hidden> </Visibility> </HeaderBand> <FooterBand> <Height>5.78529cm</Height> <ReportItems> </ReportItems>
</FooterBand> <Groups />
<Height>0.235642cm</Height>
<Visibility> <Hidden>True</Hidden> </Visibility>

<DataElementName>Table511</DataElementName> <DataSetName>EnergyCost</DataSetName> <DetailDataElementOutput>Auto</DetailDataElementOutput>
<TableRows> <TableRow> <Height>0.62cm</Height> <TableCells> <TableCell> True Restricted <ReportItems> <Value>=Fields!PriceTypeName.Value</Value>
</ReportItems> </TableCell> <TableCell> True Restricted <ReportItems> <Value>=Fields!PriceCodeName.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!YearName.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox12</DataElementName> <Value>=Fields!D1.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox15</DataElementName> <Value>=Fields!D2.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox18</DataElementName> <Value>=Fields!D3.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox21</DataElementName> <Value>=Fields!D4.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox24</DataElementName> <Value>=Fields!D5.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox27</DataElementName> <Value>=Fields!D6.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox30</DataElementName> <Value>=Fields!D7.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox33</DataElementName> <Value>=Fields!D8.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox36</DataElementName> <Value>=Fields!D9.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox39</DataElementName> <Value>=Fields!D10.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox42</DataElementName> <Value>=Fields!D11.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox45</DataElementName> <Value>=Fields!D12.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox7</DataElementName> <Value>=Fields!Total.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> </TableRows>
<Height>1.818888cm</Height> <Left>0.2cm</Left>
<TableColumns> <TableColumn> <Width>0.700481cm</Width> </TableColumn> <TableColumn> <Width>0.700481cm</Width> </TableColumn> <TableColumn> <Width>1.50103cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.15079cm</Width> </TableColumn> <TableColumn> <Width>1.200824cm</Width> </TableColumn> </TableColumns> <Top>23.8cm</Top> <Width>17.9cm</Width> <ZIndex>12</ZIndex>

<CanGrow>true</CanGrow> <DataElementName>TextBox51</DataElementName> <Height>0.47cm</Height> <Left>0.191088cm</Left> <Value>▶단가변동현황</Value>
<Top>23.2cm</Top> <Width>4.8cm</Width> <ZIndex>13</ZIndex> <CanGrow>true</CanGrow> <DataElementName>TextBox511</DataElementName> <Height>0.47cm</Height> <Left>14.66218cm</Left> <Value>(단위:KW)</Value>
<Top>23.2cm</Top> <Width>3.1794cm</Width> <ZIndex>14</ZIndex> <Type>BandedList</Type> <Top>3.2cm</Top> <Left>0.2116667cm</Left> <Width>17.8cm</Width> <Height>9.4cm</Height> <ZIndex>16</ZIndex> <CustomData> <DataSetName>EnergyUsage</DataSetName> <Filters> <Filter> <FilterExpression>=Fields!FuelTypeId.Value</FilterExpression> <FilterValues> <FilterValue>3</FilterValue> </FilterValues> <Operator>NotEqual</Operator> </Filter> </Filters> <DataRowGroupings> <DataGroupings> <DataGrouping> <GroupExpressions> <GroupExpression>=Fields!FuelTypeId.Value</GroupExpression> </GroupExpressions> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox6</DataElementName> <Height>0.4cm</Height> <Left>0.046786cm</Left> <Value>=IIF( Fields!FuelTypeId.Value = 4, "▶ 등유 사용량", IIF( Fields!FuelTypeId.Value = 5, "▶ LPG 사용량", IIF( Fields!FuelTypeId.Value = 6, "▶ 중온수 사용량", "▶ 도시가스 사용량")</Value>
<Top>0.1322917cm</Top> <Width>4.8cm</Width> <ZIndex>1</ZIndex>

<DataSetName>EnergyUsage</DataSetName> <DetailDataElementOutput>Auto</DetailDataElementOutput>
<TableRows> <TableRow> <Height>0.599722cm</Height> <TableCells> <TableCell> <ColSpan>2</ColSpan> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox58</DataElementName> <Value>=Fields!YearName.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox60</DataElementName> <Value>=Fields!D1.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox61</DataElementName> <Value>=Fields!D2.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox62</DataElementName> <Value>=Fields!D3.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox63</DataElementName> <Value>=Fields!D4.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox64</DataElementName> <Value>=Fields!D5.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox65</DataElementName> <Value>=Fields!D6.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox66</DataElementName> <Value>=Fields!D7.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox67</DataElementName> <Value>=Fields!D8.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox68</DataElementName> <Value>=Fields!D9.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox69</DataElementName> <Value>=Fields!D10.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox70</DataElementName> <Value>=Fields!D11.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox71</DataElementName> <Value>=Fields!D12.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox73</DataElementName> <Value>=Fields!Total.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> </TableRows>
<Filters> <Filter> <FilterExpression>=Fields!FuelTypeId.Value</FilterExpression> <FilterValues> <FilterValue>=Fields!FuelTypeId.Value</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> </Filters> <Height>2.299722cm</Height> <Left>0.046786cm</Left>
<TableColumns> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> <TableColumn> <Width>1.173333cm</Width> </TableColumn> </TableColumns> <TableGroups> <TableGroup>
<GroupExpressions> <GroupExpression>=Fields!PriceTypeId.Value</GroupExpression> </GroupExpressions> <Sorting> <SortBy> <Direction>Ascending</Direction> <SortExpression>=Fields!PriceTypeId.Value</SortExpression> </SortBy> </Sorting> true </TableGroup> </TableGroups> <Top>0.6cm</Top> <Width>17.6cm</Width> <ZIndex>2</ZIndex>

<Type>BandedList</Type> <Top>3.2cm</Top> <Width>17.8cm</Width> <Height>5.8657cm</Height> <ZIndex>3</ZIndex> <CustomData> <DataSetName>EnergyUsage</DataSetName> <Filters> <Filter> <FilterExpression>=Fields!FuelTypeId.Value</FilterExpression> <FilterValues> <FilterValue>=Fields!FuelTypeId.Value</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> <Filter> <FilterExpression>=Fields!Sort.Value</FilterExpression> <FilterValues> <FilterValue>1</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> </Filters> <DataRowGroupings> <DataGroupings> <DataGrouping> <ReportItems> <Height>5.6cm</Height> <Left>0.04678601cm</Left> <Parameters> <Value>=Parameters!SiteId.Value</Value> <Value>=Parameters!Year.Value</Value> <Value>=Parameters!Month.Value</Value> <Value>=Parameters!ApiUrl.Value</Value> <Value>=Fields!PriceTypeId.Value</Value> </Parameters> <ReportName>EnergyUsageGasWaterGraph.rdlx</ReportName> <Top>0.05cm</Top> <Width>17.6cm</Width> <ZIndex>1</ZIndex> </ReportItems> </DataGrouping> </DataGroupings> </DataRowGroupings> </CustomData> <HeaderBand> <Height>0cm</Height> <CanGrow>false</CanGrow>
<Visibility> <Hidden>True</Hidden> </Visibility> </HeaderBand> <FooterBand> <Height>0cm</Height>
<Visibility> <Hidden>True</Hidden> </Visibility> </FooterBand> <Groups />
<Height>5.865663cm</Height> <ReportItems> </ReportItems>
</ReportItems> <DataGroupings> <DataGrouping /> </DataGroupings> </DataGrouping> </DataGroupings> </DataRowGroupings> </CustomData> <HeaderBand> <Height>0cm</Height>
<Visibility> <Hidden>True</Hidden> </Visibility> </HeaderBand> <FooterBand> <Height>0cm</Height>
<Visibility> <Hidden>True</Hidden> </Visibility> </FooterBand> <Groups> <HeaderBand> <Height>9.4cm</Height> <KeepTogether>false</KeepTogether> <ReportItems> </ReportItems>
</HeaderBand> <FooterBand> <Height>0cm</Height>
<Visibility> <Hidden>True</Hidden> </Visibility> </FooterBand> <Visibility> <Hidden>False</Hidden> </Visibility> </Groups>
<Height>0cm</Height>
<Visibility> <Hidden>True</Hidden> </Visibility>
</ReportItems>
<BottomMargin>2.5cm</BottomMargin> <LeftMargin>1.5cm</LeftMargin> <PageHeight>29.7cm</PageHeight> <PageWidth>21cm</PageWidth> <RightMargin>1cm</RightMargin> <TopMargin>2.5cm</TopMargin> <Width>23.30551cm</Width> <ReportParameters> <DataType>String</DataType> <Prompt>SiteId</Prompt> <DefaultValue> <Values> <Value>115</Value> </Values> </DefaultValue> <DataType>String</DataType> <Prompt>Month</Prompt> <DefaultValue> <Values> <Value>7</Value> </Values> </DefaultValue> <DataType>String</DataType> <Prompt>Year</Prompt> <DefaultValue> <Values> <Value>2020</Value> </Values> </DefaultValue> <DataType>String</DataType> <Prompt>ApiUrl</Prompt> <DefaultValue> <Values> <Value>http://api.ezwork.kr/api</Value> </Values> </DefaultValue> </ReportParameters> <DataSources> <ConnectionProperties> <ConnectString>="jsondoc=" & Parameters!ApiUrl.Value & "/app/MonthlyReport/GetJson?siteId=" & Parameters!SiteId.Value & "&month=" & Parameters!Month.Value & "&year=" & Parameters!Year.Value & "&tabName=Building"</ConnectString> <DataProvider>JSON</DataProvider> </ConnectionProperties> <ConnectionProperties> <ConnectString>="jsondoc=" & Parameters!ApiUrl.Value & "/app/MonthlyReport/GetJson?siteId=" & Parameters!SiteId.Value & "&month=" & Parameters!Month.Value & "&year=" & Parameters!Year.Value & "&tabName=EnergyUsageGasWater"</ConnectString> <DataProvider>JSON</DataProvider> </ConnectionProperties> </DataSources> <DataSets> <Fields> <DataField>SiteId</DataField> <DataField>Name</DataField> <DataField>PhoneNo</DataField> <DataField>AddressZip1</DataField> <DataField>CompletionDate</DataField> <DataField>Address1</DataField> <DataField>BuildingSize</DataField> <DataField>GrossArea</DataField> <DataField>BuildingArea</DataField> <DataField>FloorAreaRatio</DataField> <DataField>BuildingCoverageRatio</DataField> <DataField>MainUse</DataField> <DataField>Standard</DataField> <DataField>Url</DataField> <DataField>ImageFile.FileId</DataField> <DataField>ImageFile.Name</DataField> <DataField>ImageFile.FileCategoryId</DataField> <DataField>ImageFile.FileSize</DataField> <DataField>ImageFile.ContentType</DataField> <DataField>ImageFile.Path</DataField> <DataField>ImageFile.Url</DataField> <DataField>DesignSupervision</DataField> <DataField>ConstructionCompany</DataField> <DataField>ConstructionPeriod</DataField> <DataField>Structure</DataField> <DataField>LobbyFloor</DataField> <DataField>OfficeFloor</DataField> <DataField>ToiletFloor</DataField> <DataField>EVHall</DataField> <DataField>ParkingLot</DataField> <DataField>ParkingFacilities</DataField> <DataField>OuterWall</DataField> <DataField>LandArea</DataField> <DataField>LandscapingArea</DataField> <DataField>BuildingFloors</DataField> <DataField>BuildingHeight</DataField> <DataField>ConversionRate</DataField> <DataField>AuditoriumFacilities</DataField> </Fields> <Query> <CommandText>$.Building.SiteInfo</CommandText> <DataSourceName>FMS</DataSourceName> </Query> <Fields> <DataField>Type</DataField> <DataField>FuelTypeId</DataField> <DataField>PriceTypeId</DataField> <DataField>YearName</DataField> <DataField>PriceTypeName</DataField> <DataField>PriceCode</DataField> <DataField>PriceCodeName</DataField> <DataField>IsTypeFirst</DataField> <DataField>Sort</DataField> <DataField>Total</DataField> <DataField>D1</DataField> <DataField>D2</DataField> <DataField>D3</DataField> <DataField>D4</DataField> <DataField>D5</DataField> <DataField>D6</DataField> <DataField>D7</DataField> <DataField>D8</DataField> <DataField>D9</DataField> <DataField>D10</DataField> <DataField>D11</DataField> <DataField>D12</DataField> </Fields> <Query> <CommandText>$.EnergyUsageGasWater.EnergyUsage[*]</CommandText> <DataSourceName>EnergyUsageGasWater</DataSourceName> </Query> <Fields> <DataField>FuelTypeId</DataField> <DataField>Title</DataField> <DataField>TitleId</DataField> <DataField>PriceCode</DataField> <DataField>TabType</DataField> <DataField>LineName</DataField> <DataField>LineLastName</DataField> <DataField>Day</DataField> <DataField>Value</DataField> <DataField>LastValue</DataField> <DataField>MaxValue</DataField> <DataField>MinValue</DataField> </Fields> <Query> <CommandText>$.EnergyUsageGasWater.EnergyUsageGraph[*]</CommandText> <DataSourceName>EnergyUsageGasWater</DataSourceName> </Query> <Fields> <DataField>Type</DataField> <DataField>FuelTypeId</DataField> <DataField>PriceTypeId</DataField> <DataField>YearName</DataField> <DataField>PriceTypeName</DataField> <DataField>PriceCode</DataField> <DataField>PriceCodeName</DataField> <DataField>IsTypeFirst</DataField> <DataField>Sort</DataField> <DataField>Total</DataField> <DataField>D1</DataField> <DataField>D2</DataField> <DataField>D3</DataField> <DataField>D4</DataField> <DataField>D5</DataField> <DataField>D6</DataField> <DataField>D7</DataField> <DataField>D8</DataField> <DataField>D9</DataField> <DataField>D10</DataField> <DataField>D11</DataField> <DataField>D12</DataField> </Fields> <Query> <CommandText>$.EnergyUsageGasWater.EnergyCost[*]</CommandText> <DataSourceName>EnergyUsageGasWater</DataSourceName> </Query> <Fields> <DataField>FuelTypeId</DataField> <DataField>Title</DataField> <DataField>TitleId</DataField> <DataField>PriceCode</DataField> <DataField>TabType</DataField> <DataField>LineName</DataField> <DataField>LineLastName</DataField> <DataField>Day</DataField> <DataField>Value</DataField> <DataField>LastValue</DataField> <DataField>MaxValue</DataField> <DataField>MinValue</DataField> </Fields> <Filters> <Filter> <FilterExpression>=Fields!PriceCode.Value</FilterExpression> <FilterValues> <FilterValue>W007</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> </Filters> <Query> <CommandText>$.EnergyUsageGasWater.EnergyUsageGraph[*]</CommandText> <DataSourceName>EnergyUsageGasWater</DataSourceName> </Query> <Fields> <DataField>FuelTypeId</DataField> <DataField>Title</DataField> <DataField>TitleId</DataField> <DataField>PriceCode</DataField> <DataField>TabType</DataField> <DataField>LineName</DataField> <DataField>LineLastName</DataField> <DataField>Day</DataField> <DataField>Value</DataField> <DataField>LastValue</DataField> <DataField>MaxValue</DataField> <DataField>MinValue</DataField> </Fields> <Filters> <Filter> <FilterExpression>=Fields!PriceCode.Value</FilterExpression> <FilterValues> <FilterValue>W007</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> </Filters> <Query> <CommandText>$.EnergyUsageGasWater.EnergyUsageGraph[*]</CommandText> <DataSourceName>EnergyUsageGasWater</DataSourceName> </Query> <Fields> <DataField>FuelTypeId</DataField> <DataField>Title</DataField> <DataField>TitleId</DataField> <DataField>PriceCode</DataField> <DataField>TabType</DataField> <DataField>LineName</DataField> <DataField>LineLastName</DataField> <DataField>Day</DataField> <DataField>Value</DataField> <DataField>LastValue</DataField> <DataField>MaxValue</DataField> <DataField>MinValue</DataField> </Fields> <Filters> <Filter> <FilterExpression>=Fields!PriceCode.Value</FilterExpression> <FilterValues> <FilterValue>W008</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> </Filters> <Query> <CommandText>$.EnergyUsageGasWater.EnergyUsageGraph[*]</CommandText> <DataSourceName>EnergyUsageGasWater</DataSourceName> </Query> </DataSets>