﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="08/09/2022 12:12:25" ReportInfo.Modified="05/24/2023 15:52:34" 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;ShowAccAge&quot;)) == &quot;1&quot;)
      {
      MessageBox.Show( &quot;الرجاء اختيار تصميم آخر&quot;);

      Report.Abort();
    }             
  else    
  {
   if(((String)Report.GetParameterValue(&quot;ShowAccAge&quot;)) == &quot;0&quot;)            
     {
         
      if((Convert.ToString(((Guid)Report.GetColumnValue(&quot;Acc_Statement_Report.AccID&quot;))) == ((String)Report.GetParameterValue(&quot;Acc&quot;)))||(((String)Report.GetColumnValue(&quot;Acc_Statement_Report.CustName&quot;)) == ((String)Report.GetParameterValue(&quot;Cust&quot;))))                                                               
        {
                       
           Page2.Visible=true;
           Page1.Visible=false ;
                                  
        }
        else
        {          
           Page1.Visible=true;
           Page2.Visible=false;
                   
        }                                           
     }
  }
      
      
    }
  }
}
/*
{

}
*/</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBiHvL1D3R/ZPYDVVa5Loc9UYb7RKhUtpflorZaKqsXCcnyxGxsoOtxmj8O3zAzOr8xulWz9WMrEwbL1fT7FwSnrHlZdnbLlrLvi0Hl5ljEDIDvuLRbkEayLcznNYU2Se6a1MULOn4LRvgaQDqvFNv9KnBlYocPWYbk+mImkhNzwphnAPm19EAMfOWzZIH/gkCgmG5erP07xFYacJU67NRHIa5zRBGhk/MBzkiuHq7BiytJ5ka8BXgUoHesPW/c6F654DdFjb6+SWuh1ESk1bHceqHw+o+11GwleWoTwn3AOa2BkRvuP+nJTeFBtov3c9+cD9sSejpYNsJmExV19R0iu56apnmDTEajBUGmOQKJosPJdV9KPa5PpDz4EFxsFgZFP20cXDBcscHmyy9POamElxU9h978rao3whMFdcC0W/Jjby9rqWpOEia9jA59WdFVWz/B/RDG2uyCVjYU8kBuhPvtvacwAe+QUUdia/QEWzTsCw2a8oOuoGOAfep9XaQ5XPIwFD+MGv16II+hbp5EDTF81HKScMYSBBd/2nH3hZ3kAljfzArmODivZITH2lpq">
      <TableDataSource Name="Acc_Statement_Report" DataType="System.Int32" Enabled="true" TableName="Acc_Statement_Report" SelectCommand="exec mnrPrcRepAccStatement5 '{00000000-0000-0000-0000-000000000000}' , '{68A38CC7-BA57-4c49-BBC9-FB794C8C086A}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '' , '' , '{6C5EBEEB-5D9F-41ff-BB95-104BC4E30DBC}' , '{D435BD3C-9C45-46be-BA4C-18C9425C364E}' , '1-1-2021' , '5-24-2023' , '' , '' ,  6  ,	1  ,  0  ,  1  ,  0  ,  2  ,  0  ,  0  ,  0  ,  0  ,  0  ,  0  ,  0  ,  0  ,  0  ,  0  ,  0  ,  0  , '' , '' , '' ,  0  ,  0  ,  0  , '{00000000-0000-0000-0000-000000000000}','{00000000-0000-0000-0000-000000000000}',0,0,0">
        <Column Name="EID" DataType="System.Guid"/>
        <Column Name="EParentID" DataType="System.Guid"/>
        <Column Name="ETypeID" DataType="System.Guid"/>
        <Column Name="EDate" DataType="System.DateTime"/>
        <Column Name="CustID" DataType="System.Guid"/>
        <Column Name="CustName" DataType="System.String"/>
        <Column Name="CustLatinName" DataType="System.String"/>
        <Column Name="AccID" DataType="System.Guid"/>
        <Column Name="AccCode" DataType="System.String"/>
        <Column Name="AccName" DataType="System.String"/>
        <Column Name="AccLatinName" DataType="System.String"/>
        <Column Name="Debit" DataType="System.Double"/>
        <Column Name="Credit" DataType="System.Double"/>
        <Column Name="DefDebit" DataType="System.Double"/>
        <Column Name="DefCredit" DataType="System.Double"/>
        <Column Name="AccCurrDebit" DataType="System.Double"/>
        <Column Name="AccCurrCredit" DataType="System.Double"/>
        <Column Name="BNID" DataType="System.Guid"/>
        <Column Name="TypeID" DataType="System.Guid"/>
        <Column Name="parentID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Int32"/>
        <Column Name="type" DataType="System.Int32"/>
        <Column Name="State" DataType="System.Int32"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="DueDate" DataType="System.DateTime"/>
        <Column Name="CollectionDate" DataType="System.DateTime"/>
        <Column Name="TypeName" DataType="System.String"/>
        <Column Name="BNLatinName" DataType="System.String"/>
        <Column Name="InOut" DataType="System.Int32"/>
        <Column Name="PayType" DataType="System.Int32"/>
        <Column Name="CurrencyVal" DataType="System.Int32"/>
        <Column Name="MainCurrencyID" DataType="System.Guid"/>
        <Column Name="bItemNum" DataType="System.Int32"/>
        <Column Name="MatID" DataType="System.Guid"/>
        <Column Name="MatCode" DataType="System.String"/>
        <Column Name="MatName" DataType="System.String"/>
        <Column Name="MatLatinName" DataType="System.String"/>
        <Column Name="ContrastAccID" DataType="System.Guid"/>
        <Column Name="ContrastAccCode" DataType="System.String"/>
        <Column Name="ContrastAccName" DataType="System.String"/>
        <Column Name="ContrastAccLName" DataType="System.String"/>
        <Column Name="Unit" DataType="System.String"/>
        <Column Name="ItemQty" DataType="System.Double"/>
        <Column Name="ItemPrice" DataType="System.Double"/>
        <Column Name="Disc" DataType="System.Double"/>
        <Column Name="Extra" DataType="System.Double"/>
        <Column Name="Vat" DataType="System.Double"/>
        <Column Name="BillTotal" DataType="System.Double"/>
        <Column Name="payment" DataType="System.Double"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="flag" DataType="System.Int32"/>
        <Column Name="Balanced" DataType="System.Int32"/>
        <Column Name="RepType" DataType="System.Int32"/>
        <Column Name="ItemOption" DataType="System.Int32"/>
        <Column Name="HasEntry" DataType="System.Int32"/>
        <Column Name="BNAge" DataType="System.Double"/>
        <Column Name="DocType" DataType="System.Int32"/>
        <Column Name="Vendor" DataType="System.String"/>
        <Column Name="HasPayment" DataType="System.Int32"/>
        <Column Name="txt1" DataType="System.String"/>
        <Column Name="txt2" DataType="System.String"/>
        <Column Name="txt3" DataType="System.String"/>
        <Column Name="txt4" DataType="System.String"/>
        <Column Name="txt5" DataType="System.String"/>
        <Column Name="txt6" DataType="System.String"/>
        <Column Name="Date1" DataType="System.DateTime"/>
        <Column Name="Date2" DataType="System.DateTime"/>
        <Column Name="Date3" DataType="System.DateTime"/>
        <Column Name="OpClass" DataType="System.String"/>
        <Column Name="TTC" DataType="System.Int32"/>
      </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;24/5/2023&quot;"/>
    <Parameter Name="Currency" DataType="System.String" Expression="&quot;ليرة تركي&quot;"/>
    <Parameter Name="ShowDiscExtra" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="CurrencyID" DataType="System.String" Expression="&quot;{D435BD3C-9C45-46be-BA4C-18C9425C364E}&quot;"/>
    <Parameter Name="SmName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="StoreName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="Acc" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="Cust" DataType="System.String" Expression="&quot;اب حسان&quot;"/>
    <Parameter Name="CostJob" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="SaleMan" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="Vendor" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="Class" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="CurrName" DataType="System.String" Expression="&quot;ليرة تركي&quot;"/>
    <Parameter Name="PeriodCnt" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="PeriodLen" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowAccAge" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowDueDate" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="BillPayType" DataType="System.String" Expression="&quot;1&quot;"/>
    <Total Name="Total_p1_a_1" Expression="IIf(([Acc_Statement_Report.HasEntry] == 1) || ([Acc_Statement_Report.flag]==1) || ([Acc_Statement_Report.flag]==6),IIf([Acc_Statement_Report.Debit]&gt;0,[Acc_Statement_Report.Debit],IIf(([Acc_Statement_Report.flag]==4) &amp;&amp; ([Acc_Statement_Report.PayType]==0),[Acc_Statement_Report.Credit],0))   ,0)" Evaluator="MasterData2"/>
    <Total Name="Total_p1_a_2" Expression="IIf(([Acc_Statement_Report.HasEntry] == 1) || ([Acc_Statement_Report.flag]==1) || ([Acc_Statement_Report.flag]==6),IIf([Acc_Statement_Report.Credit]&gt;0,[Acc_Statement_Report.Credit],IIf(([Acc_Statement_Report.flag]==4) &amp;&amp; ([Acc_Statement_Report.PayType]==0),[Acc_Statement_Report.Debit],0))   ,0)" Evaluator="MasterData2"/>
    <Total Name="Total_p1_b" Expression="IIf(([Acc_Statement_Report.HasEntry] == 1) || ([Acc_Statement_Report.flag]==1) || ([Acc_Statement_Report.flag]==6),IIf([Acc_Statement_Report.Debit]&gt;0,[Acc_Statement_Report.Debit],IIf(([Acc_Statement_Report.flag]==4) &amp;&amp; ([Acc_Statement_Report.PayType]==0),[Acc_Statement_Report.Credit],0))   ,0)" Evaluator="MasterData2"/>
    <Total Name="Total_p1_c" Expression="IIf(([Acc_Statement_Report.HasEntry] == 1) || ([Acc_Statement_Report.flag]==1) || ([Acc_Statement_Report.flag]==6),IIf([Acc_Statement_Report.Credit]&gt;0,[Acc_Statement_Report.Credit],IIf(([Acc_Statement_Report.flag]==4) &amp;&amp; ([Acc_Statement_Report.PayType]==0),[Acc_Statement_Report.Debit],0))   ,0)" Evaluator="MasterData2"/>
    <Total Name="Total_p1_d_1" Expression="IIf(([Acc_Statement_Report.HasEntry] == 1) || ([Acc_Statement_Report.flag]==1) || ([Acc_Statement_Report.flag]==6),IIf([Acc_Statement_Report.Debit]&gt;0,[Acc_Statement_Report.Debit],IIf(([Acc_Statement_Report.flag]==4) &amp;&amp; ([Acc_Statement_Report.PayType]==0),[Acc_Statement_Report.Credit],0))   ,0)" Evaluator="MasterData2"/>
    <Total Name="Total_p1_d_2" Expression="IIf(([Acc_Statement_Report.HasEntry] == 1) || ([Acc_Statement_Report.flag]==1) || ([Acc_Statement_Report.flag]==6),IIf([Acc_Statement_Report.Credit]&gt;0,[Acc_Statement_Report.Credit],IIf(([Acc_Statement_Report.flag]==4) &amp;&amp; ([Acc_Statement_Report.PayType]==0),[Acc_Statement_Report.Debit],0))   ,0)" Evaluator="MasterData2"/>
    <Total Name="Total_p2_a_1" Expression="IIf([Acc_Statement_Report.PayType] == 1,[Acc_Statement_Report.Debit],null)" Evaluator="Data1"/>
    <Total Name="Total_p2_a_2" Expression="IIf([Acc_Statement_Report.PayType] == 1,[Acc_Statement_Report.Credit],null)" Evaluator="MasterData2"/>
    <Total Name="Total_p2_a_3" Expression="IIf([Acc_Statement_Report.PayType] == 1,[Acc_Statement_Report.Debit],null)" Evaluator="MasterData2"/>
    <Total Name="Total_p2_a_4" Expression="IIf([Acc_Statement_Report.PayType] == 1,[Acc_Statement_Report.Credit],null)" Evaluator="MasterData2"/>
    <Total Name="Total_p2_b" Expression="IIf([Acc_Statement_Report.PayType] ==1,[Acc_Statement_Report.Debit],0)" Evaluator="MasterData2"/>
    <Total Name="Total_p2_c" Expression="IIf([Acc_Statement_Report.PayType] ==1,[Acc_Statement_Report.Credit],0)" Evaluator="MasterData2"/>
  </Dictionary>
  <ReportPage Name="Page1" LeftMargin="3.5" TopMargin="3.5" RightMargin="3.5" BottomMargin="3.5" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="767.34" Height="219.21">
      <TextObject Name="Memo5" Left="-166.3" Top="156.18" Width="1099.84" Height="22.68" Text="كشف حساب زبون" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Memo17" Left="691.72" Top="182.86" Width="66.14" Height="18.9" Text=": إعتبارا من" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo18" Left="601.04" Top="182.86" Width="79.37" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo25" Left="537.77" Top="182.86" Width="51.02" Height="18.9" Text=": ولغاية " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo27" Left="455.74" Top="182.86" Width="79.37" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo1" Left="0.98" Top="182.86" Width="162.52" Height="18.9" Text=" [Currency] " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo2" Left="162.52" Top="182.86" Width="51.02" Height="18.9" Text=": العملة " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <PictureObject Name="Company_Logo" Left="3.78" Top="3.78" Width="755.91" Height="154.96" Fill.Color="White" ImageLocation="D:\almanarasoft\almanaratools\logo.png"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="223.81" Width="767.34" Height="151.2">
      <TextObject Name="Text1" Left="670.95" Top="9.45" Width="85.04" Height="18.9" Text="كشف حساب " Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="LightCoral"/>
      <TextObject Name="Text2" Left="670.95" Top="37.8" Width="85.04" Height="18.9" Text="اسم الحساب" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="LightCoral"/>
      <TextObject Name="Text3" Left="378" Top="9.45" Width="283.49" Height="18.9" Text="[Acc_Statement_Report.CustName]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text4" Left="378" Top="37.8" Width="283.49" Height="18.9" Text="[Acc_Statement_Report.AccCode]-[Acc_Statement_Report.AccName]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TableObject Name="Table1" Top="132.3" Width="765.4" Height="18.9">
        <TableColumn Name="Column24" Width="55.75"/>
        <TableColumn Name="Column25" Width="55.75"/>
        <TableColumn Name="Column26" Width="93.55"/>
        <TableColumn Name="Column27" Width="93.55"/>
        <TableColumn Name="Column28" Width="36.85"/>
        <TableColumn Name="Column29" Width="131.35"/>
        <TableColumn Name="Column30" Width="74.65"/>
        <TableColumn Name="Column31" Width="74.65"/>
        <TableColumn Name="Column32" Width="74.65"/>
        <TableColumn Name="Column33" Width="74.65"/>
        <TableRow Name="Row11">
          <TableCell Name="Cell113" Border.Lines="All" Fill.Color="LightBlue" Text="الحسميات" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell114" Border.Lines="All" Fill.Color="LightBlue" Text="الإضافات" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell115" Border.Lines="All" Fill.Color="LightBlue" Text="الإجمالي" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell116" Border.Lines="All" Fill.Color="LightBlue" Text="السعر" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell117" Border.Lines="All" Fill.Color="LightBlue" Text="الكمية" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell138" Border.Lines="All" Fill.Color="LightBlue" Text="البيان" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell139" Border.Lines="All" Fill.Color="LightBlue" Text="دائن" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell140" Border.Lines="All" Fill.Color="LightBlue" Text="مدين" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell141" Border.Lines="All" Fill.Color="LightBlue" Text="التاريخ" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell142" Border.Lines="All" Fill.Color="LightBlue" Text="رقم المستند" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt, style=Bold"/>
        </TableRow>
      </TableObject>
    </PageHeaderBand>
    <GroupHeaderBand Name="GroupHeader1" Top="379.61" Width="767.34" Condition="[Acc_Statement_Report.CustName]">
      <DataBand Name="MasterData2" Top="384.2" Width="767.34" Height="18.9" DataSource="Acc_Statement_Report">
        <TableObject Name="Table2" Width="765.4" Height="18.9">
          <TableColumn Name="Column34" Width="55.75"/>
          <TableColumn Name="Column35" Width="55.75"/>
          <TableColumn Name="Column36" Width="93.55"/>
          <TableColumn Name="Column37" Width="93.55"/>
          <TableColumn Name="Column38" Width="36.85"/>
          <TableColumn Name="Column39" Width="131.35"/>
          <TableColumn Name="Column40" Width="74.65"/>
          <TableColumn Name="Column41" Width="74.65"/>
          <TableColumn Name="Column42" Width="74.65"/>
          <TableColumn Name="Column43" Width="74.65"/>
          <TableRow Name="Row12">
            <TableCell Name="Cell143" Border.Lines="All" Text="[IIf([Acc_Statement_Report.Disc]== 0,null,(([Acc_Statement_Report.Disc]) *1000)/1000)]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
            <TableCell Name="Cell144" Border.Lines="All" Text="[IIf([Acc_Statement_Report.Extra]== 0,null,[Acc_Statement_Report.Extra])]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
            <TableCell Name="Cell145" Border.Lines="All" Text="[IIf([Acc_Statement_Report.ItemQty]== 0,null,Round([Acc_Statement_Report.ItemQty] * [Acc_Statement_Report.ItemPrice]))]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
            <TableCell Name="Cell146" Border.Lines="All" Text="[IIf([Acc_Statement_Report.ItemPrice] == 0,null,[Acc_Statement_Report.ItemPrice])]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
            <TableCell Name="Cell147" Border.Lines="All" Text="[IIf([Acc_Statement_Report.ItemQty] == 0,null,[Acc_Statement_Report.ItemQty])]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
            <TableCell Name="Cell148" Border.Lines="All" Text="[Acc_Statement_Report.Notes] [IIf([Acc_Statement_Report.ItemOption] == 1, ToString(IIf( [Acc_Statement_Report.Notes]  != &quot;&quot;, &quot; / &quot;  , &quot;&quot;)) + [Acc_Statement_Report.MatName]   ,IIf( ([Acc_Statement_Report.RepType] == -1) &amp;&amp;([Acc_Statement_Report.PayType] == 1) , ToString(IIf(  ([Acc_Statement_Report.Notes]  != &quot;&quot;)  ||  ([Acc_Statement_Report.MatName]  !=  &quot;&quot; ), &quot; / &quot; , &quot;&quot;)) +&quot; الرصيد السابق &quot;,IIf(([Acc_Statement_Report.Extra] &gt; 0) || ([Acc_Statement_Report.Disc] &gt; 0),  &quot; إجمالي الإضافات - الحسميات &quot; +ToString(IIf(  ([Acc_Statement_Report.Notes]  != &quot;&quot;)  ||  ([Acc_Statement_Report.MatName] != &quot;&quot; ) || ([Acc_Statement_Report.RepType] == -1) &amp;&amp;([Acc_Statement_Report.PayType] == 1) , &quot; / &quot; , &quot;&quot;)) ,null)))][IIf([Acc_Statement_Report.flag]==4,IIf([BillPayType]==&quot;1&quot;,  ToString(IIf([Acc_Statement_Report.PayType]==1, &quot; آجل &quot;,&quot; نقدي &quot;))  +ToString(IIf(  ([Acc_Statement_Report.Notes]  != &quot;&quot;)  ||  ([Acc_Statement_Report.MatName] != &quot;&quot; ) || ([Acc_Statement_Report.RepType] == -1) &amp;&amp;([Acc_Statement_Report.PayType] == 1) || ([Acc_Statement_Report.Extra] &gt; 0) || ([Acc_Statement_Report.Disc] &gt; 0)  , &quot; / &quot; , &quot;&quot;)) ,&quot;&quot;),&quot;&quot;)]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
            <TableCell Name="Cell149" Border.Lines="All" Text="[IIf( [Acc_Statement_Report.DocType] == 16 ,   [Acc_Statement_Report.Credit] ,IIf([Acc_Statement_Report.RepType] == -1,IIf(([Acc_Statement_Report.Credit] - [Acc_Statement_Report.Debit] ) &gt;0,[Acc_Statement_Report.Credit] - [Acc_Statement_Report.Debit],null),IIf([Acc_Statement_Report.Credit] == 0,IIf(([Acc_Statement_Report.RepType]==0) &amp;&amp; ([Acc_Statement_Report.MatCode] == &quot;&quot;),IIf([Acc_Statement_Report.PayType]==0,[Acc_Statement_Report.Debit],null),null),[Acc_Statement_Report.Credit])))]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
            <TableCell Name="Cell150" Border.Lines="All" Text="[IIf([Acc_Statement_Report.DocType] == 16 , [Acc_Statement_Report.Debit],IIf([Acc_Statement_Report.RepType] == -1,IIf(([Acc_Statement_Report.Debit] - [Acc_Statement_Report.Credit] ) &gt;0,[Acc_Statement_Report.Debit] - [Acc_Statement_Report.Credit],&quot;&quot;),IIf([Acc_Statement_Report.Debit] == 0,IIf(([Acc_Statement_Report.RepType]== 0) &amp;&amp; ([Acc_Statement_Report.MatCode] == &quot;&quot;),IIf([Acc_Statement_Report.PayType]==0,[Acc_Statement_Report.Credit],&quot;&quot;),&quot;&quot;),[Acc_Statement_Report.Debit])))]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
            <TableCell Name="Cell151" Border.Lines="All" Text="[IIf([Acc_Statement_Report.Number] == 0,null,IIf([Acc_Statement_Report.Date] ==ToDateTime(&quot;1/1/1980&quot;),null,[Acc_Statement_Report.Date]))]" Format="Date" Format.Format="d" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
            <TableCell Name="Cell152" Border.Lines="All" Text="[IIf([Acc_Statement_Report.RepType] == -1,null,IIf([Acc_Statement_Report.RepType] == 2,&quot;سند قيد&quot;,[Acc_Statement_Report.TypeName]))] -  [IIf([Acc_Statement_Report.flag] == 3 , null ,[Acc_Statement_Report.Number])]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
          </TableRow>
        </TableObject>
        <DataFooterBand Name="DataFooter1" Top="407.7" Width="767.34"/>
      </DataBand>
      <GroupFooterBand Name="GroupFooter1" Top="412.3" Width="767.34" CanBreak="true"/>
    </GroupHeaderBand>
    <ReportSummaryBand Name="ReportSummary1" Top="416.9" Width="767.34" Height="114.5" PrintOnBottom="true">
      <TextObject Name="Memo14" Left="581.26" Top="32.66" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="رصيد الحركة" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 11pt, style=Bold"/>
      <TextObject Name="Text5" Left="581.45" Top="54.35" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="المجموع الحالي" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 11pt, style=Bold"/>
      <TextObject Name="Text6" Left="581.45" Top="75.7" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="الرصيد الحالي" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 11pt, style=Bold"/>
      <TextObject Name="Text7" Left="399" Top="32.45" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[[Total_p1_a_1]-[Total_p1_a_2]]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text8" Left="398.9" Top="54.8" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[Total_p1_b]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text9" Left="398.9" Top="76.7" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[[Total_p1_d_1]-[Total_p1_d_2]]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text10" Left="217" Top="32.45" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text11" Left="216.9" Top="54.8" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[Total_p1_c]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text12" Left="216.9" Top="76.7" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="535.99" Width="767.34" Height="45.61">
      <TextObject Name="Memo6" Left="675.48" Top="1.78" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo21" Left="78.15" Top="1.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="Memo28" Left="18.9" Top="1.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="Memo29" Left="167.64" Top="1.78" Width="39.69" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo30" Left="210.1" Top="1.78" Width="56.69" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo24" Left="588.19" Top="27.83" Width="185.17" Height="13.34" Border.Lines="All" Border.Color="White" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
  <ReportPage Name="Page2" RawPaperSize="9" LeftMargin="3.5" TopMargin="3.5" RightMargin="3.5" BottomMargin="3.5" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle2" Width="767.34" Height="240.01">
      <TextObject Name="Text22" Left="-9450" Top="-9297.6" Width="1099.84" Height="22.68" Text="كشف حساب زبون" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Text23" Left="-8591.98" Top="-9270.92" Width="66.14" Height="18.9" Text=": إعتبارا من" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text24" Left="-8682.66" Top="-9270.92" Width="79.37" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text25" Left="-8745.93" Top="-9270.92" Width="51.02" Height="18.9" Text=": ولغاية " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text26" Left="-8827.96" Top="-9270.92" Width="79.37" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text27" Left="-9282.72" Top="-9270.92" Width="162.52" Height="18.9" Text=" [Currency] " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text28" Left="-9121.18" Top="-9270.92" Width="51.02" Height="18.9" Text=": العملة " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <PictureObject Name="Picture1" Left="-9279.92" Top="-9450" Width="755.91" Height="154.96" Fill.Color="White" ImageLocation="D:\almanarasoft\almanaratools\logo.png"/>
      <TextObject Name="Text29" Left="-9450" Top="-9297.6" Width="1099.84" Height="22.68" Text="كشف حساب زبون" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Text30" Left="-8591.98" Top="-9270.92" Width="66.14" Height="18.9" Text=": إعتبارا من" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text31" Left="-8682.66" Top="-9270.92" Width="79.37" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text32" Left="-8745.93" Top="-9270.92" Width="51.02" Height="18.9" Text=": ولغاية " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text33" Left="-8827.96" Top="-9270.92" Width="79.37" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text34" Left="-9282.72" Top="-9270.92" Width="162.52" Height="18.9" Text=" [Currency] " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text35" Left="-9121.18" Top="-9270.92" Width="51.02" Height="18.9" Text=": العملة " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <PictureObject Name="Picture2" Left="-9279.92" Top="-9450" Width="755.91" Height="154.96" Fill.Color="White" ImageLocation="D:\almanarasoft\almanaratools\logo.png"/>
      <PictureObject Name="Picture3" Width="755.91" Height="154.96" Fill.Color="White" ImageLocation="D:\almanarasoft\almanaratools\logo.png"/>
      <TextObject Name="Text36" Left="-189" Top="160.65" Width="1099.84" Height="22.68" Text="كشف حساب زبون" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Text37" Left="179.55" Top="207.9" Width="51.02" Height="18.9" Text=": العملة " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text38" Left="18.9" Top="207.9" Width="162.52" Height="18.9" Text=" [Currency] " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text39" Left="642.6" Top="207.9" Width="66.14" Height="18.9" Text=": إعتبارا من" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text40" Left="557.55" Top="207.9" Width="79.37" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text41" Left="500.85" Top="207.9" Width="51.02" Height="18.9" Text=": ولغاية " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text42" Left="415.8" Top="207.9" Width="79.37" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader2" Top="244.61" Width="767.34" Height="94.5">
      <TextObject Name="Text43" Left="595.35" Top="9.45" Width="85.04" Height="18.9" Text="كشف حساب " Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text44" Left="302.4" Top="9.45" Width="283.49" Height="18.9" Text="[Acc_Statement_Report.CustName]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text45" Left="595.35" Top="37.8" Width="85.04" Height="18.9" Text="اسم الحساب" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text46" Left="302.4" Top="37.8" Width="283.49" Height="18.9" Text="[Acc_Statement_Report.AccCode]-[Acc_Statement_Report.AccName]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TableObject Name="Table3" Top="75.6" Width="765.45" Height="18.9">
        <TableColumn Name="Column44" Width="60.48"/>
        <TableColumn Name="Column45" Width="60.48"/>
        <TableColumn Name="Column46" Width="69.93"/>
        <TableColumn Name="Column47" Width="69.93"/>
        <TableColumn Name="Column48" Width="60.48"/>
        <TableColumn Name="Column49" Width="164.43"/>
        <TableColumn Name="Column50" Width="69.93"/>
        <TableColumn Name="Column51" Width="69.93"/>
        <TableColumn Name="Column52" Width="69.93"/>
        <TableColumn Name="Column53" Width="69.93"/>
        <TableRow Name="Row13">
          <TableCell Name="Cell153" Border.Lines="All" Fill.Color="LightBlue" Text="الحسميات" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell154" Border.Lines="All" Fill.Color="LightBlue" Text="الإضافات" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell155" Border.Lines="All" Fill.Color="LightBlue" Text="الإجمالي" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell156" Border.Lines="All" Fill.Color="LightBlue" Text="السعر" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell157" Border.Lines="All" Fill.Color="LightBlue" Text="الكمية" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell158" Border.Lines="All" Fill.Color="LightBlue" Text="البيان" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell159" Border.Lines="All" Fill.Color="LightBlue" Text="دائن" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell160" Border.Lines="All" Fill.Color="LightBlue" Text="مدين" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell161" Border.Lines="All" Fill.Color="LightBlue" Text="التاريخ" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
          <TableCell Name="Cell162" Border.Lines="All" Fill.Color="LightBlue" Text="رقم المستند" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt, style=Bold"/>
        </TableRow>
      </TableObject>
    </PageHeaderBand>
    <DataBand Name="Data1" Top="343.71" Width="767.34" Height="18.9" DataSource="Acc_Statement_Report">
      <TableObject Name="Table4" Width="765.45" Height="18.9">
        <TableColumn Name="Column54" Width="60.48"/>
        <TableColumn Name="Column55" Width="60.48"/>
        <TableColumn Name="Column56" Width="69.93"/>
        <TableColumn Name="Column57" Width="69.93"/>
        <TableColumn Name="Column58" Width="60.48"/>
        <TableColumn Name="Column59" Width="164.43"/>
        <TableColumn Name="Column60" Width="69.93"/>
        <TableColumn Name="Column61" Width="69.93"/>
        <TableColumn Name="Column62" Width="69.93"/>
        <TableColumn Name="Column63" Width="69.93"/>
        <TableRow Name="Row14">
          <TableCell Name="Cell163" Border.Lines="All" Text="[IIf([Acc_Statement_Report.Disc]== 0,null,(([Acc_Statement_Report.Disc]) *1000)/1000)]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
          <TableCell Name="Cell164" Border.Lines="All" Text="[IIf([Acc_Statement_Report.Extra]== 0,null,[Acc_Statement_Report.Extra])]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
          <TableCell Name="Cell165" Border.Lines="All" Text="[IIf([Acc_Statement_Report.ItemQty]== 0,null,Round([Acc_Statement_Report.ItemQty] * [Acc_Statement_Report.ItemPrice]))]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
          <TableCell Name="Cell166" Border.Lines="All" Text="[IIf([Acc_Statement_Report.ItemPrice] == 0,null,[Acc_Statement_Report.ItemPrice])]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
          <TableCell Name="Cell167" Border.Lines="All" Text="[IIf([Acc_Statement_Report.ItemQty] == 0,null,[Acc_Statement_Report.ItemQty])]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
          <TableCell Name="Cell168" Border.Lines="All" Text="[Acc_Statement_Report.Notes] [IIf([Acc_Statement_Report.ItemOption] == 1, ToString(IIf( [Acc_Statement_Report.Notes]  != &quot;&quot;, &quot; / &quot;  , &quot;&quot;)) + [Acc_Statement_Report.MatName]   ,IIf( ([Acc_Statement_Report.RepType] == -1) &amp;&amp;([Acc_Statement_Report.PayType] == 1) , ToString(IIf(  ([Acc_Statement_Report.Notes]  != &quot;&quot;)  ||  ([Acc_Statement_Report.MatName]  !=  &quot;&quot; ), &quot; / &quot; , &quot;&quot;)) +&quot; الرصيد السابق &quot;,IIf(([Acc_Statement_Report.Extra] &gt; 0) || ([Acc_Statement_Report.Disc] &gt; 0),  &quot; إجمالي الإضافات - الحسميات &quot; +ToString(IIf(  ([Acc_Statement_Report.Notes]  != &quot;&quot;)  ||  ([Acc_Statement_Report.MatName] != &quot;&quot; ) || ([Acc_Statement_Report.RepType] == -1) &amp;&amp;([Acc_Statement_Report.PayType] == 1) , &quot; / &quot; , &quot;&quot;)) ,null)))][IIf([Acc_Statement_Report.flag]==4,IIf([BillPayType]==&quot;1&quot;,  ToString(IIf([Acc_Statement_Report.PayType]==1, &quot; آجل &quot;,&quot; نقدي &quot;))  +ToString(IIf(  ([Acc_Statement_Report.Notes]  != &quot;&quot;)  ||  ([Acc_Statement_Report.MatName] != &quot;&quot; ) || ([Acc_Statement_Report.RepType] == -1) &amp;&amp;([Acc_Statement_Report.PayType] == 1) || ([Acc_Statement_Report.Extra] &gt; 0) || ([Acc_Statement_Report.Disc] &gt; 0)  , &quot; / &quot; , &quot;&quot;)) ,&quot;&quot;),&quot;&quot;)]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
          <TableCell Name="Cell169" Border.Lines="All" Text="[IIf( [Acc_Statement_Report.DocType] == 16 ,   [Acc_Statement_Report.Credit] ,IIf([Acc_Statement_Report.RepType] == -1,IIf(([Acc_Statement_Report.Credit] - [Acc_Statement_Report.Debit] ) &gt;0,[Acc_Statement_Report.Credit] - [Acc_Statement_Report.Debit],null),IIf([Acc_Statement_Report.Credit] == 0,IIf(([Acc_Statement_Report.RepType]==0) &amp;&amp; ([Acc_Statement_Report.MatCode] == &quot;&quot;),IIf([Acc_Statement_Report.PayType]==0,[Acc_Statement_Report.Debit],null),null),[Acc_Statement_Report.Credit])))]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
          <TableCell Name="Cell170" Border.Lines="All" Text="[IIf([Acc_Statement_Report.DocType] == 16 , [Acc_Statement_Report.Debit],IIf([Acc_Statement_Report.RepType] == -1,IIf(([Acc_Statement_Report.Debit] - [Acc_Statement_Report.Credit] ) &gt;0,[Acc_Statement_Report.Debit] - [Acc_Statement_Report.Credit],&quot;&quot;),IIf([Acc_Statement_Report.Debit] == 0,IIf(([Acc_Statement_Report.RepType]== 0) &amp;&amp; ([Acc_Statement_Report.MatCode] == &quot;&quot;),IIf([Acc_Statement_Report.PayType]==0,[Acc_Statement_Report.Credit],&quot;&quot;),&quot;&quot;),[Acc_Statement_Report.Debit])))]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
          <TableCell Name="Cell171" Border.Lines="All" Text="[IIf([Acc_Statement_Report.Number] == 0,null,IIf([Acc_Statement_Report.Date] ==ToDateTime(&quot;1/1/1980&quot;),null,[Acc_Statement_Report.Date]))]" Format="Date" Format.Format="d" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
          <TableCell Name="Cell172" Border.Lines="All" Text="[IIf([Acc_Statement_Report.RepType] == -1,null,IIf([Acc_Statement_Report.RepType] == 2,&quot;سند قيد&quot;,[Acc_Statement_Report.TypeName]))] -  [IIf([Acc_Statement_Report.flag] == 3 , null ,[Acc_Statement_Report.Number])]" AutoShrink="FontSize" HorzAlign="Center" VertAlign="Center" Font="Arial, 11pt"/>
        </TableRow>
      </TableObject>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary2" Top="367.2" Width="767.34" Height="132.3">
      <TextObject Name="Text47" Left="525.01" Top="47.46" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="رصيد الحركة" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text48" Left="525.2" Top="69.15" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="المجموع الحالي" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text50" Left="342.75" Top="47.25" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[IIf([Total_p2_a_1]-[Total_p1_d_2]&lt; 0,null,[Total_p2_a_3]-[Total_p2_a_4])]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text51" Left="342.65" Top="69.6" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[Total_p2_b]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text53" Left="160.75" Top="47.25" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[IIf([Total_p2_a_1]-[Total_p1_d_2]&lt; 0,null,[Total_p2_a_3]-[Total_p2_a_4])]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text54" Left="160.65" Top="69.6" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[Total_p2_c]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text49" Left="525.2" Top="90.5" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="الرصيد الحالي" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text52" Left="342.65" Top="91.95" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[IIf([Total_p2_a_1]-[Total_p1_d_2]&lt; 0,null,[Total_p2_a_3]-[Total_p2_a_4])]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Text55" Left="160.65" Top="91.95" Width="182.58" Height="22" Border.Lines="All" Fill.Color="186, 211, 254" Text="[IIf([Total_p2_a_1]-[Total_p1_d_2]&lt; 0,null,[Total_p2_a_3]-[Total_p2_a_4])]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter2" Top="504.1" Width="767.34" Height="122.85">
      <TextObject Name="Text56" Left="628.23" Top="9.45" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text57" Left="68.7" Top="9.45" 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="Text58" Left="9.45" Top="9.45" 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="Text59" Left="158.19" Top="9.45" Width="39.69" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Text60" Left="200.65" Top="9.45" Width="56.69" Height="15.12" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Text61" Left="540.94" Top="35.5" Width="185.17" Height="13.34" Border.Lines="All" Border.Color="White" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>
