库存表1.dnr

用delphi+intraweb写的简单报表系统（activeform使用技术）

<Report ContainerWidth="32000" LayoutWidth="10000" FixedPageFooter="-1" TableGridLine="-1" TableHeaderHeight="520"><!--Created by DataNewReport Designer--><Variants DateFormat=""/><Functions/><DNPaper/><DNDb Type="3" ConnectionString="Provider=SQLOLEDB.1;Password=admin;Persist Security Info=True;User ID=sa;Initial Catalog=tempdb;Data Source=owen\mypm6" Server="" Database="" User="" Password="" Sql="SELECT top 200 [cWhCode] as 仓库编码, [cWhName] as 仓库名称, [cVouchType] as 单据类型, [cVouchName] as 单据名称, [cInvCode] as 存货编码, &#xA;[cBusType] as 业务类型, [cBusCode] as 业务编码, [cCode] as 收发单据号, [cDepName] as 部门名称, [cCusAbbName] as 客户简称, [cVenAbbName] as 供应商简称,&#xA;[cRdName] as 收发类别, [cInvName] as 存货名称, [cInvAddCode] as 存货代码, [cInvStd] as 规格型号, [cInvCCode] as 存货分类码, &#xA;[cInvCName] as 存货大类, [cComUnitName] as 计量单位, [cItemCName] as 项目大类, [cItemCode] as 项目分类, [iInNum] as 入库件数, &#xA;[iOutNum] as 发出件数, [RKSL] as 入库数量, [CKSL] as 出库数量, [RKDJ] as 入库单价, [CKDJ] as 出库单价, [RKJE] as 入库金额, &#xA;[CKJE] as 出库金额, [JHDJ] as 计划单价, [JHJE] as 计划金额, [iQCJCSL] as 期初数量, [iQCJCJS] as 期初件数, [iQMJCSL] as 期末数量, &#xA;[iQMJCJS] as 期末件数  FROM tempdb..[XXLR_TempOWEN389786851]" ProjectPath="C:\HappyReport\reports\标准\vbscript\" ProjectDbList="NWind_chs|中文版数据库实例|0|Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\NWind_chs.mdb;Persist Security Info=False||||}NWind_enu|英文版数据库实例|0|Provider=Microsoft.Jet.OLEDB.4.0;Data Source=..\..\NWind_enu.mdb;Persist Security Info=False||||" UseBDO="0" BDOID="" BDOName=""/><DNCrosstab XField="仓库名称" YField="部门名称" ZField="期末数量" YTitle="部门名称" ZTitle="期末数量" ZAggregate="Sum" XSort="0" YSort="0" XSubtotal="0" YSubtotal="0" ColumnLeft="810" ColumnWidth="1732" Left="810" Top="990" Width="6930" Height="2445" Section="1"><XDNObject FontBold="1" Align="34" BackColor="15724527" BackStyle="0"/><YDNObject FontBold="1" Align="34" BackColor="16763594" BackStyle="0"/><ZDNObject FontName="Arial" Align="36" MarginRight="50"/><XSubtotalDNObject FontName="Arial" Align="36" MarginRight="50" BackColor="12648175" BackStyle="0"/><YSubtotalDNObject FontName="Arial" Align="36" MarginRight="50" BackColor="16763594" BackStyle="0"/><XGrandtotalDNObject FontName="Arial" FontBold="1" Align="36" MarginRight="50" BackColor="12648175" BackStyle="0"/><YGrandtotalDNObject FontName="Arial" FontBold="1" Align="36" MarginRight="50" BackColor="16763594" BackStyle="0"/><XSubtotalTitleDNObject FontBold="1" Align="34" BackColor="12648175" BackStyle="0"/><YSubtotalTitleDNObject FontBold="1" Align="34" BackColor="16763594" BackStyle="0"/><XGrandtotalTitleDNObject FontBold="1" Align="34" MarginRight="50" BackColor="12648175" BackStyle="0"/><YGrandtotalTitleDNObject FontBold="1" Align="34" MarginRight="50" BackColor="16763594" BackStyle="0"/></DNCrosstab><Groups/><Sections><Section Name="明细" Type="0" Height="365" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat=""><Os/></Section><Section Name="表头" Type="1" Height="3835" BackStyle="1" BackColor="16777215" OnFormat=""><Os/></Section><Section Name="表尾" Type="2" Height="2090" BackStyle="1" BackColor="16777215" OnFormat=""><Os/></Section><Section Name="页头" Type="3" Height="520" BackStyle="1" BackColor="16777215" DesignAlign="128" OnFormat=""><Os/></Section><Section Name="页尾" Type="4" Height="405" BackStyle="1" BackColor="16777215" OnFormat=""><Os/></Section></Sections></Report>