﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="10/02/2023 11:49:45" ReportInfo.Modified="07/10/2024 14:25:05" ReportInfo.CreatorVersion="2021.4.3.0">
  <ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {
    
    int getFirstMonth(DateTime fullDate){
      if(Year(fullDate) == Year(ToDateTime(((String)Report.GetParameterValue(&quot;FromDate&quot;)))))
          return    Report.GetTotalValue(&quot;Total4&quot;);
 
       return   Report.GetTotalValue(&quot;Total1&quot;);;
      
    }
   

    private void Page1_StartPage(object sender, EventArgs e)
    {
        
    }

    private void _StartReport(object sender, EventArgs e)
    {
      Page1.Visible = false; 
      if( ((String)Report.GetParameterValue(&quot;AccordingDay&quot;)) !=&quot;0&quot; ){
        MessageBox.Show(&quot;الرجاء ادخال حسب التاريخ&quot;);
      
      }
      else{
        Page1.Visible = true;
      }
    }
  }
}
</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqKjSU40dlxFMmorDfgW0xWghLfHh9It0YM419tI3EqnDwCQRhxmoCe6bhrhjTzx2YAVLq9o5g7RQzmr9pdkvua9IR937wVnH0RYiKW145BNnR56/Rxth0vKZG9jLLgFaRBMP3xHKJakvEJ3kut3It2S2qOiLz+6Av7MLjIQ0ERiTmV3wZfYlUo+1PC1D7v0207N7Rw6y0I+1vhc/AENeA8tY/HGASkao0IZLjjDo5tHATg31XRur26vgmYeqJGYggvYFk6Ov9tkeATqkaz0gbJW2ItrQzoXz1gmPSee6YTxImSxkKJK2c44+VfQhUPdDxli8cYhhK+Gat8crQw1rZiN1DYl/x0alReiQSyJoKnOjpBYJFGdsmDkn5c1hWmClDhWqmRykh9jmQ2RaqZyRiJKXueEYAey1CGDIm4MwlRAtvBmEfVmScjS/IMOg24D1GI9oyjyn6FRDkcSH4g6HpsMslu4f5lPJ9j1l4ACqcZBjRuuaFDUGECTOYS48ZzDfuA6pEDXkL+fvS/r8YWiATxgrthdc0jekD1rescx9c1J84CdtARRTKBAKkurRe/brHvwSBi1Mm5XvQkntUWWrhDM+HOPGqOebAuhQL5b5mY3x0zDDcEZevVXGtcq/IzQUpSXn7I7eswM/wg54KNITFIwuU7msww/mSvAbP+n7GB7UC0FrnWym/s6yKhGMf36O9s0F/0CO1qAfz2z1cLptdXw==" CommandTimeout="1200">
      <TableDataSource Name="Table1" DataType="System.Int32" Enabled="true" SelectCommand="SET FMTONLY OFF&#13;&#10;exec [mnrPrcHrCalcEmployeeNumber]@fromDate, @toDate">
        <Column Name="FullDate" DataType="System.DateTime"/>
        <Column Name="numOfEmployeeStartOfTheMonth" DataType="System.Int32"/>
        <Column Name="numOfEmployeeEndOfTheMonth" DataType="System.Int32"/>
        <Column Name="numOfLeaveEmployee" DataType="System.Int32"/>
        <CommandParameter Name="fromDate" DataType="4" Expression="[FromDate]" DefaultValue="2012-03-03"/>
        <CommandParameter Name="toDate" DataType="4" Expression="[Todate]" DefaultValue="2012-03-03"/>
      </TableDataSource>
      <TableDataSource Name="EmpPersInfo_Report" DataType="System.Int32" Enabled="true" TableName="EmpPersInfo_Report" SelectCommand="EXEC mnrPrcHrRepEmpPersInfo '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '4' , '2' , '{7A1D5EF7-F867-411b-B9C9-82FD13B4748D}' , '{00000000-0000-0000-0000-000000000000}' , '1-1-2024' , '7-10-2024' , 'EmpCode' , '1' , '0' , '0' , '0' , '0' , '{00000000-0000-0000-0000-000000000000}'">
        <Column Name="EmpID" DataType="System.Guid"/>
        <Column Name="EmpNumber" DataType="System.Double"/>
        <Column Name="EmpCode" DataType="System.String"/>
        <Column Name="EmpName" DataType="System.String"/>
        <Column Name="EmpLatinName" DataType="System.String"/>
        <Column Name="EmpFName" DataType="System.String"/>
        <Column Name="EmpLFName" DataType="System.String"/>
        <Column Name="EmpFamName" DataType="System.String"/>
        <Column Name="EmpLFamName" DataType="System.String"/>
        <Column Name="EmpGFName" DataType="System.String"/>
        <Column Name="EmpLGFName" DataType="System.String"/>
        <Column Name="EmpMotherName" DataType="System.String"/>
        <Column Name="EmpLMotherName" DataType="System.String"/>
        <Column Name="EmpDateOfBirth" DataType="System.DateTime"/>
        <Column Name="EmpGender" DataType="System.Int32"/>
        <Column Name="EmpMilSrv" DataType="System.Int32"/>
        <Column Name="EmpMilFromDate" DataType="System.DateTime"/>
        <Column Name="EmpMilToDate" DataType="System.DateTime"/>
        <Column Name="EmpDrvLiceNum" DataType="System.String"/>
        <Column Name="EmpIsActive" DataType="System.Int32"/>
        <Column Name="EmpWorkType" DataType="System.Int32"/>
        <Column Name="EmpBirthPlace" DataType="System.String"/>
        <Column Name="EmpSocialStatus" DataType="System.Int32"/>
        <Column Name="EmpKids" DataType="System.Int32"/>
        <Column Name="EmpNatID" DataType="System.Guid"/>
        <Column Name="EmpReligionID" DataType="System.Guid"/>
        <Column Name="EmpCatID" DataType="System.Guid"/>
        <Column Name="EmpBuildUnitID" DataType="System.Guid"/>
        <Column Name="EmpDateWork" DataType="System.DateTime"/>
        <Column Name="EmpPositionID" DataType="System.Guid"/>
        <Column Name="EmpBranchID" DataType="System.Guid"/>
        <Column Name="EmpDepID" DataType="System.Guid"/>
        <Column Name="EmpSupervisorID" DataType="System.Guid"/>
        <Column Name="EmpIsLeave" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpDateLeave" DataType="System.DateTime"/>
        <Column Name="EmpResLeaveID" DataType="System.Guid"/>
        <Column Name="EmpLeaveNote" DataType="System.String"/>
        <Column Name="EmpPhone1" DataType="System.String"/>
        <Column Name="EmpPhone2" DataType="System.String"/>
        <Column Name="EmpMobile1" DataType="System.String"/>
        <Column Name="EmpMobile2" DataType="System.String"/>
        <Column Name="EmpAddress1" DataType="System.String"/>
        <Column Name="EmpAddress2" DataType="System.String"/>
        <Column Name="EmpDistrict" DataType="System.String"/>
        <Column Name="EmpCity" DataType="System.String"/>
        <Column Name="EmpNeighborhood" DataType="System.String"/>
        <Column Name="EmpStreet" DataType="System.String"/>
        <Column Name="EmpEmail1" DataType="System.String"/>
        <Column Name="EmpEmail2" DataType="System.String"/>
        <Column Name="EmpIdNumber" DataType="System.String"/>
        <Column Name="EmpPassportNum" DataType="System.String"/>
        <Column Name="EmpSponsorID" DataType="System.Guid"/>
        <Column Name="EmpPassNum" DataType="System.String"/>
        <Column Name="EmpPassJob" DataType="System.String"/>
        <Column Name="EmpDatePass" DataType="System.DateTime"/>
        <Column Name="EmpBorderPerson" DataType="System.String"/>
        <Column Name="EmpBorderNum" DataType="System.String"/>
        <Column Name="EmpDateEnter" DataType="System.DateTime"/>
        <Column Name="EmpContraTypeID" DataType="System.Guid"/>
        <Column Name="EmpbOffContra" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpOffNum" DataType="System.String"/>
        <Column Name="EmpOffContraType" DataType="System.Int32"/>
        <Column Name="EmpOffQualID" DataType="System.Guid"/>
        <Column Name="EmpQualDate" DataType="System.DateTime"/>
        <Column Name="EmpOffEduDegID" DataType="System.Guid"/>
        <Column Name="EmpOffNote" DataType="System.String"/>
        <Column Name="EmpOffJob" DataType="System.String"/>
        <Column Name="EmpEnsrTypeID" DataType="System.Guid"/>
        <Column Name="EmpEnsrTypeWifeID" DataType="System.Guid"/>
        <Column Name="EmpEnsrTypeKidID" DataType="System.Guid"/>
        <Column Name="EmpbEnsrPragnance" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpSlarySysID" DataType="System.Guid"/>
        <Column Name="EmpTimeSysID" DataType="System.Guid"/>
        <Column Name="EmpAccGrpID" DataType="System.Guid"/>
        <Column Name="EmpFingerNB" DataType="System.String"/>
        <Column Name="EmpBSalary" DataType="System.Double"/>
        <Column Name="EmpSpeSalary" DataType="System.Double"/>
        <Column Name="EmpSpareSalary" DataType="System.Double"/>
        <Column Name="EmpHourCost" DataType="System.Double"/>
        <Column Name="EmpMonthlyDays" DataType="System.Double"/>
        <Column Name="EmpHoursWork" DataType="System.Double"/>
        <Column Name="EmpDayCost" DataType="System.Double"/>
        <Column Name="EmpBalanced" DataType="System.Double"/>
        <Column Name="EmpBalance" DataType="System.Double"/>
        <Column Name="EmpExcusedAbsence" DataType="System.Double"/>
        <Column Name="EmpUnExcusedAbsence" DataType="System.Double"/>
        <Column Name="EmpYearHoliday" DataType="System.Double"/>
        <Column Name="EmpSickYearHoliday" DataType="System.Double"/>
        <Column Name="EmpDaysPerYear" DataType="System.Double"/>
        <Column Name="EmpClearHolidays" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpWayPay" DataType="System.Int32"/>
        <Column Name="EmpCurrencyID" DataType="System.Guid"/>
        <Column Name="EmpbStopSalary" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpStopSalaryDate" DataType="System.DateTime"/>
        <Column Name="EmpBankID" DataType="System.Guid"/>
        <Column Name="EmpBankNum" DataType="System.String"/>
        <Column Name="EmpSoEnsrNumber" DataType="System.String"/>
        <Column Name="EmpSoEnsrDate" DataType="System.DateTime"/>
        <Column Name="EmpSoInsrEndDate" DataType="System.DateTime"/>
        <Column Name="EmpTS1" DataType="System.Guid"/>
        <Column Name="EmpTS2" DataType="System.Guid"/>
        <Column Name="EmpTS3" DataType="System.Guid"/>
        <Column Name="EmpTS4" DataType="System.Guid"/>
        <Column Name="EmpTS5" DataType="System.Guid"/>
        <Column Name="EmpTS6" DataType="System.Guid"/>
        <Column Name="EmpTS7" DataType="System.Guid"/>
        <Column Name="EmpRepMSalary" DataType="System.Double"/>
        <Column Name="EmpRepNegate" DataType="System.Double"/>
        <Column Name="EmpRepDevide" DataType="System.Double"/>
        <Column Name="EmpRepTotal" DataType="System.Double"/>
        <Column Name="EmpRepYears" DataType="System.Int32"/>
        <Column Name="EmpRepAllYears" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpHeadingID" DataType="System.Guid"/>
        <Column Name="EmpRegularTicket" DataType="System.Int32"/>
        <Column Name="EmpSpecificTicket" DataType="System.Int32"/>
        <Column Name="EmpVIPTicket" DataType="System.Int32"/>
        <Column Name="EmpVIPTicketBal" DataType="System.Int32"/>
        <Column Name="EmpNotes" DataType="System.String"/>
        <Column Name="NNumber" DataType="System.Double"/>
        <Column Name="NCode" DataType="System.String"/>
        <Column Name="NName" DataType="System.String"/>
        <Column Name="NLatinName" DataType="System.String"/>
        <Column Name="BuNumber" DataType="System.Double"/>
        <Column Name="BuCode" DataType="System.String"/>
        <Column Name="BuName" DataType="System.String"/>
        <Column Name="BuLatinName" DataType="System.String"/>
        <Column Name="RNumber" DataType="System.Double"/>
        <Column Name="RCode" DataType="System.String"/>
        <Column Name="RName" DataType="System.String"/>
        <Column Name="RLatinName" DataType="System.String"/>
        <Column Name="SNumber" DataType="System.Double"/>
        <Column Name="SCode" DataType="System.String"/>
        <Column Name="SName" DataType="System.String"/>
        <Column Name="SLatinName" DataType="System.String"/>
        <Column Name="BrID" DataType="System.Guid"/>
        <Column Name="BrNumber" DataType="System.Int32"/>
        <Column Name="BrCode" DataType="System.String"/>
        <Column Name="BrName" DataType="System.String"/>
        <Column Name="BrLatinName" DataType="System.String"/>
        <Column Name="DNumber" DataType="System.Double"/>
        <Column Name="DCode" DataType="System.String"/>
        <Column Name="DName" DataType="System.String"/>
        <Column Name="DLatinName" DataType="System.String"/>
        <Column Name="PoID" DataType="System.Guid"/>
        <Column Name="PoNumber" DataType="System.Double"/>
        <Column Name="PoCode" DataType="System.String"/>
        <Column Name="PoName" DataType="System.String"/>
        <Column Name="PoLatinName" DataType="System.String"/>
        <Column Name="CNumber" DataType="System.Double"/>
        <Column Name="CCode" DataType="System.String"/>
        <Column Name="CName" DataType="System.String"/>
        <Column Name="CLatinName" DataType="System.String"/>
        <Column Name="SpEmpID" DataType="System.Guid"/>
        <Column Name="SpEmpNumber" DataType="System.Double"/>
        <Column Name="SpEmpCode" DataType="System.String"/>
        <Column Name="SpEmpName" DataType="System.String"/>
        <Column Name="SpEmpLatinName" DataType="System.String"/>
        <Column Name="EmpAccID" DataType="System.Guid"/>
        <Column Name="EmpAccName" DataType="System.String"/>
        <Column Name="EmpAccLatinName" DataType="System.String"/>
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="CFGrpID" DataType="System.Guid"/>
        <Column Name="DID" DataType="System.Int32"/>
        <Column Name="ObjID" DataType="System.Guid"/>
        <Column Name="EmpbFixed" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpDateFixed" DataType="System.DateTime"/>
        <Column Name="EmpbSummryWork" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpbEndContra" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EmpDateEndContra" DataType="System.DateTime"/>
        <Column Name="EmpFullName" DataType="System.String"/>
        <Column Name="EmpLFullName" DataType="System.String"/>
        <Column Name="EmpSectorID" DataType="System.Guid"/>
        <Column Name="EmpSectorName" DataType="System.String"/>
        <Column Name="EmpSectorLatinName" DataType="System.String"/>
        <Column Name="EmpLeftReasID" DataType="System.Guid"/>
        <Column Name="EmpLeftReasName" DataType="System.String"/>
        <Column Name="EmpLeftReasLatinName" DataType="System.String"/>
        <Column Name="EmpQualName" DataType="System.String"/>
        <Column Name="EmpQualLatinName" DataType="System.String"/>
        <Column Name="EmpEduName" DataType="System.String"/>
        <Column Name="EmpEduLatinName" DataType="System.String"/>
        <Column Name="EmpInsName" DataType="System.String"/>
        <Column Name="EmpInsLatinName" DataType="System.String"/>
        <Column Name="EmpKidInsName" DataType="System.String"/>
        <Column Name="EmpKidInsLatinName" DataType="System.String"/>
        <Column Name="EmpWifeInsName" DataType="System.String"/>
        <Column Name="EmpWifeInsLatinName" DataType="System.String"/>
        <Column Name="EmpSalaryName" DataType="System.String"/>
        <Column Name="EmpSalaryLatinName" DataType="System.String"/>
        <Column Name="EmpTimeSysName" DataType="System.String"/>
        <Column Name="EmpTimeSysLatinName" DataType="System.String"/>
        <Column Name="EmpAccGrpName" DataType="System.String"/>
        <Column Name="EmpAccGrpLatinName" DataType="System.String"/>
        <Column Name="EmpBankName" DataType="System.String"/>
        <Column Name="EmpBankLatinName" DataType="System.String"/>
        <Column Name="EmpTicketName" DataType="System.String"/>
        <Column Name="EmpTicketLatinName" DataType="System.String"/>
        <Column Name="EmpNormalTickBal" DataType="System.Int32"/>
        <Column Name="EmpLowTickBal" DataType="System.Int32"/>
        <Column Name="CFVal1" DataType="System.String"/>
        <Column Name="CFVal2" DataType="System.String"/>
        <Column Name="CFVal3" DataType="System.String"/>
        <Column Name="CFVal4" DataType="System.String"/>
        <Column Name="CFVal5" DataType="System.String"/>
        <Column Name="CFVal6" DataType="System.String"/>
        <Column Name="CFVal7" DataType="System.String"/>
        <Column Name="CFVal8" DataType="System.String"/>
        <Column Name="CFVal9" DataType="System.String"/>
        <Column Name="CFVal10" DataType="System.String"/>
        <Column Name="CFVal11" DataType="System.String"/>
        <Column Name="CFVal12" DataType="System.String"/>
        <Column Name="CFVal13" DataType="System.String"/>
        <Column Name="CFVal14" DataType="System.String"/>
        <Column Name="CFVal15" DataType="System.String"/>
        <Column Name="CFVal16" DataType="System.String"/>
        <Column Name="CFVal17" DataType="System.String"/>
        <Column Name="CFVal18" DataType="System.String"/>
        <Column Name="CFVal19" DataType="System.String"/>
        <Column Name="CFVal20" DataType="System.String"/>
        <Column Name="CFVal21" DataType="System.String"/>
        <Column Name="CFVal22" DataType="System.String"/>
        <Column Name="CFVal23" DataType="System.String"/>
        <Column Name="CFVal24" DataType="System.String"/>
        <Column Name="CFVal25" DataType="System.String"/>
        <Column Name="CFVal26" DataType="System.String"/>
        <Column Name="CFVal27" DataType="System.String"/>
        <Column Name="CFVal28" DataType="System.String"/>
        <Column Name="CFVal29" DataType="System.String"/>
        <Column Name="CFVal30" DataType="System.String"/>
        <Column Name="CFVal31" DataType="System.String"/>
        <Column Name="CFVal32" DataType="System.String"/>
        <Column Name="CFVal33" DataType="System.String"/>
        <Column Name="CFVal34" DataType="System.String"/>
        <Column Name="CFVal35" DataType="System.String"/>
        <Column Name="CFVal36" DataType="System.String"/>
        <Column Name="CFVal37" DataType="System.String"/>
        <Column Name="CFVal38" DataType="System.String"/>
        <Column Name="CFVal39" DataType="System.String"/>
        <Column Name="CFVal40" DataType="System.String"/>
        <Column Name="CFVal41" DataType="System.String"/>
        <Column Name="CFVal42" DataType="System.String"/>
        <Column Name="CFVal43" DataType="System.String"/>
        <Column Name="CFVal44" DataType="System.String"/>
        <Column Name="CFVal45" DataType="System.String"/>
        <Column Name="CFVal46" DataType="System.String"/>
        <Column Name="CFVal47" DataType="System.String"/>
        <Column Name="CFVal48" DataType="System.String"/>
        <Column Name="CFVal49" DataType="System.String"/>
        <Column Name="CFVal50" DataType="System.String"/>
        <Column Name="CFVal51" DataType="System.String"/>
        <Column Name="CFVal52" DataType="System.String"/>
        <Column Name="CFVal53" DataType="System.String"/>
        <Column Name="CFVal54" DataType="System.String"/>
        <Column Name="CFVal55" DataType="System.String"/>
        <Column Name="CFVal56" DataType="System.String"/>
        <Column Name="CFVal57" DataType="System.String"/>
        <Column Name="CFVal58" DataType="System.String"/>
        <Column Name="CFVal59" DataType="System.String"/>
        <Column Name="CFVal60" DataType="System.String"/>
        <Column Name="CFVal61" DataType="System.String"/>
        <Column Name="CFVal62" DataType="System.String"/>
        <Column Name="CFVal63" DataType="System.String"/>
        <Column Name="CFVal64" DataType="System.String"/>
        <Column Name="SectCode" DataType="System.String"/>
        <Column Name="SectName" DataType="System.String"/>
        <Column Name="SectLatinName" DataType="System.String"/>
        <Column Name="DifCurDateWork" DataType="System.Int32"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{22EA8A5F-1607-402d-91FA-BD59DDD46DDA}&quot;"/>
    <Parameter Name="CurrencyName" DataType="System.String" Expression="&quot;ريال سعودي&quot;"/>
    <Parameter Name="WorkFromDate" DataType="System.String" Expression="&quot;1/1/2023&quot;"/>
    <Parameter Name="WorkToDate" DataType="System.String" Expression="&quot;14/11/2023&quot;"/>
    <Parameter Name="LeaveFromDate" DataType="System.String" Expression="&quot;1/1/2023&quot;"/>
    <Parameter Name="LeaveToDate" DataType="System.String" Expression="&quot;14/11/2023&quot;"/>
    <Parameter Name="ShowDisc" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowExtra" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowBonus" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowPenalty" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowCost" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowAdv" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowMis" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowVac" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="Gender" DataType="System.String" Expression="&quot;2&quot;"/>
    <Parameter Name="SocialStatus" DataType="System.String" Expression="&quot;4&quot;"/>
    <Parameter Name="SalType" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;1/1/2024&quot;"/>
    <Parameter Name="Todate" DataType="System.String" Expression="&quot;10/7/2024&quot;"/>
    <Parameter Name="EmpID" DataType="System.String" Expression="&quot;{0DD3AB58-E8B1-483c-B13B-0928BDBB48EE}&quot;"/>
    <Parameter Name="ShowTodate" DataType="System.String" Expression="&quot;30/11/2023&quot;"/>
    <Parameter Name="CurWorker" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="CurLeaveWorker" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="PrevCurInssurance" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="EndContra" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="AccordingDay" DataType="System.String" Expression="&quot;0&quot;"/>
    <Total Name="Total" Expression="[Table1.numOfEmployeeStartOfTheMonth]" Evaluator="Data1"/>
    <Total Name="Total1" Expression="IIf(Month([Table1.FullDate])==1,[Table1.numOfEmployeeStartOfTheMonth],0)" Evaluator="Data1" PrintOn="GroupFooter1"/>
    <Total Name="Total2" Expression="[Table1.numOfEmployeeEndOfTheMonth]" Evaluator="Data1" PrintOn="GroupFooter1"/>
    <Total Name="Total3" Expression="[Table1.numOfLeaveEmployee]" Evaluator="Data1" PrintOn="GroupFooter1"/>
    <Total Name="Total4" Expression="IIf(Month([Table1.FullDate])== Month(ToDateTime([FromDate])),[Table1.numOfEmployeeStartOfTheMonth],0)" Evaluator="Data1" PrintOn="GroupFooter1"/>
  </Dictionary>
  <ReportPage Name="Page1" RawPaperSize="9" LeftMargin="3" RightMargin="3" FirstPageSource="15" OtherPagesSource="15" LastPageSource="15" Watermark.Font="Arial, 60pt" StartPageEvent="Page1_StartPage">
    <ReportTitleBand Name="ReportTitle1" Width="771.12" Height="160.63">
      <TextObject Name="Memo2" Left="241.46" Top="119.06" Width="288.21" Height="35.05" Text="معدل دوران العمالة في السنة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 16pt, style=Bold"/>
      <PictureObject Name="Company_Logo" Left="7.51" Top="4.75" Width="756.09" Height="98.83" Fill.Color="White" ImageLocation="\\server\mnr\WhatsApp Image 2023-07-15 at 7.17.20 PM.jpeg" SizeMode="StretchImage"/>
    </ReportTitleBand>
    <GroupHeaderBand Name="GroupHeader1" Top="164.63" Width="771.12" Height="57.7" Condition="Year([Table1.FullDate])">
      <TextObject Name="Text12" Left="30.1" Top="29.35" Width="94.5" Height="28.35" Border.Lines="All" Fill.Color="186, 211, 254" Text="نسبة الدوران" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text5" Left="664.6" Top="29.35" Width="94.5" Height="28.35" Border.Lines="All" Fill.Color="186, 211, 254" Text="الشهر" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text6" Left="522.85" Top="29.35" Width="141.75" Height="28.35" Border.Lines="All" Fill.Color="186, 211, 254" Text="عدد الموظفين في بداية الشهر" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text7" Left="362.35" Top="29.35" Width="160.65" Height="28.35" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Text="عدد الموظفين في  نهاية الشهر" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text8" Left="238.75" Top="29.35" Width="122.85" Height="28.35" Border.Lines="All" Fill.Color="186, 211, 254" Text="عدد المغادرين في الشهر" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text10" Left="125.35" Top="29.35" Width="113.4" Height="28.35" Border.Lines="All" Fill.Color="186, 211, 254" Text="معدل عدد الموظفين" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Text25" Left="567" Top="6.45" Width="189" Height="18.9" Text="[Year([Table1.FullDate])]:  السنة " HorzAlign="Right" Font="Arial, 10pt, style=Bold"/>
      <DataBand Name="Data1" Top="226.33" Width="771.12" Height="18.9" DataSource="Table1">
        <TextObject Name="Text1" Left="664.6" Width="94.5" Height="18.9" Border.Lines="All" Fill.Color="220, 238, 242" Text="[MonthName(Month([Table1.FullDate]))]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text2" Left="522.85" Width="141.75" Height="18.9" Border.Lines="All" Text="[Table1.numOfEmployeeStartOfTheMonth]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text3" Left="362.35" Width="160.65" Height="18.9" Border.Lines="All" Text="[Table1.numOfEmployeeEndOfTheMonth]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text4" Left="238.75" Width="122.85" Height="18.9" Border.Lines="All" Text="[Table1.numOfLeaveEmployee]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text9" Left="125.35" Width="113.4" Height="18.9" Border.Lines="All" Text=" [ (ToDouble([Table1.numOfEmployeeStartOfTheMonth]) + ToDouble([Table1.numOfEmployeeEndOfTheMonth])) /2]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text11" Left="30.1" Width="94.5" Height="18.9" Border.Lines="All" Text="[IIf( ((ToDouble([Table1.numOfEmployeeStartOfTheMonth]) + ToDouble([Table1.numOfEmployeeEndOfTheMonth])) /2) ==ToDouble(0.0),&quot;null&quot;,[Table1.numOfLeaveEmployee] /  ((ToDouble([Table1.numOfEmployeeStartOfTheMonth]) + ToDouble([Table1.numOfEmployeeEndOfTheMonth])) /2))] %" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <Sort>
          <Sort Expression="[Table1.FullDate]"/>
        </Sort>
      </DataBand>
      <GroupFooterBand Name="GroupFooter1" Top="249.23" Width="771.12" Height="323">
        <TextObject Name="Text18" Left="30.1" Top="11.15" Width="94.5" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" Text="نسبة الدوران" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text13" Left="664.6" Top="11.15" Width="94.5" Height="37.8" Border.Lines="All" Fill.Color="186, 211, 254" Text="معدل الدوران السنوي" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text14" Left="522.85" Top="11.15" Width="141.75" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" Text="عدد الموظفين في بداية السنة" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text15" Left="362.35" Top="11.15" Width="160.65" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" Text="عدد الموظفين في نهاية السنة" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text16" Left="238.75" Top="11.15" Width="122.85" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" Text="عدد المغادرين في السنة" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text17" Left="125.35" Top="11.15" Width="113.4" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" Text="معدل عدد الموظفين" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
        <TextObject Name="Text20" Left="522.85" Top="30.01" Width="141.75" Height="18.9" Border.Lines="Left, Right, Bottom" Text="[getFirstMonth([Table1.FullDate])]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text21" Left="362.35" Top="30.01" Width="160.65" Height="18.9" Border.Lines="Left, Right, Bottom" Text="[Table1.numOfEmployeeEndOfTheMonth]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text22" Left="238.75" Top="30.01" Width="122.85" Height="18.9" Border.Lines="Left, Right, Bottom" Text="[Total3]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text23" Left="125.35" Top="30.01" Width="113.4" Height="18.9" Border.Lines="Left, Right, Bottom" Text="[([Table1.numOfEmployeeEndOfTheMonth]+getFirstMonth([Table1.FullDate]))/2]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <TextObject Name="Text24" Left="30.1" Top="30.01" Width="94.5" Height="18.9" Border.Lines="Left, Right, Bottom" Text="[IIf((([Table1.numOfEmployeeEndOfTheMonth]+getFirstMonth([Table1.FullDate]))/2)==0,0,[Total3]/(([Table1.numOfEmployeeEndOfTheMonth]+getFirstMonth([Table1.FullDate]))/2))] %" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
        <MSChartObject Name="MSChart1" Left="-1.45" Top="75.6" Width="774.9" Height="217.35" DataSource="Table1" ChartData="PENoYXJ0IFNpemU9IjQzMiwgMzQ4IiBCb3JkZXJsaW5lQ29sb3I9IkRhcmtHcmF5IiBCb3JkZXJsaW5lV2lkdGg9IjIiIEJvcmRlcmxpbmVEYXNoU3R5bGU9IlNvbGlkIj4NCiAgPFNlcmllcz4NCiAgICA8U2VyaWVzIE5hbWU9ItmF2LnYr9mEINiv2YjYsdin2YYg2KfZhNi52YXYp9mE2KkiIExlZ2VuZD0iRGVmYXVsdCIgWFZhbHVlVHlwZT0iU3RyaW5nIiBZVmFsdWVUeXBlPSJEb3VibGUiIENoYXJ0VHlwZT0iTGluZSIgQ2hhcnRBcmVhPSJEZWZhdWx0IiBGb250PSJNaWNyb3NvZnQgU2FucyBTZXJpZiwgOHB0Ij4NCiAgICAgIDxQb2ludHM+DQogICAgICAgIDxEYXRhUG9pbnQgWVZhbHVlcz0iMC4xIiBBeGlzTGFiZWw9IkEiIC8+DQogICAgICAgIDxEYXRhUG9pbnQgWVZhbHVlcz0iMC41IiBBeGlzTGFiZWw9IkIiIC8+DQogICAgICAgIDxEYXRhUG9pbnQgWVZhbHVlcz0iMSIgQXhpc0xhYmVsPSJDIiAvPg0KICAgICAgICA8RGF0YVBvaW50IFlWYWx1ZXM9IjEuNSIgQXhpc0xhYmVsPSJEIiAvPg0KICAgICAgICA8RGF0YVBvaW50IFlWYWx1ZXM9IjIiIEF4aXNMYWJlbD0iZSIgLz4NCiAgICAgICAgPERhdGFQb2ludCBZVmFsdWVzPSIyLjUiIEF4aXNMYWJlbD0iZiIgLz4NCiAgICAgICAgPERhdGFQb2ludCBZVmFsdWVzPSIzIiBBeGlzTGFiZWw9ImciIC8+DQogICAgICAgIDxEYXRhUG9pbnQgWVZhbHVlcz0iMy41IiBBeGlzTGFiZWw9ImgiIC8+DQogICAgICAgIDxEYXRhUG9pbnQgWVZhbHVlcz0iNCIgQXhpc0xhYmVsPSJpIiAvPg0KICAgICAgICA8RGF0YVBvaW50IFlWYWx1ZXM9IjQuNSIgQXhpc0xhYmVsPSJrIiAvPg0KICAgICAgICA8RGF0YVBvaW50IFlWYWx1ZXM9IjUiIEF4aXNMYWJlbD0ibCIgLz4NCiAgICAgICAgPERhdGFQb2ludCBZVmFsdWVzPSI1LjUiIEF4aXNMYWJlbD0ibSIgLz4NCiAgICAgIDwvUG9pbnRzPg0KICAgIDwvU2VyaWVzPg0KICA8L1Nlcmllcz4NCiAgPExlZ2VuZHM+DQogICAgPExlZ2VuZCBOYW1lPSJEZWZhdWx0IiBJc1RleHRBdXRvRml0PSJGYWxzZSIgSXNEb2NrZWRJbnNpZGVDaGFydEFyZWE9IkZhbHNlIiBBbGlnbm1lbnQ9IkZhciIgRG9ja2luZz0iVG9wIj4NCiAgICA8L0xlZ2VuZD4NCiAgPC9MZWdlbmRzPg0KICA8VGl0bGVzPg0KICAgIDxUaXRsZSBOYW1lPSJUaXRsZTEiIFZpc2libGU9IkZhbHNlIj4NCiAgICA8L1RpdGxlPg0KICA8L1RpdGxlcz4NCiAgPENoYXJ0QXJlYXM+DQogICAgPENoYXJ0QXJlYSBOYW1lPSJEZWZhdWx0IiBCb3JkZXJXaWR0aD0iNiI+DQogICAgICA8QXhpc1kgSXNMYWJlbEF1dG9GaXQ9IkZhbHNlIj4NCiAgICAgICAgPE1ham9yR3JpZCBMaW5lQ29sb3I9IjY0LCA2NCwgNjQsIDY0IiAvPg0KICAgICAgPC9BeGlzWT4NCiAgICAgIDxBeGlzWCBJc0xhYmVsQXV0b0ZpdD0iRmFsc2UiIEludGVydmFsPSIxIj4NCiAgICAgICAgPE1ham9yR3JpZCBMaW5lQ29sb3I9IjY0LCA2NCwgNjQsIDY0IiAvPg0KICAgICAgICA8TGFiZWxTdHlsZSBGb250PSJNaWNyb3NvZnQgVGFpIExlLCA2cHQiIC8+DQogICAgICA8L0F4aXNYPg0KICAgICAgPEF4aXNYMiBJc0xhYmVsQXV0b0ZpdD0iRmFsc2UiPg0KICAgICAgICA8TWFqb3JHcmlkIExpbmVDb2xvcj0iNjQsIDY0LCA2NCwgNjQiIC8+DQogICAgICA8L0F4aXNYMj4NCiAgICAgIDxBeGlzWTIgSXNMYWJlbEF1dG9GaXQ9IkZhbHNlIj4NCiAgICAgICAgPE1ham9yR3JpZCBMaW5lQ29sb3I9IjY0LCA2NCwgNjQsIDY0IiAvPg0KICAgICAgPC9BeGlzWTI+DQogICAgPC9DaGFydEFyZWE+DQogIDwvQ2hhcnRBcmVhcz4NCiAgPEJvcmRlclNraW4gU2tpblN0eWxlPSJFbWJvc3MiIC8+DQo8L0NoYXJ0Pg==">
          <MSChartSeries Name="Series1" XValue="MonthName(Month([Table1.FullDate]))" YValue1=" (ToDouble([Table1.numOfEmployeeStartOfTheMonth]) + ToDouble([Table1.numOfEmployeeEndOfTheMonth])) /2"/>
        </MSChartObject>
      </GroupFooterBand>
    </GroupHeaderBand>
    <PageFooterBand Name="PageFooter1" Top="576.23" Width="771.12" Height="42.36">
      <TextObject Name="Memo1" Left="641.65" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo284" Left="67.46" Width="72.18" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo285" Left="7.56" Width="56.69" Height="15.12" Text="Printed on:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo286" Left="139.64" Width="38.96" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo288" Left="569.84" Top="27.24" Width="147.4" Height="15.12" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
      <TextObject Name="Text26" Left="189" Width="72.18" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
    </PageFooterBand>
  </ReportPage>
</Report>
