﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="05/17/2023 10:45:35" ReportInfo.Modified="05/17/2023 11:05:20" 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
  {

    private void _StartReport(object sender, EventArgs e)
    {
      if(((String)Report.GetParameterValue(&quot;Debit&quot;))  ==&quot;1&quot;)
      {
      memod.Visible=true;
      Memo20.Visible=true;
      Memo14.Visible=true;
      Memo10.Visible=true;
      Memo9.Visible=true;        
    }
    
      if(((String)Report.GetParameterValue(&quot;Credit&quot;)) ==&quot;1&quot;)
      {      
      memocr.Visible=true;
      Memo32.Visible=true;
      Memo15.Visible=true;       
      }       
      if(((String)Report.GetParameterValue(&quot;Balance&quot;))  ==&quot;1&quot;)
      {
      Memo34.Visible=true;
      Memo33.Visible=true;
      Memo16.Visible=true;        
      }        
    }
  }
}
/*void CostJobAnnualTrial_ReportDebitOnBeforePrint(TfrxComponent Sender)
{
  if(&lt;Debit&gt;==1)
  {
    memod.Visible=true;
    memo20.Visible=true;
    memo14.Visible=true;
    memo10.Visible=true;
    memo9.Visible=true;        
  }
    
  if(&lt;Credit&gt;==1)
  {      
   memocr.Visible=true;
   memo32.Visible=true;
   memo15.Visible=true;       
   }       
  if(&lt;Balance&gt;==1)
  {
    memo34.Visible=true;
    memo33.Visible=true;
    memo16.Visible=true;        
  }        
}
  
{

}
*/</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBiHvL1D3R/ZPYDVVa5Loc9UYb7RKhUtpflorZaKqsXCcnyxGxsoOtxmj8O3zAzOr8xulWz9WMrEwbL1fT7FwSnrHlZdnbLlrLvi0Hl5ljEDIDvuLRbkEayLcznNYU2Se6a1MULOn4LRvgaQDqvFNv9KnBlYocPWYbk+mImkhNzwpiStFsRikCpoX7mjkcNp6l4R6Aq3N5c3QvUjplXacR4ML/mtPF0xnDhD7W2Jl4RWobBorLXkaPZxd5RGxrxSrxVNC8XOD+jzOMKZnTCnDDeGUh+tUJoGWexvkPNmrSKTzTN4jT30KEV+ZsOY+TlwZV89ddf38gkSdFg52eWadl3iXexPKtzx5EnNFb6EoXx7BqmN7doDSmhAAG1J1/Ivi9FYFbm4hSMfUFdsx3mC7+OZbRcCWyWa9KWwSHRTAgIIesWC/nu1BZL/JgiwT0yyNeKxj5dqc14GZZX2LwlcgN0+FsAI8x7jWY1cKkGm31TIdF69Y7AKg7oPhfs9CIKWtdZSkHkVvvvudnt2JNvc3nu+kFIERfZYeKKYj9ILypLy/t390V2CwycIC0vqyl/WN4TRts+rwHtIv1+98BhXj2PCg==">
      <TableDataSource Name="CostJobAnnualTrial_Report" DataType="System.Int32" Enabled="true" TableName="CostJobAnnualTrial_Report" SelectCommand="exec MnrRepCostJobAnnualTrial '{E35B9C96-6BCB-46fe-9783-69C121C8F7FD}' , '{B11AC6E9-5064-48fd-917A-2AB834A04540}' , 1 , '{ABF5FA47-2A75-438a-98DE-2FE64A587EE4}' , '{D435BD3C-9C45-46be-BA4C-18C9425C364E}' , '1-1-2021' , '5-17-2023' , 1 , 1 , 1">
        <Column Name="Name" DataType="System.String"/>
        <Column Name="LatinName" DataType="System.String"/>
        <Column Name="Code" DataType="System.String"/>
        <Column Name="CostJobID" DataType="System.Guid"/>
        <Column Name="ParentCostJobID" DataType="System.Guid"/>
        <Column Name="Debit" DataType="System.Double"/>
        <Column Name="Credit" DataType="System.Double"/>
        <Column Name="FromDate" DataType="System.DateTime"/>
        <Column Name="Type" DataType="System.Int32"/>
        <Column Name="Level" DataType="System.Int32"/>
        <Column Name="path" DataType="System.String"/>
        <Column Name="AccID" DataType="System.Guid"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{2E273315-DE25-4ad2-9F43-48D27CF2C2ED}&quot;"/>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;1/1/2021&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;17/5/2023&quot;"/>
    <Parameter Name="Currency" DataType="System.String" Expression="&quot;ليرة تركي&quot;"/>
    <Parameter Name="Debit" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="Credit" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="Balance" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="ShowAccDetails" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="CostJobLevel" DataType="System.String" Expression="&quot;1&quot;"/>
    <Total Name="Total_1" Expression="IIf([Debit]==&quot;1&quot;,[CostJobAnnualTrial_Report.Debit],IIf([Credit]==&quot;1&quot;,[CostJobAnnualTrial_Report.Credit],IIf([Balance]==&quot;1&quot;,[CostJobAnnualTrial_Report.Debit]-[CostJobAnnualTrial_Report.Credit],0)))" Evaluator="MasterData2" PrintOn="ReportSummary1"/>
    <Total Name="Total_2" Expression="IIf([Credit]==&quot;1&quot;,[CostJobAnnualTrial_Report.Credit],IIf([Balance]==&quot;1&quot;,[CostJobAnnualTrial_Report.Debit]-[CostJobAnnualTrial_Report.Credit],0))" Evaluator="MasterData2" PrintOn="ReportSummary1"/>
    <Total Name="Total_3" Expression="IIf([Balance]==&quot;1&quot;,[CostJobAnnualTrial_Report.Debit]-[CostJobAnnualTrial_Report.Credit],0)" Evaluator="MasterData2" PrintOn="ReportSummary1"/>
  </Dictionary>
  <ReportPage Name="Page1" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="718.2" Height="170.08">
      <PictureObject Name="Company_Logo" Left="75.59" Width="566.93" Height="86.93" Fill.Color="White" ImageLocation="D:\almanarasoft\almanaratools\logo.png" SizeMode="CenterImage"/>
      <TextObject Name="Memo1" Left="1.89" Top="94.49" Width="714.33" Height="18.9" Text="ميزان مراجعة سنوي لمراكز الكلف" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt"/>
      <TextObject Name="Memo2" Left="644.41" Top="127.18" Width="69.92" Height="18.9" Text=" : اعتبارا من" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo3" Left="503.34" Top="127.18" Width="56.7" Height="18.9" Text=": ولغاية" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo4" Left="564.82" Top="127.18" Width="79.37" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo5" Left="423.53" Top="127.18" Width="79.37" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo6" Left="136.06" Top="127.18" Width="47.25" Height="18.9" Text=": العملة" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo7" Left="7.56" Top="127.18" Width="128.5" Height="18.9" Text=" [Currency] " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
    </ReportTitleBand>
    <GroupHeaderBand Name="GroupHeader2" Top="174.68" Width="718.2" Height="19.68" Condition="[CostJobAnnualTrial_Report.Name]">
      <TextObject Name="Memo11" Left="241.89" Width="464.88" Height="18.9" Text="[CostJobAnnualTrial_Report.Name]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <DataBand Name="MasterData2" Top="222.45" Width="718.2" Height="19.68" CanGrow="true" CanShrink="true" DataSource="CostJobAnnualTrial_Report">
        <TextObject Name="memod" Left="423.31" Top="0.78" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" GrowToBottom="true" Text="[IIf([Debit]==&quot;1&quot;,[CostJobAnnualTrial_Report.Debit],IIf([Credit]==&quot;1&quot;,[Credit],IIf([Balance]==&quot;1&quot;,[CostJobAnnualTrial_Report.Debit]-[CostJobAnnualTrial_Report.Credit],&quot;&quot;)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="memocr" Left="329.16" Top="0.78" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" GrowToBottom="true" Text="[IIf([Credit]==&quot;1&quot;,[CostJobAnnualTrial_Report.Credit],IIf([Balance]==&quot;1&quot;,[CostJobAnnualTrial_Report.Debit]-[CostJobAnnualTrial_Report.Credit],&quot;&quot;))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo34" Left="234.67" Top="0.78" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" GrowToBottom="true" Text="[[CostJobAnnualTrial_Report.Debit]- [CostJobAnnualTrial_Report.Credit]]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo12" Left="517.8" Top="0.78" Width="94.49" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[CostJobAnnualTrial_Report.FromDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <DataHeaderBand Name="Header1" Top="198.96" Width="718.2" Height="18.9">
          <TextObject Name="Memo13" Left="517.46" Width="94.49" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" Text="تاريخ" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TextObject Name="Memo20" Left="422.97" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" Text="[IIf([Debit]==&quot;1&quot;,&quot;مدين&quot;,IIf([Credit]==&quot;1&quot;,&quot;دائن&quot;,IIf([Balance]==&quot;1&quot;,&quot;رصيد&quot;,&quot;&quot;)))]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TextObject Name="Memo32" Left="328.82" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" Text="[IIf([Credit]==&quot;1&quot;,&quot;دائن&quot;,IIf([Balance]==&quot;1&quot;,&quot;رصيد&quot;,&quot;&quot;))]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TextObject Name="Memo33" Left="234.33" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" Text="[IIf([Balance]==&quot;1&quot;,&quot;رصيد&quot;,&quot;&quot;)]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
          <TextObject Name="Memo8" Left="612.28" Width="94.49" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" Text="مركز كلفة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
        </DataHeaderBand>
      </DataBand>
      <GroupFooterBand Name="GroupFooter2" Top="246.73" Width="718.2"/>
    </GroupHeaderBand>
    <ReportSummaryBand Name="ReportSummary1" Top="251.33" Width="718.2" Height="22.68">
      <TextObject Name="Memo9" Left="612.28" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" Text="الاجمالي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo10" Left="517.8" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo14" Left="423.31" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" Text="[Total_1]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo15" Left="328.82" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" Text="[Total_2]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo16" Left="234.33" Width="94.49" Height="18.9" Visible="false" Border.Lines="All" Fill.Color="186, 211, 254" Text="[Total_3]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="278.61" Width="718.2" Height="42.36">
      <TextObject Name="Memo27" Left="627.4" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo140" Left="63.03" Width="83.15" 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="Memo141" Left="3.78" 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="Memo142" Left="152.52" Width="39.69" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo28" Left="566.93" Top="23.46" Width="143.62" Height="18.9" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Blue"/>
      <TextObject Name="Text1" Left="198.45" Width="83.15" 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>
