<?xml version="1.0" encoding="utf-8"?>
<TfrxReport Version="4.6.98" DotMatrixReport="False" EngineOptions.UseFileCache="True" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Default" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="39863,6152412384" ReportOptions.Description.Text="" ReportOptions.LastChange="42320,4557606134" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end." PropData="08446174617365747301010C2000000020446174615365743D2253514C2220446174615365744E616D653D2253514C2200010C3200000020446174615365743D224F7267616E69736174696F6E2220446174615365744E616D653D224F7267616E69736174696F6E220000095661726961626C65730100055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxADODatabase Name="DB" LoginPrompt="False" PropData="05704C65667402230470546F700221"/>
    <TfrxADOQuery Name="SQL" UserName="SQL" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="select &#13;&#10;2012 As MyYear, &#13;&#10;ItemID, ItemCode, ItemName,FamilyCode,FamilyName,MainSupplier,&#13;&#10;MONTH(date)As M,&#13;&#10;SUM(Qty) As Q &#13;&#10;from VwRelatorioDeCompra  &#13;&#10;WHERE  &#13;&#10;ItemID IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,1605,1050,1051,1231,118,128,1235,1033,1034,1038) &#13;&#10;AND &#13;&#10;WhID  IN (911,1000,997,999,998)  &#13;&#10;AND &#13;&#10;Year(Date) = 2012&#13;&#10;group by &#13;&#10;ItemID, ItemCode, ItemName,FamilyCode,FamilyName,MainSupplier,Month(Date)  &#13;&#10;order by M,FamilyCode,ItemCode&#13;&#10;&#13;&#10;  " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C65667402530470546F7002210A506172616D65746572730100"/>
    <TfrxADOQuery Name="Organisation" UserName="Organisation" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="SELECT * FROM Organisation                                                                                                          " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C6566740384000470546F7002210A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" Orientation="poLandscape" PaperWidth="279,4" PaperHeight="215,9" PaperSize="1" LeftMargin="5" RightMargin="5" TopMargin="5" BottomMargin="5" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxPageFooter Name="PageFooter2" Height="41,57483" Left="0" Top="177,63791" Width="1018,205382">
      <TfrxMemoView Name="Memo2" Align="baCenter" Left="361,701039305" Top="18,09765" Width="294,80330339" Height="15,91811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Courier New" Font.Style="0" HAlign="haCenter" ParentFont="False" Text="PAGE [Page#] OF [TotalPages#]"/>
      <TfrxMemoView Name="Memo3" Left="831,3389" Top="4,57953" Width="177,63787339" Height="15,11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="8421504" Font.Height="-8" Font.Name="Courier New" Font.Style="2" HAlign="haRight" ParentFont="False" Text="[Date]  [Time]"/>
    </TfrxPageFooter>
    <TfrxReportTitle Name="ReportTitle2" Height="97,78787905" Left="0" Top="18,89765" Width="1018,205382">
      <TfrxPictureView Name="PicLogo" Left="4,2" Top="1,91812" Width="59,02458472" Height="81,95454524" ShowHint="False" Center="True" DataField="Logo" DataSet="Organisation" DataSetName="Organisation" Picture.PropData="[encoded data, 77492 characters]" HightQuality="True"/>
      <TfrxMemoView Name="Memo4" Align="baCenter" Left="177,635591" Top="46,81304905" Width="662,9342" Height="25,37483" ShowHint="False" Font.Charset="1" Font.Color="2105376" Font.Height="-16" Font.Name="Courier New" Font.Style="5" HAlign="haCenter" ParentFont="False" Text="RELATORIO DE COMPRA MENSAL ([SQL.&#34;MyYear&#34;])"/>
    </TfrxReportTitle>
    <TfrxDBCrossView Name="DBCross2" Align="baLeft" ShiftMode="smDontShift" Left="0" Top="124,76877" Width="662" Height="91,65669291" ShowHint="False" AddHeight="0" AddWidth="0" AutoSize="False" DownThenAcross="False" NextCrossGap="0" RowLevels="4" ShowTitle="False" CellFields.Text="Q" ColumnFields.Text="M" DataSet="SQL" DataSetName="SQL" RowFields.Text="FamilyName&#13;&#10;ItemCode&#13;&#10;ItemName&#13;&#10;MainSupplier" PropData="[encoded data, 21654 characters]"/>
  </TfrxReportPage>
</TfrxReport>
