<?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="43147.4825071065" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end." PropData="08446174617365747301010C2000000020446174615365743D2253514C2220446174615365744E616D653D2253514C2200010C3200000020446174615365743D224F7267616E69736174696F6E2220446174615365744E616D653D224F7267616E69736174696F6E2200010C2200000020446174615365743D224974656D2220446174615365744E616D653D224974656D220000095661726961626C65730100055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxADODatabase Name="DB" LoginPrompt="False" PropData="05704C65667402240470546F700224"/>
    <TfrxADOQuery Name="SQL" UserName="SQL" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="select  'RealDate Between 11/2/2014 AND 16/2/2018 All' as FilterView, ItemFamily,Code,Description1 ,sum(OrderedQty)as OrderedQty,SUM(DeliveredQty)as DeliveredQty,SUM(PendingQty)as PendingQty,dbo.fn_ibt_qty(ItemID,'2014-2-11','2018-2-16')As IBTQty From Vw_Sale_Order_Report_Summary  Where RealDate Between '2014-2-11' AND '2018-2-16' group by ItemFamily,ItemID, Code,Description1 order by ItemFamily, code  " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C65667403A7000470546F7003D1000A506172616D65746572730100"/>
    <TfrxADOQuery Name="Organisation" UserName="Organisation" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="SELECT * FROM Organisation                                                                                                          " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C65667403B4010470546F7002500A506172616D65746572730100"/>
    <TfrxADOTable Name="Item" UserName="Item" CloseDataSource="True" FieldAliases.Text="" Master="SQL" MasterFields="Code=Code" TableName="Item" IndexFieldNames="Code" Database="DB" PropData="05704C656674030C010470546F70035001"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="7.5" RightMargin="5" TopMargin="5" BottomMargin="5" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" Height="17.00787402" Left="0" Top="355.27582" Width="746.457175" ColumnWidth="0" ColumnGap="0" DataSet="SQL" DataSetName="SQL" RowCount="0">
      <TfrxMemoView Name="Memo2" Left="0" Top="1.88976378" Width="83.14966" Height="15.11811024" ShowHint="False" DataField="Code" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" WordWrap="False" Text="[SQL.&#34;Code&#34;]"/>
      <TfrxMemoView Name="SQLDescription1" Left="94.48825" Top="1.88976378" Width="340.1577" Height="15.11811024" ShowHint="False" DataField="Description1" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" WordWrap="False" Text="[SQL.&#34;Description1&#34;]"/>
      <TfrxMemoView Name="TxtPedido" Left="440.88219" Top="1.88976378" Width="60.47248" Height="15.11811024" ShowHint="False" DataField="OrderedQty" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;OrderedQty&#34;]"/>
      <TfrxMemoView Name="SQLDeliveredQty" Left="601.59091" Top="1.88976378" Width="64.25201" Height="15.11811024" 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" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[&#60;SQL.&#34;OrderedQty&#34;&#62;+&#60;SQL.&#34;IBTQty&#34;&#62;]"/>
      <TfrxMemoView Name="TxtIBT" Left="514.23655" Top="1.88976378" Width="60.47248" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SQL.&#34;IBTQty&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="PageFooter1" Height="41.57483" Left="0" Top="623.62245" Width="746.457175">
      <TfrxMemoView Name="Memo1" Left="192.75603" Top="18.89765" Width="294.80330339" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="8421504" Font.Height="-11" Font.Name="Courier New" Font.Style="0" HAlign="haCenter" ParentFont="False" Text="PAGE [Page#] OF [TotalPages#]"/>
      <TfrxMemoView Name="Memo7" Left="491.3389" Top="3.77953000000014" Width="177.63787339" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Courier New" Font.Style="2" HAlign="haRight" ParentFont="False" Text="[Date]  [Time]"/>
      <TfrxMemoView Name="Memo37" Left="0" Top="0" 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>
    <TfrxReportTitle Name="ReportTitle1" Height="222.9922578" Left="0" Top="18.89765" Width="746.457175">
      <TfrxPictureView Name="PicLogo" Left="1" Top="13.11812" Width="154.19304472" Height="127.30890524" ShowHint="False" Center="True" DataField="Logo" DataSet="Organisation" DataSetName="Organisation" Picture.PropData="[encoded data, 77492 characters]" HightQuality="True"/>
      <TfrxMemoView Name="Memo16" Align="baCenter" Left="195.0118275" Top="70.34693905" Width="356.43352" Height="35.69295" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-19" Font.Name="Courier New" Font.Style="5" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="SALE ORDER RESUME"/>
      <TfrxMemoView Name="Memo30" Align="baLeft" Left="0" Top="128.50402" Width="730.60699" Height="50.81107" ShowHint="False" Font.Charset="1" Font.Color="16711680" Font.Height="-13" Font.Name="Courier New" Font.Style="1" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="[SQL.&#34;FilterView&#34;]"/>
      <TfrxMemoView Name="Memo13" Left="0" Top="200.31509" Width="748.34689118" Height="22.6771678" ShowHint="False" Color="4643583" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="8421504" HAlign="haCenter" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text=""/>
      <TfrxMemoView Name="Memo5" Left="-0.22047" Top="204.52767378" Width="83.14966" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" Text="CODIGO"/>
      <TfrxMemoView Name="Memo6" Left="94.26778" Top="204.52767378" Width="340.1577" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" Text="DESCR"/>
      <TfrxMemoView Name="Memo8" Left="440.66172" Top="204.52767378" Width="60.47248" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="PEDIDO"/>
      <TfrxMemoView Name="Memo9" Left="601.37044" Top="204.52767378" Width="68.03154" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="TOTAL"/>
      <TfrxMemoView Name="Memo11" Left="514.01608" Top="204.47244094" Width="60.47248" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="IBT"/>
    </TfrxReportTitle>
    <TfrxReportSummary Name="ReportSummary1" Height="98.26778" Left="0" Top="502.67749" Width="746.457175">
      <TfrxLineView Name="Line1" Left="305.3624" Top="23" Width="438.42548" Height="0" ShowHint="False" Diagonal="True"/>
      <TfrxMemoView Name="Memo18" Left="437.42548" Top="23.7953" Width="60.47248" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;OrderedQty&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo19" Left="598.1342" Top="23.7953" Width="68.03154" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;OrderedQty&#34;&#62;+&#60;SQL.&#34;IBTQty&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo21" Left="510.77984" Top="23.7953" Width="60.47248" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;IBTQty&#34;&#62;,MasterData1)]"/>
    </TfrxReportSummary>
    <TfrxGroupHeader Name="GroupHeader1" Height="29.23624" Left="0" Top="302.3624" Width="746.457175" Condition="SQL.&#34;ItemFamily&#34;">
      <TfrxMemoView Name="Memo3" Left="0" Top="6.55906" Width="260.78757" Height="22.67718" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.DropShadow="True" ParentFont="False" Text="[SQL.&#34;ItemFamily&#34;]"/>
    </TfrxGroupHeader>
    <TfrxGroupFooter Name="GroupFooter1" Height="45.35436" Left="0" Top="396.85065" Width="746.457175">
      <TfrxMemoView Name="Memo12" Left="440.42548" Top="0" Width="60.47248" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="8421504" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;OrderedQty&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo14" Left="601.1342" Top="0" Width="68.03154" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="8421504" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;OrderedQty&#34;&#62;+&#60;SQL.&#34;IBTQty&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo17" Left="513.77984" Top="0" Width="60.47248" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" Frame.Color="8421504" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;IBTQty&#34;&#62;,MasterData1)]"/>
    </TfrxGroupFooter>
  </TfrxReportPage>
</TfrxReport>
