<?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="42579" ReportOptions.Description.Text="" ReportOptions.LastChange="42618,5312325" ScriptLanguage="PascalScript" ScriptText.Text="Var&#13;&#10;  Toplam, GToplam: Real;&#13;&#10;    &#13;&#10;procedure MASTERDATAOnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin&#13;&#10;  Toplam:= Toplam + &#60;Alanlar.&#34;TUTARI&#34;&#62;;  &#13;&#10;  if &#60;Alanlar.&#34;VADE&#34;&#62; &#62; Date Then           &#13;&#10;    GToplam:= GToplam + ((&#60;Alanlar.&#34;VADE&#34;&#62; - Date) * &#60;Alanlar.&#34;TUTARI&#34;&#62;)                                                                                            &#13;&#10;end;&#13;&#10;&#13;&#10;procedure SAYFAOnBeforePrint(Sender: TfrxComponent);&#13;&#10;begin  &#13;&#10;end;&#13;&#10;&#13;&#10;procedure Memo11OnBeforePrint(Sender: TfrxComponent);&#13;&#10;Var&#13;&#10;  G: Integer;                                &#13;&#10;begin&#13;&#10;  if Toplam &#62; 0 Then&#13;&#10;  Begin&#13;&#10;    G:= Trunc(GToplam / Toplam);                               &#13;&#10;    Memo11.Text:= DateToStr(Date + G) + ' ( ' + IntToStr(G) + ' Gün )';&#13;&#10;  End;                  &#13;&#10;end;&#13;&#10;&#13;&#10;begin&#13;&#10;  Toplam := 0;               &#13;&#10;  GToplam:= 0;&#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;   EvrakTipi, &#13;&#10;   Case E.STATUS &#13;&#10;     When 0 Then 'Portföyde' &#13;&#10;     When 1 Then 'Ödendi' &#13;&#10;     When 2 Then 'Kısmen Ödendi' &#13;&#10;     When 3 Then 'Ciro' &#13;&#10;     When 4 Then 'İade Edildi' &#13;&#10;     When 5 Then 'Teminat Verildi' &#13;&#10;     When 6 Then 'Zimmette' &#13;&#10;     When 7 Then 'Takasta' &#13;&#10;   END AS EDURUM, &#13;&#10;   E.PORTFOYNO, &#13;&#10;   E.VADE, &#13;&#10;   DATEPART(MONTH, E.VADE) AS VADEAY, &#13;&#10;   DATEPART(YEAR, E.VADE) AS VADEYIL, &#13;&#10;   E.TUTARI, &#13;&#10;   E.PARABIRIMI, &#13;&#10;   E.GIRISTARIHI, &#13;&#10;   E.GFIRMAKODU, &#13;&#10;   E.GFIRMAADI, &#13;&#10;   E.TARIH, &#13;&#10;   E.CFIRMAKODU, &#13;&#10;   E.CFIRMAADI &#13;&#10; from TUMEVRAKLAR E&#13;&#10;WHERE E.STATUS = 0                                              &#13;&#10; AND E.ISLEM IN(1,4)&#13;&#10;ORDER BY E.VADE" PropData="05704C65667402640470546F7002640A506172616D65746572730100"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" Orientation="poLandscape" PaperWidth="297" PaperHeight="210" PaperSize="256" LeftMargin="10" RightMargin="10" TopMargin="10" BottomMargin="10" ColumnWidth="0" ColumnPositions.Text="" HGuides.Text="" VGuides.Text="" OnBeforePrint="SAYFAOnBeforePrint">
    <TfrxPageHeader Name="HEADER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="100" Left="0" Top="18,89765" Width="1046,92981">
      <TfrxMemoView Name="BASLIK" Left="184,41744" 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="GUN POLI Tüm Evraklar Raporu"/>
      <TfrxMemoView Name="TARIH" Left="950,22851" Top="32,55906" Width="94,76376" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[Date]"/>
      <TfrxLineView Name="BASLIKCIZGI" Left="1" Top="98" Width="1041,88992" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="EvrakTipiBASLIK" Left="0" Top="75" Width="62,2047" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Evrak"/>
      <TfrxMemoView Name="EDURUMBASLIK" Left="70,2047" Top="75" Width="62,2047" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Durum"/>
      <TfrxMemoView Name="PORTFOYNOBASLIK" Left="131,85034" Top="75" Width="73,54329" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Portföy No"/>
      <TfrxMemoView Name="TUTARIBASLIK" Left="284,28324" Top="75" Width="96,22047" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Tutarı"/>
      <TfrxMemoView Name="Memo1" Left="492,79561" Top="75" Width="215,43321" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Gir. Firma"/>
      <TfrxMemoView Name="Memo2" Left="208,87415" Top="75" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Vade"/>
      <TfrxMemoView Name="Memo3" Left="712,00835" Top="75" Width="79,37013" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Çık. Tarihi"/>
      <TfrxMemoView Name="Memo4" Left="796,37848" Top="75" Width="249,44898" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Çık. Firma"/>
      <TfrxMemoView Name="Memo9" Left="385,51206" Top="75,5906" Width="98,26778" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Tahoma" Font.Style="1" ParentFont="False" Text="Gir. Tarihi"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="21" Left="0" Top="181,41744" Width="1046,92981" OnBeforePrint="MASTERDATAOnBeforePrint" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxMemoView Name="Memo5" Left="0" Top="0" Width="1046,92981" Height="18,89765" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" Fill.BackColor="16777215" HAlign="haRight" 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 = 0" Highlight.FillType="ftBrush" Highlight.Fill.BackColor="16776960" ParentFont="False" Text=""/>
      <TfrxMemoView Name="EvrakTipiVIEW" Left="0" Top="0" Width="62,2047" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;EvrakTipi&#34;]"/>
      <TfrxMemoView Name="EDURUMVIEW" Left="70,2047" Top="0" Width="62,2047" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;EDURUM&#34;]"/>
      <TfrxMemoView Name="PORTFOYNOVIEW" Left="131,85034" Top="0" Width="73,54329" Height="16,22047" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;PORTFOYNO&#34;]"/>
      <TfrxMemoView Name="TUTARIVIEW" Left="284,28324" Top="0" Width="96,22047" 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" HAlign="haRight" ParentFont="False" Text="[Alanlar.&#34;TUTARI&#34;]"/>
      <TfrxMemoView Name="AlanlarGFIRMAADI" Left="492,79561" Top="0" Width="219,21274" Height="15,11812" DataField="GFIRMAADI" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;GFIRMAADI&#34;]"/>
      <TfrxMemoView Name="AlanlarVADE" Left="208,87415" Top="0" Width="71,81107" Height="15,11812" DataField="VADE" DataSet="KullaniciQ" DataSetName="Alanlar" DisplayFormat.FormatStr="dd.mm.yyyy" DisplayFormat.Kind="fkDateTime" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;VADE&#34;]"/>
      <TfrxMemoView Name="AlanlarTARIH" Left="712,00835" Top="0" Width="79,37013" Height="15,11812" DataField="TARIH" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;TARIH&#34;]"/>
      <TfrxMemoView Name="AlanlarCFIRMAADI" Left="796,37848" Top="0" Width="249,44898" Height="15,11812" DataField="CFIRMAADI" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="0" Font.Height="-12" Font.Name="Tahoma" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;CFIRMAADI&#34;]"/>
      <TfrxMemoView Name="AlanlarGIRISTARIHI" Left="385,51206" Top="0" Width="98,26778" Height="15,11812" DataField="GIRISTARIHI" DataSet="KullaniciQ" DataSetName="Alanlar" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[Alanlar.&#34;GIRISTARIHI&#34;]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="40" Left="0" Top="340,1577" Width="1046,92981">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="8" Width="1053,22851" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="FOOTERSAYFA" Left="920,03958" Top="11,22047" Width="120" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Sayfa:  [Page#] / [TotalPages#]"/>
    </TfrxPageFooter>
    <TfrxReportSummary Name="ReportSummary1" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="52,91342" Left="0" Top="264,5671" Width="1046,92981">
      <TfrxLineView Name="Line1" Left="0" Top="7,11812" Width="1045,66945" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="Memo6" Left="45,35436" Top="15,11812" Width="71,81107" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="Toplamlar: "/>
      <TfrxMemoView Name="Memo7" Left="120,51175" Top="15,11812" Width="73,54329" Height="18,89765" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" ParentFont="False" Text="[COUNT()] Adet"/>
      <TfrxMemoView Name="Memo8" Left="295,62183" Top="15,11812" Width="84,88188" Height="18,89765" DisplayFormat.FormatStr="#,#0.#0" DisplayFormat.Kind="fkNumeric" Font.Charset="1" Font.Color="-16777208" Font.Height="-13" Font.Name="Arial" Font.Style="0" HAlign="haRight" ParentFont="False" Text="[SUM(&#60;Alanlar.&#34;TUTARI&#34;&#62;,MASTERDATA)]"/>
      <TfrxMemoView Name="Memo10" Left="419,52783" Top="15,11812" Width="136,06308" Height="18,89765" Text="Ortalama Vade: "/>
      <TfrxMemoView Name="Memo11" Left="578,26809" Top="15,11812" Width="370,39394" Height="18,89765" OnBeforePrint="Memo11OnBeforePrint" Text=""/>
    </TfrxReportSummary>
  </TfrxReportPage>
</TfrxReport>
