使用报表自带的导出excel功能，导出的excel文件有空白行

收藏

使用报表自带的导出excel功能，导出的excel文件有空白行。空白行高度为0，使用鼠标调整高度后可以看到，影响客户使用excel的统计等等操作。请问有谁知道怎么解决么？

KearneyKang · KearneyKang

能提供你报表的具体的报表文件吗，我这边看看你具体的设计样式

mumudu · mumudu

<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition">
<Body>
<Height>30cm</Height>
<ReportItems>
<Table Name="Table2">
<DataSetName>StaticsByInOutType</DataSetName>
<Header>
<RepeatOnNewPage>true</RepeatOnNewPage>
<TableRows>
<TableRow>
<Height>0.758467cm</Height>
<TableCells>
<TableCell>
<ColSpan>14</ColSpan>
<ReportItems>
<Textbox Name="TextBox2">
<CanGrow>true</CanGrow>
<Value>商品进销存分析</Value>
<Style>
<Color>Black</Color>
<FontFamily>新宋体</FontFamily>
<FontSize>14pt</FontSize>
<FontStyle>Normal</FontStyle>
<FontWeight>400</FontWeight>
<

addingBottom>2pt</PaddingBottom>
<

addingLeft>2pt</PaddingLeft>
<

addingRight>2pt</PaddingRight>
<

addingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.758467cm</Height>
<TableCells>
<TableCell>
<ColSpan>5</ColSpan>
<ReportItems>
<Textbox Name="TextBox135">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<

addingBottom>2pt</PaddingBottom>
<

addingLeft>2pt</PaddingLeft>
<

addingRight>2pt</PaddingRight>
<

addingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="TextBox140">
<CanGrow>true</CanGrow>
<Value>期初</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<

addingBottom>2pt</PaddingBottom>
<

addingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="TextBox142">
<CanGrow>true</CanGrow>
<Value>本期入</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="TextBox144">
<CanGrow>true</CanGrow>
<Value>本期出</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>3</ColSpan>
<ReportItems>
<Textbox Name="TextBox146">
<CanGrow>true</CanGrow>
<Value>结存</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.758543cm</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="TextBox48">
<CanGrow>true</CanGrow>
<Value>类型名称</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox49">
<CanGrow>true</CanGrow>
<Value>商品编号</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox50">
<CanGrow>true</CanGrow>
<Value>商品名称</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox61">
<CanGrow>true</CanGrow>
<Value>商品分类</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox67">
<CanGrow>true</CanGrow>
<Value>单位</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox108">
<CanGrow>true</CanGrow>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox111">
<CanGrow>true</CanGrow>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0.0000</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox114">
<CanGrow>true</CanGrow>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox117">
<CanGrow>true</CanGrow>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox120">
<CanGrow>true</CanGrow>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox123">
<CanGrow>true</CanGrow>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox126">
<CanGrow>true</CanGrow>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox129">
<CanGrow>true</CanGrow>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox132">
<CanGrow>true</CanGrow>
<Value>均价</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.8cm</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="TextBox51">
<CanGrow>true</CanGrow>
<Value>=Fields!SummaryDescription.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox53">
<CanGrow>true</CanGrow>
<Value>=Fields!ProductCode.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox55">
<CanGrow>true</CanGrow>
<Value>=Fields!ProductName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox62">
<CanGrow>true</CanGrow>
<Value>=Fields!CategoryName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox106">
<CanGrow>true</CanGrow>
<Value>=Fields!TypeName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox109">
<CanGrow>true</CanGrow>
<Value>=Fields!BeginQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox112">
<CanGrow>true</CanGrow>
<Value>=Fields!BeginAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox115">
<CanGrow>true</CanGrow>
<Value>=Fields!InQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox118">
<CanGrow>true</CanGrow>
<Value>=Fields!InAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox121">
<CanGrow>true</CanGrow>
<Value>=Fields!OutQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox124">
<CanGrow>true</CanGrow>
<Value>=Fields!OutAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox127">
<CanGrow>true</CanGrow>
<Value>=Fields!BalanceQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox130">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<Value>=Fields!BalanceAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox133">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<Value>=Fields!BalanceAmount.Value/iif(Fields!BalanceQty.Value=0,1,Fields!BalanceQty.Value)</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<Footer>
<TableRows>
<TableRow>
<Height>0.756017cm</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="TextBox57">
<CanGrow>true</CanGrow>
<Value>总计：</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox59">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox60">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox64">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox107">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox110">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BeginQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox113">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BeginAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox116">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!InQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox119">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!InAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox122">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!OutQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox125">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!OutAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox128">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BalanceQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox131">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<Value>=Sum(Fields!BalanceAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox134">
<CanGrow>true</CanGrow>
<CanShrink>true</CanShrink>
<Value>=Sum(Fields!BalanceAmount.Value)/iif(Sum(Fields!BalanceQty.Value)=0,1,Sum(Fields!BalanceQty.Value))</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<Height>3.831494cm</Height>
<Style>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<TableColumns>
<TableColumn>
<Width>3.237366cm</Width>
</TableColumn>
<TableColumn>
<Width>2.681741cm</Width>
</TableColumn>
<TableColumn>
<Width>4.7cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>3.422574cm</Width>
</TableColumn>
<TableColumn>
<Width>3.316741cm</Width>
</TableColumn>
<TableColumn>
<Width>3.396116cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>2.7cm</Width>
</TableColumn>
<TableColumn>
<Width>3cm</Width>
</TableColumn>
<TableColumn>
<Width>3cm</Width>
</TableColumn>
</TableColumns>
<Visibility>
<Hidden>=Parameters!ReportType.Value=2 or Parameters!ReportType.Value=1</Hidden>
</Visibility>
<Width>42.06949cm</Width>
<ZIndex>3</ZIndex>
</Table>
<Table Name="Table3">
<DataSetName>StaticsByInOutType</DataSetName>
<Header>
<RepeatOnNewPage>true</RepeatOnNewPage>
<TableRows>
<TableRow>
<Height>0.758467cm</Height>
<TableCells>
<TableCell>
<ColSpan>14</ColSpan>
<ReportItems>
<Textbox Name="TextBox1">
<CanGrow>true</CanGrow>
<Value>商品进销存分析</Value>
<Style>
<FontFamily>新宋体</FontFamily>
<FontSize>14pt</FontSize>
<FontStyle>Normal</FontStyle>
<FontWeight>400</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>None</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.758467cm</Height>
<TableCells>
<TableCell>
<ColSpan>5</ColSpan>
<ReportItems>
<Textbox Name="TextBox137">
<CanGrow>true</CanGrow>
<DataElementName>TextBox135</DataElementName>
<Value />
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="TextBox138">
<CanGrow>true</CanGrow>
<DataElementName>TextBox140</DataElementName>
<Value>期初</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="TextBox139">
<CanGrow>true</CanGrow>
<DataElementName>TextBox142</DataElementName>
<Value>本期入</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="TextBox141">
<CanGrow>true</CanGrow>
<DataElementName>TextBox144</DataElementName>
<Value>本期出</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>3</ColSpan>
<ReportItems>
<Textbox Name="TextBox143">
<CanGrow>true</CanGrow>
<DataElementName>TextBox146</DataElementName>
<Value>结存</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.758543cm</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="TextBox145">
<CanGrow>true</CanGrow>
<DataElementName>TextBox48</DataElementName>
<Value>类型名称</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox147">
<CanGrow>true</CanGrow>
<DataElementName>TextBox49</DataElementName>
<Value>商品编号</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox148">
<CanGrow>true</CanGrow>
<DataElementName>TextBox50</DataElementName>
<Value>商品名称</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox149">
<CanGrow>true</CanGrow>
<DataElementName>TextBox61</DataElementName>
<Value>商品分类</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox150">
<CanGrow>true</CanGrow>
<DataElementName>TextBox67</DataElementName>
<Value>单位</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox151">
<CanGrow>true</CanGrow>
<DataElementName>TextBox108</DataElementName>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox152">
<CanGrow>true</CanGrow>
<DataElementName>TextBox111</DataElementName>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0.0000</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox153">
<CanGrow>true</CanGrow>
<DataElementName>TextBox114</DataElementName>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox154">
<CanGrow>true</CanGrow>
<DataElementName>TextBox117</DataElementName>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox155">
<CanGrow>true</CanGrow>
<DataElementName>TextBox120</DataElementName>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox156">
<CanGrow>true</CanGrow>
<DataElementName>TextBox123</DataElementName>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox157">
<CanGrow>true</CanGrow>
<DataElementName>TextBox126</DataElementName>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox158">
<CanGrow>true</CanGrow>
<DataElementName>TextBox129</DataElementName>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox159">
<CanGrow>true</CanGrow>
<DataElementName>TextBox132</DataElementName>
<Value>均价</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.8cm</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="TextBox160">
<CanGrow>true</CanGrow>
<DataElementName>TextBox51</DataElementName>
<Value>=Fields!SummaryDescription.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox161">
<CanGrow>true</CanGrow>
<DataElementName>TextBox53</DataElementName>
<Value>=Fields!ProductCode.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox162">
<CanGrow>true</CanGrow>
<DataElementName>TextBox55</DataElementName>
<Value>=Fields!ProductName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox163">
<CanGrow>true</CanGrow>
<DataElementName>TextBox62</DataElementName>
<Value>=Fields!CategoryName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox164">
<CanGrow>true</CanGrow>
<DataElementName>TextBox106</DataElementName>
<Value>=Fields!TypeName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox165">
<CanGrow>true</CanGrow>
<DataElementName>TextBox109</DataElementName>
<Value>=Fields!BeginQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox166">
<CanGrow>true</CanGrow>
<DataElementName>TextBox112</DataElementName>
<Value>=Fields!BeginAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox167">
<CanGrow>true</CanGrow>
<DataElementName>TextBox115</DataElementName>
<Value>=Fields!InQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox168">
<CanGrow>true</CanGrow>
<DataElementName>TextBox118</DataElementName>
<Value>=Fields!InAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox169">
<CanGrow>true</CanGrow>
<DataElementName>TextBox121</DataElementName>
<Value>=Fields!OutQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox170">
<CanGrow>true</CanGrow>
<DataElementName>TextBox124</DataElementName>
<Value>=Fields!OutAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox171">
<CanGrow>true</CanGrow>
<DataElementName>TextBox127</DataElementName>
<Value>=Fields!BalanceQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox172">
<CanGrow>true</CanGrow>
<DataElementName>TextBox130</DataElementName>
<Value>=Fields!BalanceAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox173">
<CanGrow>true</CanGrow>
<DataElementName>TextBox133</DataElementName>
<Value>=Fields!BalanceAmount.Value/iif(Fields!BalanceQty.Value=0,1,Fields!BalanceQty.Value)</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>2pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<Footer>
<TableRows>
<TableRow>
<Height>0.756017cm</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="TextBox174">
<CanGrow>true</CanGrow>
<DataElementName>TextBox57</DataElementName>
<Value>总计：</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox175">
<CanGrow>true</CanGrow>
<DataElementName>TextBox59</DataElementName>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox176">
<CanGrow>true</CanGrow>
<DataElementName>TextBox60</DataElementName>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox177">
<CanGrow>true</CanGrow>
<DataElementName>TextBox64</DataElementName>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox178">
<CanGrow>true</CanGrow>
<DataElementName>TextBox107</DataElementName>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox179">
<CanGrow>true</CanGrow>
<DataElementName>TextBox110</DataElementName>
<Value>=Sum(Fields!BeginQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox180">
<CanGrow>true</CanGrow>
<DataElementName>TextBox113</DataElementName>
<Value>=Sum(Fields!BeginAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox181">
<CanGrow>true</CanGrow>
<DataElementName>TextBox116</DataElementName>
<Value>=Sum(Fields!InQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox182">
<CanGrow>true</CanGrow>
<DataElementName>TextBox119</DataElementName>
<Value>=Sum(Fields!InAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox183">
<CanGrow>true</CanGrow>
<DataElementName>TextBox122</DataElementName>
<Value>=Sum(Fields!OutQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox184">
<CanGrow>true</CanGrow>
<DataElementName>TextBox125</DataElementName>
<Value>=Sum(Fields!OutAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox185">
<CanGrow>true</CanGrow>
<DataElementName>TextBox128</DataElementName>
<Value>=Sum(Fields!BalanceQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox186">
<CanGrow>true</CanGrow>
<DataElementName>TextBox131</DataElementName>
<Value>=Sum(Fields!BalanceAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox187">
<CanGrow>true</CanGrow>
<DataElementName>TextBox134</DataElementName>
<Value>=Sum(Fields!BalanceAmount.Value)/iif(Sum(Fields!BalanceQty.Value)=0,1,Sum(Fields!BalanceQty.Value))</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<dd:ShrinkToFit xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">True</dd:ShrinkToFit>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<Height>3.831494cm</Height>
<Left>0.01748in</Left>
<Style>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<TableColumns>
<TableColumn>
<Width>3cm</Width>
<Visibility>
<Hidden>=IIF( Parameters!ReportType.Value =1,TRUE,FALSE)</Hidden>
</Visibility>
</TableColumn>
<TableColumn>
<Width>2.681741cm</Width>
</TableColumn>
<TableColumn>
<Width>4.7cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>3.422574cm</Width>
</TableColumn>
<TableColumn>
<Width>3.316741cm</Width>
</TableColumn>
<TableColumn>
<Width>3.396116cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>2.522991cm</Width>
</TableColumn>
<TableColumn>
<Width>2.95cm</Width>
</TableColumn>
<TableColumn>
<Width>3cm</Width>
</TableColumn>
<TableColumn>
<Width>3cm</Width>
</TableColumn>
</TableColumns>
<Top>0.009921in</Top>
<Visibility>
<Hidden>=Parameters!ReportType.Value=2 or Parameters!ReportType.Value=3</Hidden>
</Visibility>
<Width>42.08213cm</Width>
<ZIndex>4</ZIndex>
</Table>
<Table Name="Table1">
<DataSetName>StaticsByDepartment</DataSetName>
<Header>
<RepeatOnNewPage>true</RepeatOnNewPage>
<TableRows>
<TableRow>
<Height>0.781588cm</Height>
<TableCells>
<TableCell>
<ColSpan>14</ColSpan>
<ReportItems>
<Textbox Name="TextBox3">
<CanGrow>true</CanGrow>
<Value>商品进销存分析</Value>
<Style>
<Color>Black</Color>
<FontFamily>新宋体</FontFamily>
<FontSize>14pt</FontSize>
<FontStyle>Normal</FontStyle>
<FontWeight>400</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.781588cm</Height>
<TableCells>
<TableCell>
<ColSpan>5</ColSpan>
<ReportItems>
<Textbox Name="TextBox47">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="TextBox52">
<CanGrow>true</CanGrow>
<Value>期初</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="TextBox54">
<CanGrow>true</CanGrow>
<Value>本期入</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>2</ColSpan>
<ReportItems>
<Textbox Name="TextBox56">
<CanGrow>true</CanGrow>
<Value>本期出</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ColSpan>3</ColSpan>
<ReportItems>
<Textbox Name="TextBox58">
<CanGrow>true</CanGrow>
<Value>结存</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
<TableRow>
<Height>0.755212cm</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="TextBox31">
<CanGrow>true</CanGrow>
<Value>仓库</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox63">
<CanGrow>true</CanGrow>
<Value>商品编码</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox70">
<CanGrow>true</CanGrow>
<Value>商品名称</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox73">
<CanGrow>true</CanGrow>
<Value>商品分类</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox76">
<CanGrow>true</CanGrow>
<Value>单位</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox79">
<CanGrow>true</CanGrow>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox82">
<CanGrow>true</CanGrow>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<Format>0.0000</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox85">
<CanGrow>true</CanGrow>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox88">
<CanGrow>true</CanGrow>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox91">
<CanGrow>true</CanGrow>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox94">
<CanGrow>true</CanGrow>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox97">
<CanGrow>true</CanGrow>
<Value>数量</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox100">
<CanGrow>true</CanGrow>
<Value>金额</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox103">
<CanGrow>true</CanGrow>
<Value>均价</Value>
<Style>
<BackgroundColor>SteelBlue</BackgroundColor>
<Color>White</Color>
<FontFamily>新宋体</FontFamily>
<FontWeight>700</FontWeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Header>
<Details>
<TableRows>
<TableRow>
<Height>0.8cm</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="TextBox65">
<CanGrow>true</CanGrow>
<Value>=Fields!WareHouseName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox66">
<CanGrow>true</CanGrow>
<Value>=Fields!ProductCode.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox71">
<CanGrow>true</CanGrow>
<Value>=Fields!ProductName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox74">
<CanGrow>true</CanGrow>
<Value>=Fields!CategoryName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox77">
<CanGrow>true</CanGrow>
<Value>=Fields!TypeName.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox80">
<CanGrow>true</CanGrow>
<Value>=Fields!BeginQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox83">
<CanGrow>true</CanGrow>
<Value>=Fields!BeginAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox86">
<CanGrow>true</CanGrow>
<Value>=Fields!InQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox89">
<CanGrow>true</CanGrow>
<Value>=Fields!InAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox92">
<CanGrow>true</CanGrow>
<Value>=Fields!OutQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox95">
<CanGrow>true</CanGrow>
<Value>=Fields!OutAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox98">
<CanGrow>true</CanGrow>
<Value>=Fields!BalanceQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox101">
<Value>=Fields!BalanceAmount.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox104">
<Value>=Fields!BalanceAmount.Value/Fields!BalanceQty.Value</Value>
<Style>
<BackgroundColor>=iif(RowNumber() Mod 2=0,"#dbeeff","#f6f6ff"）</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<LineHeight>1pt</LineHeight>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Details>
<Footer>
<TableRows>
<TableRow>
<Height>0.755212cm</Height>
<TableCells>
<TableCell>
<ReportItems>
<Textbox Name="TextBox68">
<CanGrow>true</CanGrow>
<Value>总计：</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox69">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox72">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox75">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox78">
<CanGrow>true</CanGrow>
<Value />
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox81">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BeginQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox84">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BeginAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox87">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!InQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox90">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!InAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox93">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!OutQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox96">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!OutAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox99">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BalanceQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox102">
<Value>=Sum(Fields!BalanceAmount.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
<TableCell>
<ReportItems>
<Textbox Name="TextBox105">
<CanGrow>true</CanGrow>
<Value>=Sum(Fields!BalanceAmount.Value)/Sum(Fields!BalanceQty.Value)</Value>
<Style>
<BackgroundColor>#e0e0e0</BackgroundColor>
<FontFamily>新宋体</FontFamily>
<Format>0.00</Format>
<PaddingBottom>2pt</PaddingBottom>
<PaddingLeft>2pt</PaddingLeft>
<PaddingRight>2pt</PaddingRight>
<PaddingTop>2pt</PaddingTop>
<TextAlign>Center</TextAlign>
<VerticalAlign>Middle</VerticalAlign>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
</Textbox>
</ReportItems>
</TableCell>
</TableCells>
</TableRow>
</TableRows>
</Footer>
<Height>3.8736cm</Height>
<Style>
<PaddingBottom>1pt</PaddingBottom>
<PaddingLeft>1pt</PaddingLeft>
<PaddingRight>1pt</PaddingRight>
<PaddingTop>1pt</PaddingTop>
<BorderColor>
<Default>LightGray</Default>
</BorderColor>
<BorderStyle>
<Default>Solid</Default>
</BorderStyle>
</Style>
<TableColumns>
<TableColumn>
<Width>4.318131cm</Width>
</TableColumn>
<TableColumn>
<Width>2.943445cm</Width>
</TableColumn>
<TableColumn>
<Width>4.7cm</Width>
</TableColumn>
<TableColumn>
<Width>2.278514cm</Width>
</TableColumn>
<TableColumn>
<Width>2.27345cm</Width>
</TableColumn>
<TableColumn>
<Width>3.078218cm</Width>
</TableColumn>
<TableColumn>
<Width>3.212992cm</Width>
</TableColumn>
<TableColumn>
<Width>2.727808cm</Width>
</TableColumn>
<TableColumn>
<Width>2.781718cm</Width>
</TableColumn>
<TableColumn>
<Width>2.242625cm</Width>
</TableColumn>
<TableColumn>
<Width>2.700854cm</Width>
</TableColumn>
<TableColumn>
<Width>2.8cm</Width>
</TableColumn>
<TableColumn>
<Width>2.9cm</Width>
</TableColumn>
<TableColumn>
<Width>3cm</Width>
</TableColumn>
</TableColumns>
<Visibility>
<Hidden>=Parameters!ReportType.Value=3 or Parameters!ReportType.Value=1</Hidden>
</Visibility>
<Width>41.95776cm</Width>
<ZIndex>2</ZIndex>
</Table>
</ReportItems>
<Style>
<BorderColor>
<Default>Black</Default>
</BorderColor>
</Style>
</Body>
<PageFooter>
<Height>0.882292cm</Height>
<PrintOnFirstPage>true</PrintOnFirstPage>
<PrintOnLastPage>true</PrintOnLastPage>
<Style />
</PageFooter>
<BottomMargin>0.5cm</BottomMargin>
<Code>Function ArrayToString(list As Object()) As String
Dim re = ""
For Each item As String In list
If item Is Nothing Then
Continue For
End If

If re <> "" Then
re += ","
End If

re += item
Next
Return re
End Function </Code>
<LeftMargin>0.5cm</LeftMargin>
<PageHeight>30cm</PageHeight>
<PageWidth>100cm</PageWidth>
<RightMargin>0.5cm</RightMargin>
<TopMargin>0.5cm</TopMargin>
<Width>46cm</Width>
<ReportParameters>
<ReportParameter Name="CorporationID">
<DataType>String</DataType>
<Prompt>CorporationID</Prompt>
<Hidden>true</Hidden>
<DefaultValue>
<Values>
<Value>1</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="UserID">
<DataType>String</DataType>
<Prompt>UserID</Prompt>
<Hidden>true</Hidden>
<DefaultValue>
<Values>
<Value>10465</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="StartDate">
<DataType>DateTime</DataType>
<Prompt>(出库)开始时间：</Prompt>
<dd

ateOnly xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">false</dd

ateOnly>
<DefaultValue>
<Values>
<Value>=Today.AddDays(-1.0*Today.Day+1)</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="EndDate">
<DataType>DateTime</DataType>
<Prompt>(出库)结束日期：</Prompt>
<dd

ateOnly xmlns:dd="http://schemas.datadynamics.com/reporting/2005/02/reportdefinition">false</dd

ateOnly>
<DefaultValue>
<Values>
<Value>=Today.AddDays(1).AddSeconds(-1)</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="BranchID">
<DataType>Integer</DataType>
<Prompt>分公司：</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>CorporationBranch</DataSetName>
<LabelField>CompanyName</LabelField>
<ValueField>CompanyID</ValueField>
</DataSetReference>
</ValidValues>
<DefaultValue>
<DataSetReference>
<DataSetName>CorporationBranch</DataSetName>
<LabelField>CompanyID</LabelField>
<ValueField>CompanyID</ValueField>
</DataSetReference>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="DepartmentID">
<DataType>String</DataType>
<Nullable>true</Nullable>
<Prompt>部门：</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>BranchDepartment</DataSetName>
<LabelField>DepartmentName</LabelField>
<ValueField>DepartmentID</ValueField>
</DataSetReference>
</ValidValues>
<DefaultValue>
<DataSetReference>
<DataSetName>BranchDepartment</DataSetName>
<ValueField>DepartmentID</ValueField>
</DataSetReference>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="WarehouseID">
<DataType>String</DataType>
<Nullable>true</Nullable>
<Prompt>仓库：</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>Warehouse</DataSetName>
<LabelField>WareHouseName</LabelField>
<ValueField>WarehouseID</ValueField>
</DataSetReference>
</ValidValues>
<DefaultValue>
<DataSetReference>
<DataSetName>Warehouse</DataSetName>
<ValueField>WarehouseID</ValueField>
</DataSetReference>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="SearchBy">
<AllowBlank>true</AllowBlank>
<DataType>String</DataType>
<Prompt>商品搜索：</Prompt>
</ReportParameter>
<ReportParameter Name="ProductCategoryIDStr">
<DataType>String</DataType>
<Prompt>商品分类：</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>BranchProductCategory</DataSetName>
<LabelField>CategoryName</LabelField>
<ValueField>Category</ValueField>
</DataSetReference>
</ValidValues>
<DefaultValue>
<DataSetReference>
<DataSetName>BranchProductCategory</DataSetName>
<ValueField>Category</ValueField>
</DataSetReference>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="ProductID">
<DataType>String</DataType>
<Prompt>商品：</Prompt>
<ValidValues>
<DataSetReference>
<DataSetName>BranchProductFilter</DataSetName>
<LabelField>ProductName</LabelField>
<ValueField>ProductID</ValueField>
</DataSetReference>
</ValidValues>
<DefaultValue>
<DataSetReference>
<DataSetName>BranchProductFilter</DataSetName>
<ValueField>ProductID</ValueField>
</DataSetReference>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="ReportType">
<DataType>String</DataType>
<Prompt>汇总类型</Prompt>
<ValidValues>
<ParameterValues>
<ParameterValue>
<Label>按公司</Label>
<Value>1</Value>
</ParameterValue>
<ParameterValue>
<Label>按仓库</Label>
<Value>2</Value>
</ParameterValue>
<ParameterValue>
<Label>按出入库类型</Label>
<Value>3</Value>
</ParameterValue>
</ParameterValues>
</ValidValues>
</ReportParameter>
<ReportParameter Name="BillType">
<DataType>String</DataType>
<Prompt>单据类型：</Prompt>
<MultiValue>true</MultiValue>
<ValidValues>
<DataSetReference>
<DataSetName>BillType</DataSetName>
<LabelField>SummaryDescription</LabelField>
<ValueField>sStockActionTypeKey</ValueField>
</DataSetReference>
</ValidValues>
<DefaultValue>
<Values>
<Value>ALL</Value>
</Values>
</DefaultValue>
</ReportParameter>
<ReportParameter Name="ReportName">
<DataType>String</DataType>
<Prompt>报表名称：</Prompt>
<Hidden>true</Hidden>
<DefaultValue>
<Values>
<Value>商品进销存分析</Value>
</Values>
</DefaultValue>
</ReportParameter>
</ReportParameters>
<DataSources>
<DataSource Name="BSMasterDB_B9_ZJK_80">
<DataSourceReference>DataBaseConnect\BSMasterDB_QA.rdsx</DataSourceReference>
</DataSource>
<DataSource Name="OlapReportDB_ZJK_80">
<DataSourceReference>DataBaseConnect\OlapReportDB.rdsx</DataSourceReference>
</DataSource>
</DataSources>
<DataSets>
<DataSet Name="CorporationBranch">
<Fields>
<Field Name="CompanyID">
<DataField>CompanyID</DataField>
</Field>
<Field Name="CompanyName">
<DataField>CompanyName</DataField>
</Field>
</Fields>
<Query>
<CommandText>usp_hman_Report_GetUserVisibleBranch</CommandText>
<DataSourceName>BSMasterDB_B9_ZJK_80</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<QueryParameters>
<QueryParameter Name="@UserID">
<Value>=Parameters!UserID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="BranchDepartment">
<Fields>
<Field Name="DepartmentID">
<DataField>DepartmentID</DataField>
</Field>
<Field Name="DepartmentName">
<DataField>DepartmentName</DataField>
</Field>
<Field Name="DepartmentTypeID">
<DataField>DepartmentTypeID</DataField>
</Field>
</Fields>
<Query>
<CommandText>SELECT 0 AS DepartmentID, '所有部门' AS DepartmentName, 0 AS DepartmentTypeID
UNION ALL
SELECT DepartmentID, DepartmentName, DepartmentTypeID
FROM    DW.dbo.DimDepartment
WHERE (BranchID = @BranchID) AND (IsActive = 1) AND (IsDelete = 0)</CommandText>
<DataSourceName>OlapReportDB_ZJK_80</DataSourceName>
<QueryParameters>
<QueryParameter Name="@BranchID">
<Value>=Parameters!BranchID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="Warehouse">
<Fields>
<Field Name="WarehouseID">
<DataField>WarehouseID</DataField>
</Field>
<Field Name="WareHouseName">
<DataField>WareHouseName</DataField>
</Field>
<Field Name="WarehoueTypeID">
<DataField>WarehoueTypeID</DataField>
</Field>
</Fields>
<Query>
<CommandText>SELECT 0 AS WarehouseID, '所有' AS WareHouseName, 0 AS WarehoueTypeID
UNION ALL
SELECT a.WarehouseID, a.WareHouseName, a.WarehoueTypeID
FROM    invn_Warehouse AS a WITH (nolock) INNER JOIN
            invn_Warehouse_Company_Map AS b WITH (nolock) ON a.WarehouseID = b.WarehouseID
WHERE (ISNULL(@DepartmentID, 0) = 0 OR (ISNULL(@DepartmentID, 0) <> 0 AND b.DepartmentID=@DepartmentID))
AND ( ISNULL(@BranchID, 0)=0 OR (ISNULL(@BranchID, 0)<>0 AND b.BranchID=@BranchID ))
AND CorporationID=@CorporationID
AND a.IsActive=1 AND a.IsDelete=0</CommandText>
<DataSourceName>BSMasterDB_B9_ZJK_80</DataSourceName>
<QueryParameters>
<QueryParameter Name="@CorporationID">
<Value>=Parameters!CorporationID.Value</Value>
</QueryParameter>
<QueryParameter Name="@BranchID">
<Value>=Parameters!BranchID.Value</Value>
</QueryParameter>
<QueryParameter Name="@DepartmentID">
<Value>=Parameters!DepartmentID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="BranchProductCategory">
<Fields>
<Field Name="Category">
<DataField>Category</DataField>
</Field>
<Field Name="CategoryName">
<DataField>CategoryName</DataField>
</Field>
</Fields>
<Query>
<CommandText>SELECT 'ALL' AS Category, '所有类别' AS CategoryName
UNION ALL
SELECT DISTINCT Level1CategoryName, Level1CategoryName AS CategoryName
FROM    DW.dbo.DimProductCategory AS c
WHERE (CorporationID = @CorporationID) and Level1CategoryName is not null
AND c.IsDeleted = 0</CommandText>
<DataSourceName>OlapReportDB_ZJK_80</DataSourceName>
<QueryParameters>
<QueryParameter Name="@CorporationID">
<Value>=Parameters!CorporationID.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="BranchProductFilter">
<Fields>
<Field Name="ProductID">
<DataField>ProductID</DataField>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
</Field>
</Fields>
<Query>
<CommandText>SELECT 0 AS ProductID, '所有商品' AS ProductName
UNION ALL
SELECT a.ProductID,a.ProductName
FROM    DW.dbo.DimProduct AS a INNER JOIN
            DW.dbo.DimProduct_Company_Map AS m ON a.ProductID = m.ProductID INNER JOIN
            DW.dbo.DimProductCategory AS c ON a.ProductCategoryID = c.ProductCategoryID
WHERE (m.IsVisible = 1) AND (m.BranchID = @BranchID AND @BranchID <> 0 OR
            @BranchID = 0 AND m.BranchID = @CorporationID) AND (ISNULL(@ProductCategory, 'ALL') = 'ALL' OR
            ISNULL(@ProductCategory, 'ALL') <> 'ALL' AND (c.Level1CategoryName = @ProductCategory OR
            c.Level2CategoryName = @ProductCategory)) AND (ISNULL(@SearchBy, '') = '' OR
            ISNULL(@SearchBy, '') <> '' AND (a.ProductName LIKE '%' + @SearchBy + '%' OR
            a.ProductCode LIKE '%' + @SearchBy + '%'))
ORDER BY 1</CommandText>
<DataSourceName>OlapReportDB_ZJK_80</DataSourceName>
<QueryParameters>
<QueryParameter Name="@CorporationID">
<Value>=Parameters!CorporationID.Value</Value>
</QueryParameter>
<QueryParameter Name="@BranchID">
<Value>=Parameters!BranchID.Value</Value>
</QueryParameter>
<QueryParameter Name="@ProductCategory">
<Value>=Parameters!ProductCategoryIDStr.Value</Value>
</QueryParameter>
<QueryParameter Name="@SearchBy">
<Value>=Parameters!SearchBy.Value</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="BillType">
<Fields>
<Field Name="ID">
<DataField>ID</DataField>
</Field>
<Field Name="sStockActionTypeKey">
<DataField>sStockActionTypeKey</DataField>
</Field>
<Field Name="SummaryDescription">
<DataField>SummaryDescription</DataField>
</Field>
</Fields>
<Query>
<CommandText>SELECT ID,sStockActionTypeKey,
   SummaryDescription FROM OLAPReportDB.dbo.invn_zStockInOutType ORDER BY DisplayOrder</CommandText>
<DataSourceName>OlapReportDB_ZJK_80</DataSourceName>
</Query>
</DataSet>
<DataSet Name="StaticsByCompany">
<Fields>
<Field Name="CorporationName">
<DataField>CorporationName</DataField>
</Field>
<Field Name="BranchID">
<DataField>BranchID</DataField>
</Field>
<Field Name="BranchName">
<DataField>BranchName</DataField>
</Field>
<Field Name="ProductVariantID">
<DataField>ProductVariantID</DataField>
</Field>
<Field Name="ProductCode">
<DataField>ProductCode</DataField>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
</Field>
<Field Name="CategoryName">
<DataField>CategoryName</DataField>
</Field>
<Field Name="TypeName">
<DataField>TypeName</DataField>
</Field>
<Field Name="BeginQty">
<DataField>BeginQty</DataField>
</Field>
<Field Name="BeginAmount">
<DataField>BeginAmount</DataField>
</Field>
<Field Name="InQty">
<DataField>InQty</DataField>
</Field>
<Field Name="InAmount">
<DataField>InAmount</DataField>
</Field>
<Field Name="OutQty">
<DataField>OutQty</DataField>
</Field>
<Field Name="OutAmount">
<DataField>OutAmount</DataField>
</Field>
<Field Name="BalanceQty">
<DataField>BalanceQty</DataField>
</Field>
<Field Name="BalanceAmount">
<DataField>BalanceAmount</DataField>
</Field>
<Field Name="AveragePrice">
<DataField>AveragePrice</DataField>
</Field>
</Fields>
<Query>
<CommandText>usp_Finance_Sale_Rpt_StockInOutSummary</CommandText>
<DataSourceName>OlapReportDB_ZJK_80</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<QueryParameters>
<QueryParameter Name="@CorporationID">
<Value>=Parameters!CorporationID.Value</Value>
</QueryParameter>
<QueryParameter Name="@StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@BranchID">
<Value>=Parameters!BranchID.Value</Value>
</QueryParameter>
<QueryParameter Name="@DepartmentID">
<Value>=Parameters!DepartmentID.Value</Value>
</QueryParameter>
<QueryParameter Name="@WarehouseID">
<Value>=Parameters!WarehouseID.Value</Value>
</QueryParameter>
<QueryParameter Name="@ProductCategoryIDStr">
<Value>=Parameters!ProductCategoryIDStr.Value</Value>
</QueryParameter>
<QueryParameter Name="@ProductID">
<Value>=Parameters!ProductID.Value</Value>
</QueryParameter>
<QueryParameter Name="@ReportType">
<Value>=Parameters!ReportType.Value</Value>
</QueryParameter>
<QueryParameter Name="@BillType">
<Value>=Code.ArrayToString(Parameters!BillType.Value)</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="StaticsByInOutType">
<Fields>
<Field Name="CorporationID">
<DataField>CorporationID</DataField>
</Field>
<Field Name="CorporationName">
<DataField>CorporationName</DataField>
</Field>
<Field Name="BranchID">
<DataField>BranchID</DataField>
</Field>
<Field Name="BranchName">
<DataField>BranchName</DataField>
</Field>
<Field Name="ProductVariantID">
<DataField>ProductVariantID</DataField>
</Field>
<Field Name="ProductCode">
<DataField>ProductCode</DataField>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
</Field>
<Field Name="CategoryName">
<DataField>CategoryName</DataField>
</Field>
<Field Name="TypeName">
<DataField>TypeName</DataField>
</Field>
<Field Name="BeginQty">
<DataField>BeginQty</DataField>
</Field>
<Field Name="BeginAmount">
<DataField>BeginAmount</DataField>
</Field>
<Field Name="InQty">
<DataField>InQty</DataField>
</Field>
<Field Name="InAmount">
<DataField>InAmount</DataField>
</Field>
<Field Name="OutQty">
<DataField>OutQty</DataField>
</Field>
<Field Name="OutAmount">
<DataField>OutAmount</DataField>
</Field>
<Field Name="BalanceQty">
<DataField>BalanceQty</DataField>
</Field>
<Field Name="BalanceAmount">
<DataField>BalanceAmount</DataField>
</Field>
<Field Name="DepartmentName">
<DataField>DepartmentName</DataField>
</Field>
<Field Name="WareHouseName">
<DataField>WareHouseName</DataField>
</Field>
<Field Name="AveragePrice">
<DataField>AveragePrice</DataField>
</Field>
<Field Name="SummaryDescription">
<DataField>SummaryDescription</DataField>
</Field>
</Fields>
<Query>
<CommandText>usp_Finance_Sale_Rpt_StockInOutSummary</CommandText>
<DataSourceName>OlapReportDB_ZJK_80</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<QueryParameters>
<QueryParameter Name="@CorporationID">
<Value>=Parameters!CorporationID.Value</Value>
</QueryParameter>
<QueryParameter Name="@StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@BranchID">
<Value>=Parameters!BranchID.Value</Value>
</QueryParameter>
<QueryParameter Name="@DepartmentID">
<Value>=Parameters!DepartmentID.Value</Value>
</QueryParameter>
<QueryParameter Name="@WarehouseID">
<Value>=Parameters!WarehouseID.Value</Value>
</QueryParameter>
<QueryParameter Name="@ProductCategoryIDStr">
<Value>=Parameters!ProductCategoryIDStr.Value</Value>
</QueryParameter>
<QueryParameter Name="@ProductID">
<Value>=Parameters!ProductID.Value</Value>
</QueryParameter>
<QueryParameter Name="@ReportType">
<Value>=Parameters!ReportType.Value</Value>
</QueryParameter>
<QueryParameter Name="@BillType">
<Value>=Code.ArrayToString(Parameters!BillType.Value)</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
<DataSet Name="StaticsByDepartment">
<Fields>
<Field Name="CorporationID">
<DataField>CorporationID</DataField>
</Field>
<Field Name="CorporationName">
<DataField>CorporationName</DataField>
</Field>
<Field Name="BranchID">
<DataField>BranchID</DataField>
</Field>
<Field Name="BranchName">
<DataField>BranchName</DataField>
</Field>
<Field Name="ProductVariantID">
<DataField>ProductVariantID</DataField>
</Field>
<Field Name="ProductCode">
<DataField>ProductCode</DataField>
</Field>
<Field Name="ProductName">
<DataField>ProductName</DataField>
</Field>
<Field Name="CategoryName">
<DataField>CategoryName</DataField>
</Field>
<Field Name="TypeName">
<DataField>TypeName</DataField>
</Field>
<Field Name="BeginQty">
<DataField>BeginQty</DataField>
</Field>
<Field Name="BeginAmount">
<DataField>BeginAmount</DataField>
</Field>
<Field Name="InQty">
<DataField>InQty</DataField>
</Field>
<Field Name="InAmount">
<DataField>InAmount</DataField>
</Field>
<Field Name="OutQty">
<DataField>OutQty</DataField>
</Field>
<Field Name="OutAmount">
<DataField>OutAmount</DataField>
</Field>
<Field Name="BalanceQty">
<DataField>BalanceQty</DataField>
</Field>
<Field Name="BalanceAmount">
<DataField>BalanceAmount</DataField>
</Field>
<Field Name="WareHouseName">
<DataField>WareHouseName</DataField>
</Field>
<Field Name="DepartmentName">
<DataField>DepartmentName</DataField>
</Field>
<Field Name="AveragePrice">
<DataField>AveragePrice</DataField>
</Field>
</Fields>
<Query>
<CommandText>usp_Finance_Sale_Rpt_StockInOutSummary</CommandText>
<DataSourceName>OlapReportDB_ZJK_80</DataSourceName>
<CommandType>StoredProcedure</CommandType>
<QueryParameters>
<QueryParameter Name="@CorporationID">
<Value>=Parameters!CorporationID.Value</Value>
</QueryParameter>
<QueryParameter Name="@StartDate">
<Value>=Parameters!StartDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@EndDate">
<Value>=Parameters!EndDate.Value</Value>
</QueryParameter>
<QueryParameter Name="@BranchID">
<Value>=Parameters!BranchID.Value</Value>
</QueryParameter>
<QueryParameter Name="@DepartmentID">
<Value>=Parameters!DepartmentID.Value</Value>
</QueryParameter>
<QueryParameter Name="@WarehouseID">
<Value>=Parameters!WarehouseID.Value</Value>
</QueryParameter>
<QueryParameter Name="@ProductCategoryIDStr">
<Value>=Parameters!ProductCategoryIDStr.Value</Value>
</QueryParameter>
<QueryParameter Name="@ProductID">
<Value>=Parameters!ProductID.Value</Value>
</QueryParameter>
<QueryParameter Name="@ReportType">
<Value>=Parameters!ReportType.Value</Value>
</QueryParameter>
<QueryParameter Name="@BillType">
<Value>=Code.ArrayToString(Parameters!BillType.Value)</Value>
</QueryParameter>
</QueryParameters>
</Query>
</DataSet>
</DataSets>
<CustomProperties>
<CustomProperty>
<Name>report

esignTimeBackgroundRendering</Name>
<Value>True</Value>
</CustomProperty>
</CustomProperties>
</Report>

mumudu · mumudu

以上是设计文件内容

KearneyKang · KearneyKang

你使用的是RDL报表，你能把报表文件提供给我吗就是 .rdlx 文件，你这是记事本代开的一个文档，我这复制打开有问题。

mumudu · mumudu

附件压缩包内是rdlx文件，请查看

KearneyKang · KearneyKang

你好，我看了你的报表设计，设计上我没有看出什么问题

		自动登录	找回密码
密码			立即注册

[已处理] 使用报表自带的导出excel功能，导出的excel文件有空白行

6 个回复

本帖子中包含更多资源

圣诞拼拼乐

微信认证勋章

讲师达人

悬赏达人

元老葡萄