﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="09/30/2022 11:58:00" ReportInfo.Modified="03/16/2023 11:43:06" 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 MasterData2_BeforePrint(object sender, EventArgs e)
    {                                                                               
      if (((Int32)Report.GetColumnValue(&quot;Acc_TrialBalance_Report.AccType&quot;))== 0 )
      {
      if (((Double)Report.GetColumnValue(&quot;Acc_TrialBalance_Report.Debit&quot;)) &gt;((Double)Report.GetColumnValue(&quot;Acc_TrialBalance_Report.Credit&quot;)) )                         
      {
      AccNum2.TextColor = Color.Red;                                       
      AccCode2.TextColor   =Color.Red; 
      AccName2.TextColor   =Color.Red; 
      AccODebit2.TextColor =Color.Red;      
      AccOCredit2.TextColor =Color.Red;                                        
      AccBDebit2.TextColor =Color.Red;    
      AccBCredit2.TextColor =Color.Red;                                      
      AccFDebit2.TextColor =Color.Red;    
      AccFDebit2.TextColor  =Color.Red;                                    
    }                                 
                          
      else            
      {
      AccNum2.TextColor    = Color.Green;  
      AccCode2.TextColor   = Color.Green;  
      AccName2.TextColor   = Color.Green;                   
      AccODebit2.TextColor = Color.Green;       
      AccOCredit2.TextColor = Color.Green;                                         
      AccBDebit2.TextColor = Color.Green;     
      AccBCredit2.TextColor = Color.Green;                                       
      AccFDebit2.TextColor = Color.Green;     
      AccFDebit2.TextColor  = Color.Green;                 
      }
      }                                
      else                
      {
      if (((Double)Report.GetColumnValue(&quot;Acc_TrialBalance_Report.Debit&quot;))&gt; ((Double)Report.GetColumnValue(&quot;Acc_TrialBalance_Report.Credit&quot;)))                            
      {
      AccNum2.TextColor    = Color.Black; 
      AccCode2.TextColor   = Color.Black;             
      AccName2.TextColor   = Color.Black;             
      AccODebit2.TextColor = Color.Black;      
      AccOCredit2.TextColor = Color.Black;                                        
      AccBDebit2.TextColor = Color.Black;    
      AccBCredit2.TextColor = Color.Black;                                      
      AccFDebit2.TextColor = Color.Black;    
      AccFDebit2.TextColor  = Color.Black;        
      }                                              
      else
      {
      AccNum2.TextColor    =  Color.Blue; 
      AccCode2.TextColor   =  Color.Blue;             
      AccName2.TextColor   =  Color.Blue;             
      AccODebit2.TextColor =  Color.Blue;      
      AccOCredit2.TextColor =  Color.Blue;                                        
      AccBDebit2.TextColor =  Color.Blue;    
      AccBCredit2.TextColor =  Color.Blue;                                      
      AccFDebit2.TextColor =  Color.Blue;    
      AccFDebit2.TextColor  =  Color.Blue;                      
      }                  
      }    
      } 


   
  }} 

