﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="01/19/2023 11:21:35" ReportInfo.Modified="10/15/2024 12:51:35" 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
  {
    void _StartReport(object sender, EventArgs e)
    {                     
      if((((String)Report.GetParameterValue(&quot;OldBalance&quot;)) != &quot;1&quot;))  
      {
        MessageBox.Show(&quot;خيار الرصيد السابق غير مفعل&quot;);
        Page1.Visible = false;
        // TfrxReport( Sender).Terminated = true;
        
      }
      else if((((String)Report.GetParameterValue(&quot;bRepTypeBalanceBalanced&quot;)) == &quot;0&quot;) &amp;&amp; ( ((String)Report.GetParameterValue(&quot;bRepTypeTotaly&quot;))== &quot;0&quot;) &amp;&amp; (((String)Report.GetParameterValue(&quot;bRepTypeBalance&quot;)) == &quot;0&quot;))
      {
        MessageBox.Show(&quot;يجب اختيار نوع الميزان&quot;);
          Page1.Visible = false;
        //  TfrxReport( Sender).Terminated = true;    
      }
    }      

    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="rijcmlqKjSU40dlxFMmorDfgW0xWghLfHh9It0YM419tI3EqnDwCQRhxmoCe6bhrhjTzx2Y0F0RTONUmYAGZ6dlXfrK+aaLoV3VCX81Ee/g9bTWGPLv0zbl5s2dOBVHvBKLS+Kdw1xelblGqTVepGfVY2zk+Y23WFm9hnxIT4nk8bJ+3+/0bRvr5TEDiVcIhN2qBJ2H8kT5g8c4LUiFC0IebojO5zuiQ2q0itFGH/zR/n6SlQtPw9EmA4j0TqdPVc9CViU3FoctYq33BMJQr4mApyOEZ+zUiLVrRGdC7IRe0Jv23xeB93phov6pBgoAlZNWXpXsRd9fMEEJOacMxba5FGFjr8jxfWrbJaNhePfuIFafSNbtCAF11VXnFztmtzGgVgjlrc3/FiyfRscPkj4cTi4T3oasx79+c1RzHxwxMJUp0TJNDAN3Ficp31azRHBAcCqjvLVuYrEnxQt5HqAGZBmk/tjwQ63TdEYRP4wlGCpJJU26TReRvv8+4CarkbUL8RH1c4bJxd04gXyCmhGxv/0FUbVK/PD02VwwOnxt+GdcdenQyeyM8udqi6L+58IcEYWczclyTb2JVkTVD9r6zY7NDDr1HuZQJCJ7UwhVIiwKHZ9ZfND153yfv5eo/CjltDnhvL0ntRfk+7Jnsc4Zs7/pphij4HYnZ8t+jczZl+B4rNRswSLFy96CK27twewF1MneSY7XO1Vn5JIOCI/8cRU6cA==" CommandTimeout="1200">
      <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}' , '{C1779595-C78A-43d4-A95F-822D03EC4110}' , '{8DD84EF1-89BA-4673-8A9F-44DC7375BCDD}' , 1 , '12-31-2023' , '10-15-2024' , '' , '' , 0 , 1 , 0 , 0 , 0 , 0 , 0 , 0 , 1 , 1 , 1 , 0 , 0 , 0 , 0 , 1 , 0 , 1 , 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>
      <TableDataSource Name="ExtSecConnection" DataType="System.Int32" Enabled="true" TableName="ExtSecConnection" SelectCommand="exec mnrFrxPrcConnection_Add '{6CCA4800-C4E7-4c35-A2D8-FC4F74F6199B}'">
        <Column Name="TmpVal" DataType="System.Int32"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;31/12/2023&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;15/10/2024&quot;"/>
    <Parameter Name="OldBalance" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{6CCA4800-C4E7-4c35-A2D8-FC4F74F6199B}&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;1&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_PrevBalDebit" Expression="IIf([bShowMainAcc]== &quot;1&quot; ,IIf([Acc_TrialBalance_Report.Level]==0,[Acc_TrialBalance_Report.PrevBalDebit],0), [Acc_TrialBalance_Report.PrevBalDebit])" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total_PrevDebit" Expression="IIf([bShowMainAcc] ==&quot;1&quot;,IIf([Acc_TrialBalance_Report.Level]==0,[Acc_TrialBalance_Report.PrevDebit],0), [Acc_TrialBalance_Report.PrevDebit])" Evaluator="MasterData2"/>
    <Total Name="Total_PrevDebit-PrevCredit" Expression="IIf( [bShowMainAcc] == &quot;1&quot; ,  IIf([Acc_TrialBalance_Report.Level]==0,IIf([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit]&lt;0,0,[Acc_TrialBalance_Report.PrevDebit]- [Acc_TrialBalance_Report.PrevCredit]),0),IIf([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit] &lt;0,0,[Acc_TrialBalance_Report.PrevDebit] -[Acc_TrialBalance_Report.PrevCredit]))" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total_PrevBalCredit" Expression="IIf([bShowMainAcc]== &quot;1&quot; ,IIf([Acc_TrialBalance_Report.Level]==0,[Acc_TrialBalance_Report.PrevBalCredit],0), [Acc_TrialBalance_Report.PrevBalCredit])" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total_PrevCredit" Expression="IIf([bShowMainAcc] ==&quot;1&quot;,IIf([Acc_TrialBalance_Report.Level]==0,[Acc_TrialBalance_Report.PrevCredit],0), [Acc_TrialBalance_Report.PrevCredit])" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total_PrevDebitC" Expression="IIf([bShowMainAcc] == &quot;1&quot; ,  IIf([Acc_TrialBalance_Report.Level]==0,IIf([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit]&gt; 0,0, Abs([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit])),0),IIf([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit] &gt; 0 ,0, Abs([Acc_TrialBalance_Report.PrevDebit] - [Acc_TrialBalance_Report.PrevCredit])))        " Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total_BalDebit" Expression="IIf([Acc_TrialBalance_Report.Level] == 0 ,[Acc_TrialBalance_Report.BalDebit],0)" Evaluator="MasterData2"/>
    <Total Name="Total_BalCredit" Expression="IIf([Acc_TrialBalance_Report.Level]== 0,[Acc_TrialBalance_Report.BalCredit],0)" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total_Level-BalDebit" Expression="IIf([Acc_TrialBalance_Report.Level]==0,[Acc_TrialBalance_Report.BalDebit],0)" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="TotalBalDebit" Expression="[Acc_TrialBalance_Report.BalDebit]" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="TotalBalCredit" Expression="[Acc_TrialBalance_Report.BalCredit]" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total_Debit" Expression="IIf([bShowMainAcc] ==&quot;1&quot;,IIf( [Acc_TrialBalance_Report.Level]== 0 ,[Acc_TrialBalance_Report.Debit],0 ),[Acc_TrialBalance_Report.Debit] )" Evaluator="MasterData2"/>
    <Total Name="TotalBalDebit" Expression="IIf([bShowMainAcc] == &quot;1&quot; ,IIf([Acc_TrialBalance_Report.Level] == 0 ,  [Acc_TrialBalance_Report.BalDebit],0 ), [Acc_TrialBalance_Report.BalDebit])   " Evaluator="MasterData2"/>
    <Total Name="Total_Credit" Expression="IIf([bShowMainAcc] ==  &quot;1&quot;  ,   IIf( [Acc_TrialBalance_Report.Level]  == 0 ,  [Acc_TrialBalance_Report.Credit] , 0 )   ,  [Acc_TrialBalance_Report.Credit] )" Evaluator="MasterData2"/>
    <Total Name="Total_1-0-BalCredit" Expression="IIf( [bShowMainAcc] ==&quot;1&quot;,IIf( [Acc_TrialBalance_Report.Level] == 0,[Acc_TrialBalance_Report.BalCredit] , 0 ),[Acc_TrialBalance_Report.BalCredit])" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total_PrevBalDebit+BalDebit" 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" PrintOn="ReportSummary2"/>
    <Total Name="Total_PrevDebit+Debit" Expression="IIf( [bShowMainAcc]==&quot;1&quot; , IIf([Acc_TrialBalance_Report.Level]==0, [Acc_TrialBalance_Report.Debit]+[Acc_TrialBalance_Report.PrevDebit],0) , [Acc_TrialBalance_Report.Debit]+[Acc_TrialBalance_Report.PrevDebit])" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total_PrevBalCredit+BalCredit" 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" PrintOn="ReportSummary2"/>
    <Total Name="Total_1-0-PrevBalCredit+BalCredit" 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="Total_1-0-PrevCredit+Credit" Expression="IIf([bShowMainAcc]==&quot;1&quot; , IIf([Acc_TrialBalance_Report.Level]==0,[Acc_TrialBalance_Report.Credit]+[Acc_TrialBalance_Report.PrevCredit],0) , [Acc_TrialBalance_Report.Credit]  +[Acc_TrialBalance_Report.PrevCredit])" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total" 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" PrintOn="ReportSummary2"/>
    <Total Name="TotalBalCredit1" Expression="IIf( [Acc_TrialBalance_Report.Level]  == 0 ,    [Acc_TrialBalance_Report.BalCredit]  ,0)" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="TotalBalDebit1" Expression="IIf( [Acc_TrialBalance_Report.Level]  == 0 ,  [Acc_TrialBalance_Report.BalDebit]  ,0)" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="TotalBalCredit2" Expression=" IIf( [Acc_TrialBalance_Report.Level]  == 0 ,  [Acc_TrialBalance_Report.BalCredit]  ,0)" Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="TotalBalDebit2" Expression=" IIf( [Acc_TrialBalance_Report.Level]  == 0 ,  [Acc_TrialBalance_Report.BalDebit]  ,0) " Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total12" Expression="   IIf([bShowMainAcc] ==   &quot;1&quot;  ,   IIf( [Acc_TrialBalance_Report.Level]  == 0 ,  [Acc_TrialBalance_Report.Credit] , 0 )   ,  [Acc_TrialBalance_Report.Credit] )  " Evaluator="MasterData2" PrintOn="ReportSummary2"/>
    <Total Name="Total133" Expression="IIf( [Acc_TrialBalance_Report.Level]  == 0 ,  [Acc_TrialBalance_Report.BalCredit] , 0 ) " Evaluator="MasterData2"/>
  </Dictionary>
  <ReportPage Name="Page1" LeftMargin="5" RightMargin="5" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle2" Width="756" Height="159.39">
      <TextObject Name="Memo7" Left="64.25" Top="102.28" Width="627.4" Height="30.24" Text="ميزان المراجعة مع رصيد سابق" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 16pt, style=Bold"/>
      <TextObject Name="Memo18" Left="657.16" 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="580.71" Top="134.18" Width="79.37" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo26" Left="526.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="460.31" Top="134.18" Width="71.81" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt, style=Bold"/>
      <PictureObject Name="Company_Logo1" Left="4.77" Top="13.23" Width="746.47" Height="85.04" Fill.Color="White" ImageLocation="C:\Program Files (x86)\Almanara Business Solutions\Bin\Res\Logo.bmp" SizeMode="CenterImage" ImageFormat="Bmp"/>
      <TextObject Name="Memo58" Left="111.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="-3.22" 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, style=Bold"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader2" Top="163.39" Width="756" Height="32.13" CanGrow="true" CanShrink="true">
      <TextObject Name="Memo38" Left="716.4" Top="3.78" Width="37.8" Height="28.35" 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="599.23" Top="3.78" Width="117.17" Height="28.35" 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="504.74" Top="3.78" Width="94.49" Height="28.35" 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="AccOCredit" Left="410.25" Top="3.78" Width="94.49" Height="28.35" 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="Memo42" Left="321.86" Top="3.78" Width="88.39" Height="28.35" 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="Memo43" Left="223.87" Top="3.78" Width="97.99" Height="28.35" 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="112.37" Top="3.78" Width="111.5" Height="28.35" 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, 9pt, style=Bold"/>
      <TextObject Name="Memo45" Left="10.32" Top="3.78" Width="102.05" Height="28.35" 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, 9pt, style=Bold"/>
    </PageHeaderBand>
    <DataBand Name="MasterData2" Top="199.52" Width="756" Height="18.9" CanGrow="true" CanShrink="true" BeforePrintEvent="MasterData2_BeforePrint" DataSource="Acc_TrialBalance_Report">
      <TextObject Name="AccBCredit2" Left="223.87" Width="97.99" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[IIf([bRepTypeBalanceBalanced] == &quot;1&quot; ,IIf([Acc_TrialBalance_Report.BalDebit] - [Acc_TrialBalance_Report.BalCredit] &gt; 0,0, [Acc_TrialBalance_Report.BalCredit]-[Acc_TrialBalance_Report.BalDebit]),IIf([bRepTypeTotaly] == &quot;1&quot; , [Acc_TrialBalance_Report.Credit] ,IIf([bRepTypeBalance]  == &quot;1&quot; , [Acc_TrialBalance_Report.BalCredit],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="AccBDebit2" Left="321.86" Width="88.39" Height="18.9" Border.Lines="Top, Bottom" GrowToBottom="true" Text="[IIf([bRepTypeBalanceBalanced] == &quot;1&quot; ,IIf([Acc_TrialBalance_Report.BalDebit] -[Acc_TrialBalance_Report.BalCredit] &lt; 0,0,  [Acc_TrialBalance_Report.BalDebit]-[Acc_TrialBalance_Report.BalCredit]),IIf([bRepTypeTotaly] == &quot;1&quot; ,[Acc_TrialBalance_Report.Debit] ,IIf([bRepTypeBalance] == &quot;1&quot; ,[Acc_TrialBalance_Report.BalDebit],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="10.32" Width="102.05" 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="112.37" Width="111.5" 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="410.25" Width="94.49" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;,[Acc_TrialBalance_Report.PrevBalCredit],IIf([bBalType]==&quot;1&quot;, [Acc_TrialBalance_Report.PrevCredit] ,IIf([Acc_TrialBalance_Report.PrevDebit]==0,IIf([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit] &gt;0,0,Abs([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit])),&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="AccODebit2" Left="504.74" Width="94.49" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;,[Acc_TrialBalance_Report.PrevBalDebit], IIf([bBalType]==&quot;1&quot;, [Acc_TrialBalance_Report.PrevDebit], IIf([bBalType]==&quot;0&quot;,IIf([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit] &lt;0,0,[Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit]),&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="AccName2" Left="599.23" Width="117.17" 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="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="AccNum2" Left="716.4" Width="37.8" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary2" Top="222.42" Width="756" Height="19.06" CanGrow="true" CanShrink="true" CanBreak="true">
      <TextObject Name="Memo19" Left="593.55" Width="160.65" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" CanGrow="true" GrowToBottom="true" Text="الإجمالي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo20" Left="504.74" Width="94.49" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;, [Total_PrevBalDebit],IIf([bBalType]==&quot;1&quot;,[Total_PrevDebit] ,IIf([bBalType]==&quot;0&quot;,[Total_PrevDebit-PrevCredit],&quot;&quot;)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo22" Left="410.25" Width="94.49" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;, [Total_PrevBalCredit],IIf([bBalType]==&quot;1&quot;, [Total_PrevCredit] ,IIf([bBalType]==&quot;0&quot;, [Total_PrevDebitC],&quot;&quot;)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo23" Left="321.86" Width="88.39" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Text="[IIf( [bRepTypeBalanceBalanced] == &quot;1&quot; ,  IIf( [bShowMainAcc] == &quot;1&quot; ,    IIf(   [Total_BalDebit] - [Total_BalCredit] &gt; 0 , [Total_BalDebit] -  [Total_BalCredit] ,  0 )   , IIf(   [TotalBalDebit] -  [TotalBalCredit]  &gt; 0 , [TotalBalDebit] -  [TotalBalCredit] ,  0 ) ) , IIf( [bRepTypeTotaly] ==&quot;1&quot; ,  [Total_Debit], IIf([bRepTypeBalance] == &quot;1&quot; ,[TotalBalDebit] , 0)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo55" Left="223.87" Width="97.99" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Text="[IIf([bRepTypeBalanceBalanced] == &quot;1&quot; ,IIf( [bShowMainAcc] == &quot;1&quot;,IIf([TotalBalCredit1] - [TotalBalDebit1] &gt; 0 ,[TotalBalCredit2]-[TotalBalDebit2],0),IIf( ([TotalBalCredit]- [TotalBalDebit] ) &gt; 0 ,[TotalBalCredit]- [TotalBalDebit] ,  0 )) ,IIf( [bRepTypeTotaly] == &quot;1&quot; ,[Total12],IIf([bRepTypeBalance] == &quot;1&quot;,[Total133],0)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo56" Left="112.37" Width="111.5" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;,[Total_PrevBalDebit+BalDebit],IIf([bBalType]==&quot;1&quot;, [Total_PrevDebit+Debit],IIf([bBalType]==&quot;0&quot;,[Total_PrevBalCredit+BalCredit],&quot;&quot;)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo57" Left="10.32" Width="102.05" Height="18.9" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Text="[IIf([bBalType]==&quot;2&quot;, [Total_1-0-PrevBalCredit+BalCredit],IIf([bBalType]==&quot;1&quot;,   [Total_1-0-PrevCredit+Credit],IIf([bBalType]==&quot;0&quot;,[Total],&quot;&quot;)))]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" Font="Times New Roman, 10pt"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter2" Top="245.48" Width="756" Height="56.19">
      <TextObject Name="Memo32" Left="648.32" Top="2" 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="77.81" Top="6" Width="83.15" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo34" Left="0.56" Top="6" Width="75.59" Height="15.12" Text="Printed on:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo35" Left="163.52" Top="4" Width="41.57" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo36" Left="215.32" Top="6" Width="56.69" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo37" Left="600.47" Top="31.51" Width="153.04" Height="24.68" Border.Lines="All" Border.Color="White" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>
