<?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="41981" ReportOptions.Description.Text="" ReportOptions.LastChange="41986,4936429861" 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;  S.KARTNO, STOKKODU, CINSI, S.ETKENMADDE AS ANAGRUP, S.GRUPADI AS ALTGRUP, B.BIRIMADI, B.BARKOD,    &#13;&#10;  KOD1, KOD2, KOD3, KOD4, KOD5, B.SATISFIYATI1, ISNULL(SD.SEMBOL, 'TL') AS PB1, B.ALISFIYATI1, &#13;&#10;  ISNULL(AD.SEMBOL, 'TL') AS APB1, B.CARPAN,  &#13;&#10;  CASE S.KDVDAHIL WHEN 1 THEN CAST(S.KDV AS VARCHAR(2)) + ' D' ELSE CAST(S.KDV AS VARCHAR(2)) + ' H' END AS KDV,    &#13;&#10;  B.ALISFIYATI1, B.MINUMUMFIYAT AS MINSATISFIYATI, B.MAXIMUMFIYAT MAXALISFIYATI,    &#13;&#10;  (SELECT SUM(ISNULL(GIREN, 0) - ISNULL(CIKAN, 0)) FROM STOKHAREKET WHERE STOKID = S.KARTNO AND ISLEMTIPI IN(2, 3, 4, 5)) AS DEPO  &#13;&#10;from TBLSTOKLAR S  &#13;&#10;LEFT OUTER JOIN TBLBIRIMLEREX B WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON B.KARTNO = S.ANABIRIM  &#13;&#10;LEFT OUTER JOIN TBLDOVIZLER SD ON SD.KARTNO = B.SATISFIYATIPB1  &#13;&#10;LEFT OUTER JOIN TBLDOVIZLER AD ON AD.KARTNO = B.ALISFIYATIPB1  &#13;&#10;WHERE S.DELETED = 0" 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="100" Left="0" Top="16" Width="718,1107">
      <TfrxMemoView Name="BASLIK" Left="4" Top="5" Width="708,42517" 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,4094" Top="31,33859" Width="87,2047" Height="20" Text="[Date]"/>
      <TfrxLineView Name="BASLIKCIZGI" Left="1" Top="98" Width="800" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="STOKKODUBASLIK" Left="4" Top="75" Width="100" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Stok Kodu"/>
      <TfrxMemoView Name="CINSIBASLIK" Left="106" Top="75" Width="164,25201" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Cinsi"/>
      <TfrxMemoView Name="ANAGRUPBASLIK" Left="407" Top="75" Width="122,67718" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Ana Grup"/>
      <TfrxMemoView Name="ALTGRUPBASLIK" Left="534" Top="75" Width="77,32282" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Depo"/>
      <TfrxMemoView Name="BIRIMADIBASLIK" Left="613" Top="75" Width="100" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Birim"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="21" Left="0" Top="136" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxMemoView Name="STOKKODUVIEW" Left="4" Top="0" Width="100" Height="20" Text="[Alanlar.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="CINSIVIEW" Left="106" Top="0" Width="296,53556" Height="20" Text="[Alanlar.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="ANAGRUPVIEW" Left="407" Top="0" Width="122,67718" Height="20" Text="[Alanlar.&#34;ANAGRUP&#34;]"/>
      <TfrxMemoView Name="ALTGRUPVIEW" Left="534" Top="0" Width="77,32282" Height="20" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;DEPO&#34;]"/>
      <TfrxMemoView Name="BIRIMADIVIEW" Left="613" Top="0" Width="100" Height="20" Text="[Alanlar.&#34;BIRIMADI&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="40" Left="0" Top="176" Width="718,1107">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="1" Width="800" 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="670" Top="10" Width="120" Height="25" Text="Sayfa:  [Page#] / [TotalPages#]"/>
    </TfrxPageFooter>
  </TfrxReportPage>
</TfrxReport>
