<?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="41981" ReportOptions.Description.Text="" ReportOptions.LastChange="42592,8458037731" ScriptLanguage="PascalScript" ScriptText.Text="begin&#13;&#10;&#13;&#10;end.">
  <Datasets>
    <item DataSet="KullaniciQ" DataSetName="Alanlar"/>
  </Datasets>
  <Variables>
    <item Name="KARTNO" Value="33"/>
    <item Name="CARIID" Value="1"/>
    <item Name="TARIH" Value="1"/>
    <item Name="DETAYKARTNO" Value="1"/>
  </Variables>
  <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,&#13;&#10;  CASE S.KDVDAHIL WHEN 0 THEN B.SATISFIYATI1 ELSE SATISFIYATI1/((S.KDV+100)/100.00) END AS SATISFIYATI1,ISNULL(SD.SEMBOL, 'TL') AS PB1,&#13;&#10;  CASE S.KDVDAHIL WHEN 0 THEN B.ALISFIYATI1 ELSE ALISFIYATI1/((S.KDV+100)/100.00) END AS ALISFIYATI1,&#13;&#10;  ISNULL(AD.SEMBOL, 'TL') AS APB1, B.CARPAN,S.KDV AS KDVD,                                &#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="93" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="BASLIK" Left="4" Top="0" 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="Envanter Raporu"/>
      <TfrxLineView Name="BASLIKCIZGI" Left="1" Top="93" Width="800" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="STOKKODUBASLIK" Left="4" Top="70" Width="82" 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="88" Top="70" Width="170,25201" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Malzeme Açıklaması"/>
      <TfrxMemoView Name="ALTGRUPBASLIK" Left="261" Top="70" Width="45,32282" 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="BIRIMADIBASLIK" Left="639" Top="70" Width="74" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Tutar SF"/>
      <TfrxMemoView Name="Memo4" Left="308" Top="70,10235" Width="51,32282" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Birim"/>
      <TfrxMemoView Name="Memo5" Left="361" Top="70,10235" Width="70,32282" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="A.Fiyat"/>
      <TfrxMemoView Name="Memo6" Left="495" Top="71,10235" Width="66,91342" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="Kdv %"/>
      <TfrxMemoView Name="Memo7" Left="433" Top="70,10235" Width="58,32282" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="S.Fiyat"/>
      <TfrxMemoView Name="Memo9" Left="568,45671" Top="71,10235" Width="58,54329" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haRight" ParentFont="False" Text="Tutar AF"/>
      <TfrxMemoView Name="TARIH" Left="3,77953" Top="37,7953" Width="75,86611" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" ParentFont="False" Text="Rapor Tar:"/>
      <TfrxMemoView Name="Memo13" Left="80,33117" Top="39,5906" Width="83,42517" Height="20" Text="[Date]"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="20" Left="0" Top="173,85838" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxMemoView Name="STOKKODUVIEW" Left="4" Top="0" Width="88,7953" Height="20" Text="[Alanlar.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="CINSIVIEW" Left="94" Top="0" Width="161,90569" Height="20" Text="[Alanlar.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="ALTGRUPVIEW" Left="259" Top="0" Width="46,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="305" Top="0" Width="49" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;BIRIMADI&#34;]"/>
      <TfrxMemoView Name="AlanlarALISFIYATI1" Left="577,01577" Top="0,58256" Width="49,35436" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;Alanlar.&#34;DEPO&#34;&#62;*&#60;Alanlar.&#34;ALISFIYATI1&#34;&#62;]"/>
      <TfrxMemoView Name="Memo2" Left="357" Top="0,58256" Width="71,37013" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;ALISFIYATI1&#34;]"/>
      <TfrxMemoView Name="Memo8" Left="426,22047" Top="0,58256" Width="63,37013" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;SATISFIYATI1&#34;]"/>
      <TfrxMemoView Name="Memo10" Left="629" Top="0,58256" Width="83,37013" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[&#60;Alanlar.&#34;DEPO&#34;&#62;*&#60;Alanlar.&#34;SATISFIYATI1&#34;&#62;]"/>
      <TfrxMemoView Name="AlanlarKDVD" Left="495,11843" Top="0" Width="45,35436" Height="18,89765" DataField="KDVD" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;KDVD&#34;]"/>
      <TfrxMemoView Name="Memo14" Left="540,47279" Top="0" Width="22,67718" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="%"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="24,33055" Left="0" Top="253,22851" Width="718,1107">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="0" Width="800" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="FOOTERSAYFA" Left="5" Top="5" Width="48" Height="14" Text="Sayfa:  [Page#] / [TotalPages#]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo1" Left="261" Top="5,4329" Width="44,37013" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="5" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;DEPO&#34;&#62;,MASTERDATA)]"/>
      <TfrxMemoView Name="Memo3" Left="632" Top="5,4329" Width="80,37013" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="5" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;DEPO&#34;&#62;*&#60;Alanlar.&#34;SATISFIYATI1&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo11" Left="543" Top="5,4329" Width="83,37013" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="%2.2f" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="5" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;DEPO&#34;&#62;*&#60;Alanlar.&#34;ALISFIYATI1&#34;&#62;)]"/>
      <TfrxMemoView Name="Memo12" Left="87" Top="5,4329" Width="114,37013" Height="18,89765" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="5" ParentFont="False" Text="Toplamlar"/>
    </TfrxPageFooter>
    <TfrxPictureView Name="Picture1" Left="634,96104" Top="-22,67718" Width="98,26778" Height="86,92919" Picture.PropData="[encoded data, 54052 characters]" HightQuality="False" Transparent="False" TransparentColor="16777215"/>
  </TfrxReportPage>
  <TfrxDialogPage Name="DialogPage1" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Height="158" ClientHeight="120" Left="265" Top="150" Width="230" ClientWidth="214"/>
</TfrxReport>
