building.rdlx
<ColumnSpacing>0.5cm</ColumnSpacing> <Height>29cm</Height> <ReportItems> <CanGrow>true</CanGrow> <Height>1.2cm</Height> <Left>2.714602cm</Left> <Value>="현대해상 " & First(Fields!Name.Value) & "사옥"</Value>
<Top>0.2cm</Top> <Width>13.2cm</Width> <CanGrow>true</CanGrow> <Height>0.6cm</Height> <Left>0.2cm</Left> <Value>1. 빌딩개요</Value>
<Top>1.6cm</Top> <Width>4.8cm</Width> <ZIndex>1</ZIndex>

<DataSetName>SiteInfo</DataSetName>
<TableRows> <TableRow> <Height>0.547029cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>소재지</Value>
</ReportItems> </TableCell> <TableCell> <ColSpan>5</ColSpan> <ReportItems> <CanGrow>true</CanGrow> <Value>="도로명 : " & Fields!Address1.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.547029cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>설계/감리</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!DesignSupervision.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>시공사명</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!ConstructionCompany.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>공사기간</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!ConstructionPeriod.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.547029cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>준공일자</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!CompletionDate.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>용도</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!MainUse.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>구조</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!Structure.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.547029cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>로비바닥</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!LobbyFloor.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>사무실바닥</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!OfficeFloor.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>화장실바닥</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!ToiletFloor.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.547029cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>E/V 홀</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!EVHall.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>주차장</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!ParkingLot.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>외벽</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!OuterWall.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.547029cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>대지면적</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!LandArea.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>건축면적</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!BuildingArea.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>연면적</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!GrossArea.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.547029cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>조경면적</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!LandscapingArea.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>건물층수</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!BuildingFloors.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>건고</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!BuildingHeight.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.547029cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>건폐율</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!BuildingCoverageRatio.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>용적율</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!FloorAreaRatio.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>전용율</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!ConversionRate.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.547029cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>주차장시설</Value>
</ReportItems> </TableCell> <TableCell> <ColSpan>3</ColSpan> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!ParkingFacilities.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>강당시설</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!AuditoriumFacilities.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> </TableRows>
<Height>5.6cm</Height> <Left>0.6cm</Left>
<TableColumns> <TableColumn> <Width>2.429438cm</Width> </TableColumn> <TableColumn> <Width>3.405003cm</Width> </TableColumn> <TableColumn> <Width>2.429438cm</Width> </TableColumn> <TableColumn> <Width>3.648611cm</Width> </TableColumn> <TableColumn> <Width>2.430567cm</Width> </TableColumn> <TableColumn> <Width>3.648611cm</Width> </TableColumn> </TableColumns> <Top>3.4cm</Top> <Width>18cm</Width> <ZIndex>1</ZIndex>

<CanGrow>true</CanGrow> <Height>0.6cm</Height> <Left>0.2cm</Left> <Value>1.1 기본사항</Value>
<Top>2.6cm</Top> <Width>4.8cm</Width> <ZIndex>1</ZIndex> <CanGrow>true</CanGrow> <Height>0.6cm</Height> <Left>0.2cm</Left> <Value>1.2 설비개요</Value>
<Top>9.445625cm</Top> <Width>4.8cm</Width> <ZIndex>3</ZIndex>

<DataSetName>FacilityStandards</DataSetName>
<TableRows> <TableRow> <Height>0.488095cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!Name.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!Standard.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!Stock.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!ServiceType.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!Manufacturer.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!ManufactureDate.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!Comment.Value</Value>
</ReportItems> </TableCell> </TableCells> <Visibility> <Hidden>=iif(Fields!Name.Value="기타설비",true,false)</Hidden> </Visibility> </TableRow> <TableRow> <Height>0.488095cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>기타설비</Value>
</ReportItems> </TableCell> <TableCell> <ColSpan>6</ColSpan> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!Comment.Value</Value>
</ReportItems> </TableCell> </TableCells> <Visibility> <Hidden>=iif( Fields!Name.Value = "기타설비",false,true)</Hidden> </Visibility> </TableRow> </TableRows>
<Height>1.6cm</Height> <Left>0.6cm</Left>
<TableColumns> <TableColumn> <Width>1.944857cm</Width> </TableColumn> <TableColumn> <Width>1.944857cm</Width> </TableColumn> <TableColumn> <Width>1.215246cm</Width> </TableColumn> <TableColumn> <Width>1.944857cm</Width> </TableColumn> <TableColumn> <Width>1.944857cm</Width> </TableColumn> <TableColumn> <Width>2.431265cm</Width> </TableColumn> <TableColumn> <Width>6.565731cm</Width> </TableColumn> </TableColumns> <Top>10.23938cm</Top> <Width>18cm</Width> <ZIndex>2</ZIndex>

