chentianrui
218 lines
20 KiB
XML
218 lines
20 KiB
XML
<?xml version="1.0" encoding="UTF-8"?>
|
|
<ReportCfg templateVersion="1.0">
|
|
<GlobalFilters/>
|
|
<RowConfigs>
|
|
<rowConfig RowName="" DataSourceName="" RowType="标题行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList/>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="标题行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList/>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="辅助费用" DataSourceName="辅助费用" RowType="数据行" physicalRpt="项目划分" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="普通条件" ValueType="整型" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[输出]" LeftShowName="" RightValue="1" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
|
<conditionFilter ConditionType="普通条件" ValueType="小数" JoinOperator="或者" GroupName="第1组" CompareOperator="不等于" LeftProperty="[金额]" LeftShowName="" RightValue="0" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="" DataSourceName="" RowType="单行" physicalRpt="" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(G5==0){true}" ConditionName="小计为0时不输出此行" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
<rowConfig RowName="辅助费用" DataSourceName="辅助费用" RowType="单行" physicalRpt="项目划分" dsFilter="" varsFilter="" locateLabel="" datasetGroupExpression="" groupName="">
|
|
<commonFilterList/>
|
|
<conditionFilterList>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(G5==0){true}" ConditionName="小计为0不输出" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if([层级]==1){true}" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
|
|
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第2组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(G5==0){true}" ConditionName="小计为0时不输出小计行" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
|
|
</conditionFilterList>
|
|
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
|
|
<sorts/>
|
|
</rowConfig>
|
|
</RowConfigs>
|
|
<rows freezingRow="-1" freezingCol="-1" startRow="-1" startCol="-1">
|
|
<cells rowNum="0" rowHeight="27" HideRowHeight="0" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="文本" text="序号" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="文本" text="工程或费用名称" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="2" dataType="文本" text="计算参数" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="3" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="4" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="5" dataType="文本" text="编制依据及计算说明" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="6" dataType="文本" text="总价" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
<cells rowNum="1" rowHeight="27" HideRowHeight="25" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="2" dataType="文本" text="费用代码" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="3" dataType="文本" text="费用计算式" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="4" dataType="文本" text="费率" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="5" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="6" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
<cells rowNum="2" rowHeight="27" HideRowHeight="0" AdaptiveRowHeight="true">
|
|
<cell col="0" dataType="数据字段" text="" formual="" formualNode="" fieldName="[序号]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="1" dataType="数据字段" text="" formual="" formualNode="" fieldName="[名称]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="2" dataType="数据字段" text="" formual="" formualNode="" fieldName="[代码]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="3" dataType="数据字段" text="" formual="" formualNode="" fieldName="[取费基数替换变量]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="4" dataType="数据字段" text="" formual="" formualNode="" fieldName="[费率]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="5" dataType="数据字段" text="" formual="" formualNode="" fieldName="[编制依据]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="if([编制依据]!="" ){[编制依据] } else if([费率]==100 and [取费基数]!="") { ""&[取费基数替换变量]&"" } else if([费率]!=100 and [取费基数]!="") { "("&[取费基数替换变量]&")"&"*"&[费率]&"%" }" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[金额]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
<cells rowNum="3" rowHeight="34" HideRowHeight="0" AdaptiveRowHeight="true">
|
|
<cell col="1" dataType="文本" text="" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
<cells rowNum="4" rowHeight="27" HideRowHeight="0" AdaptiveRowHeight="true">
|
|
<cell col="1" dataType="文本" text="小计：" formual="" formualNode="" fieldName="" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
<cell col="6" dataType="数据字段" text="" formual="" formualNode="" fieldName="[金额]" fieldType="" numZeroShowEmpty="true" treeDataUpSum="false" leftBorder="false" rightBorder="false" topBorder="false" bottomBorder="false" AutoWrap="false">
|
|
<CellDataSet CellDataSetType="默认" collectFunction="">
|
|
<CellShowData ShowType="公式" formual="COLLECTNUM([金额])" commonFuntionName="" commonFuntion=""/>
|
|
</CellDataSet>
|
|
<CellFilters inheritFilter="0" inheritCellCol="0" inheritCellRow="0"/>
|
|
</cell>
|
|
</cells>
|
|
</rows>
|
|
<cols>
|
|
<col colNum="0" colWidth="44" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="序号" Filed="序号"/>
|
|
<col colNum="1" colWidth="96" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="工程或费用名称" Filed="工程或费用名称"/>
|
|
<col colNum="2" colWidth="56" hideColWidth="80" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="费用代码" Filed="计算参数.费用代码"/>
|
|
<col colNum="3" colWidth="122" hideColWidth="80" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="费用计算式" Filed="计算参数.费用计算式"/>
|
|
<col colNum="4" colWidth="56" hideColWidth="80" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="费率" Filed="计算参数.费率"/>
|
|
<col colNum="5" colWidth="122" hideColWidth="0" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="编制依据及计算说明" Filed="编制依据及计算说明"/>
|
|
<col colNum="6" colWidth="44" hideColWidth="0" colFormat="1" numberType="3" AdaptiveColWidth="1" checkRate="0" headerFiled="总价" Filed="总价"/>
|
|
</cols>
|
|
<mergeCells>
|
|
<mergeCell startRow="0" endRow="1" startCol="6" endCol="6"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="5" endCol="5"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="0" endCol="0"/>
|
|
<mergeCell startRow="0" endRow="1" startCol="1" endCol="1"/>
|
|
<mergeCell startRow="0" endRow="0" startCol="2" endCol="4"/>
|
|
</mergeCells>
|
|
</ReportCfg>
|