<?xml version="1.0" encoding="utf-8" standalone="no"?>
<TfrxReport Version="6.0.7" 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="42728" ReportOptions.Description.Text="" ReportOptions.LastChange="43444,5678087269" 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  Declare @T1 DateTime, @T2 DateTime &#13;&#10;&#13;&#10;Set @T1 = :TARIH1&#13;&#10;Set @T2 = :TARIH2&#13;&#10;   &#13;&#10;SELECT  &#13;&#10;   PERSONEL, STOKKODU, CINSI, SUM(MIKTARI) AS MIKTARI, BIRIMADI, FIYATI, A.MALIYET, TEDARIKCIFIRMA,         &#13;&#10;   (FIYATI - NETFIYATI) * SUM(MIKTARI) AS ISKONTO, NETFIYATI * SUM(MIKTARI) AS NETTUTARI,  &#13;&#10;   FIYATI * SUM(MIKTARI) AS TUTARI, A.MALIYET * SUM(MIKTARI)AS MALIYETTUTARI,  &#13;&#10;   (NETFIYATI * SUM(MIKTARI)) - (A.MALIYET * SUM(MIKTARI)) AS KAR,  &#13;&#10;   CASE WHEN A.MALIYET &#60;= 0 THEN 100 ELSE (100 * (NETFIYATI - A.MALIYET)) / (A.MALIYET) END AS GERKARORANI  &#13;&#10;FROM(  &#13;&#10;Select  &#13;&#10;   B.CARPAN, B.BIRIMADI, S.STOKKODU, S.CINSI, SB.TARIH, SB.BELGENO, TF.FIRMAADI AS TEDARIKCIFIRMA,                                                                   &#13;&#10;   H.MIKTARI, H.FIYATI, ISNULL(H.MALIYET, S.MALIYET) * B.CARPAN AS MALIYET, P.AD + ' ' + P.SOYAD AS PERSONEL,&#13;&#10;   dbo.ISKONTODUS(dbo.ISKONTODUS(((FIYATI * MIKTARI - ISKONTOTOPLAMI) /  CASE WHEN MIKTARI &#60;= 0 THEN 1 ELSE MIKTARI END), SB.ALTISKONTO1Y), SB.ALTISKONTO2Y) AS NETFIYATI  &#13;&#10;FROM TBLSATFATHAREKET H WITH(INDEX=TBLSATFATHAREKET_FATURAID)  &#13;&#10;LEFT OUTER JOIN TBLSATFATBASLIK SB WITH(INDEX=TBLSATFATBASLIK_KARTNO) ON H.FATURAID = SB.KARTNO  &#13;&#10;LEFT OUTER JOIN TBLPERSONEL P ON P.KARTNO = SB.PERSONELID&#13;&#10;LEFT OUTER JOIN TBLSTOKLAR S WITH(INDEX=TBLSTOKLAR_KARTNO) ON H.STOKID = S.KARTNO  &#13;&#10;LEFT OUTER JOIN TBLBIRIMLEREX B WITH(INDEX=TBLBIRIMLEREX_KARTNO) ON H.BIRIMID = B.KARTNO  &#13;&#10;LEFT OUTER JOIN TBLCARI C WITH(INDEX=TBLCARI_KARTNO) ON C.KARTNO = SB.CARIID&#13;&#10;LEFT OUTER JOIN TBLCARI TF WITH(INDEX=TBLCARI_KARTNO) ON TF.KARTNO = S.TEDARIKCI    &#13;&#10;WHERE ISNULL(SB.DELETED, 0) = 0 AND SB.TARIH &#62;= @T1 AND SB.TARIH &#60;= @T2 &#13;&#10;) AS A  &#13;&#10;GROUP BY STOKKODU, CINSI, BIRIMADI, FIYATI, MALIYET, NETFIYATI, CARPAN, TEDARIKCIFIRMA, PERSONEL          " PropData="05704C65667402640470546F7002640A506172616D657465727301010624204E616D653D22544152494831222044617461547970653D2266744461746554696D652200010624204E616D653D22544152494832222044617461547970653D2266744461746554696D65220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" PaperWidth="210" PaperHeight="297" PaperSize="256" LeftMargin="10" RightMargin="5" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" Frame.Typ="0" HGuides.Text="" VGuides.Text="">
    <TfrxPageHeader Name="HEADER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="103,77953" Left="0" Top="16" Width="737,00835">
      <TfrxMemoView Name="BASLIK" Left="0" Top="1" Width="734,88188" Height="25" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="PARADOX Rapor"/>
      <TfrxMemoView Name="TARIH" Left="608,39363" Top="29,77953" Width="125" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Date]"/>
      <TfrxLineView Name="BASLIKCIZGI" Left="1" Top="101,77953" Width="735,74799" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="STOKKODUBASLIK" Left="0" Top="78,77953" Width="69,76376" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="Stok Kodu"/>
      <TfrxMemoView Name="CINSIBASLIK" Left="83" Top="78,77953" Width="202,04731" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="Cinsi"/>
      <TfrxMemoView Name="MIKTARIBASLIK" Left="287,2047" Top="78,77953" Width="43,30705" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Miktarı"/>
      <TfrxMemoView Name="BIRIMADIBASLIK" Left="333,2047" Top="78,77953" Width="35,74799" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Birim"/>
      <TfrxMemoView Name="FIYATIBASLIK" Left="370,2047" Top="78,77953" Width="47,08658" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Fiyatı"/>
      <TfrxMemoView Name="MALIYETBASLIK" Left="419,29128" Top="67,44094" Width="54,64564" Height="31,33859" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Maliyet &#13;&#10;Fiyatı"/>
      <TfrxMemoView Name="Memo1" Left="476,10266" Top="79,88188" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Tutarı"/>
      <TfrxMemoView Name="Memo2" Left="550,1342" Top="67,44094" Width="60,47248" Height="31,33859" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Maliyet &#13;&#10;Tutarı"/>
      <TfrxMemoView Name="Memo3" Left="613,50433" Top="79,88188" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Kar"/>
      <TfrxMemoView Name="Memo4" Left="688,97681" Top="81,44094" Width="45,35436" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="tahoma" Font.Style="0" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Kar %"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="17,22047" Left="0" Top="140" Width="737,00835" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxMemoView Name="STOKKODUVIEW" Left="0" Top="0" Width="96,22047" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Alanlar.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="CINSIVIEW" Left="94" Top="0" Width="190,70872" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Alanlar.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="MIKTARIVIEW" Left="287,2047" Top="0" Width="43,30705" Height="16,22047" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;MIKTARI&#34;]"/>
      <TfrxMemoView Name="FIYATIVIEW" Left="370,2047" Top="0" Width="47,08658" Height="16,22047" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="MALIYETVIEW" Left="419,29128" Top="0" Width="54,64564" Height="16,22047" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;MALIYET&#34;]"/>
      <TfrxMemoView Name="AlanlarBIRIMADI" Left="333,2047" Top="0" Width="35,74799" Height="16,22047" DataField="BIRIMADI" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Alanlar.&#34;BIRIMADI&#34;]"/>
      <TfrxMemoView Name="AlanlarTUTARI" Left="476,10266" Top="0" Width="71,81107" Height="16,22047" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;NETTUTARI&#34;]"/>
      <TfrxMemoView Name="AlanlarMALIYETTUTARI" Left="550,1342" Top="0" Width="60,47248" Height="16,22047" DataField="MALIYETTUTARI" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;MALIYETTUTARI&#34;]"/>
      <TfrxMemoView Name="AlanlarKAR" Left="612,50433" Top="0" Width="71,81107" Height="16,22047" DataField="KAR" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;KAR&#34;]"/>
      <TfrxMemoView Name="AlanlarGERKARORANI" Left="685,97681" Top="0" Width="45,35436" Height="16,22047" DataField="GERKARORANI" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;GERKARORANI&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="40" Left="0" Top="244" Width="737,00835">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="1" Width="800" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="FOOTERBASLIK" Left="4,76376" Top="9,22047" Width="650" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="PARADOX ile [date] Tarihinde Yazdırılmıştır"/>
      <TfrxMemoView Name="FOOTERSAYFA" Left="659" Top="10" Width="116,22047" Height="17,44094" Frame.Typ="0" Text="Sayfa:  [Page#] / [TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="49,13389" Left="0" Top="176" Width="737,00835">
      <TfrxMemoView Name="Memo5" Left="404,05535" Top="11,33859" Width="68,03154" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Toplamlar"/>
      <TfrxMemoView Name="Memo6" Left="476,10266" Top="11,33859" Width="71,81107" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;NETTUTARI&#34;&#62;,MASTERDATA)]"/>
      <TfrxMemoView Name="Memo7" Left="550,1342" Top="11,33859" Width="60,47248" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;MALIYETTUTARI&#34;&#62;,MASTERDATA)]"/>
      <TfrxMemoView Name="Memo8" Left="612,50433" Top="11,33859" Width="71,81107" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;KAR&#34;&#62;,MASTERDATA)]"/>
      <TfrxLineView Name="Line1" Left="404,05535" Top="5,33859" Width="279,68522" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
