<?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,5390650116" ScriptLanguage="PascalScript" ScriptText.Text="&#13;&#10;begin&#13;&#10;&#13;&#10;end." PropData="08446174617365747301010C2000000020446174615365743D2253514C2220446174615365744E616D653D2253514C2200010C3200000020446174615365743D224F7267616E69736174696F6E2220446174615365744E616D653D224F7267616E69736174696F6E2200010C2400000020446174615365743D2253656C57682220446174615365744E616D653D2253656C5768220000095661726961626C65730100055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxADODatabase Name="DB" LoginPrompt="False" PropData="05704C65667402250470546F700224"/>
    <TfrxADOQuery Name="SQL" UserName="SQL" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="exec [UP_ANALYSE_STK_BY_WAREHOUSE] '2012-4-1','2012-5-31','(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15)','(912,914,920,921,922)'                                                                                                                                                   " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C65667402540470546F7002240A506172616D65746572730100"/>
    <TfrxADOQuery Name="Organisation" UserName="Organisation" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="SELECT * FROM Organisation                                                                                                          " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C6566740383000470546F7002240A506172616D65746572730100"/>
    <TfrxADOQuery Name="SelWh" UserName="SelWh" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="select name from warehouse where id in (select whid from _tmp_Wh_IDs)                                                                                                 " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C65667403B7000470546F7002240A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page2" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="8" RightMargin="5" TopMargin="5" BottomMargin="5" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxReportTitle Name="ReportTitle2" Height="106,70972349" Left="0" Top="18,89765" Width="744,56741">
      <TfrxMemoView Name="Memo23" Align="baCenter" Left="30,03958" Top="64,13568333" Width="684,48825" Height="40,89765" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="elephant" Font.Style="4" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="ESTIMATIVA DE RECUPERAÇÃO QIANTITY POR ARMAZEM"/>
      <TfrxPictureView Name="PicLogo" Left="0" Top="0" Width="65,68825" Height="84,36431666" ShowHint="False" DataField="LOGO" DataSet="Organisation" DataSetName="Organisation" HightQuality="False"/>
      <TfrxMemoView Name="Memo24" Left="645,01968504" Top="15,66929134" Width="94,48818898" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="dd/mm/yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;FromDate&#34;]"/>
      <TfrxMemoView Name="Memo25" Left="645,01968504" Top="34,56692913" Width="94,48818898" Height="18,89765" ShowHint="False" DisplayFormat.FormatStr="dd/mm/yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;ToDate&#34;]"/>
      <TfrxMemoView Name="Memo26" Left="569,42913386" Top="15,66929134" Width="75,59055118" Height="15,11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="DE DATA"/>
      <TfrxMemoView Name="Memo27" Left="566,92913386" Top="36,2335958" Width="75,59055118" Height="15,11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="ATE DATA"/>
    </TfrxReportTitle>
    <TfrxMasterData Name="MasterData2" Height="13,22834646" Left="0" Top="291,02381" Width="744,56741" ColumnWidth="0" ColumnGap="0" DataSet="SQL" DataSetName="SQL" RowCount="0">
      <TfrxMemoView Name="Memo41" Left="0" Top="0" Width="56,69291339" Height="13,22834646" ShowHint="False" DataField="ItemCode" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="8388736" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Color="536870911" Frame.Typ="15" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;ItemCode&#34;]"/>
      <TfrxMemoView Name="Memo42" Left="60,4724409448819" Top="0" Width="226,77165354" Height="13,22834646" ShowHint="False" DataField="ItemName" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="8388736" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Color="536870911" Frame.Typ="15" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;ItemName&#34;]"/>
      <TfrxMemoView Name="Memo43" Left="291,023622047244" Top="0" Width="56,6929133858268" Height="13,22834646" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Color="536870911" Frame.Typ="15" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;Stock&#34;]"/>
      <TfrxMemoView Name="Memo47" Left="447,49606299" Top="0" Width="56,69291339" Height="13,22834646" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Color="536870911" Frame.Typ="15" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;AvgPerDay&#34;]"/>
      <TfrxMemoView Name="Memo51" Left="515,96850394" Top="0" Width="56,69291339" Height="13,22834646" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Color="536870911" Frame.Typ="15" HAlign="haRight" Highlight.Font.Charset="1" Highlight.Font.Color="0" Highlight.Font.Height="-9" Highlight.Font.Name="Arial" Highlight.Font.Style="1" Highlight.Color="255" Highlight.Condition="&#60;SQL.&#34;Estimation&#34;&#62;&#60;5" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;Estimation&#34;]"/>
      <TfrxMemoView Name="Memo2" Left="367,8" Top="0" Width="64,25197339" Height="13,22834646" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Color="536870911" Frame.Typ="15" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;SoldQty&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="PageFooter2" Height="39,67718" Left="0" Top="423,30736" Width="744,56741">
      <TfrxMemoView Name="Memo53" Align="baCenter" Left="244,886067205" Top="19,69264" Width="254,79527559" Height="12,11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="8421504" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[Page#]/[TotalPages#]"/>
      <TfrxMemoView Name="Memo54" Left="496,7444472" Top="8" Width="254,79527559" Height="12,11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="8421504" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[&#60;Date&#62;]  [&#60;Time&#62;]"/>
      <TfrxLineView Name="Line2" Left="0,83333333" Top="2,00896666999984" Width="759,5" Height="0,83333333" ShowHint="False" Diagonal="True"/>
      <TfrxMemoView Name="Memo37" Left="0" Top="7,55906" Width="325,89528774" Height="15,11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="8421504" Font.Height="-9" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="DESENVOLVIDO COM THE MASTER - info@ridleys.co.ao - 925489228"/>
    </TfrxPageFooter>
    <TfrxGroupHeader Name="GroupHeader1" Height="49,2030178" Left="0" Top="219,21274" Width="744,56741" Condition="SQL.&#34;familycode&#34;">
      <TfrxMemoView Name="Memo1" Left="0,8" Top="30,30538" Width="743,89291339" Height="18,8976378" ShowHint="False" Color="14211288" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="5" Frame.Color="536870911" Frame.Typ="15" Frame.Width="0,1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo29" Left="0" Top="30,23622047" Width="56,69291339" Height="18,8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="5" Frame.Color="536870911" Frame.Typ="15" Frame.Width="0,1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="CODE"/>
      <TfrxMemoView Name="Memo30" Left="60,4724409448819" Top="30,2362204724409" Width="226,771653543307" Height="18,8976377952756" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="5" Frame.Color="536870911" Frame.Typ="15" Frame.Width="0,1" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="DESCR"/>
      <TfrxMemoView Name="Memo31" Left="291,02362205" Top="30,23622047" Width="56,69291339" Height="18,8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="5" Frame.Color="536870911" Frame.Typ="15" Frame.Width="0,1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="STOCK"/>
      <TfrxMemoView Name="Memo35" Left="447,49606299" Top="30,23622047" Width="56,69291339" Height="18,8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="5" Frame.Color="536870911" Frame.Typ="15" Frame.Width="0,1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="DAIRIA"/>
      <TfrxMemoView Name="Memo39" Left="515,96850394" Top="30,23622047" Width="56,69291339" Height="18,8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="5" Frame.Color="536870911" Frame.Typ="15" Frame.Width="0,1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="COVER"/>
      <TfrxMemoView Name="SQLFamilyName" Left="-3,77952755905512" Top="0" Width="472,29684667" Height="27,67718" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Color="8421504" Frame.DropShadow="True" Frame.Width="2" ParentFont="False" VAlign="vaCenter" Text=" [SQL.&#34;FamilyName&#34;]"/>
      <TfrxMemoView Name="Memo3" Left="368,6" Top="30,23622047" Width="64,25197339" Height="18,8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="5" Frame.Color="536870911" Frame.Typ="15" Frame.Width="0,1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="QTD Vendida"/>
    </TfrxGroupHeader>
    <TfrxGroupFooter Name="GroupFooter1" Height="34,51051333" Left="0" Top="328,81911" Width="744,56741"/>
    <TfrxMasterData Name="MasterData1" Height="12,49765" Left="0" Top="185,19697" Width="744,56741" Columns="8" ColumnWidth="94,488188976378" ColumnGap="0" DataSet="SelWh" DataSetName="SelWh" RowCount="0">
      <TfrxMemoView Name="SelWhname" Left="0" Top="0" Width="94,48818898" Height="12,49765" ShowHint="False" Color="13296895" DataField="name" DataSet="SelWh" DataSetName="SelWh" Font.Charset="1" Font.Color="0" Font.Height="-9" Font.Name="Arial" Font.Style="0" Frame.Typ="15" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SelWh.&#34;name&#34;]"/>
    </TfrxMasterData>
  </TfrxReportPage>
</TfrxReport>
