<?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="40161,5850336343" ReportOptions.Description.Text="" ReportOptions.LastChange="42320,5777650926" 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="05704C6566740318010470546F700250"/>
    <TfrxADOQuery Name="SQL" UserName="SQL" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="select&#13;&#10;Code, &#13;&#10;Description1 + ' ' + IsNull(Packing,'') AS Item, &#13;&#10;InitialWarehouse AS Warehouse, &#13;&#10;Sum(Qty) As Qty &#13;&#10;From Vw_Existencia_Ate_Data  &#13;&#10;WHERE  &#13;&#10;ItemID IN (136,137,138,139,140,141,142,143,1057,144,145,146,147,148,149,150) &#13;&#10;AND &#13;&#10;WhID  IN (921,912,913,914,915,916,917,918,919,920,968,922,969,970,971,923,972,973,974,924,975,976,925,926,927,928,930,931,929,932,933,934,935,936,1001,937,941,938,939,940,942,943,944,945,947,948,949,953,950,946,951,952,954,955,956,960,961,962,963,964,965,966,967)  &#13;&#10;AND [date] &#60; = '2012-5-9' &#13;&#10;Group By Code, InitialWarehouse  ,Description1, Packing  ORDER BY InitialWarehouse,Description1   " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C65667403B4010470546F7002500A506172616D65746572730100"/>
    <TfrxADOQuery Name="Organisation" UserName="Organisation" CloseDataSource="True" FieldAliases.Text="" IgnoreDupParams="False" SQL.Text="SELECT * FROM Organisation                                                                                                          " CommandTimeout="30" Database="DB" LockType="ltReadOnly" PropData="05704C656674026C0470546F7002500A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" Orientation="poLandscape" PaperWidth="420" PaperHeight="297" PaperSize="8" LeftMargin="5" RightMargin="5" TopMargin="5" BottomMargin="5" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxDBCrossView Name="DBCross1" Left="0" Top="0" Width="223" Height="92" ShowHint="False" AddHeight="0" AddWidth="0" DownThenAcross="False" NextCrossGap="0" RowLevels="2" ShowCorner="False" ShowTitle="False" CellFields.Text="Qty" ColumnFields.Text="Warehouse" DataSet="SQL" DataSetName="SQL" RowFields.Text="Code&#13;&#10;Item" PropData="[encoded data, 12332 characters]"/>
  </TfrxReportPage>
</TfrxReport>
