<?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="42728" ReportOptions.Description.Text="" ReportOptions.LastChange="42728,5984478472" 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 &#13;&#10; Declare @Tarih1 DateTime, @Tarih2 DateTime &#13;&#10; Declare @Rapor Table(SATIS DECIMAL(18, 4), NAKIT DECIMAL(18, 4), VISA DECIMAL(18, 4), KAR DECIMAL(18, 4)) &#13;&#10;  &#13;&#10; Set @Tarih1 = :TARIH1            &#13;&#10; Set @Tarih2 = :TARIH2&#13;&#10;  &#13;&#10; INSERT INTO @Rapor SELECT 0, 0, 0, 0 &#13;&#10;  &#13;&#10; UPDATE @Rapor Set SATIS = (Select SUM(TUTARI) from TBLSATFATBASLIK B WHERE TARIH BETWEEN CONVERT(VARCHAR, @Tarih1, 104) AND CONVERT(VARCHAR, @Tarih2, 104)) &#13;&#10; UPDATE @Rapor Set KAR = (SELECT SUM(KAR) FROM(Select  MIKTARI * (FIYATI - CASE WHEN ISNULL(H.MALIYET, 0) = 0 THEN  &#13;&#10;      ISNULL((SELECT TOP 1 FIYATI FROM TBLALFATHAREKET AFH LEFT OUTER JOIN TBLALFATBASLIK AFB WITH(INDEX=TBLALFATBASLIK_KARTNO) ON AFB.KARTNO = AFH.FATURAID &#13;&#10; 	    WHERE ISNULL(AFB.DELETED, 0) = 0 AND AFH.STOKID = H.STOKID ORDER BY AFB.TARIH DESC), 0) &#13;&#10;   ELSE H.MALIYET END) AS KAR &#13;&#10; from TBLSATFATHAREKET H &#13;&#10; LEFT OUTER JOIN TBLSATFATBASLIK B WITH(INDEX=TBLSATFATBASLIK_KARTNO) ON B.KARTNO = H.FATURAID &#13;&#10; LEFT OUTER JOIN TBLSTOKLAR S  WITH(INDEX=TBLSTOKLAR_KARTNO) ON S.KARTNO = H.STOKID &#13;&#10; WHERE TARIH BETWEEN CONVERT(VARCHAR, @Tarih1, 104) AND CONVERT(VARCHAR, @Tarih2, 104) &#13;&#10; ) AS A) &#13;&#10;  &#13;&#10; UPDATE @Rapor Set NAKIT = (Select SUM(GIREN) from KASAHAREKET where ISLEMTIPI = 1 AND EVRAKTIPI = 0 AND TARIH BETWEEN CONVERT(VARCHAR, @Tarih1, 104) AND CONVERT(VARCHAR, @Tarih2, 104)) &#13;&#10; UPDATE @Rapor Set VISA = (Select SUM(GIREN) from KASAHAREKET where ISLEMTIPI = 1 AND EVRAKTIPI = 3 AND TARIH BETWEEN CONVERT(VARCHAR, @Tarih1, 104) AND CONVERT(VARCHAR, @Tarih2, 104)) &#13;&#10;  &#13;&#10; Select * from @Rapor " PropData="05704C65667402640470546F7002640A506172616D657465727301010624204E616D653D22544152494831222044617461547970653D2266744461746554696D652200010624204E616D653D22544152494832222044617461547970653D2266744461746554696D65220000"/>
  </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="137,7953" Left="0" Top="18,89765" Width="718,1107">
      <TfrxMemoView Name="BASLIK" Left="1,66141" Top="2,44094" Width="712,2047" Height="25" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX Faaliyet Raporu"/>
      <TfrxMemoView Name="TARIH" Left="586,6141" Top="25" Width="125" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Date]"/>
      <TfrxMemoView Name="Memo1" Left="11,33859" Top="52,91342" Width="113,3859" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Başlama Tarihi : "/>
      <TfrxMemoView Name="Memo2" Left="11,33859" Top="79,37013" Width="113,3859" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Bitiş Tarihi : "/>
      <TfrxMemoView Name="tarih1" Left="132,28355" Top="52,91342" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="Tarih2" Left="132,28355" Top="79,37013" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text=""/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="172,1812" Left="0" Top="219,21274" Width="718,1107" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxMemoView Name="SATISVIEW" Left="175,65368" Top="18,89765" Width="109,60637" 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;SATIS&#34;]"/>
      <TfrxMemoView Name="NAKITVIEW" Left="175,65368" Top="49,13389" Width="109,60637" 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;NAKIT&#34;]"/>
      <TfrxMemoView Name="VISAVIEW" Left="175,65368" Top="79,37007874" Width="109,60637" 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;VISA&#34;]"/>
      <TfrxMemoView Name="KARVIEW" Left="175,65368" Top="139,84251969" Width="109,60637" 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;KAR&#34;]"/>
      <TfrxMemoView Name="Memo3" Left="15,67718" Top="18,89765" Width="154,96073" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Satışlar Toplamı : "/>
      <TfrxMemoView Name="Memo4" Left="15,67718" Top="49,13389" Width="154,96073" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Nakit Tahsilat Toplamı : "/>
      <TfrxMemoView Name="Memo5" Left="15,67718" Top="79,37007874" Width="154,96073" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="VİSA Tahsilat Toplamı : "/>
      <TfrxMemoView Name="Memo6" Left="15,67718" Top="109,60629921" Width="154,96073" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Tahsilat Toplamı : "/>
      <TfrxMemoView Name="Memo7" Left="15,67718" Top="139,84251969" Width="154,96073" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Kar Toplamı : "/>
      <TfrxMemoView Name="Memo8" Left="175,65368" Top="109,60629921" Width="109,60637" Height="18,89765" 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="[&#60;Alanlar.&#34;NAKIT&#34;&#62; + &#60;Alanlar.&#34;VISA&#34;&#62;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="40" Left="0" Top="453,5436" 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>
