<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="5.1.9" 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="41986" ReportOptions.Description.Text="" ReportOptions.LastChange="41986,9293745718" 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="Select &#13;&#10;  A.STOKID, DEPO AS DEPOID, D.KOD AS DEPOKOD, D.ACIKLAMA AS DEPOADI, S.STOKKODU, S.CINSI, B.BIRIMADI,&#13;&#10;  S.ETKENMADDE AS ANAGRUP, S.GRUPADI AS ALTGRUP, KOD1, KOD2, KOD3, KOD4, KOD5,  &#13;&#10;  (Sum(A.GIREN) - SUM(A.CIKAN)) / B.CARPAN AS DEPO From (&#13;&#10;Select &#13;&#10;  ISLEM, D.STOKID, D.CIKISDEPO AS DEPO, STOKKODU, CINSI, 0 AS GIREN, Sum(Coalesce(D.CIKAN, 0)) AS CIKAN&#13;&#10;from STOKHAREKET D&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON D.STOKID = S.KARTNO&#13;&#10;WHERE D.CIKISDEPO &#60;&#62; 0 AND D.CIKISDEPO IS NOT NULL AND ISLEMTIPI &#60;&#62; 10&#13;&#10;Group By STOKKODU, CINSI, ISLEM, STOKID, CIKISDEPO&#13;&#10;UNION ALL&#13;&#10;Select &#13;&#10;  ISLEM, D.STOKID, D.GIRISDEPO, STOKKODU, CINSI, Sum(Coalesce(D.GIREN, 0)) AS GIREN, 0 AS CIKAN &#13;&#10;from STOKHAREKET D&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON D.STOKID = S.KARTNO&#13;&#10;WHERE D.GIRISDEPO &#60;&#62; 0 AND D.GIRISDEPO IS NOT NULL AND ISLEMTIPI &#60;&#62; 10&#13;&#10;Group By STOKKODU, CINSI, ISLEM, STOKID, GIRISDEPO&#13;&#10;UNION ALL&#13;&#10;Select &#13;&#10;  ISLEM, D.STOKID, D.GIRISDEPO, STOKKODU, CINSI, Sum(Coalesce(D.CIKAN, 0)) AS GIREN, 0 AS CIKAN &#13;&#10;from STOKHAREKET D&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON D.STOKID = S.KARTNO&#13;&#10;WHERE D.GIRISDEPO &#60;&#62; 0 AND D.GIRISDEPO IS NOT NULL AND ISLEMTIPI = 10&#13;&#10;Group By STOKKODU, CINSI, ISLEM, STOKID, GIRISDEPO&#13;&#10;UNION ALL&#13;&#10;Select &#13;&#10;  ISLEM, D.STOKID, D.CIKISDEPO, STOKKODU, CINSI, 0 AS GIREN, Sum(Coalesce(D.CIKAN, 0)) AS CIKAN &#13;&#10;from STOKHAREKET D&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON D.STOKID = S.KARTNO&#13;&#10;WHERE D.CIKISDEPO &#60;&#62; 0 AND D.CIKISDEPO IS NOT NULL AND ISLEMTIPI = 10&#13;&#10;Group By STOKKODU, CINSI, ISLEM, STOKID, CIKISDEPO&#13;&#10;) AS A&#13;&#10;LEFT OUTER JOIN TBLDEPOLAR D ON A.DEPO = D.KARTNO&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON A.STOKID = S.KARTNO&#13;&#10;LEFT OUTER JOIN TBLBIRIMLEREX B WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON B.KARTNO = S.ANABIRIM&#13;&#10;Group By A.STOKID, DEPO, ACIKLAMA, S.STOKKODU, S.CINSI, B.CARPAN, B.BIRIMADI,&#13;&#10;  S.ETKENMADDE, S.GRUPADI, KOD1, KOD2, KOD3, KOD4, KOD5, D.KOD&#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="50,86611" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="BASLIK" Left="3" Top="3" Width="704,64564" Height="25" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX Rapor"/>
      <TfrxMemoView Name="TARIH" Left="624,2047" Top="25" Width="87,2047" Height="20" Text="[Date]"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="141,94496" Left="0" Top="132,28355" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxDBCrossView Name="DBCross1" Left="2,77953" Top="0,77953" Width="304" Height="128" AddHeight="0" AddWidth="0" DownThenAcross="False" NextCrossGap="0" CellFields.Text="DEPO" ColumnFields.Text="DEPOADI" DataSet="KullaniciQ" DataSetName="Alanlar" RowFields.Text="CINSI" PropData="[encoded data, 7006 characters]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="40" Left="0" Top="336,37817" Width="718,1107">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="4" Width="713,07081" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="FOOTERBASLIK" Left="35" Top="10" Width="650" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX ile [date] Tarihinde Yazdırılmıştır"/>
      <TfrxMemoView Name="FOOTERSAYFA" Left="635" Top="10" Width="78,42517" Height="25" Text="Sayfa:  [Page#] / [TotalPages#]"/>
    </TfrxPageFooter>
  </TfrxReportPage>
</TfrxReport>
