﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="03/20/2023 10:36:59" ReportInfo.Modified="10/11/2024 08:01:17" 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)
    {
       
      Memo21.AllowExpressions = false;
      Memo20.AllowExpressions = false;
      Memo28.AllowExpressions = false;
      Memo22.AllowExpressions = false;
      
      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 total = 0;
        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;

         
        while(ds.HasMoreRows)// do
        {
          
          total = total +   ((Double)Report.GetColumnValue(&quot;CalcVat_Report.Total&quot;)); 
          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(); 
        }
   
        
        Memo21.AllowExpressions = true;
        Memo20.AllowExpressions = true;
        Memo28.AllowExpressions = true;
        Memo22.AllowExpressions = true;
         Memo23.AllowExpressions = true;
         Memo25.AllowExpressions = true;
         Memo26.AllowExpressions = true;
        Text1.AllowExpressions = true;
        Text5.AllowExpressions = true;
        Text7.Text = FormatNumber((total1-total2),2);
         Text12.Text = FormatNumber((vat1-vat2),2);
        Text13.Text =   FormatNumber((tax21-tax22),2);
         Text14.Text =   FormatNumber((tax31-tax32),2);
        Memo30.Text =   FormatNumber((disc1-disc2),2);
         Memo31.Text =   FormatNumber((extra1-extra2),2);
         Memo37.Text =   FormatNumber((billNet1-billNet2),2);
        Memo39.Text =    FormatNumber((total*0.05),2);
         Memo29.Text =    FormatNumber((total*0.1),2);
      }
    } }
  
}
/*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+B4rNRswSLFy96CK27twewF1MnembQToWHKgqnVvqTZXQLDfw==" 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}' , '{D8BFE2E8-1A94-47ea-8C54-AAA686EEB9E1}' , '{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}' , '{D8BFE2E8-1A94-47ea-8C54-AAA686EEB9E1}' , '{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="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"/>
    <Relation Name="mnrBillType_CalcVat_Report" ParentDataSource="mnrBillType" ChildDataSource="CalcVat_Report" ParentColumns="ID" ChildColumns="BType" 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" 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="162.52">
      <TextObject Name="Memo2" Left="170.15" Top="120.62" 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="999.72" Top="142.08" Width="81.26" 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="925.13" 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="857.99" 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="Memo6" Left="791.85" 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="66.15" 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="1063.98" Height="105.83" Fill.Color="White" ImageLocation="C:\Program Files (x86)\Almanara Business Solutions\Bin\Res\Logo.bmp" SizeMode="StretchImage" ImageFormat="Bmp"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="166.52" Width="1092.42" CanGrow="true" CanShrink="true"/>
    <DataBand Name="MasterData1" Top="206.85" Width="1092.42" Height="22.68" CanGrow="true" CanShrink="true" CanBreak="true" DataSource="CalcVat_Report" KeepTogether="true">
      <TextObject Name="Memo19" Left="1054.6" 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="Memo21" Left="873.56" Width="100.16" 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, 8pt"/>
      <TextObject Name="Memo22" Left="752.67" Width="71.81" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[IIf([CollectType]==&quot;0&quot;,[CalcVat_Report.BCustName] ,&quot; &quot;)]" Padding="2, 1, 2, 1" AllowExpressions="false" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo23" Left="671.44" Width="81.23" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[CalcVat_Report.Total]" Padding="2, 1, 2, 1" AllowExpressions="false" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" AutoShrink="FontWidth" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo24" Left="593.77" Width="77.67" Height="22.68" Border.Lines="All" Fill.Color="White" 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="Memo25" Left="239.63" Width="81.26" 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="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo26" Left="158.37" Width="81.26" Height="22.68" Border.Lines="All" 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="Center" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo27" Left="74.46" Width="83.91" Height="22.68" Border.Lines="All" Fill.Color="White" 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="Memo42" Left="824.48" 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="Memo28" Width="74.46" Height="22.68" Border.Lines="All" Fill.Color="White" CanGrow="true" GrowToBottom="true" CanBreak="false" Text="[CalcVat_Report.Notes]   [IIf( ([CalcVat_Report.bTTC] == 1)  || ([CalcVat_Report.Flag] == 1)  || ([CalcVat_Report.bVat] == 1)  , IIf( [CalcVat_Report.Notes] == &quot;&quot; , &quot;&quot; , &quot; - &quot; )  + &quot;  خاضع للضريبة&quot; ,  &quot;&quot; )]" 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="Text1" Left="379.66" Width="58.77" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[[CalcVat_Report.Total]*0.05]" 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="Text5" Left="320.89" Width="58.77" Height="22.68" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[[CalcVat_Report.Total]*0.09975]" 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="Memo20" Left="973.72" Width="80.88" 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="Text8" Left="516.1" Width="77.67" Height="22.68" Border.Lines="All" Fill.Color="White" 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="Text10" Left="438.43" Width="77.67" Height="22.68" Border.Lines="All" Fill.Color="White" 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"/>
      <DataHeaderBand Name="Header1" Top="170.52" Width="1092.42" Height="32.33" CanGrow="true" CanShrink="true">
        <TextObject Name="Memo10" Left="1054.6" Top="0.2" Width="33.96" Height="32.13" 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="Memo12" Left="873.56" Top="0.2" Width="100.16" Height="32.13" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="الفاتورة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 9pt, style=Bold"/>
        <TextObject Name="Memo13" Left="752.67" Top="0.2" Width="71.81" Height="32.13" 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="671.44" Top="0.2" Width="81.23" Height="32.13" 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="593.77" Top="0.2" Width="77.67" Height="32.13" 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="239.63" Top="0.2" Width="81.26" Height="32.13" 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="158.37" Top="0.2" Width="81.26" Height="32.13" 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="74.46" Top="0.2" Width="83.91" Height="32.13" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="صافي الفاتورة" Padding="2, 1, 2, 1" AutoShrink="FontWidth" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 9pt, style=Bold"/>
        <TextObject Name="Memo43" Left="824.48" Top="0.2" Width="49.08" Height="32.13" 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" Top="0.2" Width="74.46" Height="32.13" 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="Text3" Left="379.66" Top="0.2" Width="58.77" Height="32.13" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="QC TPS&#13;&#10; 5%" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Text4" Left="320.89" Top="0.2" Width="58.77" Height="32.13" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Text="QC TVQ &#13;&#10;9.975%" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
        <TextObject Name="Memo11" Left="973.72" Top="0.2" Width="80.88" Height="32.13" 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="Text9" Left="516.1" Width="77.67" Height="32.13" 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="Text11" Left="438.43" Width="77.67" Height="32.13" 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"/>
      </DataHeaderBand>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary1" Top="233.53" Width="1092.42" Height="22.68">
      <TextObject Name="Memo29" Left="320.89" Width="58.77" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo30" Left="239.63" Width="81.26" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo31" Left="158.37" Width="81.26" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo37" Left="74.46" Width="83.91" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" AutoShrink="FontWidth" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo39" Left="379.66" Width="58.77" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Memo38" Left="747.52" Width="341.04" 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, 11pt, style=Bold"/>
      <TextObject Name="Text6" Width="74.46" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Text7" Left="671.44" Width="81.23" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Text12" Left="590.21" Width="81.23" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Text13" Left="512.54" Width="81.23" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
      <TextObject Name="Text14" Left="438.43" Width="77.67" Height="22.68" Border.Lines="All" Fill.Color="186, 211, 254" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="260.21" Width="1092.42" Height="43.25">
      <TextObject Name="Memo9" Left="1011.84" 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="904.34" Top="22.57" Width="181.42" 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>
