﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="05/06/2023 10:46:48" ReportInfo.Modified="10/11/2024 08:01:56" 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;CollectOnVatPercent&quot;))==&quot;1&quot;)
      {
        Page1.Visible = false;
        MessageBox.Show( &quot;يجب الغاء زر تفعيل النسبة الضريبية&quot;);
      }
      
      else if  (((String)Report.GetParameterValue(&quot;CollectType&quot;)) ==&quot;1&quot; ||((String)Report.GetParameterValue(&quot;ShowSummeryReport&quot;))==&quot;1&quot; ){              
        Page1.Visible = false;
        MessageBox.Show( &quot;There is no report...!&quot;);
      }
      else {
        
        DataSourceBase ds = Report.GetDataSource(&quot;CalcVat_Report&quot;); 
        ds.Init();
        TimeSpan ts = new TimeSpan();
        DateTime dt = new DateTime();
        double vat2=0;double vat1=0; double total =0; double total2=0; 
        double billnet1=0;
        double billnet2=0;
        double vat =0;
        double vat3 = 0;
        double disc1 = 0;
        double disc2 = 0;
        double extra1=0;
        double extra2 = 0;
        
 
        while(ds.HasMoreRows)// do
        {
          
          
          
          if( ((Double)Report.GetColumnValue(&quot;CalcVat_Report.bInOut&quot;)) == -1)
          {
            extra1 = extra1 +   ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Extras&quot;));
             disc1 = disc1 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Discount&quot;));
             vat = vat +  ((Double)Report.GetColumnValue(&quot;CalcVat_Report.VAT&quot;)) ;
              vat1 = vat1 +  ((Double)Report.GetColumnValue(&quot;CalcVat_Report.VAT2&quot;)) ;
              billnet1 = billnet1 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.BillNet&quot;)) + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.VAT2&quot;));
            total = total +       ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Total&quot;));
          }
            
            if( ((Double)Report.GetColumnValue(&quot;CalcVat_Report.bInOut&quot;)) == 1)
            {
             extra2 = extra2 +   ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Extras&quot;));
              disc2 = disc2 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Discount&quot;));
              vat3 = vat3 +  ((Double)Report.GetColumnValue(&quot;CalcVat_Report.VAT&quot;)) ;
              vat2 = vat2 +    ((Double)Report.GetColumnValue(&quot;CalcVat_Report.VAT2&quot;)) ;
                billnet2 = billnet2 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.BillNet&quot;)) +   ((Double)Report.GetColumnValue(&quot;CalcVat_Report.VAT2&quot;));
            total2 = total2 +  ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Total&quot;));
             }
          ds.Next(); 
        }
   
        dt = dt+ ts;
         
         Memo39.Text  = ToString(FormatNumber(total-total2,2));
         Memo33.Text = ToString(FormatNumber( vat2- vat1,2));
           Memo37.Text = ToString(FormatNumber(billnet2- billnet1,2) );
           Memo29.Text =  FormatNumber(vat- vat3,2);
        Memo30.Text = FormatNumber (disc1-disc2,2);
         Memo31.Text = FormatNumber (extra1-extra2,2);
         Memo40.AllowExpressions =true;
          Memo42.AllowExpressions =true;
         Memo22.AllowExpressions =true;
        Memo24.AllowExpressions =true;
         Memo25.AllowExpressions =true;
         Memo26.AllowExpressions =true;
        Memo27.AllowExpressions =true;
         Memo28.AllowExpressions =true;  
          Memo23.AllowExpressions =true;
           Memo20.AllowExpressions =true;
         Memo21.AllowExpressions =true;
        
      }
    }
  }
}
</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+B4rNRswSLFy96CK27twewF1Mne8Sj/kmvoU0DtcDW2DjPXLg==" CommandTimeout="1200">
      <TableDataSource Name="CalcVat_Report" DataType="System.Int32" Enabled="true" TableName="CalcVat_Report" SelectCommand="exec mnrRepCalcVat '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '' , '{00000000-0000-0000-0000-000000000000}' , '{723D74AF-E6E0-4b76-8F47-7817CEE40439}' , '{8DD84EF1-89BA-4673-8A9F-44DC7375BCDD}' , '12-31-2023' , '10-11-2024' , '' , '' , 0 , 0 , 0 , 1 , 1 , 0 , 0 , 0">
        <Column Name="VAT" DataType="System.Double"/>
        <Column Name="BillNet" DataType="System.Double"/>
        <Column Name="bInOut" DataType="System.Double"/>
        <Column Name="bTTC" DataType="System.Double"/>
        <Column Name="BillQty" DataType="System.Double"/>
        <Column Name="Tax2" DataType="System.Double"/>
        <Column Name="Tax3" DataType="System.Double"/>
        <Column Name="BName" DataType="System.String"/>
        <Column Name="BLatinName" DataType="System.String"/>
        <Column Name="BNumber" DataType="System.Double"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="BDate" DataType="System.DateTime"/>
        <Column Name="billType" DataType="System.Double"/>
        <Column Name="bVat" DataType="System.Int32"/>
        <Column Name="Tax2Ratio" DataType="System.String"/>
        <Column Name="Tax3Ratio" DataType="System.String"/>
        <Column Name="BID" DataType="System.Guid"/>
        <Column Name="BType" DataType="System.Guid"/>
        <Column Name="BSalesManID" DataType="System.Guid"/>
        <Column Name="BSalesManCode" DataType="System.String"/>
        <Column Name="BSalesManName" DataType="System.String"/>
        <Column Name="BSalesManLatinName" DataType="System.String"/>
        <Column Name="BCostJobID" DataType="System.Guid"/>
        <Column Name="BCostJobCode" DataType="System.String"/>
        <Column Name="BCostJobName" DataType="System.String"/>
        <Column Name="BCostJobLatinName" DataType="System.String"/>
        <Column Name="BAccID" DataType="System.Guid"/>
        <Column Name="BCustID" DataType="System.Guid"/>
        <Column Name="BCustName" DataType="System.String"/>
        <Column Name="BCustLatinName" DataType="System.String"/>
        <Column Name="BVendor" DataType="System.String"/>
        <Column Name="Total" DataType="System.Double"/>
        <Column Name="VatAffectedTotal" DataType="System.Double"/>
        <Column Name="Discount" DataType="System.Double"/>
        <Column Name="Extras" DataType="System.Double"/>
        <Column Name="TotalNotAffectedByVat" DataType="System.Double"/>
        <Column Name="DiscAffectVat" DataType="System.Double"/>
        <Column Name="DiscNotAffectVat" DataType="System.Double"/>
        <Column Name="ExtraAffectVat" DataType="System.Double"/>
        <Column Name="ExtraNotAffectVat" DataType="System.Double"/>
        <Column Name="Vat2" DataType="System.Double"/>
        <Column Name="Flag" DataType="System.Int32"/>
        <Column Name="TaxNum" DataType="System.String"/>
        <Column Name="InvoiceNum" DataType="System.String"/>
        <Column Name="EntityName" DataType="System.String"/>
        <Column Name="TaxRatio" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="Totals" DataType="System.Int32" Enabled="true" TableName="Totals" SelectCommand="exec mnrRepCalcVat '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '' , '{00000000-0000-0000-0000-000000000000}' , '{723D74AF-E6E0-4b76-8F47-7817CEE40439}' , '{8DD84EF1-89BA-4673-8A9F-44DC7375BCDD}' , '12-31-2023' , '10-11-2024' , '' , '' , 0 , 0 , 0 , 1 , 1 , 0 , 1 , 0">
        <Column Name="BName" DataType="System.String"/>
        <Column Name="BLatinName" DataType="System.String"/>
        <Column Name="VAT" DataType="System.Double"/>
        <Column Name="BillNet" DataType="System.Double"/>
        <Column Name="bTTC" DataType="System.Double"/>
        <Column Name="bInOut" DataType="System.Double"/>
        <Column Name="BillType" DataType="System.Double"/>
        <Column Name="Tax2" DataType="System.Double"/>
        <Column Name="Tax3" DataType="System.Double"/>
        <Column Name="BType" DataType="System.Guid"/>
        <Column Name="Total" DataType="System.Double"/>
        <Column Name="Discount" DataType="System.Double"/>
        <Column Name="Extras" DataType="System.Double"/>
        <Column Name="VatAffectedTotal" DataType="System.Double"/>
        <Column Name="TotalNotAffectedByVat" DataType="System.Double"/>
        <Column Name="TotalBillQty" DataType="System.Double"/>
        <Column Name="TotalDiscAffectVat" DataType="System.Double"/>
        <Column Name="TotalDiscNotAffectVat" DataType="System.Double"/>
        <Column Name="TotalExtraAffectVat" DataType="System.Double"/>
        <Column Name="TotalExtraNotAffectVat" DataType="System.Double"/>
      </TableDataSource>
      <TableDataSource Name="mnrBill" DataType="System.Int32" Enabled="true" TableName="mnrBill">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Double"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="AccCustID" DataType="System.Guid"/>
        <Column Name="AccCustName" DataType="System.String"/>
        <Column Name="PayType" DataType="System.Int32"/>
        <Column Name="AccAccountID" DataType="System.Guid"/>
        <Column Name="CurrencyID" DataType="System.Guid"/>
        <Column Name="CurrencyVal" DataType="System.Double"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="Total" DataType="System.Double"/>
        <Column Name="TotalItem" DataType="System.Double"/>
        <Column Name="TotalExtra" DataType="System.Double"/>
        <Column Name="TotalDisc" DataType="System.Double"/>
        <Column Name="ItemsExtra" DataType="System.Double"/>
        <Column Name="ItemsDisc" DataType="System.Double"/>
        <Column Name="Profits" DataType="System.Double"/>
        <Column Name="Status" DataType="System.Int32"/>
        <Column Name="StoreID" DataType="System.Guid"/>
        <Column Name="CostJobID" DataType="System.Guid"/>
        <Column Name="BillTypeID" DataType="System.Guid"/>
        <Column Name="BranchID" DataType="System.Guid"/>
        <Column Name="SalesmanID" DataType="System.Guid"/>
        <Column Name="Vendor" DataType="System.String"/>
        <Column Name="UserID" DataType="System.Guid"/>
        <Column Name="IsPosted" DataType="System.Int32"/>
        <Column Name="VAT" DataType="System.Double"/>
        <Column Name="Class" DataType="System.String"/>
        <Column Name="str1" DataType="System.String"/>
        <Column Name="str2" DataType="System.String"/>
        <Column Name="str3" DataType="System.String"/>
        <Column Name="str4" DataType="System.String"/>
        <Column Name="str5" DataType="System.String"/>
        <Column Name="str6" DataType="System.String"/>
        <Column Name="Date1" DataType="System.DateTime"/>
        <Column Name="Date2" DataType="System.DateTime"/>
        <Column Name="Date3" DataType="System.DateTime"/>
        <Column Name="LinkID" DataType="System.Guid"/>
        <Column Name="TermType" DataType="System.Int32"/>
        <Column Name="TermCnt" DataType="System.Int32"/>
        <Column Name="IsPrinted" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="TimeIn" DataType="System.DateTime"/>
        <Column Name="ParentID" DataType="System.Guid"/>
        <Column Name="ParentType" DataType="System.Int32"/>
        <Column Name="InsuranceID" DataType="System.Guid"/>
        <Column Name="InsurCardNum" DataType="System.String"/>
        <Column Name="InsurExpDate" DataType="System.DateTime"/>
        <Column Name="InsurRate" DataType="System.Double"/>
        <Column Name="InsurMaxVal" DataType="System.Double"/>
        <Column Name="InsurClass" DataType="System.String"/>
        <Column Name="InsurNetwork" DataType="System.String"/>
        <Column Name="InsurNotes" DataType="System.String"/>
        <Column Name="TotalPaid" DataType="System.Double"/>
        <Column Name="bCheck" DataType="System.Int32"/>
        <Column Name="ItemsDisc1" DataType="System.Double"/>
        <Column Name="ItemsDisc2" DataType="System.Double"/>
        <Column Name="EFaturaNumber" DataType="System.String"/>
        <Column Name="EmailSent" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="EBillType" DataType="System.Int32"/>
        <Column Name="CustID" DataType="System.Guid"/>
        <Column Name="Tax2" DataType="System.Double"/>
        <Column Name="Tax3" DataType="System.Double"/>
        <Column Name="BillOrigin" DataType="System.String"/>
      </TableDataSource>
      <TableDataSource Name="mnrCust" DataType="System.Int32" Enabled="true" TableName="mnrCust">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Int32"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="LatinName" DataType="System.String"/>
        <Column Name="PriceType" DataType="System.Int32"/>
        <Column Name="DiscRate" DataType="System.Double"/>
        <Column Name="Barcode" DataType="System.String"/>
        <Column Name="Prefix" DataType="System.String"/>
        <Column Name="Suffix" DataType="System.String"/>
        <Column Name="Country" DataType="System.String"/>
        <Column Name="City" DataType="System.String"/>
        <Column Name="Area" DataType="System.String"/>
        <Column Name="Street" DataType="System.String"/>
        <Column Name="Nationality" DataType="System.String"/>
        <Column Name="PoBox" DataType="System.String"/>
        <Column Name="MailBox" DataType="System.String"/>
        <Column Name="Phone1" DataType="System.String"/>
        <Column Name="Phone2" DataType="System.String"/>
        <Column Name="Mobile" DataType="System.String"/>
        <Column Name="Fax" DataType="System.String"/>
        <Column Name="Telex" DataType="System.String"/>
        <Column Name="Email" DataType="System.String"/>
        <Column Name="WebPage" DataType="System.String"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="TermType" DataType="System.Int32"/>
        <Column Name="TermCnt" DataType="System.Int32"/>
        <Column Name="SalesmanID" DataType="System.Guid"/>
        <Column Name="Inactive" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="Hold" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="VATAccID" DataType="System.Guid"/>
        <Column Name="Longitude" DataType="System.Double"/>
        <Column Name="Latitude" DataType="System.Double"/>
        <Column Name="CurrentPoint" DataType="System.Double"/>
        <Column Name="BeginPoint" DataType="System.Double"/>
        <Column Name="TaxNum" DataType="System.String"/>
        <Column Name="ClassID" DataType="System.Guid"/>
        <Column Name="Type" DataType="System.Int32"/>
        <Column Name="ActivityType" DataType="System.Int32"/>
        <Column Name="TaxCode" DataType="System.String"/>
        <Column Name="IdentityNum" DataType="System.String"/>
        <Column Name="PassportNum" DataType="System.String"/>
        <Column Name="ResidenceNum" DataType="System.String"/>
        <Column Name="RegistrationNum" DataType="System.String"/>
        <Column Name="License1" DataType="System.String"/>
        <Column Name="License2" DataType="System.String"/>
        <Column Name="License3" DataType="System.String"/>
        <Column Name="CreatedAt" DataType="System.DateTime"/>
        <Column Name="UpdatedAt" DataType="System.DateTime"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Relation Name="mnrBill_CalcVat_Report" ParentDataSource="mnrBill" ChildDataSource="CalcVat_Report" ParentColumns="ID" ChildColumns="BID" Enabled="true"/>
    <Relation Name="mnrCust_CalcVat_Report" ParentDataSource="mnrCust" ChildDataSource="CalcVat_Report" ParentColumns="ID" ChildColumns="BCustID" Enabled="true"/>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{6CCA4800-C4E7-4c35-A2D8-FC4F74F6199B}&quot;"/>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;31/12/2023&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;11/10/2024&quot;"/>
    <Parameter Name="CollectType" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowBillWithoutVat" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowSummeryReport" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowUNPostedBill" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="ShowPostedBill" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="Currency" DataType="System.String" Expression="&quot;����� ������&quot;"/>
    <Parameter Name="CurrName" DataType="System.String" Expression="&quot;ليرة سورية&quot;"/>
    <Parameter Name="SeparateBillNumber" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="SortBy" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowBillQty" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="CurrencyID" DataType="System.String" Expression="&quot;{8DD84EF1-89BA-4673-8A9F-44DC7375BCDD}&quot;"/>
    <Parameter Name="CostJobID" DataType="System.String" Expression="&quot;{00000000-0000-0000-0000-000000000000}&quot;"/>
    <Parameter Name="SaleManID" DataType="System.String" Expression="&quot;{00000000-0000-0000-0000-000000000000}&quot;"/>
    <Parameter Name="CustID" DataType="System.String" Expression="&quot;{00000000-0000-0000-0000-000000000000}&quot;"/>
    <Parameter Name="AccID" DataType="System.String" Expression="&quot;{00000000-0000-0000-0000-000000000000}&quot;"/>
    <Parameter Name="CollectOnVatPercent" DataType="System.String" Expression="&quot;0&quot;"/>
  </Dictionary>
  <ReportPage Name="Page1" LeftMargin="4" TopMargin="4" RightMargin="4" BottomMargin="4" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="763.56" Height="181.42">
      <TextObject Name="Memo2" Left="5.67" Top="111.17" Width="752.13" Height="26.46" Text=" ضريبة القيمة المضافة تفصيلي مع الضريبة الانتقائية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <TextObject Name="Memo3" Left="697.32" Top="160.98" Width="62.36" Height="18.9" Text="اعتباراً من:" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo4" Left="613.28" Top="160.98" Width="75.59" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo5" Left="555.59" Top="160.98" Width="56.7" Height="18.9" Text=":ولغاية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo6" Left="480" Top="160.98" Width="75.59" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo7" Left="166.3" Top="160.98" Width="56.7" Height="18.9" Text=":العملة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo8" Top="160.98" Width="166.3" Height="18.9" Text=" [CurrName] " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <PictureObject Name="Company_Logo" Left="5.67" Top="3.78" Width="752.13" Height="105.83" Fill.Color="White" ImageLocation="C:\Program Files (x86)\Almanara Business Solutions\Bin\Res\Logo.bmp" SizeMode="CenterImage" ImageFormat="Bmp"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="185.42" Width="763.56" CanGrow="true" CanShrink="true"/>
    <DataBand Name="MasterData1" Top="216.1" Width="763.56" Height="22.68" CanGrow="true" CanShrink="true" DataSource="CalcVat_Report">
      <TextObject Name="Memo19" Left="725.88" Width="33.96" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt, style=Bold"/>
      <TextObject Name="Memo20" Left="654.45" Width="71.43" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="White" GrowToBottom="true" Text="[IIf([CollectType]==&quot;0&quot;,[CalcVat_Report.BDate],&quot; &quot;)]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Date" Format.Format="d" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <TextObject Name="Memo21" Left="582.89" Width="71.81" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[CalcVat_Report.BName] - [CalcVat_Report.BNumber]" Padding="2, 1, 2, 1" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 9pt">
        <Formats>
          <GeneralFormat/>
          <GeneralFormat/>
        </Formats>
      </TextObject>
      <TextObject Name="Memo22" Left="462" Width="71.81" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[IIf([CollectType]==&quot;0&quot;,[CalcVat_Report.BCustName] ,&quot; &quot;)]" Padding="2, 1, 2, 1" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <TextObject Name="Memo24" Left="193.54" Width="64.44" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[CalcVat_Report.VAT]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <TextObject Name="Memo25" Left="140.63" Width="52.91" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[CalcVat_Report.Discount]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <TextObject Name="Memo26" Left="72.6" Width="68.03" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="White" GrowToBottom="true" Text="[CalcVat_Report.Extras]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <TextObject Name="Memo27" Left="0.03" Width="72.57" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[[CalcVat_Report.BillNet] + [CalcVat_Report.Vat2]]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <TextObject Name="Memo40" Left="390.19" Width="71.81" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[IIf([CollectType]==&quot;0&quot;, [CalcVat_Report.mnrCust.TaxNum],&quot; &quot;)]" Padding="2, 1, 2, 1" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <TextObject Name="Memo42" Left="533.81" Width="49.08" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[IIf( [CalcVat_Report.mnrBill.PayType]==1,&quot;آجل&quot;,&quot;نقدي&quot;)]" Padding="2, 1, 2, 1" AllowExpressions="false" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <TextObject Name="Memo28" Left="257.98" Width="71.77" Height="22.68" Border.Lines="Left, Top, Bottom" Fill.Color="White" GrowToBottom="true" Text="[CalcVat_Report.Vat2]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <TextObject Name="Memo23" Left="329.75" Width="60.44" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[CalcVat_Report.Total]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 9pt"/>
      <DataHeaderBand Name="Header1" Top="189.42" Width="763.56" Height="22.68">
        <TextObject Name="Memo10" Left="725.88" Width="33.96" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الرقم" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo11" Left="654.7" Width="71.18" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" GrowToBottom="true" Text="تاريخ الفاتورة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo12" Left="582.89" Width="71.81" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الفاتورة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo13" Left="462" Width="71.81" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الزبون" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo14" Left="329.75" Width="60.44" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="القيمة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo15" Left="193.54" Width="64.44" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="قيمة الضريبة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo16" Left="140.63" Width="52.91" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الحسميات" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo17" Left="72.6" Width="68.03" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الإضافات" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo18" Left="0.03" Width="72.57" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="صافي الفاتورة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo41" Left="390.19" Width="71.81" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الرقم الضريبي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo43" Left="533.81" Width="49.08" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="النوع" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo32" Left="257.98" Width="71.77" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الضريبة الانتقائية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      </DataHeaderBand>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary1" Top="242.78" Width="763.56" Height="22.68" CanGrow="true">
      <TextObject Name="Memo29" Left="193.54" Width="64.44" Height="22.68" Border.Lines="Left, Top, Bottom" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold"/>
      <TextObject Name="Memo30" Left="140.63" Width="52.91" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold"/>
      <TextObject Name="Memo31" Left="72.6" Width="68.03" Height="22.68" Border.Lines="Top, Bottom" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold"/>
      <TextObject Name="Memo37" Left="0.03" Width="72.57" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold"/>
      <TextObject Name="Memo39" Left="329.75" Width="60.44" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold"/>
      <TextObject Name="Memo38" Left="390.66" Width="369.18" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Text="المجموع النهائي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo33" Left="257.98" Width="71.77" Height="22.68" Border.Lines="Left, Top, Bottom" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 7pt, style=Bold"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="269.46" Width="763.56" Height="40.02">
      <TextObject Name="Memo9" Left="684.09" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo140" Left="63.03" Top="3.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="Memo141" Left="3.78" Top="3.78" Width="56.69" Height="15.12" Text="Printed on:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo142" Left="152.52" Top="3.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="Memo143" Left="194.99" Top="3.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="Memo1" Left="610.39" Top="21.12" Width="153.07" Height="18.9" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>