<Type>BandedList</Type> <Top>12.30313cm</Top> <Left>0.2cm</Left> <Width>18.6cm</Width> <Height>4.0018cm</Height> <ZIndex>4</ZIndex> <ReportItems> <CanGrow>true</CanGrow> <Height>0.6cm</Height> <Value>1.3 임대기준</Value>
<Top>0.2cm</Top> <Width>4.8cm</Width> <ZIndex>1</ZIndex> </ReportItems> <CustomData> <DataSetName>SiteInfo</DataSetName> <DataRowGroupings> <DataGroupings> <DataGrouping> <ReportItems>

<DataSetName>RentalStandards</DataSetName>
<TableRows> <TableRow> <Height>0.598668cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!Name.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!FirstFloorDeposit.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!StandardFloorDeposit.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!AdministrativeExpenses.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!RegularParking.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!AnyTimeParking.Value</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <Value>=Fields!Comment.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> </TableRows>
<Height>1.8cm</Height> <Left>0.4cm</Left> <TableColumns> <TableColumn> <Width>1.943009cm</Width> </TableColumn> <TableColumn> <Width>2.671702cm</Width> </TableColumn> <TableColumn> <Width>2.671702cm</Width> </TableColumn> <TableColumn> <Width>2.428805cm</Width> </TableColumn> <TableColumn> <Width>2.914601cm</Width> </TableColumn> <TableColumn> <Width>2.671702cm</Width> </TableColumn> <TableColumn> <Width>2.690145cm</Width> </TableColumn> </TableColumns> <Top>0.2cm</Top> <Width>18cm</Width> <ZIndex>1</ZIndex>

</ReportItems> </DataGrouping> </DataGroupings> </DataRowGroupings> </CustomData> <HeaderBand> <Height>1.000666cm</Height> <ReportItems> </ReportItems>
</HeaderBand> <FooterBand> <Height>0.199289cm</Height>
</FooterBand> <Groups />
<Height>2.801867cm</Height> <ReportItems> </ReportItems>

<DataSetName>Approver</DataSetName> <Value>1234</Value>
<TableRows> <TableRow> <Height>0.47466cm</Height> <TableCells> <TableCell> 3 <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox4</DataElementName> <Value>결 재</Value>
</ReportItems> </TableCell> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox5</DataElementName> <Value>=Fields!GroupNm0.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>1.650682cm</Height> <TableCells> <TableCell> <ReportItems> <DataElementName>Image2</DataElementName> <Sizing>Fit</Sizing> External
<Value>=Fields!image0.Value</Value> Center </ReportItems> </TableCell> </TableCells> </TableRow> <TableRow> <Height>0.47466cm</Height> <TableCells> <TableCell> <ReportItems> <CanGrow>true</CanGrow> <DataElementName>TextBox8</DataElementName> <Value>=Fields!Date0.Value</Value>
</ReportItems> </TableCell> </TableCells> </TableRow> </TableRows>
<Height>2.6cm</Height> <Left>16cm</Left>
<TableColumns> <TableColumn> <Width>0.764566cm</Width> </TableColumn> <TableColumn> <Width>1.835433cm</Width> </TableColumn> </TableColumns> <Top>0.2cm</Top> <Width>2.6cm</Width> <ZIndex>8</ZIndex>

</ReportItems>
<BottomMargin>1cm</BottomMargin> <LeftMargin>1cm</LeftMargin> <PageHeight>29.7cm</PageHeight> <PageWidth>21cm</PageWidth> <RightMargin>1cm</RightMargin> <TopMargin>1cm</TopMargin> <Width>21.8cm</Width> <ReportParameters> <DataType>String</DataType> <Prompt>SiteId</Prompt> <DefaultValue> <Values> <Value>102</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> </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>Name</DataField> <DataField>Standard</DataField> <DataField>Stock</DataField> <DataField>ServiceType</DataField> <DataField>Manufacturer</DataField> <DataField>ManufactureDate</DataField> <DataField>Comment</DataField> </Fields> <Query> <CommandText>$.Building.FacilityStandards[*]</CommandText> <DataSourceName>FMS</DataSourceName> </Query> <Fields> <DataField>Name</DataField> <DataField>FirstFloorDeposit</DataField> <DataField>StandardFloorDeposit</DataField> <DataField>AdministrativeExpenses</DataField> <DataField>RegularParking</DataField> <DataField>AnyTimeParking</DataField> <DataField>Comment</DataField> </Fields> <Query> <CommandText>$.Building.RentalStandards[*]</CommandText> <DataSourceName>FMS</DataSourceName> </Query> <Fields> <DataField>Approver[0].GroupNm</DataField> <DataField>Approver[1].GroupNm</DataField> <DataField>Approver[2].GroupNm</DataField> <DataField>Approver[0].Date</DataField> <DataField>Approver[1].Date</DataField> <DataField>Approver[2].Date</DataField> <DataField>Approver[0].image</DataField> <DataField>Approver[1].image</DataField> <DataField>Approver[2].image</DataField> </Fields> <Query> <CommandText>$.Building</CommandText> <DataSourceName>FMS</DataSourceName> </Query> </DataSets>