<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.3.16" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.Author="Cüneyt ELİBOL" ReportOptions.CreateDate="42772" ReportOptions.Description.Text="" ReportOptions.LastChange="42772,5892560069" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="KullaniciQ" DataSetName="Alanlar"/>
  </Datasets>
  <TfrxDataPage Name="PXData" Height="1000" Left="0" Top="0" Width="1000">
    <TfrxFDQuery Name="KullaniciQ" UserName="Alanlar" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Set DateFormat DMY &#13;&#10; SELECT  &#13;&#10;   CAST(CONVERT(VARCHAR, TARIH, 104) AS DATE) AS TARIH, ISLEM, BELGENO, S.STOKKODU, S.CINSI, C.FIRMAKODU, C.FIRMAADI, PARCASAYISI, &#13;&#10;   FIYATI, FIYATI * PARCASAYISI AS TUTARI &#13;&#10; FROM &#13;&#10; ( &#13;&#10; Select  &#13;&#10;   H.TARIH,  &#13;&#10;   CASE ISLEM  &#13;&#10;     WHEN 237 THEN 'KESİMDEN GİRİŞ'  &#13;&#10; 	WHEN 238 THEN 'FASONA GİDİŞ'  &#13;&#10; 	WHEN 239 THEN 'FASONDAN GELİŞ'  &#13;&#10; 	WHEN 240 THEN 'ÜRETİMDEN GİRİŞ' &#13;&#10;   END AS ISLEM, &#13;&#10;   H.BELGENO, UA.CIKISSTOK AS STOKNO, H.FASONCU, PARCASAYISI, PARCAUCRETI AS FIYATI &#13;&#10; From TBLSTOKURETIMISEMRIHAREKET H &#13;&#10; LEFT OUTER JOIN TBLSTOKURETIMISEMRI B ON B.ID = H.ISEMRINO &#13;&#10; LEFT OUTER JOIN TBLSTOKURUNAGACI UA ON UA.ID = B.URUNAGACIID &#13;&#10; UNION ALL &#13;&#10; Select  &#13;&#10;   H.TARIH, 'ARIZALI GELEN', B.BELGENO, UA.CIKISSTOK AS STOKNO, FASONCU,  PARCASAYISI, FIYATI &#13;&#10; from TBLSTOKURETIMISEMRIHAREKETARIZALIGELEN A &#13;&#10; LEFT OUTER JOIN TBLSTOKURETIMISEMRIHAREKET H ON A.ID = A.BASLIKID &#13;&#10; LEFT OUTER JOIN TBLSTOKURETIMISEMRI B ON B.ID = H.ISEMRINO &#13;&#10; LEFT OUTER JOIN TBLSTOKURUNAGACI UA ON UA.ID = B.URUNAGACIID &#13;&#10; UNION ALL &#13;&#10; SELECT  &#13;&#10;   TARIH, ISLEM, BELGENO, STOKID, CARIID, CASE WHEN GIREN &#62; 0 THEN GIREN ELSE CIKAN END, FIYATI &#13;&#10; from STOKHAREKET &#13;&#10; WHERE ISLEMTIPI NOT IN (145, 237, 237, 239, 240) &#13;&#10; ) AS A &#13;&#10; LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = A.STOKNO &#13;&#10; LEFT OUTER JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON C.KARTNO = A.FASONCU  &#13;&#10;     " PropData="05704C65667402640470546F7002640A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" PaperWidth="210" PaperHeight="297" PaperSize="256" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxPageHeader Name="HEADER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="137,7953" Left="0" Top="16" Width="718,1107">
      <TfrxMemoView Name="BASLIK" Left="2" Top="1" Width="715,98423" Height="25" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX Ürün Ağacı Hareket Raporu"/>
      <TfrxMemoView Name="TARIH" Left="598,42517" Top="25" Width="117,44094" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Date]"/>
      <TfrxLineView Name="BASLIKCIZGI" Left="1" Top="135,7953" Width="716,85034" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="TARIHBASLIK" Left="0" Top="113,7953" Width="73,54329" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Tarih"/>
      <TfrxMemoView Name="ISLEMBASLIK" Left="78" Top="113,7953" Width="107,55906" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="İşlem"/>
      <TfrxMemoView Name="BELGENOBASLIK" Left="192,33859" Top="113,7953" Width="81,10235" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Belge No"/>
      <TfrxMemoView Name="FIRMAADIBASLIK" Left="274,72418" Top="113,7953" Width="202,04731" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Firma Adı"/>
      <TfrxMemoView Name="PARCASAYISIBASLIK" Left="477,53525" Top="113,7953" Width="62,2047" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Miktarı"/>
      <TfrxMemoView Name="Memo1" Left="542,1342" Top="113,7953" Width="79,37013" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Fiyatı"/>
      <TfrxMemoView Name="Memo2" Left="623,62245" Top="113,7953" Width="94,48825" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Tutarı"/>
      <TfrxMemoView Name="Memo6" Left="11,33859" Top="52,91342" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Ürün Kodu : "/>
      <TfrxMemoView Name="Memo7" Left="11,33859" Top="75,14966" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Ürün Adı : "/>
      <TfrxMemoView Name="AlanlarSTOKKODU" Left="107,60637" Top="52,91342" Width="400,63018" Height="18,89765" DataField="STOKKODU" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="AlanlarCINSI" Left="107,60637" Top="75,14966" Width="400,63018" Height="18,89765" DataField="CINSI" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;CINSI&#34;]"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="21" Left="0" Top="172" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxMemoView Name="TARIHVIEW" Left="0" Top="0,5" Width="73,54329" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="ISLEMVIEW" Left="78" Top="0" Width="107,55906" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;ISLEM&#34;]"/>
      <TfrxMemoView Name="BELGENOVIEW" Left="192,33859" Top="0" Width="81,10235" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="FIRMAADIVIEW" Left="274,72418" Top="0" Width="202,04731" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;FIRMAADI&#34;]"/>
      <TfrxMemoView Name="PARCASAYISIVIEW" Left="477,53525" Top="0" Width="62,2047" Height="20" DisplayFormat.FormatStr="#,#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;PARCASAYISI&#34;]"/>
      <TfrxMemoView Name="AlanlarFIYATI" Left="542,1342" Top="0" Width="79,37013" Height="18,89765" DataField="FIYATI" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="AlanlarTUTARI" Left="623,62245" Top="0" Width="94,48825" Height="18,89765" DataField="TUTARI" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;TUTARI&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="40" Left="0" Top="280" Width="718,1107">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="1" Width="800" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="FOOTERBASLIK" Left="3" Top="11" Width="714,25201" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX ile (www.elibolyazilim.com) [date] Tarihinde Yazdırılmıştır"/>
      <TfrxMemoView Name="FOOTERSAYFA" Left="670" Top="10" Width="120" Height="25" Text="Sayfa:  [Page#] / [TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="49,13389" Left="0" Top="212" Width="718,1107">
      <TfrxLineView Name="Line1" Left="0,77953" Top="7,55906" Width="716,85034" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo3" Left="360,49629" Top="18,89765" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Toplamlar: "/>
      <TfrxMemoView Name="Memo4" Left="477,53525" Top="18,89765" Width="62,2047" Height="18,89765" DisplayFormat.FormatStr="#,#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;PARCASAYISI&#34;&#62;,MASTERDATA)]"/>
      <TfrxMemoView Name="Memo5" Left="623,62245" Top="18,89765" Width="94,48825" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;TUTARI&#34;&#62;,MASTERDATA)]"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