</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBieCxotcH2hUtyMN3HKcJlMnIc573nib6FlxDbWckCUdNG2nFnYXef/888mBOr3VwlTsvr/KtnrXJMDiOvBhXmCV4VCJvSs3ndrLSWLJEU/5ejlw0WobaBCW8oZCkfddVQmzUFOCHleUyEbIWg/JgbZJ9xalo1VD7Wfq/DX5ejAYlH4E3VHLCQI2I05j3GJYgN4s86QsUdYiFprXFMu3OyHeJiKyvcrpSXZbxtmMQUmMwd8dQ6KqZX1va26DH41Hlqm8JboKzOF32CdUO/ZYv3KHLjAIdmeiPvTjv1R3UpZKKmHPEHPSbQf0ZUsDRtF5TopWeOX6McV7aF79kjJj7qCeBsPDXmIA7gTKRyCeTZcB79IudtlTn/MT84HXHDsj1d/uGiDa/6kKjRMkS7iLSB1HhmEXU7Xrg//zY/t5PGxSyAtwq4driEF1YpmTK6ZhdSEYfYy1sv+u2ffBOHK+190Vy1rvYnOavPe9WLnSJoon1Du0wGgQKcUpAfzqKPzNoV6imfBPp6XDupbqyYU6A+0HLT4xy0GG7JXyw9sD+z/pLDx97twsuTuXcF1HFLUUvbmf9ifRGZUwp9phFqzzn/qA==">
      <TableDataSource Name="Acc_TrialBalance_Report" DataType="System.Int32" Enabled="true" TableName="Acc_TrialBalance_Report" SelectCommand="exec mnrPrcRepAccTrialBal '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{B9EEC3C2-29E0-4c74-B417-AF59EECCA3DF}' , '{8461AA7C-F8FF-43e7-AB90-A32E42CA5782}' , 1 , '1-1-2022' , '3-16-2023' , '' , '' , 0 , 1 , 0 , 0 , 0 , 0 , 0 , 0 , 1 , 1 , 0 , 0 , 0 , 0 , 0 , 1 , 0 , 0 , 0 , 0 , 0 , '{00000000-0000-0000-0000-000000000000}', '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}'">
        <Column Name="AccID" DataType="System.Guid"/>
        <Column Name="AccCode" DataType="System.String"/>
        <Column Name="AccName" DataType="System.String"/>
        <Column Name="AccLName" DataType="System.String"/>
        <Column Name="Debit" DataType="System.Double"/>
        <Column Name="Credit" DataType="System.Double"/>
        <Column Name="Debit2" DataType="System.Double"/>
        <Column Name="Credit2" DataType="System.Double"/>
        <Column Name="BalDebit" DataType="System.Double"/>
        <Column Name="BalCredit" DataType="System.Double"/>
        <Column Name="BalDebit2" DataType="System.Double"/>
        <Column Name="BalCredit2" DataType="System.Double"/>
        <Column Name="AccCurrencyID" DataType="System.Guid"/>
        <Column Name="CostID" DataType="System.Guid"/>
        <Column Name="CostCode" DataType="System.String"/>
        <Column Name="CostName" DataType="System.String"/>
        <Column Name="CostLName" DataType="System.String"/>
        <Column Name="SalesManID" DataType="System.Guid"/>
        <Column Name="SalesManCode" DataType="System.String"/>
        <Column Name="SalesManName" DataType="System.String"/>
        <Column Name="SalesManLName" DataType="System.String"/>
        <Column Name="AccType" DataType="System.Int32"/>
        <Column Name="PrevDebit" DataType="System.Double"/>
        <Column Name="PrevCredit" DataType="System.Double"/>
        <Column Name="PrevDebit2" DataType="System.Double"/>
        <Column Name="PrevCredit2" DataType="System.Double"/>
        <Column Name="PrevBalDebit" DataType="System.Double"/>
        <Column Name="PrevBalCredit" DataType="System.Double"/>
        <Column Name="PrevBalDebit2" DataType="System.Double"/>
        <Column Name="PrevBalCredit2" DataType="System.Double"/>
        <Column Name="Path" DataType="System.String"/>
        <Column Name="Level" DataType="System.Int32"/>
        <Column Name="LastPay" DataType="System.Double"/>
        <Column Name="LastPayDate" DataType="System.DateTime"/>
        <Column Name="LastDebit" DataType="System.Double"/>
        <Column Name="LastDebitDate" DataType="System.DateTime"/>
        <Column Name="LastCredit" DataType="System.Double"/>
        <Column Name="LastCreditDate" DataType="System.DateTime"/>
        <Column Name="AccCurBal" DataType="System.Double"/>
        <Column Name="AccPCode" DataType="System.String"/>
        <Column Name="AccPName" DataType="System.String"/>
        <Column Name="AccPID" DataType="System.Guid"/>
        <Column Name="crCode" DataType="System.String"/>
        <Column Name="BeDebit" DataType="System.Double"/>
        <Column Name="BeCredit" DataType="System.Double"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;01/01/2022&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;16/03/2023&quot;"/>
    <Parameter Name="OldBalance" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{1D9649A7-6D5B-436d-A486-8A8C13EC1791}&quot;"/>
    <Parameter Name="FromAcc" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="ToAcc" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="AccCurrency" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowCurrency2" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="Level" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bRepTypeBalanceBalanced" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="bRepTypeTotaly" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bRepTypeBalance" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bBalType" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="CurrncyType" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="AccOrder" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="PeriodType" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bShowSubAcc" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="bShowMainAcc" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="bShowAccBalanced" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bShowAccEmpty" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bShowLastPay" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bShowLastDebit" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bShowLastCredit" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bShowPostedEntry" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="bShowPostedUnEntry" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bShowCostJob" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bShowSalesMan" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ConditionAcc" DataType="System.String" Expression="&quot;{00000000-0000-0000-0000-000000000000}&quot;"/>
    <Parameter Name="CurrencyName" DataType="System.String" Expression="&quot;دولار أمريكي&quot;"/>
    <Parameter Name="AccCodeName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="CostJobCodeName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="SellManCodeName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="Vendor" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="Class" DataType="System.String" Expression="&quot;&quot;"/>
    <Total Name="Total" Expression=" IIf( ([Acc_TrialBalance_Report.AccType] == 0) &amp;&amp; ([Acc_TrialBalance_Report.Level] == 0) , [Acc_TrialBalance_Report.BeDebit]  , 0)  " Evaluator="MasterData2"/>
    <Total Name="Total1" Expression=" IIf( ([Acc_TrialBalance_Report.AccType] == 1) , [Acc_TrialBalance_Report.BeDebit] , 0) " Evaluator="MasterData2"/>
    <Total Name="Total2" Expression=" IIf( ([Acc_TrialBalance_Report.AccType] == 0) &amp;&amp; ([Acc_TrialBalance_Report.Level] == 0) ,  [Acc_TrialBalance_Report.BeCredit]  , 0)   " Evaluator="MasterData2"/>
    <Total Name="Total3" Expression="   IIf( ([Acc_TrialBalance_Report.AccType] == 1) ,  [Acc_TrialBalance_Report.BeCredit] , 0)   " Evaluator="MasterData2"/>
    <Total Name="Total4" Expression="IIf( [Acc_TrialBalance_Report.Level]  == 0 ,    [Acc_TrialBalance_Report.BalDebit]  ,0) " Evaluator="MasterData2"/>
    <Total Name="Total5" Expression=" IIf( [Acc_TrialBalance_Report.Level] == 0 ,  [Acc_TrialBalance_Report.BalCredit]  ,0) " Evaluator="MasterData2"/>
    <Total Name="Total6" Expression="[Acc_TrialBalance_Report.BalDebit]" Evaluator="MasterData2"/>
    <Total Name="Total7" Expression="[Acc_TrialBalance_Report.BalCredit]" Evaluator="MasterData2"/>
    <Total Name="Total8" Expression="  IIf( [bShowMainAcc] == &quot;1&quot; ,  IIf([Acc_TrialBalance_Report.Level]==0,[Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit],0) , [Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])    " Evaluator="MasterData2"/>
    <Total Name="Total9" Expression=" IIf([Acc_TrialBalance_Report.Level]==0, [Acc_TrialBalance_Report.Debit]+[Acc_TrialBalance_Report.PrevDebit],0) " Evaluator="MasterData2"/>
    <Total Name="Total10" Expression=" IIf([bShowMainAcc] == &quot;1&quot; , IIf([Acc_TrialBalance_Report.Level]==0, IIf(([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit])&gt;0,([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit]),0),0) , IIf(([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit])   &gt;  0,([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit]),0) )   " Evaluator="MasterData2"/>
    <Total Name="Total11" Expression=" IIf( [bShowMainAcc] == &quot;1&quot; ,  IIf([Acc_TrialBalance_Report.Level]==0,[Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit],0) , [Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit]) " Evaluator="MasterData2"/>
    <Total Name="Total12" Expression=" IIf([Acc_TrialBalance_Report.Level]==0, [Acc_TrialBalance_Report.Credit]+[Acc_TrialBalance_Report.PrevCredit],0) " Evaluator="MasterData2"/>
    <Total Name="Total13" Expression=" IIf([bShowMainAcc] == &quot;1&quot; , IIf([Acc_TrialBalance_Report.Level]==0, IIf(([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit]) &lt; 0, Abs(([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit])),0),0) , IIf(([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit])   &lt;  0,Abs(([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit])),0) )   " Evaluator="MasterData2"/>
  </Dictionary>
  <ReportPage Name="Page1" LeftMargin="5" RightMargin="5" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle2" Width="756" Height="168.84">
      <TextObject Name="Memo7" Left="-11.34" Top="100.28" Width="778.58" Height="22.68" Text="ميزان المراجعة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Memo18" Left="670.94" Top="134.18" Width="66.14" Height="18.9" Text=": إعتبارا من" Padding="2, 1, 2, 1" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo25" Left="598.71" Top="134.18" Width="79.37" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo26" Left="544.89" Top="134.18" Width="51.02" Height="18.9" Text=": ولغاية " Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo27" Left="478.31" Top="134.18" Width="71.81" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <PictureObject Name="Company_Logo1" Left="24.57" Top="3.78" Width="706.77" Height="94.49" Fill.Color="White" SizeMode="CenterImage"/>
      <TextObject Name="Memo58" Left="113.49" Top="134.18" Width="47.25" Height="18.9" Text=": العملة" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo59" Left="0.78" Top="134.18" Width="120.94" Height="18.9" Text=" [CurrencyName] " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader2" Top="172.84" Width="756" Height="22.68" CanGrow="true" CanShrink="true">
      <TextObject Name="Memo38" Left="714.45" Top="3.78" Width="41.57" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" GrowToBottom="true" Text="الرقم" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo39" Left="536.81" Top="3.78" Width="109.61" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" GrowToBottom="true" Text="حسابات" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo40" Left="453.66" Top="3.78" Width="83.15" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" GrowToBottom="true" Text="[&quot;الرصيد الافتتاحي - مدين&quot;]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="AccOCredit" Left="362.95" Top="3.78" Width="90.71" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" GrowToBottom="true" Text="[&quot;الرصيد الافتتاحي - دائن&quot;]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo42" Left="276.24" Top="3.78" Width="86.59" Height="18.9" Border.Lines="Left, Top, Bottom" Fill.Color="187, 210, 244" GrowToBottom="true" Text="رصيد مدين" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo43" Left="185.98" Top="3.78" Width="89.93" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" GrowToBottom="true" Text="رصيد دائن" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo44" Left="91.49" Top="3.78" Width="94.49" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;,&quot;آخر الفترة-مجموع رصيد مدين&quot;,IIf([bBalType]==&quot;1&quot;,&quot;آخر الفترة-إجماليرصيد مدين&quot;,IIf([bBalType]==&quot;0&quot;,&quot;آخر الفترة- رصيد مدين&quot;,&quot;&quot;)))]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo45" Left="-1.13" Top="3.78" Width="92.61" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;,&quot;آخر الفترة-مجموع رصيد دائن&quot;,IIf([bBalType]==&quot;1&quot;,&quot;آخر الفترة- إجمالي رصيد دائن&quot;,IIf([bBalType]==&quot;0&quot;,&quot;آخر الفترة- رصيد دائن&quot;,&quot;&quot;)))]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo41" Left="646.42" Top="3.78" Width="68.03" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" GrowToBottom="true" Text="رمز الحساب" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
    </PageHeaderBand>
    <GroupHeaderBand Name="GroupHeader1" Top="199.52" Width="756" Condition="[Acc_TrialBalance_Report.AccID]" SortOrder="None" KeepTogether="true">
      <DataBand Name="MasterData2" Top="203.52" Width="756" Height="18.9" CanGrow="true" CanShrink="true" BeforePrintEvent="MasterData2_BeforePrint" DataSource="Acc_TrialBalance_Report"/>
      <GroupFooterBand Name="GroupFooter1" Top="226.42" Width="756" Height="18.9" CanGrow="true" CanShrink="true">
        <TextObject Name="AccBCredit2" Left="186.1" Width="89.8" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[(ToDouble(IIf([bRepTypeBalanceBalanced] == &quot;1&quot; , IIf(([Acc_TrialBalance_Report.BalDebit] -  [Acc_TrialBalance_Report.BeDebit]) -([Acc_TrialBalance_Report.BalCredit] -[Acc_TrialBalance_Report.BeCredit]) &gt; 0,0,([Acc_TrialBalance_Report.BalCredit]-[Acc_TrialBalance_Report.BeCredit])-([Acc_TrialBalance_Report.BalDebit] -  [Acc_TrialBalance_Report.BeDebit])) ,  IIf([bRepTypeTotaly] == &quot;1&quot; , [Acc_TrialBalance_Report.Credit] , IIf([bRepTypeBalance]  == &quot;1&quot; , IIf(([Acc_TrialBalance_Report.BalDebit] -  [Acc_TrialBalance_Report.BeDebit])-([Acc_TrialBalance_Report.BalCredit] -[Acc_TrialBalance_Report.BeCredit]) &gt; 0,0,([Acc_TrialBalance_Report.BalCredit] -[Acc_TrialBalance_Report.BeCredit])-([Acc_TrialBalance_Report.BalDebit] -  [Acc_TrialBalance_Report.BeDebit])),0 )))))  - (ToDouble(IIf([bRepTypeBalanceBalanced]== &quot;1&quot; , IIf(([Acc_TrialBalance_Report.BalDebit]-[Acc_TrialBalance_Report.BeDebit]) -([Acc_TrialBalance_Report.BalCredit]-[Acc_TrialBalance_Report.BeCredit]) &lt; 0,  ([Acc_TrialBalance_Report.BeCredit] - [Acc_TrialBalance_Report.BeCredit] )  , 0 ) , IIf([bRepTypeTotaly] == &quot;1&quot; , IIf([Acc_TrialBalance_Report.Credit]  &gt;  0 , [Acc_TrialBalance_Report.BeCredit] , 0), IIf([bRepTypeBalance]  == &quot;1&quot; ,     IIf(([Acc_TrialBalance_Report.BalDebit]-[Acc_TrialBalance_Report.BeDebit]) -([Acc_TrialBalance_Report.BalCredit]-[Acc_TrialBalance_Report.BeCredit]) &lt; 0,  ([Acc_TrialBalance_Report.BeCredit] - [Acc_TrialBalance_Report.BeCredit] )  , 0 ),0 )))))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="AccFCredit2" Left="-1" Width="92.61" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;,[Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit],IIf([bBalType]==&quot;1&quot;,[Acc_TrialBalance_Report.Credit]+[Acc_TrialBalance_Report.PrevCredit],IIf([bBalType]==&quot;0&quot;, IIf(([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit])&lt;0, Abs(([Acc_TrialBalance_Report.BalDebit]     +[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit])),0)  ,  &quot;&quot;  )))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="AccFDebit2" Left="91.61" Width="94.49" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;,[Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit],IIf([bBalType]==&quot;1&quot;,[Acc_TrialBalance_Report.Debit]+[Acc_TrialBalance_Report.PrevDebit],IIf([bBalType]==&quot;0&quot;, IIf(([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit])&gt;0,  ([Acc_TrialBalance_Report.BalDebit]+[Acc_TrialBalance_Report.PrevBalDebit])-([Acc_TrialBalance_Report.BalCredit]+[Acc_TrialBalance_Report.PrevBalCredit]),0)  ,  &quot;&quot;  )))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="AccOCredit2" Left="363.08" Width="90.58" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[Acc_TrialBalance_Report.BeCredit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="AccODebit2" Left="453.66" Width="83.15" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[Acc_TrialBalance_Report.BeDebit]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="AccName2" Left="536.81" Width="109.61" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[[Acc_TrialBalance_Report.AccCode]]-[[Acc_TrialBalance_Report.AccName]]" Padding="2, 1, 2, 1" HorzAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
        <TextObject Name="AccNum2" Left="714.45" Width="41.57" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="AccCode2" Left="646.42" Width="68.03" Height="18.9" Border.Lines="Top, Bottom" GrowToBottom="true" Text="[Acc_TrialBalance_Report.AccCode]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="AccBDebit2" Left="276.37" Width="86.46" Height="18.9" Border.Lines="Top, Bottom" GrowToBottom="true" Text="[(ToDouble(IIf([bRepTypeBalanceBalanced] == &quot;1&quot; ,IIf(([Acc_TrialBalance_Report.BalDebit]-[Acc_TrialBalance_Report.BeDebit]) -([Acc_TrialBalance_Report.BalCredit] -  [Acc_TrialBalance_Report.BeCredit])  &lt; 0,0,([Acc_TrialBalance_Report.BalDebit]-[Acc_TrialBalance_Report.BeDebit])-([Acc_TrialBalance_Report.BalCredit] -  [Acc_TrialBalance_Report.BeCredit])) , IIf([bRepTypeTotaly] == &quot;1&quot; , [Acc_TrialBalance_Report.Debit] , IIf([bRepTypeBalance]  == &quot;1&quot; , IIf(([Acc_TrialBalance_Report.BalDebit]-[Acc_TrialBalance_Report.BeDebit]) -([Acc_TrialBalance_Report.BalCredit] -  [Acc_TrialBalance_Report.BeCredit])  &lt; 0,0,([Acc_TrialBalance_Report.BalDebit]-[Acc_TrialBalance_Report.BeDebit]) -([Acc_TrialBalance_Report.BalCredit] -  [Acc_TrialBalance_Report.BeCredit])),0 )))))-(ToDouble(IIf([bRepTypeBalanceBalanced] == &quot;1&quot; ,  IIf(([Acc_TrialBalance_Report.BalDebit]-[Acc_TrialBalance_Report.BalDebit]) -([Acc_TrialBalance_Report.BalCredit]-[Acc_TrialBalance_Report.BeCredit]) &gt; 0,([Acc_TrialBalance_Report.BeDebit] - [Acc_TrialBalance_Report.BeDebit] )  , 0 ) , IIf([bRepTypeTotaly] == &quot;1&quot; , IIf([Acc_TrialBalance_Report.Debit] &gt;0 ,[Acc_TrialBalance_Report.BeDebit], 0) , IIf([bRepTypeBalance]  == &quot;1&quot; ,  IIf(([Acc_TrialBalance_Report.BalDebit]-[Acc_TrialBalance_Report.BeDebit]) -([Acc_TrialBalance_Report.BalCredit]-[Acc_TrialBalance_Report.BeCredit]) &gt; 0,  ([Acc_TrialBalance_Report.BalDebit] - [Acc_TrialBalance_Report.BalDebit] )  , 0 ),0 )) )))]&#13;&#10;" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      </GroupFooterBand>
    </GroupHeaderBand>
    <ReportSummaryBand Name="ReportSummary2" Top="249.32" Width="756" Height="18.9" CanGrow="true" CanShrink="true">
      <TextObject Name="Memo19" Left="536.81" Top="0.16" Width="219.21" Height="18.74" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" GrowToBottom="true" Text="الإجمالي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo20" Left="453.66" Width="83.15" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="[IIf(  [bShowMainAcc] == &quot;1&quot;   ,   [Total]     , [Total1]  )]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo22" Left="362.95" Width="90.71" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="[IIf( [bShowMainAcc] == &quot;1&quot;   ,  [Total2]     ,  [Total3]  )]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo56" Left="91.61" Width="94.49" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;, [Total8],IIf([bBalType]==&quot;1&quot;,   [Total9],IIf([bBalType]==&quot;0&quot;, [Total10],&quot;&quot;)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo57" Left="-1" Width="92.61" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="[IIf([bBalType] == &quot;2&quot;,  [Total11],IIf([bBalType]== &quot;1&quot;,  [Total12],IIf([bBalType]==&quot;0&quot;,[Total13],&quot;&quot;)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo1" Left="276.24" Width="86.59" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="[IIf( [bShowMainAcc] == &quot;1&quot; ,    IIf([Total4]   -  [Total5] &gt; 0 ,  [Total4]  -   [Total5] ,  0 )   ,   IIf([Total6] -  [Total7]  &gt; 0 ,    [Total6] -   [Total7] ,  0 ))]&#13;&#10;&#13;&#10;" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo2" Left="185.98" Width="89.93" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" Text="[IIf( [bShowMainAcc] ==&quot;1&quot; ,    IIf(([Total5]  -  [Total4] ) &gt; 0 ,  ([Total5] -  [Total4]),  0 )   ,   IIf(([Total7]   - [Total6]) &gt; 0 , ( [Total7] -  [Total6]) ,  0 ) )]&#13;&#10;" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter2" Top="272.22" Width="756" Height="45.35">
      <TextObject Name="Memo32" Left="664.32" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo33" Left="63.81" Top="5.78" 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="Memo34" Left="4.56" Top="5.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="Memo35" Left="153.3" Top="5.78" Width="30.24" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo37" Left="610.02" Top="28.51" Width="147.37" Height="13.34" Border.Lines="All" Border.Color="White" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>
