105.fr3

这个是功能强大的报表软件

<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Version="4.0a" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.DoubleBuffered="False" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="39009,0101075926" ReportOptions.Description.Text="This report demonstrates how to print several cross-tabs." ReportOptions.LastChange="39012,5593753588" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end." PropData="044C656674026003546F7003700108446174617365747301010C2F00000020446174615365743D2241444F5175657279312220446174615365744E616D653D224375737450657253746174652200010C3000000020446174615365743D2241444F5175657279322220446174615365744E616D653D2253616C657350657253746174652200010C3700000020446174615365743D2241444F5175657279332220446174615365744E616D653D2253616C65735065725374617465506572596561722200010C3800000020446174615365743D2241444F5175657279342220446174615365744E616D653D2253616C657350657243757374596561724D6F6E7468220000095661726961626C65730100055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxADOQuery Name="ADOQuery1" UserName="CustPerState" CloseDataSource="True" FieldAliases.Text="" SQL.Text="SELECT c.Company, c.State&#13;&#10;FROM&#13;&#10;    customer c" SQLSchema="eAGLdkksSXRKLE6N5eUKDvSxNTQ3tDAzMTK3MOLlig5JTMpJLQbKJNsmlxaX5OemFumYGumYmukYGRjoGJoaANW4F2WmAFUY2Drn5xYk5lXqwFUm6xjqGIAhL5ehbXBJYkkqdslon8y8bJA1AA4WJ64=" CommandTimeout="30" PropData="05704C656674023C0470546F70023C0A506172616D65746572730100"/>
    <TfrxADOQuery Name="ADOQuery2" UserName="SalesPerState" CloseDataSource="True" FieldAliases.Text="" SQL.Text="SELECT o.ItemsTotal, c.State&#13;&#10;FROM&#13;&#10;    orders o&#13;&#10;    INNER JOIN customer c ON (o.CustNo=c.CustNo)" SQLSchema="eAFNjj8LwjAUxPdAvskb3ktoQocsIojQRdotODzTDMXWQBK/v/EPKrfd7+44v+fKOy7xLMV4Gpy2pHqj0Vgp/MSXNZZGkkt5jrmA0dBZUIhAHUoRXLiXmraYgaj5vfkxf8jL3LrojjVuZUqVV/jMJCDAl6QgN1auEb5L4Q/6Ybldnw/QqZanN5LiARggMO8=" CommandTimeout="30" PropData="05704C656674023C0470546F700388000A506172616D65746572730100"/>
    <TfrxADOQuery Name="ADOQuery3" UserName="SalesPerStatePerYear" CloseDataSource="True" FieldAliases.Text="State=State&#13;&#10;ItemsTotal=ItemsTotal&#13;&#10;Expr1002=Year" SQL.Text="SELECT c.State, o.ItemsTotal, Year(o.SaleDate)&#13;&#10;FROM&#13;&#10;    orders o&#13;&#10;    INNER JOIN customer c ON (o.CustNo=c.CustNo)" SQLSchema="eAFtjj0LwjAQhvdA/skNl2AbO9wigghdpN2Cw9neUGwbSOL/N36gDvKOz/vl95x5x0nOWnWnliw2ztlm6yqtfM+XWVIhgUIcJSaoG6g3YBHBVKjVQMMt5bBIBIMObFV/mT/EaSxZpC5zFvg4BzCAT2ll6JhlSX3IPMN7I/xwSx3PUj7KP+rbab0+/iHZUmheQa3ulqA5dg==" CommandTimeout="30" PropData="05704C656674023C0470546F7003D8000A506172616D65746572730100"/>
    <TfrxADOQuery Name="ADOQuery4" UserName="SalesPerCustYearMonth" CloseDataSource="True" FieldAliases.Text="Company=Company&#13;&#10;Expr1001=Year&#13;&#10;Expr1002=Month&#13;&#10;ItemsTotal=ItemsTotal" SQL.Text="SELECT c.Company, YEAR(o.SaleDate), MONTH(o.SaleDate), o.ItemsTotal&#13;&#10;FROM&#13;&#10;    customer c&#13;&#10;    INNER JOIN orders o ON (c.CustNo=o.CustNo)" SQLSchema="eAFNjjELwjAQRvdA/skN11yKOtyigksXqVtwONMMxbaRpA7+e1MVlW98fI/n9jLLVnI4a9UeGyZCJFuvyGrlTnIZQi7Es7/nOY4hgSWgNRhEqGrUKnJMXUgZNgiG6AfcIfVduSLv4niT6QFfhYcK8DWtKm5lCCUiwEcU/6hr+um6BCAvF/NGWj0B39wweg==" CommandTimeout="30" PropData="05704C656674023C0470546F700320010A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" EndlessHeight="True" EndlessWidth="True" HGuides.Text="" VGuides.Text="">