<?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="">
    <TfrxReportTitle Name="ReportTitle1" Height="22,67718" Left="0" Top="18,89765" Width="718,1107" Child="Child1">
      <TfrxMemoView Name="Memo1" Left="75,5906" Top="0" Width="234,33086" Height="18,89765" DisplayFormat.DecimalSeparator="," Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Number of customers in each state"/>
    </TfrxReportTitle>
    <TfrxChild Name="Child1" Height="106" Left="0" Top="64,25201" Width="718,1107" Child="Child2">
      <TfrxDBCrossView Name="DBCross1" Left="37,7953" Top="0" Width="85" Height="106" AddHeight="0" AddWidth="0" DownThenAcross="False" NextCrossGap="0" RowLevels="0" ShowColumnTotal="False" CellFields.Text="Company" ColumnFields.Text="State" DataSet="ADOQuery1" DataSetName="CustPerState" RowFields.Text="" PropData="[encoded data, 8608 characters]"/>
    </TfrxChild>
    <TfrxChild Name="Child2" Height="34,01577" Left="0" Top="192,75603" Width="718,1107" Child="Child3">
      <TfrxMemoView Name="Memo2" Left="75,5906" Top="11,33859" Width="215,43321" Height="18,89765" DisplayFormat.DecimalSeparator="," Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Sales in each state"/>
    </TfrxChild>
    <TfrxChild Name="Child3" Height="106" Left="0" Top="249,44898" Width="718,1107" Child="Child4">
      <TfrxDBCrossView Name="DBCross2" Left="37,7953" Top="0" Width="166" Height="106" AddHeight="0" AddWidth="0" DownThenAcross="False" NextCrossGap="0" RowLevels="0" CellFields.Text="ItemsTotal" ColumnFields.Text="State" DataSet="ADOQuery2" DataSetName="SalesPerState" RowFields.Text="" PropData="[encoded data, 8938 characters]"/>
    </TfrxChild>
    <TfrxChild Name="Child4" Height="37,7953" Left="0" Top="377,953" Width="718,1107" Child="Child5">
      <TfrxMemoView Name="Memo3" Left="75,5906" Top="15,11812" Width="234,33086" Height="18,89765" DisplayFormat.DecimalSeparator="," Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Sales in each state grouped by year"/>
    </TfrxChild>
    <TfrxChild Name="Child5" Height="128" Left="0" Top="438,42548" Width="718,1107" Child="Child6">
      <TfrxDBCrossView Name="DBCross3" Left="37,7953" Top="0" Width="245" Height="128" AddHeight="0" AddWidth="0" DownThenAcross="False" NextCrossGap="0" CellFields.Text="ItemsTotal" ColumnFields.Text="Year" DataSet="ADOQuery3" DataSetName="SalesPerStatePerYear" RowFields.Text="State" PropData="[encoded data, 10904 characters]"/>
    </TfrxChild>
    <TfrxChild Name="Child6" Height="37,7953" Left="0" Top="589,60668" Width="718,1107" Child="Child7">
      <TfrxMemoView Name="Memo4" Left="75,5906" Top="11,33859" Width="321,26005" Height="18,89765" DisplayFormat.DecimalSeparator="," Font.Charset="1" Font.Color="-2147483640" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Sales by customers grouped by year and month"/>
    </TfrxChild>
    <TfrxChild Name="Child7" Height="150" Left="0" Top="650,07916" Width="718,1107">
      <TfrxDBCrossView Name="DBCross4" Left="37,7953" Top="0" Width="296" Height="150" AddHeight="0" AddWidth="0" ColumnLevels="2" DownThenAcross="False" NextCrossGap="0" CellFields.Text="ItemsTotal" ColumnFields.Text="Year&#13;&#10;Month" DataSet="ADOQuery4" DataSetName="SalesPerCustYearMonth" RowFields.Text="Company" PropData="[encoded data, 14368 characters]"/>
    </TfrxChild>
  </TfrxReportPage>
</TfrxReport>
