energyChargeGasWater.rdlx
<ColumnSpacing>1cm</ColumnSpacing> <Height>12.4cm</Height> <ReportItems> <CanGrow>true</CanGrow> <Height>1.2cm</Height> <Left>0.2cm</Left> <Value>="현대해상 " & First(Fields!Name.Value, "SiteInfo") & "사옥"</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.3 요금분석</Value>
<Top>1.8cm</Top> <Width>6.8cm</Width> <ZIndex>8</ZIndex> <DataSetName>EnergyChargeGroup</DataSetName> <Height>8.7238cm</Height> <Left>0.2cm</Left> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox51</DataElementName> <Height>0.47cm</Height> <Value>="* " & Fields!PriceTypeName.Value</Value>
<Top>0.2cm</Top> <Width>4.8cm</Width> <ZIndex>11</ZIndex> <Height>5.5238cm</Height> <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> <Value>=Fields!PriceTypeName.Value</Value> </Parameters> <ReportName>energyChargeGasWaterGraph.rdlx</ReportName> <Top>3cm</Top> <Width>8.6cm</Width> <ZIndex>13</ZIndex> <DataSetName>EnergyAnalysis</DataSetName> <Filters> <Filter> <FilterExpression>=ToInt32(Fields!PriceTypeId.Value)</FilterExpression> <FilterValues> <FilterValue>=ToInt32(Fields!PriceTypeId.Value)</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> </Filters> <Height>5.5196cm</Height> <Left>8.8cm</Left> <ReportItems> <CanGrow>true</CanGrow> <Height>5.2cm</Height> <Left>0.08695cm</Left> <Value>=Fields!Content.Value</Value>
<Top>0.2cm</Top> <Width>8.83685cm</Width> <ZIndex>16</ZIndex> </ReportItems> <Top>3cm</Top> <Width>9cm</Width> <ZIndex>14</ZIndex>

<DataSetName>EnergyCharge</DataSetName> <DetailDataElementOutput>Auto</DetailDataElementOutput>
<TableRows> <TableRow> <Height>0.599722cm</Height> <TableCells> <TableCell> <ColSpan>2</ColSpan> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox5</DataElementName> <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>
<Filters> <Filter> <FilterExpression>=Fields!PriceTypeId.Value</FilterExpression> <FilterValues> <FilterValue>=Fields!PriceTypeId.Value</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> </Filters> <Height>1.8cm</Height>
<TableColumns> <TableColumn> <Width>0.623596cm</Width> </TableColumn> <TableColumn> <Width>0.623596cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> <TableColumn> <Width>1.273293cm</Width> </TableColumn> </TableColumns> <Top>0.8cm</Top> <Width>17.8cm</Width> <ZIndex>12</ZIndex>

</ReportItems> <Top>2.8cm</Top> <Width>17.94703cm</Width> <ZIndex>15</ZIndex> </ReportItems>
<BottomMargin>2.5cm</BottomMargin> <LeftMargin>1.5cm</LeftMargin> <PageHeight>29.7cm</PageHeight> <PageWidth>21cm</PageWidth> <RightMargin>1cm</RightMargin> <TopMargin>2.5cm</TopMargin> <Width>18.4cm</Width> <ReportParameters> <DataType>String</DataType> <Prompt>SiteId</Prompt> <DefaultValue> <Values> <Value>115</Value> </Values> </DefaultValue> <DataType>String</DataType> <Prompt>Year</Prompt> <DefaultValue> <Values> <Value>2020</Value> </Values> </DefaultValue> <DataType>String</DataType> <Prompt>Month</Prompt> <DefaultValue> <Values> <Value>07</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 & "&addDate=" & Parameters!Year.Value & "-" & Parameters!Month.Value & "&tabName=Building"</ConnectString> <DataProvider>JSON</DataProvider> </ConnectionProperties> <ConnectionProperties> <ConnectString>="jsondoc=" & Parameters!ApiUrl.Value & "/app/MonthlyReport/GetJson?siteId=" & Parameters!SiteId.Value & "&addDate=" & Parameters!Year.Value & "-" & Parameters!Month.Value & "&tabName=EnergyChargeGasWater"</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>$.EnergyChargeGasWater.EnergyCharge[*]</CommandText> <DataSourceName>EnergyChargeGasWater</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> </Fields> <Filters> <Filter> <FilterExpression>=Fields!Sort.Value</FilterExpression> <FilterValues> <FilterValue>1</FilterValue> </FilterValues> <Operator>Equal</Operator> </Filter> </Filters> <Query> <CommandText>$.EnergyChargeGasWater.EnergyCharge[*]</CommandText> <DataSourceName>EnergyChargeGasWater</DataSourceName> </Query> <Fields> <DataField>FuelTypeId</DataField> <DataField>PriceTypeId</DataField> <DataField>Content</DataField> </Fields> <Query> <CommandText>$.EnergyChargeGasWater.EnergyAnalysis[*]</CommandText> <DataSourceName>EnergyChargeGasWater</DataSourceName> </Query> </DataSets>