﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="10/01/2022 10:58:18" ReportInfo.Modified="11/01/2022 09:48:11" 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 ReportOnStartReport(TfrxComponent Sender)
{                     
  if((&lt;OldBalance&gt; != &quot;1&quot;))  
  {
    ShowMessage( &quot;يجب تفعيل خيار الرصيد السابق&quot;);
    TfrxReport( Sender).Terminated = true;
  }
  else if((&lt;bRepTypeBalanceBalanced&gt; == 0) &amp;&amp; (&lt;bRepTypeTotaly&gt; == 0) &amp;&amp; (&lt;bRepTypeBalance&gt; == 0))
}        
{
}
*/</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBi552QMfN68eCaxvzwiCxxzbgJkOfJy1Qc+Nbcc3HQer8qTWWB42iHe9wQ6KV9n94zES5wsJXOUBDDqF5w4GqMZicvw7RzuFSAOV6oJEXfwY43rW83fKAFO7tf9X8Cmb/3enk4Ijmr0GBQ1BanmPO/UHaKEHONoLE9Lrzyxa3Bi9aDPSh2XobN7B2AJCOwCQVgagRgo8uwCArYvtCyQ11srbbXXfqpfLl2W5VTUWTbjRTck9TSN4sX6BrRb/XrQR31vKnk6e8HWXyvil62W/DhxEDEIUhJM5jdOXPVKCNPTl+0JbhRDBiEXDdnYlcWbDzeKmN/XvWF34BYMkCLbW+7+m8IcAGy3A32ZpFNRc91hXfVtYIFMA5HqsQlx+3TeLU7JMxWwtu5QsyJmltmW37VbP9cbhm5D/pgxxTAtXkJPSm9v8qNwSnYl7jvvUiBP9CdIslOpitxa5DcrP5Vx71XLjXBPUsD60M5dfKDWYKsg4prQ29mgFx5qdVe4WStlif1L/AJWGh37xeQQV9mLI8tUWEPRfLoGfOeiOn2FVvvD4F2nMeS0nrf+vdZIN0ZhFza">
      <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}' , '{F1EDCF0E-0590-4bb5-8F8E-0968BAD58563}' , '{E61ACA59-4B49-4f3b-B724-856787E1D754}' , 1 , '1-1-1999' , '11-1-2022' , '' , '' , 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/1999&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;01/11/2022&quot;"/>
    <Parameter Name="OldBalance" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{5F6A475B-4C02-4e8f-8B04-70BEE61C7CDA}&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([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;)))" Evaluator="MasterData2"/>
    <Total Name="Total1" Expression="IIf([bBalType]==&quot;2&quot;,[Acc_TrialBalance_Report.PrevBalCredit], IIf([bBalType]==&quot;1&quot;, [Acc_TrialBalance_Report.PrevCredit] , IIf([bBalType]==&quot;0&quot;,IIf([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit] &gt;0,0,Abs([Acc_TrialBalance_Report.PrevDebit]-[Acc_TrialBalance_Report.PrevCredit])),&quot;&quot;)))" Evaluator="MasterData2"/>
    <Total Name="Total2" Expression="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;  )))" Evaluator="MasterData2"/>
    <Total Name="Total3" Expression="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;  )))" Evaluator="MasterData2"/>
    <Total Name="Total4" Expression="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;  )))" Evaluator="MasterData2"/>
  </Dictionary>
  <ReportPage Name="Page1" LeftMargin="5" RightMargin="5" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle2" Width="756" Height="132.29">
      <TextObject Name="Memo2" Left="22.68" Top="3.78" Width="714.33" Height="34.02" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Memo3" Left="18.9" Top="37.8" Width="718.11" Height="26.46" Text="ميزان مراجعة الأستاذ العام" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 12pt, style=Bold"/>
      <LineObject Name="Line1" Left="18.9" Top="105.83" Width="718.11" Diagonal="true"/>
      <TextObject Name="Memo4" Left="642.52" Top="113.39" Width="94.49" Height="18.9" Text="مركز تكلفة" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo5" Left="480" Top="113.39" Width="94.49" Height="18.9" Text="من فترة" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo6" Left="294.8" Top="113.39" Width="79.37" Height="18.9" Text="الى فترة" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo7" Left="90.71" Top="113.39" Width="90.71" Height="18.9" Text="الميزانية" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Arial, 10pt, style=Bold"/>
      <TextObject Name="Memo25" Left="400.63" Top="113.39" Width="79.37" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo27" Left="222.99" Top="113.39" Width="71.81" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt, style=Bold"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader2" Top="136.29" Width="756" Height="25.02" CanGrow="true" CanShrink="true">
      <TextObject Name="Memo39" Left="519.8" Top="3.78" Width="188.98" Height="18.9" Border.Lines="All" Fill.Color="204, 204, 204" GrowToBottom="true" Text="اسم" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo40" Left="391.29" Top="3.78" Width="128.5" Height="18.9" Border.Lines="All" Fill.Color="204, 204, 204" GrowToBottom="true" Text="رصيد ماقبله" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
      <TextObject Name="Memo44" Left="5.78" Top="3.78" Width="128.5" Height="18.9" Border.Lines="All" Fill.Color="204, 204, 204" GrowToBottom="true" Text="رصيد أخر الفترة " Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Blue"/>
      <TextObject Name="Memo41" Left="708.77" Top="3.78" Width="41.57" Height="18.9" Border.Lines="All" Fill.Color="204, 204, 204" GrowToBottom="true" Text="كود" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo42" Left="262.79" Top="3.78" Width="128.5" Height="18.9" Border.Lines="All" Fill.Color="204, 204, 204" GrowToBottom="true" Text="حركة مدينة " Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="0, 193, 0"/>
      <TextObject Name="Memo43" Left="134.28" Top="3.78" Width="128.5" Height="18.9" Border.Lines="All" Fill.Color="204, 204, 204" GrowToBottom="true" Text="حركة دائنة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Purple"/>
    </PageHeaderBand>
    <DataBand Name="MasterData2" Top="165.31" Width="756" Height="18.9" CanGrow="true" CanShrink="true" DataSource="Acc_TrialBalance_Report">
      <TextObject Name="AccFDebit2" Left="5.78" Width="128.5" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[[Total3] -[Total4]]&#13;&#10;&#13;&#10;" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt" TextFill.Color="Blue"/>
      <TextObject Name="AccODebit2" Left="391.29" Width="128.5" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[[Total]-[Total1]]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt" TextFill.Color="Red"/>
      <TextObject Name="AccName2" Left="519.8" Width="188.98" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[[Acc_TrialBalance_Report.AccCode]]-[[Acc_TrialBalance_Report.AccName]]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="AccCode2" Left="708.77" Width="41.57" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[Acc_TrialBalance_Report.AccCode]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="AccBCredit2" Left="134.28" Width="128.5" Height="18.9" Border.Lines="All" 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" TextFill.Color="Purple"/>
      <TextObject Name="AccBDebit2" Left="262.79" Width="128.5" Height="18.9" Border.Lines="All" 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" TextFill.Color="0, 193, 0"/>
    </DataBand>
    <PageFooterBand Name="PageFooter2" Top="188.21" 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="Memo37" Left="581.57" Top="31.51" Width="143.59" 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>
