<?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="42499" ReportOptions.Description.Text="" ReportOptions.LastChange="43657,7938452315" ScriptLanguage="PascalScript" ScriptText.Text="procedure SAYFAOnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  QueryLoadAllRecords(ekstreQ);&#13;&#10;  ekstreQ.Active:= True;&#13;&#10;  CalcCariHesapDetay(ekstreQ);&#13;&#10;end;&#13;&#10;&#13;&#10;VAR&#13;&#10;T1,T2:TDATETIME;&#13;&#10;begin&#13;&#10;   Input2Date('Tarih Aralığı Seç',T1,T2);&#13;&#10;   SetQueryParam('cariQ', 'KARTNO', &#60;KARTNO&#62;);&#13;&#10;   SetQueryParam('ekstreQ', 'TARIH1',T1);&#13;&#10;   SetQueryParam('ekstreQ', 'TARIH2',T2);&#13;&#10;   SetQueryParam('ekstreQ', 'CARIID',&#60;KARTNO&#62;);&#13;&#10;end.">
  <Datasets>
    <item DataSet="ekstreQ" DataSetName="Hesap Ekstresi"/>
    <item DataSet="cariQ" DataSetName="Cari Kart"/>
  </Datasets>
  <Variables>
    <item Name="KARTNO" Value="1"/>
    <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="ekstreQ" UserName="Hesap Ekstresi" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="SET DATEFORMAT DMY &#13;&#10;  &#13;&#10;DECLARE @CARIID INT, @T1 DATETIME, @T2 DATETIME, @T Decimal(18, 4)                                          &#13;&#10;  &#13;&#10;SET @CARIID = :CARIID               &#13;&#10;SET @T1 = :TARIH1            &#13;&#10;SET @T2 = :TARIH2&#13;&#10;&#13;&#10;SET @T = ISNULL((SELECT SUM((TLALACAK - TLBORC) * KUR) FROM CARIDOKUM WHERE CARIID =  @CARIID AND TARIH &#60; @T1), 0)&#13;&#10;&#13;&#10;SELECT &#13;&#10;    BIRIMADI, CARIID, ISLEM, KUR, TARIH, BELGENO, STOKKODU, CINSI, MIKTARI, FIYATI, BORC, ALACAK, &#13;&#10;    KUR * BORC / CARIDOVIZKURU AS CARIBORC, &#13;&#10;	   KUR * ALACAK / CARIDOVIZKURU AS CARIALACAK,&#13;&#10;    KUR * BORC AS TLBORC, KUR * ALACAK AS TLALACAK,                                                                                                               &#13;&#10;   	CAST(0 AS NVARCHAR(32)) AS TLDURUM, CAST(0 AS NVARCHAR(32)) AS CARIDURUM&#13;&#10;from DETAYCARIDOKUM &#13;&#10;WHERE CARIID = @CARIID and TARIH BETWEEN @T1 AND @T2&#13;&#10;UNION ALL&#13;&#10;SELECT &#13;&#10;  '', 0, 'DEVİR', 1, @T1 - 1, 'DEVİR', 'DEVİR', 'DEVİR', NULL, NULL, &#13;&#10;  CASE WHEN @T &#60; 0 THEN -1 * @T ELSE @T END, &#13;&#10;  CASE WHEN @T &#60; 0 THEN 0 ELSE @T END, &#13;&#10;  CASE WHEN @T &#60; 0 THEN -1 * @T ELSE @T END, &#13;&#10;  CASE WHEN @T &#60; 0 THEN 0 ELSE @T END, &#13;&#10;  CASE WHEN @T &#60; 0 THEN -1 * @T ELSE @T END, &#13;&#10;  CASE WHEN @T &#60; 0 THEN 0 ELSE @T END, &#13;&#10;  NULL, NULL&#13;&#10;ORDER BY TARIH&#13;&#10;  " PropData="05704C65667402640470546F7002640A506172616D657465727301010623204E616D653D22434152494944222044617461547970653D226674496E74656765722200010620204E616D653D22544152494831222044617461547970653D226674446174652200010620204E616D653D22544152494832222044617461547970653D22667444617465220000"/>
    <TfrxFDQuery Name="cariQ" UserName="Cari Kart" CloseDataSource="True" FieldAliases.Text="" BCDToCurrency="False" IgnoreDupParams="False" SQL.Text="Select * from TBLCARI&#13;&#10;WHERE KARTNO = :KARTNO                                                                   " PropData="05704C65667402640470546F7003B0000A506172616D657465727301010623204E616D653D224B4152544E4F222044617461547970653D226674496E7465676572220000"/>
  </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="" OnBeforePrint="SAYFAOnBeforePrint">
    <TfrxPageHeader Name="HEADER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="47,67718" Left="0" Top="18,89765" Width="737,00835">
      <TfrxMemoView Name="BASLIK" Left="0,98423" Top="0" Width="715,98423" Height="25" Font.Charset="1" Font.Color="0" Font.Height="-16" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haCenter" ParentFont="False" Text="Detaylı Hesap Ekstresi"/>
      <TfrxMemoView Name="TARIH" Left="641,08658" Top="2,10235" Width="75,86611" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Date]"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="151,1811878" Left="0" Top="128,50402" Width="737,00835" ColumnWidth="0" ColumnGap="0" DataSet="ekstreQ" DataSetName="Hesap Ekstresi" RowCount="0">
      <TfrxLineView Name="BASLIKCIZGI" Left="-2" Top="144,13389" Width="800" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="TARIHBASLIK" Left="77,69295" Top="124,13389" Width="54,64564" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Tarih"/>
      <TfrxMemoView Name="BELGENOBASLIK" Left="134,69295" Top="124,13389" Width="62,2047" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Belge No"/>
      <TfrxMemoView Name="STOKKODUBASLIK" Left="199,01577" Top="124,13389" Width="65,98423" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="St. Kodu"/>
      <TfrxMemoView Name="CINSIBASLIK" Left="265,11812" Top="124,13389" Width="145,35436" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Cinsi"/>
      <TfrxMemoView Name="MIKTARIBASLIK" Left="411,76376" Top="124,13389" Width="69,92125984" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Miktarı"/>
      <TfrxMemoView Name="FIYATIBASLIK" Left="483,92115" Top="124,13389" Width="54,64564" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Fiyatı"/>
      <TfrxMemoView Name="BORCBASLIK" Left="537,24397" Top="124,13389" Width="66,14172984" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Borç"/>
      <TfrxMemoView Name="Memo1" Left="603,74057" Top="124,72449" Width="66,14172984" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Alacak"/>
      <TfrxMemoView Name="Memo7" Left="11,33859" Top="7,55906" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Firma Kodu : "/>
      <TfrxMemoView Name="Memo8" Left="11,33859" Top="30,23624" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Firma Ünvanı : "/>
      <TfrxMemoView Name="Memo9" Left="11,33859" Top="52,91342" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Yetkili : "/>
      <TfrxMemoView Name="Memo10" Left="11,33859" Top="75,5906" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Telefon : "/>
      <TfrxMemoView Name="Memo11" Left="470,44125" Top="3,77953" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="Adres"/>
      <TfrxMemoView Name="CariKartFIRMAKODU" Left="109,60637" Top="7,55906" Width="359,05535" Height="18,89765" DataField="FIRMAKODU" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAKODU&#34;]"/>
      <TfrxMemoView Name="CariKartFIRMAUNVANI" Left="109,60637" Top="30,23624" Width="359,05535" Height="18,89765" DataField="FIRMAUNVANI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Cari Kart.&#34;FIRMAUNVANI&#34;]"/>
      <TfrxMemoView Name="CariKartYETKILI" Left="109,60637" Top="52,91342" Width="359,05535" Height="18,89765" DataField="YETKILI" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Cari Kart.&#34;YETKILI&#34;]"/>
      <TfrxMemoView Name="CariKartTELEFON1" Left="109,60637" Top="75,5906" Width="359,05535" Height="18,89765" DataSet="cariQ" DataSetName="Cari Kart" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" ParentFont="False" Text="[Cari Kart.&#34;TELEFON1&#34;], [Cari Kart.&#34;TELEFON2&#34;], [Cari Kart.&#34;TELEFON3&#34;], [Cari Kart.&#34;FAKS&#34;]"/>
      <TfrxMemoView Name="Memo12" Left="472,44125" Top="26,45671" Width="241,88992" Height="68,03154" AllowHTMLTags="True" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="15" GapX="5" GapY="5" ParentFont="False" Text="[Cari Kart.&#34;ADRES&#34;]&#13;&#10;[Cari Kart.&#34;POSTAKODU&#34;], [Cari Kart.&#34;ILCE&#34;] / &#60;b&#62;[Cari Kart.&#34;SEHIR&#34;]&#60;/b&#62;">
        <Formats>
          <item/>
          <item/>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="Memo13" Left="0" Top="124,72449" Width="73,54329" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="İşlem"/>
      <TfrxMemoView Name="Memo15" Left="668,97681" Top="124,72449" Width="66,14172984" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" ParentFont="False" Text="Durum"/>
    </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="464,88219" Width="737,00835">
      <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" Frame.Typ="0" 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" 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="60,47248" Left="0" Top="381,73253" Width="737,00835">
      <TfrxMemoView Name="Memo4" Left="562,48021" Top="26,45671" Width="73,54329" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Hesap Ekstresi.&#34;BORC&#34;&#62;,DetailData1)]"/>
      <TfrxMemoView Name="Memo5" Left="642,97681" Top="26,45671" Width="73,54329" 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" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Hesap Ekstresi.&#34;ALACAK&#34;&#62;,DetailData1)]"/>
      <TfrxLineView Name="Line1" Left="415,7483" Top="14,55906" Width="298,58287" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo6" Left="451,64595" Top="26,45671" Width="94,48825" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" Frame.Typ="0" HAlign="haRight" ParentFont="False" Text="Toplamlar"/>
    </TfrxReportSummary>
    <TfrxDetailData Name="DetailData1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Frame.Typ="0" Height="18,8976378" Left="0" Top="302,3624" Width="737,00835" ColumnWidth="0" ColumnGap="0" DataSet="ekstreQ" DataSetName="Hesap Ekstresi" RowCount="0" Stretched="True">
      <TfrxMemoView Name="Memo3" Align="baClient" Left="0" Top="0" Width="737,00835" Height="18,8976378" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" Frame.Typ="0" Highlight.Font.Charset="1" Highlight.Font.Color="255" Highlight.Font.Height="-13" Highlight.Font.Name="Arial" Highlight.Font.Style="0" Highlight.Condition="&#60;Line&#62; Mod 2 = 1" Highlight.FillType="ftBrush" Highlight.Fill.BackColor="-16777212" Highlight.Frame.Typ="0" ParentFont="False" Text=""/>
      <TfrxMemoView Name="TARIHVIEW" Left="74,69295" Top="0" Width="62,2047" Height="20" StretchMode="smMaxHeight" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" VAlign="vaCenter" Text="[Hesap Ekstresi.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="BELGENOVIEW" Left="134,69295" Top="0" Width="62,2047" Height="20" StretchMode="smMaxHeight" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" VAlign="vaCenter" Text="[Hesap Ekstresi.&#34;BELGENO&#34;]"/>
      <TfrxMemoView Name="STOKKODUVIEW" Left="199,01577" Top="0" Width="65,98423" Height="20" StretchMode="smMaxHeight" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" VAlign="vaCenter" Text="[Hesap Ekstresi.&#34;STOKKODU&#34;]"/>
      <TfrxMemoView Name="CINSIVIEW" Left="265,11812" Top="0" Width="145,35436" Height="20" StretchMode="smMaxHeight" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" VAlign="vaCenter" Text="[Hesap Ekstresi.&#34;CINSI&#34;]"/>
      <TfrxMemoView Name="MIKTARIVIEW" Left="408,76376" Top="0" Width="77,48031984" Height="20" StretchMode="smMaxHeight" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" HideZeros="True" ParentFont="False" VAlign="vaCenter" Text="[FormatFloat('#,#0.#0', &#60;Hesap Ekstresi.&#34;MIKTARI&#34;&#62;)] [Hesap Ekstresi.&#34;BIRIMADI&#34;]">
        <Formats>
          <item/>
          <item/>
        </Formats>
      </TfrxMemoView>
      <TfrxMemoView Name="BORCVIEW" Left="537,24397" Top="0" Width="66,14172984" Height="20" StretchMode="smMaxHeight" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" HideZeros="True" ParentFont="False" VAlign="vaCenter" Text="[Hesap Ekstresi.&#34;BORC&#34;]"/>
      <TfrxMemoView Name="FIYATIVIEW" Left="487,92115" Top="0" Width="47,08658" Height="20" StretchMode="smMaxHeight" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" HideZeros="True" ParentFont="False" VAlign="vaCenter" Text="[Hesap Ekstresi.&#34;FIYATI&#34;]"/>
      <TfrxMemoView Name="Memo2" Left="603,74057" Top="0" Width="66,14172984" Height="20" StretchMode="smMaxHeight" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" HideZeros="True" ParentFont="False" VAlign="vaCenter" Text="[Hesap Ekstresi.&#34;ALACAK&#34;]"/>
      <TfrxMemoView Name="HesapEkstresiISLEM" Left="-0,22047" Top="0" Width="71,81107" Height="18,89765" StretchMode="smMaxHeight" DataField="ISLEM" DataSet="ekstreQ" DataSetName="Hesap Ekstresi" Font.Charset="1" Font.Color="-16777208" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" ParentFont="False" VAlign="vaCenter" Text="[Hesap Ekstresi.&#34;ISLEM&#34;]"/>
      <TfrxMemoView Name="Memo14" Left="668,97681" Top="0" Width="66,14172984" Height="20" StretchMode="smMaxHeight" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="0" Font.Height="-11" Font.Name="Tahoma" Font.Style="0" Frame.Typ="0" HAlign="haRight" HideZeros="True" ParentFont="False" VAlign="vaCenter" Text="[Hesap Ekstresi.&#34;CARIDURUM&#34;]"/>
    </TfrxDetailData>
  </TfrxReportPage>
</TfrxReport>
