<?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="42377.4779832639" ScriptLanguage="PascalScript" ScriptText.Text="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="05704C65667402240470546F700224"/>
    <TfrxADOQuery Name="SQL" UserName="SQL" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="select '2015-7-24' As TillDate ,WhID,whCode ,whName,sum(Total) as Total,sum(TotalPrice)As TotalPrice,180 as USDRate from VwTotalOfWarehouse where whid in (951,963,967) and [date]&#60;='2015-7-24'  group by WhID, whCode ,whName                                                                                                                    " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C65667402530470546F7002230A506172616D65746572730100"/>
    <TfrxADOQuery Name="Organisation" UserName="Organisation" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="SELECT * FROM Organisation                                                                                                          " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C6566740330010470546F7002380A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="5" TopMargin="7.5" BottomMargin="5" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxMasterData Name="MasterData1" Height="15.11811024" Left="0" Top="253.22851" Width="737.00835" ColumnWidth="0" ColumnGap="0" DataSet="SQL" DataSetName="SQL" RowCount="0">
      <TfrxMemoView Name="Memo2" Left="0" Top="0" Width="56.40167" Height="15.1181102362205" ShowHint="False" 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;whCode&#34;]"/>
      <TfrxMemoView Name="Memo10" Left="60.47248" Top="0" Width="166.00804" Height="15.11811024" ShowHint="False" 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;whName&#34;]"/>
      <TfrxMemoView Name="SQLTotal" Left="319.370078740157" Top="0" Width="75.5905511811024" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" 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="[SQL.&#34;Total&#34;]"/>
      <TfrxMemoView Name="SQLTotalPrice" Left="239.622047244094" Top="0" Width="75.5905511811024" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" 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="[SQL.&#34;TotalPrice&#34;]"/>
      <TfrxMemoView Name="Memo4" Left="398.16535433" Top="0" Width="75.59055118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" 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;TotalPrice&#34;&#62;-&#60;SQL.&#34;Total&#34;&#62;]"/>
      <TfrxMemoView Name="Memo24" Left="497.22834646" Top="0" Width="75.59055118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" 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;TotalPrice&#34;&#62;/&#60;SQL.&#34;USDRate&#34;&#62;]"/>
      <TfrxMemoView Name="Memo26" Left="576.5984252" Top="0" Width="75.59055118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" 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;Total&#34;&#62;/&#60;SQL.&#34;USDRate&#34;&#62;]"/>
      <TfrxMemoView Name="Memo27" Left="655.96850394" Top="0" Width="75.59055118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" 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;TotalPrice&#34;&#62;-&#60;SQL.&#34;Total&#34;&#62;)/&#60;SQL.&#34;USDRate&#34;&#62;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="PageFooter1" Height="41.57483" Left="0" Top="434.64595" Width="737.00835">
      <TfrxMemoView Name="Memo1" Left="3.77953" Top="22.67718" Width="729.44925339" 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="49.13389" Top="3.77953000000008" Width="684.09489339" 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="3.77953" 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>
    <TfrxReportTitle Name="ReportTitle1" Height="175.07875236" Left="0" Top="18.89765" Width="737.00835">
      <TfrxMemoView Name="Memo23" Left="0" Top="154.65368" Width="737.00787646" Height="18.89765" ShowHint="False" Color="13434879" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" Text=""/>
      <TfrxMemoView Name="Memo22" Left="0" Top="132.3859" Width="737.00787646" Height="22.67718" ShowHint="False" Color="7000063" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="1" ParentFont="False" WordWrap="False" Text=""/>
      <TfrxPictureView Name="PicLogo" Left="3.77953" Top="4.11812" Width="173.9605152" Height="95.37786" ShowHint="False" Center="True" DataField="Logo" DataSet="Organisation" DataSetName="Organisation" Picture.PropData="[encoded data, 77492 characters]" HightQuality="True"/>
      <TfrxMemoView Name="Memo25" Align="baCenter" Left="111.49616551" Top="64.25201" Width="514.01601898" Height="30.23623024" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="-16777208" Font.Height="-21" Font.Name="Courier New" Font.Style="5" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="EXISTENCIA DE ARMAZEM"/>
      <TfrxMemoView Name="Memo15" Left="7" Top="132.28346457" Width="226.77165354" Height="18.8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="5" ParentFont="False" VAlign="vaCenter" Text="Warehouse"/>
      <TfrxMemoView Name="Memo3" Left="239.622047244094" Top="156.18110236" Width="75.5905511811024" Height="18.89765" 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" VAlign="vaCenter" Text="PRICE"/>
      <TfrxMemoView Name="Memo5" Left="632.29926386" Top="18.89764512" Width="94.48825" Height="18.8976378" ShowHint="False" Color="14211288" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[SQL.&#34;TillDate&#34;] "/>
      <TfrxMemoView Name="Memo6" Left="632.29926386" Top="49.13386559" Width="94.48825" Height="18.8976378" ShowHint="False" Color="14211288" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[SQL.&#34;USDRate&#34;] "/>
      <TfrxMemoView Name="Memo8" Left="532.91343709" Top="18.89764512" Width="94.48818898" Height="18.8976378" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Til Date"/>
      <TfrxMemoView Name="Memo9" Left="532.91343709" Top="49.13386559" Width="94.48818898" Height="18.8976378" ShowHint="False" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Current USD Rate"/>
      <TfrxMemoView Name="Memo11" Left="239.5511811" Top="132.28346457" Width="234.33070866" Height="18.8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="5" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="TOTAL (LOCAL CURRENCY)"/>
      <TfrxMemoView Name="Memo12" Left="319.370078740157" Top="156.18110236" Width="75.5905511811024" Height="18.89765" 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" VAlign="vaCenter" Text="COST"/>
      <TfrxMemoView Name="Memo13" Left="398.29133858" Top="156.18110236" Width="75.59055118" Height="18.89765" 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" VAlign="vaCenter" Text="GROSS"/>
      <TfrxMemoView Name="Memo14" Left="7" Top="156.18110236" Width="56.69291339" Height="18.89765" 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="CODE"/>
      <TfrxMemoView Name="Memo16" Left="67.47244094" Top="156.18110236" Width="166.2992126" Height="18.89765" 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" VAlign="vaCenter" Text="NAME"/>
      <TfrxMemoView Name="Memo17" Left="497.3389" Top="156.18110236" Width="75.59055118" Height="18.89765" 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" VAlign="vaCenter" Text="PRICE"/>
      <TfrxMemoView Name="Memo18" Left="497.3389" Top="132.28346457" Width="234.33070866" Height="18.8976378" ShowHint="False" DataSet="SQL" DataSetName="SQL" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="5" HAlign="haCenter" ParentFont="False" VAlign="vaCenter" Text="TOTAL (USD-CURRENT RATE)"/>
      <TfrxMemoView Name="Memo20" Left="576.70897874" Top="156.18110236" Width="75.59055118" Height="18.89765" 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" VAlign="vaCenter" Text="COST"/>
      <TfrxMemoView Name="Memo21" Left="656.07905748" Top="156.18110236" Width="75.59055118" Height="18.89765" 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" VAlign="vaCenter" Text="GROSS"/>
    </TfrxReportTitle>
    <TfrxReportSummary Name="ReportSummary1" Height="83.01051333" Left="0" Top="328.81911" Width="737.00835">
      <TfrxMemoView Name="Memo28" Left="238.11039" Top="7.55906" Width="79.37008118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Tahoma" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;TotalPrice&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo29" Left="317.48046874" Top="7.55906" Width="79.37008118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Tahoma" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;Total&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo30" Left="396.85054748" Top="7.55906" Width="79.37008118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Tahoma" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;TotalPrice&#34;&#62;-&#60;SQL.&#34;Total&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo31" Left="495.91353961" Top="7.55906" Width="79.37008118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Tahoma" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;TotalPrice&#34;&#62;/&#60;SQL.&#34;USDRate&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo32" Left="575.28361835" Top="7.55906" Width="79.37008118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Tahoma" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM(&#60;SQL.&#34;Total&#34;&#62;/&#60;SQL.&#34;USDRate&#34;&#62;,MasterData1)]"/>
      <TfrxMemoView Name="Memo33" Left="654.65369709" Top="7.55906" Width="79.37008118" Height="15.11811024" ShowHint="False" DataSet="SQL" DataSetName="SQL" DisplayFormat.FormatStr="#,###.00" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-8" Font.Name="Tahoma" Font.Style="1" Frame.Typ="4" HAlign="haRight" ParentFont="False" WordWrap="False" VAlign="vaCenter" Text="[SUM((&#60;SQL.&#34;TotalPrice&#34;&#62;-&#60;SQL.&#34;Total&#34;&#62;)/&#60;SQL.&#34;USDRate&#34;&#62;,MasterData1)]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
