﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="05/22/2023 17:08:30" ReportInfo.Modified="10/11/2024 07:59:37" 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;يجب إلغاء تفعيل خيار تجميع الفواتير حسب النوع&quot;);

      }
      else {
        
      DataSourceBase ds = Report.GetDataSource(&quot;CalcVat_Report&quot;); 
        ds.Init();    
        double  total1=0;
        double total2=0;double vat1=0; double vat2=0; 
        double disc1=0; double disc2=0;
        double extra1=0; double extra2=0;
        double billNet1=0; double billNet2=0;
        double tax21=0;double tax22=0;
        double tax31=0;double tax32=0;

          GroupHeader1.Condition = &quot;[CalcVat_Report.BName]&quot;;
        while(ds.HasMoreRows)// do
        {
          if( ((Double)Report.GetColumnValue(&quot;CalcVat_Report.bInOut&quot;)) ==-1){
           total1  = total1 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Total&quot;));
            vat1 = vat1 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.VAT&quot;));
            disc1 = disc1 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Discount&quot;));
            extra1 = extra1 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Extras&quot;));
            billNet1 = billNet1 +  ((Double)Report.GetColumnValue(&quot;CalcVat_Report.BillNet&quot;));
            tax21 = tax21 +  ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Tax2&quot;));
            tax31 = ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Tax3&quot;));   
            
          }
          else if (  ((Double)Report.GetColumnValue(&quot;CalcVat_Report.bInOut&quot;))==1){
            total2 = total2 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Total&quot;));
            vat2 = vat2 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.VAT&quot;));
            disc2 = disc2 + ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Discount&quot;));
            extra2 = extra2+ ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Extras&quot;));
            billNet2 = billNet2 +  ((Double)Report.GetColumnValue(&quot;CalcVat_Report.BillNet&quot;));
            tax22 =    ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Tax2&quot;));
            tax32 = ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Tax3&quot;));
          }   
          ds.Next(); 
        }   
        
         Memo39.Text= FormatNumber((total1-total2),2);
         Memo29.Text= FormatNumber((vat1-vat2),2);
        Text6.Text =  FormatNumber((tax21-tax22),2);
         Text7.Text =  FormatNumber((tax31-tax32),2);
        Memo30.Text =  FormatNumber((disc1-disc2),2);
          Memo37.Text =  FormatNumber((extra1-extra2),2); 
             Memo23.AllowExpressions = true; 
         Memo25.AllowExpressions = true; 
        Memo26.AllowExpressions = true; 
       Memo20.AllowExpressions = true;
        Memo21.AllowExpressions = true;
        Memo22.AllowExpressions = true;
        Memo78.AllowExpressions = true;
        Memo48.AllowExpressions = true;
        Text17.AllowExpressions = true; 
        Text16.AllowExpressions = true;  
        Memo50.AllowExpressions = true;     
        Memo65.AllowExpressions = true;
        Memo63.AllowExpressions = true;    
      }
    }
  }
}
/*void Page1OnBeforePrint(TfrxComponent Sender)
{
     if  (&lt;CollectType&gt; ==1){              
   Page1.Visible = false;
    ShowMessage( &quot;يجب إلغاء تفعيل خيار تجميع الفواتير حسب النوع&quot;);

   }
           
      
}


{
}    
*/</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+B4rNRswSLFy96CK27twewF1MneILOTUs9+uCDqt+PiVbH+Ig==" 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}' , '{163A7FF1-BD54-4659-BA32-2587B501613C}' , '{8DD84EF1-89BA-4673-8A9F-44DC7375BCDD}' , '12-31-2023' , '10-11-2024' , '' , '' , 0 , 0 , 0 , 1 , 1 , 0 , 0 , 0">
        <Column Name="BillNet" DataType="System.Double"/>
        <Column Name="BillQty" DataType="System.Double"/>
        <Column Name="bInOut" DataType="System.Double"/>
        <Column Name="bTTC" DataType="System.Double"/>
        <Column Name="Tax2" DataType="System.Double"/>
        <Column Name="Tax3" DataType="System.Double"/>
        <Column Name="VAT" 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}' , '{163A7FF1-BD54-4659-BA32-2587B501613C}' , '{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="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"/>
      </TableDataSource>
      <TableDataSource Name="mnrBillType" DataType="System.Int32" Enabled="true" TableName="mnrBillType">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="Number" DataType="System.Int32"/>
        <Column Name="Code" DataType="System.String"/>
        <Column Name="Name" DataType="System.String"/>
        <Column Name="LatinName" DataType="System.String"/>
        <Column Name="Type" DataType="System.Int32"/>
        <Column Name="bInOut" DataType="System.Int32"/>
        <Column Name="DefPayType" DataType="System.Int32"/>
        <Column Name="Color1" DataType="System.Int32"/>
        <Column Name="Color2" DataType="System.Int32"/>
        <Column Name="bAffectCostPrice" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bDiscAffectCost" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bExtraAffectCost" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bAffectProfit" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bDiscAffectProfit" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bExtraAffectProfit" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bAffectLastPrice" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bAffectCustPrice" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bNoEntry" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bAutoEntry" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bAutoEntryPost" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bContInv" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bNoPost" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bAutoPost" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bShortEntry" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bNoCostFld" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bNoAccFld" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bNoStoreFld" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bNoSellManFld" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bNoBranchFld" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bBarcodeFld" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="FldMat" DataType="System.Int32"/>
        <Column Name="FldBarCode" DataType="System.Int32"/>
        <Column Name="FldNotes" DataType="System.Int32"/>
        <Column Name="FldPrice" DataType="System.Int32"/>
        <Column Name="FldTotalPrice" DataType="System.Int32"/>
        <Column Name="FldStore" DataType="System.Int32"/>
        <Column Name="FldCost" DataType="System.Int32"/>
        <Column Name="FldDiscValue" DataType="System.Int32"/>
        <Column Name="FldExtraValue" DataType="System.Int32"/>
        <Column Name="FldDiscRatio" DataType="System.Int32"/>
        <Column Name="FldExtraRatio" DataType="System.Int32"/>
        <Column Name="FldQty" DataType="System.Int32"/>
        <Column Name="FldQty2" DataType="System.Int32"/>
        <Column Name="FldQty3" DataType="System.Int32"/>
        <Column Name="FldQty4" DataType="System.Int32"/>
        <Column Name="FldQty5" DataType="System.Int32"/>
        <Column Name="FldUnit" DataType="System.Int32"/>
        <Column Name="FldBonus1" DataType="System.Int32"/>
        <Column Name="FldBonus2" DataType="System.Int32"/>
        <Column Name="FldBonus3" DataType="System.Int32"/>
        <Column Name="FldBonus4" DataType="System.Int32"/>
        <Column Name="FldBonus5" DataType="System.Int32"/>
        <Column Name="FldProdDate" DataType="System.Int32"/>
        <Column Name="FldExpireDate" DataType="System.Int32"/>
        <Column Name="FldSellMan" DataType="System.Int32"/>
        <Column Name="FldCostItem" DataType="System.Int32"/>
        <Column Name="FldLength" DataType="System.Int32"/>
        <Column Name="FldWidth" DataType="System.Int32"/>
        <Column Name="FldHigh" DataType="System.Int32"/>
        <Column Name="DefMatAccID" DataType="System.Guid"/>
        <Column Name="DefAccID" DataType="System.Guid"/>
        <Column Name="DefDiscAccID" DataType="System.Guid"/>
        <Column Name="DefExtraAccID" DataType="System.Guid"/>
        <Column Name="DefCostAccID" DataType="System.Guid"/>
        <Column Name="DefStoreAccID" DataType="System.Guid"/>
        <Column Name="DefBonusAccID" DataType="System.Guid"/>
        <Column Name="DefBonusContraAccID" DataType="System.Guid"/>
        <Column Name="DefPriceType" DataType="System.Int32"/>
        <Column Name="DefCostPriceType" DataType="System.Int32"/>
        <Column Name="DefBonusPriceType" DataType="System.Int32"/>
        <Column Name="DefStoreID" DataType="System.Guid"/>
        <Column Name="DefCostJobID" DataType="System.Guid"/>
        <Column Name="DefSellManID" DataType="System.Guid"/>
        <Column Name="DefBranchID" DataType="System.Guid"/>
        <Column Name="bVAT" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="DefVATAccID" DataType="System.Guid"/>
        <Column Name="FldClass" DataType="System.Int32"/>
        <Column Name="FldVAT" DataType="System.Int32"/>
        <Column Name="FldVendor" DataType="System.Int32"/>
        <Column Name="TransID" DataType="System.Guid"/>
        <Column Name="bPayTerm" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="TermType" DataType="System.Int32"/>
        <Column Name="TermCnt" DataType="System.Int32"/>
        <Column Name="MenuName" DataType="System.String"/>
        <Column Name="MenuLatinName" DataType="System.String"/>
        <Column Name="bUseSMS" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bCash" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bForceCostJob" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bForceSalesman" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="FldCnt" DataType="System.Int32"/>
        <Column Name="smsMsg" DataType="System.String"/>
        <Column Name="smsLatinMsg" DataType="System.String"/>
        <Column Name="bsmsAdd" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bsmsUpdate" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bsmsDelete" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="DefCurID" DataType="System.Guid"/>
        <Column Name="bCostJobToCust" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bCostJobToItem" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bTotalQtyFld" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="CFldMask" DataType="System.Int64"/>
        <Column Name="bUseInsurance" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bTTC" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="FldStatus" DataType="System.Int32"/>
        <Column Name="bNoPayTypeFld" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="FldProvideDate" DataType="System.Int32"/>
        <Column Name="bExtraVAT" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bDiscVAT" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="bUseCheck" DataType="System.Boolean" BindableControl="CheckBox"/>
        <Column Name="FldDisc1Value" DataType="System.Int32"/>
        <Column Name="FldDisc2Value" DataType="System.Int32"/>
      </TableDataSource>
      <TableDataSource Name="mnrLogFile" DataType="System.Int32" Enabled="true" TableName="mnrLogFile">
        <Column Name="ID" DataType="System.Guid"/>
        <Column Name="UserID" DataType="System.Guid"/>
        <Column Name="DID" DataType="System.Int32"/>
        <Column Name="LogTime" DataType="System.DateTime"/>
        <Column Name="Computer" DataType="System.String"/>
        <Column Name="SysUser" DataType="System.String"/>
        <Column Name="Type" DataType="System.Int32"/>
        <Column Name="SubType" DataType="System.Int32"/>
        <Column Name="RecID" DataType="System.Guid"/>
        <Column Name="RecNum" DataType="System.String"/>
        <Column Name="RecTypeID" DataType="System.Guid"/>
        <Column Name="FromDate" DataType="System.DateTime"/>
        <Column Name="ToDate" DataType="System.DateTime"/>
        <Column Name="CustID" DataType="System.Guid"/>
        <Column Name="AccID" DataType="System.Guid"/>
        <Column Name="GrpID" DataType="System.Guid"/>
        <Column Name="MatID" DataType="System.Guid"/>
        <Column Name="CostID" DataType="System.Guid"/>
        <Column Name="SellManID" DataType="System.Guid"/>
        <Column Name="StoreID" DataType="System.Guid"/>
        <Column Name="Notes" DataType="System.String"/>
        <Column Name="Guid1" DataType="System.Guid"/>
        <Column Name="Guid2" DataType="System.Guid"/>
        <Column Name="Guid3" DataType="System.Guid"/>
        <Column Name="Guid4" DataType="System.Guid"/>
        <Column Name="Str1" DataType="System.String"/>
        <Column Name="Str2" DataType="System.String"/>
        <Column Name="Str3" DataType="System.String"/>
        <Column Name="Str4" DataType="System.String"/>
      </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"/>
      </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="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" Landscape="true" PaperWidth="297" PaperHeight="210" RawPaperSize="9" LeftMargin="4" TopMargin="4" RightMargin="4" BottomMargin="4" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="1092.42" Height="192.78">
      <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="142.08" 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="622.73" Top="142.08" 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="565.04" Top="142.08" Width="66.15" Height="18.9" Text=":ولغاية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo6" Left="498.9" Top="142.08" 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="142.08" 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="142.08" 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="StretchImage" ImageFormat="Bmp"/>
      <TextObject Name="Memo12" Left="876.82" Top="170.1" Width="90.71" 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="235.71" Top="170.1" Width="96.38" 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="129.88" Top="170.1" Width="105.83" 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="19.51" Top="170.1" Width="110.37" 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="Memo14" Left="582.11" Top="170.1" Width="83.11" 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="967.53" Top="170.1" Width="71.18" 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="737.03" Top="170.1" Width="90.71" 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="665.22" Top="170.1" 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="Memo43" Left="827.74" Top="170.1" 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="Memo15" Left="489.32" Top="170.1" Width="92.79" 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="Text2" Left="405.98" Top="170.1" Width="83.34" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="ضريبة 2" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Text4" Left="332.09" Top="170.1" Width="73.89" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="ضريبة 3" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo10" Left="1038.71" Top="170.1" 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"/>
    </ReportTitleBand>
    <GroupHeaderBand Name="GroupHeader1" Top="196.78" Width="1092.42" Condition="[Totals.VAT]">
      <DataBand Name="MasterData1" Top="200.78" Width="1092.42" Height="22.68" CanGrow="true" CanShrink="true" DataSource="CalcVat_Report">
        <TextObject Name="Memo25" Left="235.71" Width="96.38" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[CalcVat_Report.Discount]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo26" Left="129.88" Width="105.83" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[CalcVat_Report.Extras]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo27" Left="19.51" Width="110.37" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[CalcVat_Report.BillNet]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo23" Left="582.11" Width="83.11" 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="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo19" Left="1038.96" Width="33.96" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo20" Left="967.53" Width="71.43" Height="22.68" Border.Lines="All" 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="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo21" Left="876.82" Width="90.71" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[CalcVat_Report.BNumber]-[CalcVat_Report.BName]" Padding="2, 1, 2, 1" AllowExpressions="false" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo22" Left="737.03" Width="90.71" Height="22.68" Border.Lines="All" 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" RightToLeft="true" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo40" Left="665.22" Width="71.81" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[IIf([CollectType]==&quot;0&quot;,[CalcVat_Report.mnrCust.TaxNum] ,&quot; &quot;)]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo42" Left="827.74" Width="49.08" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[IIf([CalcVat_Report.mnrBill.PayType]==1,&quot;آجل&quot;,&quot;نقدي&quot;)]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Memo24" Left="489.32" Width="92.79" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[CalcVat_Report.VAT]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Text1" Left="405.98" Width="83.34" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[CalcVat_Report.Tax2]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
        <TextObject Name="Text3" Left="332.09" Width="73.89" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" Text="[CalcVat_Report.Tax3]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
      </DataBand>
      <GroupFooterBand Name="GroupFooter1" Top="227.46" Width="1092.42"/>
    </GroupHeaderBand>
    <ReportSummaryBand Name="ReportSummary1" Top="231.46" Width="1092.42" Height="32.13">
      <SubreportObject Name="Subreport2" Left="18.93" Width="295.56" Height="22.68" Border.Lines="All" Fill.Color="Silver" ReportPage="Page3"/>
      <ChildBand Name="Child1" Top="267.59" Width="1092.42" Height="35.13">
        <TextObject Name="Memo31" Left="129.88" Top="3" Width="105.83" Height="22.68" Border.Lines="All" Fill.Color="DarkRed" GrowToBottom="true" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="White"/>
        <TextObject Name="Memo29" Left="489.32" Top="3" Width="92.79" Height="22.68" Border.Lines="All" Fill.Color="DarkRed" GrowToBottom="true" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="White"/>
        <TextObject Name="Memo30" Left="235.71" Top="3" Width="96.38" Height="22.68" Border.Lines="All" Fill.Color="DarkRed" GrowToBottom="true" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="White"/>
        <TextObject Name="Memo37" Left="19.51" Top="3" Width="110.37" Height="22.68" Border.Lines="All" Fill.Color="DarkRed" GrowToBottom="true" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="White"/>
        <TextObject Name="Memo39" Left="582.11" Top="3" Width="83.11" Height="22.68" Border.Lines="Left, Top, Bottom" Fill.Color="DarkRed" GrowToBottom="true" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="White"/>
        <TextObject Name="Memo38" Left="665.22" Top="3" Width="407.19" Height="22.68" Border.Lines="All" Fill.Color="DarkRed" GrowToBottom="true" Text="المجموع النهائي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="White"/>
        <TextObject Name="Text6" Left="405.98" Top="3" Width="83.34" Height="22.68" Border.Lines="All" Fill.Color="DarkRed" GrowToBottom="true" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="White"/>
        <TextObject Name="Text7" Left="332.09" Top="3" Width="73.89" Height="22.68" Border.Lines="All" Fill.Color="DarkRed" GrowToBottom="true" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="White"/>
      </ChildBand>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="306.72" Width="1092.42" Height="49.47">
      <TextObject Name="Memo9" Left="999.72" Top="3.78" 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="30.24" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo143" Left="185.54" 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="912.79" Top="30.57" Width="162.52" 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>
  <ReportPage Name="Page3" Landscape="true" PaperWidth="297" PaperHeight="210" RawPaperSize="9" LeftMargin="4" TopMargin="4" RightMargin="4" BottomMargin="4" Watermark.Font="Arial, 60pt">
    <GroupHeaderBand Name="GroupHeader2" Width="1092.42" Condition="[Totals.BName]" KeepTogether="true">
      <DataBand Name="MasterData3" Top="4" Width="1092.42" DataSource="Totals"/>
      <GroupFooterBand Name="GroupFooter2" Top="8" Width="1092.42" Height="22.68">
        <TextObject Name="Memo48" Left="469.81" Width="92.79" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="[Totals.VAT]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo50" Left="216.2" Width="96.38" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="[Totals.Discount]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo63" Left="110.37" Width="105.83" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="[Totals.Extras]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo65" Width="110.37" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="[Totals.BillNet]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo78" Left="562.6" Width="83.11" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="[Totals.Total]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo77" Left="645.71" Width="407.19" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="[Totals.BName]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
        <TextObject Name="Text16" Left="312.58" Width="73.89" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" CanGrow="true" Text="[Totals.Tax3]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Text17" Left="386.47" Width="83.34" Height="22.68" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" CanGrow="true" GrowToBottom="true" Text="[Totals.Tax2]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      </GroupFooterBand>
    </GroupHeaderBand>
  </ReportPage>
</Report>
