Files
xml_to_json/ceshi1/报表附件/预制基础明细表.rptx
chentianrui 4459270336 上传文件
2025-10-21 11:34:54 +08:00

138 lines
13 KiB
XML

<?xml version="1.0" encoding="UTF-8"?>
<ReportCfg>
<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>
<conditionFilter ConditionType="公式条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="" LeftProperty="" LeftShowName="" RightValue="" FormulaValue="if(G2==0 or G2==&quot;&quot;){1}" ConditionName="过滤空行" DataSrcFilter="0" ResultFilter="1" delRow="0" delRowContainRef="1" PagingTag="0"/>
<conditionFilter ConditionType="普通条件" ValueType="字符串" JoinOperator="并且" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属组件分类名称]" LeftShowName="" RightValue="底盘" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
<conditionFilter ConditionType="普通条件" ValueType="字符串" JoinOperator="或者" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属组件分类名称]" LeftShowName="" RightValue="卡盘" FormulaValue="" ConditionName="" DataSrcFilter="1" ResultFilter="0"/>
<conditionFilter ConditionType="普通条件" ValueType="字符串" JoinOperator="或者" GroupName="第1组" CompareOperator="等于" LeftProperty="[所属组件分类名称]" LeftShowName="" RightValue="拉线盘" 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/>
<summary type="普通方式汇总" formula="" commSumName="" commSum=""/>
<sorts/>
</rowConfig>
</RowConfigs>
<rows freezingRow="-1" freezingCol="-1" startRow="0" startCol="-1">
<cells rowNum="0" 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>
<cell col="7" 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="=SEQ(&quot;组件序号&quot;,1)" 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="if([所属组件分类名称]==&quot;底盘&quot; or [所属组件分类名称]==&quot;卡盘&quot;){[每基块数]}&#10;else if([所属组件分类名称]==&quot;拉线盘&quot;){[每组块数]}&#10;" 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="if([所属组件分类名称]==&quot;底盘&quot; or [所属组件分类名称]==&quot;卡盘&quot;){[基数]}&#10;else if([所属组件分类名称]==&quot;拉线盘&quot;){[组数]}&#10;" 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="=D2*E2*F2" 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="25" HideRowHeight="25" AdaptiveRowHeight="true"/>
</rows>
<cols>
<col colNum="0" colWidth="126" hideColWidth="100" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="序号" Filed="序号"/>
<col colNum="1" colWidth="70" hideColWidth="100" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="基础名称" Filed="基础名称"/>
<col colNum="2" colWidth="56" hideColWidth="100" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="基础型式" Filed="基础型式"/>
<col colNum="3" colWidth="70" hideColWidth="100" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="组合块数" Filed="组合块数"/>
<col colNum="4" colWidth="44" hideColWidth="100" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="总基数" Filed="总基数"/>
<col colNum="5" colWidth="110" hideColWidth="100" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="每块重量" Filed="每块重量"/>
<col colNum="6" colWidth="68" hideColWidth="100" colFormat="1" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="总重" Filed="总重"/>
<col colNum="7" colWidth="30" hideColWidth="100" colFormat="2" numberType="0" AdaptiveColWidth="1" checkRate="0" headerFiled="备注" Filed="备注"/>
</cols>
<mergeCells/>
</ReportCfg>