<?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="42577" ReportOptions.Description.Text="" ReportOptions.LastChange="42578,4928856713" 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="SELECT &#13;&#10;   AD + ' ' + SOYAD AS PERSONEL, GUN,&#13;&#10;   CAST(CAST(CAST((TOTDAKIKA / 60) AS INT) AS VARCHAR) + ':' + CAST(A.TOTDAKIKA - (CAST((TOTDAKIKA / 60) AS INT) * 60) AS VARCHAR) AS TIME) AS SAAT       &#13;&#10;--   CAST((TOTDAKIKA / 60) AS INT) AS SAAT &#13;&#10; FROM( &#13;&#10; SELECT  &#13;&#10;   PERSONELID, DATEPART(DAY, TARIH) AS GUN, &#13;&#10;   DATEPART(HOUR, SAAT) * 60 + DATEPART(MINUTE, SAAT) AS TOTDAKIKA &#13;&#10; FROM TBLPERSONELCALISMASAATLERI PCS &#13;&#10; LEFT OUTER JOIN TBLPERSONEL P1 WITH(INDEX=TBLPERSONEL_KARTNO) ON P1.KARTNO = PCS.PERSONELID  &#13;&#10; WHERE DATEPART(M, TARIH) = :AY AND DATEPART(YEAR, TARIH) = DATEPART(YEAR, GETDATE()) &#13;&#10; GROUP BY PERSONELID, TARIH, SAAT &#13;&#10; ) AS A &#13;&#10; LEFT OUTER JOIN TBLPERSONEL P WITH(INDEX=TBLPERSONEL_KARTNO) ON P.KARTNO = A.PERSONELID &#13;&#10; ORDER BY AD, SOYAD" PropData="05704C65667402640470546F7002640A506172616D65746572730101061F204E616D653D224159222044617461547970653D226674496E7465676572220000"/>
  </TfrxDataPage>
  <TfrxReportPage Name="SAYFA" Orientation="poLandscape" PaperWidth="420" 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="45" Left="0" Top="18,89765" Width="1511,812">
      <TfrxMemoView Name="BASLIK" Left="4,76376" Top="2,32282" Width="1366,06339" Height="20" Font.Charset="1" Font.Color="0" Font.Height="-13" Font.Name="Arial" Font.Style="1" HAlign="haCenter" ParentFont="False" Text="PARADOX Personel Çalışma Saatleri"/>
      <TfrxMemoView Name="TARIH" Left="1372,75634" Top="2,32282" Width="125" Height="20" Text="[Date]"/>
      <TfrxLineView Name="Line1" Left="3,77953" Top="25,7953" Width="1506,77211" Height="0" Color="0" Frame.Typ="4"/>
    </TfrxPageHeader>
    <TfrxMasterData Name="MASTERDATA" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="243,99227" Left="0" Top="124,72449" Width="1511,812" ColumnWidth="0" ColumnGap="0" DataSet="KullaniciQ" DataSetName="Alanlar" RowCount="0">
      <TfrxDBCrossView Name="DBCross1" Left="3,77953" Top="4,55906" Width="169" Height="84" AddHeight="0" AddWidth="0" DownThenAcross="False" NextCrossGap="0" ShowColumnTotal="False" ShowCorner="False" ShowRowTotal="False" ShowTitle="False" CellFields.Text="SAAT" ColumnFields.Text="GUN" DataSet="KullaniciQ" DataSetName="Alanlar" RowFields.Text="PERSONEL" PropData="[encoded data, 9678 characters]"/>
    </TfrxMasterData>
    <TfrxPageFooter Name="FOOTER" FillType="ftBrush" FillGap.Top="0" FillGap.Left="0" FillGap.Bottom="0" FillGap.Right="0" Height="40" Left="0" Top="430,86642" Width="1511,812">
      <TfrxLineView Name="FOOTERCIZGI" Left="1" Top="1" Width="1506,77211" Height="0" Color="0" Frame.Typ="4"/>
      <TfrxMemoView Name="FOOTERBASLIK" Left="3,77953" Top="13,22047" Width="1281,18151" 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="1308,74057" Top="13,22047" Width="199,37013" 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>
  </TfrxReportPage>
</TfrxReport>
