<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="4.11.13" DotMatrixReport="False" IniFile="\Software\Fast Reports" PreviewOptions.Buttons="4095" PreviewOptions.Zoom="1" PrintOptions.Printer="Varsayılan" PrintOptions.PrintOnSheet="0" ReportOptions.CreateDate="41031,571732037" ReportOptions.Description.Text="" ReportOptions.LastChange="41268,5309640857" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end." PropData="044C65667403900103546F700380010844617461736574730101062920446174615365743D226465706F512220446174615365744E616D653D224465706F20447572756D220000095661726961626C65730100055374796C650100">
  <TfrxDataPage Name="Data" Height="1000" Left="0" Top="0" Width="1000">
    <TFrxFDQuery Name="depoQ" UserName="Depo Durum" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select &#13;&#10;  STOKID, DEPO AS DEPOID, D.ACIKLAMA AS DEPOADI, STOKKODU, CINSI, &#13;&#10;  {iif (SQLITE, Sum(GIREN) - SUM(CIKAN) AS &#34;DEPO::numeric(18,8)&#34;, Sum(GIREN) - SUM(CIKAN) 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 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 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 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 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;Group By  STOKID, DEPO, ACIKLAMA, STOKKODU, CINSI  " PropData="05704C65667402500470546F7002680A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="Page1" PaperWidth="210" PaperHeight="297" PaperSize="9" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="">
    <TfrxPageHeader Name="PageHeader1" Height="75,5906" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="Memo1" Left="3,77953" Top="3,77953" Width="706,77211" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="ATLANTİS Depo Stok Durumu Analiz Raporu"/>
      <TfrxMemoView Name="Memo2" Left="616,06339" Top="25,23624" Width="94,48825" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Date]"/>
      <TfrxLineView Name="Line1" Left="0,77953" Top="48,13389" Width="710,55164" Height="0" ShowHint="False" Frame.Typ="4"/>
    </TfrxPageHeader>
    <TfrxPageFooter Name="PageFooter1" Height="56,69295" Left="0" Top="430,86642" Width="718,1107">
      <TfrxLineView Name="Line2" Left="7,55906" Top="7,55905999999999" Width="702,99258" Height="0" ShowHint="False" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo3" Left="15,11812" Top="18,89765" Width="408,18924" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="ATLANTİS ile [Date] Tarihinde yazdırılmıştır"/>
      <TfrxMemoView Name="Memo4" Left="593,38621" Top="18,89765" Width="117,16543" Height="18,89765" ShowHint="False" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="Sayfa: [Page] / [TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxMasterData Name="MasterData1" Height="215,60637" Left="0" Top="154,96073" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="depoQ" DataSetName="Depo Durum" RowCount="0">
      <TfrxDBCrossView Name="DBCross1" Left="3,77953" Top="3,77953" Width="258" Height="84" ShowHint="False" AddHeight="0" AddWidth="0" DownThenAcross="True" JoinEqualCells="True" NextCrossGap="0" ShowRowTotal="False" ShowTitle="False" CellFields.Text="DEPO" ColumnFields.Text="DEPOADI" DataSet="depoQ" DataSetName="Depo Durum" RowFields.Text="CINSI" PropData="[encoded data, 6934 characters]"/>
    </TfrxMasterData>
  </TfrxReportPage>
</TfrxReport>
