﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" StartReportEvent="_StartReport" ReportInfo.Created="01/16/2023 10:01:45" ReportInfo.Modified="02/14/2023 14:18:06" ReportInfo.CreatorVersion="2021.4.3.0">
  <ScriptText>using System;
using System.Collections;
using System.Collections.Generic;
using System.ComponentModel;
using System.Windows.Forms;
using System.Drawing;
using System.Data;
using FastReport;
using FastReport.Data;
using FastReport.Dialog;
using FastReport.Barcode;
using FastReport.Table;
using FastReport.Utils;

namespace FastReport
{
  public class ReportScript
  {
    void _StartReport(object sender, EventArgs e)
    {
      //Memo34.Visible = false;
      // Memo36.Visible = false;
                                 
      if(Convert.ToInt32((String)Report.GetParameterValue(&quot;DateType&quot;))!= 1)
      {
        GroupHeader1.Visible = false ;
        GroupFooter1.Visible = false ;
        MasterData1.Visible = false ;
        GroupHeader2.Visible = true ;
        GroupFooter2.Visible = true ;
        MasterData2.Visible = true  ;          
        Memo43.Visible = false ;
        Memo42.Visible = false ;
        Memo41.Visible = false ;
        Memo37.Visible = false ;          
        Memo9.Text = &quot;تاريخ الإنتاج&quot; ;                                                
      //  Memo34.DataSet = MatExpireDate_Report;
      //  Memo34.DataField = &quot;Price&quot;;
            
  
        if(Convert.ToInt32((String)Report.GetParameterValue(&quot;ShowPrice&quot;))!= 0)
        {
          Memo10.Visible = true;
          Memo11.Visible = true;
          Memo34.Visible = true;
          Memo36.Visible = true;                   
              
        
        }
        else
        {
          Memo34.Visible = false;
          Memo36.Visible = false;
          Memo10.Visible = false;
          Memo11.Visible = false;                    
        }                 
                                
      }
      else
      {
        GroupHeader2.Visible = false ;
        GroupFooter2.Visible = false ;
        MasterData2.Visible = false  ;
        Memo17.Visible = false ;
        Memo16.Visible = false ;
        Memo15.Visible = false ;
        Memo14.Visible = false ;                   
        Memo9.Text = &quot;تاريخ الصلاحية&quot;;                                                       
       // MatTotalPrice.DataSet = MatExpireDate_Report;
       // MatTotalPrice.DataField = &quot;Price&quot;;
            
        if(Convert.ToInt32((String)Report.GetParameterValue(&quot;ShowPrice&quot;)) != 0)
        {
          Memo10.Visible = true;
          Memo11.Visible = true;
          MatPrice.Visible = true;
          MatTotalPrice.Visible = true;
          Memo52.Visible = true;
          Memo53.Visible = true;                   
        }
        else
        {
          MatTotalPrice.Visible = false;
          MatPrice.Visible = false;                     
          Memo10.Visible = false;
          Memo11.Visible = false;
          Memo52.Visible = false;
          Memo53.Visible = false;                       
        }                 
      }  
   

  }

   
   
  }
}
</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBiLeyYgzGsg8K0w/wV+uVJpRb9DC+IFtFJ1Ya+wGL6sGP+LlGmWCsZftl80X1OZU2OLg7Xmxnkp41Wl7LrNJHJ83vvlYpsJ+6DtFdt82j1thRJJ4BPMOXXQ/VznxXbVK4wYXEfc/GT9jRWt/AYscmVrEJOp4AS6pfF/zabOfAeUxnPCFZuNTTYf/Anqida2Bnq4wWsjYQk+bW2BLfUXiq65uF50V779GQRASHenAhYUkWSzDbA55v76C9I5KXmHcVFOiKZ+crBw0xzYGCLy1zA+5u2EhK1ncHnju8fsDtQSCKHPF/gcZOsPDlVLbNE0mfQthSkUwe+rOWG2wRpE+KPod4Fcxq3gunpXyR6lKHmlhZCpEl+DhWx7PfMSbDazPY+COK+/qGCXHLZyacBrpvSmak7r6CzLPw4+h0pwFa+tzSii0Zv9DN8UEf7Wbq03UkBiyGMlaM3mpkAwbcbFlMcfoVkaKlOuSDBdv7Zmh9anZplloQRffHv2Tv2GkEp72wdqH/k4XVmDCpyw2JLs0oHt2xIq29iX3qXEUhQeNJBjOCsK4r0Uq7hFWmN6TQWZjgtJbpDytI+xrJcby2dVcjTGw==">
      <TableDataSource Name="MatExpireDate_Report" DataType="System.Int32" Enabled="true" TableName="MatExpireDate_Report" SelectCommand="exec mnrPrcRepMatExpireDate '{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}' , '' , '' , '{FF8C56CA-3B5A-4b8a-B4EA-44D7E863D60C}' , '{5B1F9CA5-11FC-42cf-B5FF-70D8449C3EF4}' , '2-14-2023' , 0 , 0 , 0 , 1 , 0 , 0 , 0 , 0 , 1 , 0 , 0 , 0 , 1 , 0, 0,1 , 0, '{00000000-0000-0000-0000-000000000000}',3,'2-14-2023', 0 , '{00000000-0000-0000-0000-000000000000}' , '' , '1' , 0 , '{00000000-0000-0000-0000-000000000000}'">
        <Column Name="MatID" DataType="System.Guid"/>
        <Column Name="MatCode" DataType="System.String"/>
        <Column Name="MatName" DataType="System.String"/>
        <Column Name="MatLatinName" DataType="System.String"/>
        <Column Name="GrpID" DataType="System.Guid"/>
        <Column Name="GrpCode" DataType="System.String"/>
        <Column Name="GrpName" DataType="System.String"/>
        <Column Name="GrpLatinName" DataType="System.String"/>
        <Column Name="Qty" DataType="System.Double"/>
        <Column Name="Qty1" DataType="System.Double"/>
        <Column Name="Qty2" DataType="System.Double"/>
        <Column Name="Qty3" DataType="System.Double"/>
        <Column Name="Qty4" DataType="System.Double"/>
        <Column Name="Qty5" DataType="System.Double"/>
        <Column Name="ExpireDate" DataType="System.DateTime"/>
        <Column Name="ProductDate" DataType="System.DateTime"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="Remaining" DataType="System.Double"/>
        <Column Name="Remaining2" DataType="System.Double"/>
        <Column Name="Remaining3" DataType="System.Double"/>
        <Column Name="Remaining4" DataType="System.Double"/>
        <Column Name="Remaining5" DataType="System.Double"/>
        <Column Name="Bonus" DataType="System.Double"/>
        <Column Name="Bonus1" DataType="System.Double"/>
        <Column Name="Bonus2" DataType="System.Double"/>
        <Column Name="Bonus3" DataType="System.Double"/>
        <Column Name="Bonus4" DataType="System.Double"/>
        <Column Name="Bonus5" DataType="System.Double"/>
        <Column Name="MatUnitName" DataType="System.String"/>
        <Column Name="BillType" DataType="System.Guid"/>
        <Column Name="BillID" DataType="System.Guid"/>
        <Column Name="BillNum" DataType="System.Double"/>
        <Column Name="BillName" DataType="System.String"/>
        <Column Name="BillLatinName" DataType="System.String"/>
        <Column Name="DayesCount" DataType="System.Int32"/>
        <Column Name="BillNotes" DataType="System.String"/>
        <Column Name="Age" DataType="System.Int32"/>
        <Column Name="Class" DataType="System.String"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;14/2/2023&quot;"/>
    <Parameter Name="ShowPrice" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="DateType" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{452D9B5F-1CC9-4407-B937-7ACB53469411}&quot;"/>
    <Parameter Name="CurrName" DataType="System.String" Expression="&quot;دولار أمريكي&quot;"/>
    <Parameter Name="ShowClass" DataType="System.String" Expression="&quot;0&quot;"/>
    <Total Name="Total_QTY" Expression="[MatExpireDate_Report.Qty]" Evaluator="MasterData1" PrintOn="GroupFooter1"/>
    <Total Name="Total_Remaning" Expression="[MatExpireDate_Report.Remaining]" Evaluator="MasterData1" PrintOn="GroupFooter1"/>
    <Total Name="Total_QTY_Data2" Expression="[MatExpireDate_Report.Qty]" Evaluator="MasterData2" PrintOn="GroupFooter2"/>
    <Total Name="Total_Remaining_Data2" Expression="[MatExpireDate_Report.Remaining]" Evaluator="MasterData2" PrintOn="GroupFooter2"/>
    <Total Name="Total_QTY_Summary" Expression="[MatExpireDate_Report.Qty]" Evaluator="MasterData1" PrintOn="ReportSummary1"/>
    <Total Name="Total_Remaining_Summary" Expression="[MatExpireDate_Report.Remaining]" Evaluator="MasterData1" PrintOn="ReportSummary1"/>
  </Dictionary>
  <ReportPage Name="Page1" Landscape="true" PaperWidth="297" PaperHeight="210" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="1047.06" Height="155.96">
      <TextObject Name="Memo13" Left="17.01" Top="96.15" Width="1012.91" Height="22.68" Text="صلاحية المواد" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <PictureObject Name="Company_Logo" Left="7.56" Top="2.22" Width="1031.81" Height="86.93" Fill.Color="White" SizeMode="CenterImage" Image=""/>
      <TextObject Name="Memo44" Left="949.86" Top="123.17" Width="81.26" Height="18.9" Text=": الى تاريخ" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo45" Left="897.63" Top="123.17" Width="79.37" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo46" Left="133.71" Top="123.17" Width="49.13" Height="18.9" Text=":العملة" Padding="2, 1, 2, 1" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo47" Left="3.78" Top="123.17" Width="128.5" Height="18.9" Text="[CurrName]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="159.96" Width="1047.06" Height="18.9">
      <TextObject Name="Memo2" Left="986.91" Width="45.35" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" Text="الرقم" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo3" Left="766.61" Width="219.22" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" Text="مـــــادة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo4" Left="656.89" Width="111.5" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" Text="الفاتورة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo5" Left="564.52" Width="92.6" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" Text="كمية مشتراة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo6" Left="463.27" Width="102.05" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" Text="تاريخ الشراء" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo7" Left="354.99" Width="107.72" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" Text="إجمالي الكمية المتبقية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo8" Left="254.01" Width="100.16" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" Text="عمر الكمية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo10" Left="3.3" Width="22.67" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" Text="إجمالي السعر" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo11" Left="36.2" Width="60.47" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" Text="الإفرادي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo12" Left="55.31" Width="94.49" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" Text="عدد الأيام" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo9" Left="150.57" Width="102.05" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" Text="تاريخ الصلاحية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
    </PageHeaderBand>
    <GroupHeaderBand Name="GroupHeader1" Top="182.86" Width="1047.06" Condition="[MatExpireDate_Report.MatName]">
      <DataBand Name="MasterData1" Top="186.86" Width="1047.06" Height="18.9" CanGrow="true" CanShrink="true" CanBreak="true" DataSource="MatExpireDate_Report">
        <TextObject Name="MatExpireDate_ReportQty" Left="564.52" Width="92.6" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatExpireDate_Report.Qty]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatExpireDate_ReportRemaining" Left="354.99" Width="107.72" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatExpireDate_Report.Remaining]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatExpireDate_ReportMatID" Left="986.91" Width="45.35" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatExpireDate_ReportMatName" Left="766.61" Width="219.22" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatExpireDate_Report.MatName]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatExpireDate_ReportBillName" Left="656.89" Width="111.5" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text=" [MatExpireDate_Report.BillNum] - [MatExpireDate_Report.BillName] " Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatExpireDate_ReportDate" Left="463.27" Width="102.05" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatExpireDate_Report.Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatExpireDate_ReportAge" Left="254.01" Width="100.16" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text=" [MatExpireDate_Report.Age] يوم" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatTotalPrice" Left="-6.15" Width="41.57" Height="18.9" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatCountDate" Left="55.39" Width="94.49" Height="18.9" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Text="[IIf([MatExpireDate_Report.ExpireDate] ==ToDateTime( &quot;1-1-1980&quot;),0,[MatExpireDate_Report.DayesCount])] يوم" Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatPrice" Left="54.92" Width="22.67" Height="18.9" Visible="false" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="MatExpireDate" Left="150.57" Width="102.05" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[IIf([MatExpireDate_Report.ExpireDate] == ToDateTime(&quot;1-1-1980&quot;),null,[MatExpireDate_Report.ExpireDate])]" Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
      </DataBand>
      <GroupFooterBand Name="GroupFooter1" Top="209.76" Width="1047.06" Height="15.12">
        <TextObject Name="Memo19" Left="656.89" Width="111.5" Height="15.12" Border.Lines="All" Fill.Color="186, 211, 254" Text="الإجمالي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
        <TextObject Name="Memo27" Left="354.99" Width="107.72" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Text="[Total_Remaning]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo32" Left="564.52" Width="92.6" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Text="[Total_QTY]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo48" Left="463.27" Width="102.05" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo49" Left="254.01" Width="100.16" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo51" Left="55.39" Width="94.49" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo52" Left="36.02" Width="60.47" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo53" Left="-6.15" Width="41.57" Height="15.12" Border.Lines="All" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo50" Left="150.57" Width="102.05" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
      </GroupFooterBand>
    </GroupHeaderBand>
    <GroupHeaderBand Name="GroupHeader2" Top="228.88" Width="1047.06" Condition="[MatExpireDate_Report.MatName]">
      <DataBand Name="MasterData2" Top="232.88" Width="1047.06" Height="18.9" CanGrow="true" CanShrink="true" CanBreak="true" DataSource="MatExpireDate_Report">
        <TextObject Name="Memo24" Left="564.52" Width="92.6" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatExpireDate_Report.Qty]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo26" Left="354.99" Width="107.72" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatExpireDate_Report.Remaining]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo20" Left="986.91" Width="45.35" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[Row#]" Padding="2, 1, 2, 1" HorzAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo22" Left="766.61" Width="219.22" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatExpireDate_Report.MatName]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo23" Left="656.89" Width="111.5" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text=" [MatExpireDate_Report.BillNum] - [MatExpireDate_Report.BillName] " Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo25" Left="463.27" Width="102.05" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatExpireDate_Report.Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo31" Left="254.01" Width="100.16" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[MatExpireDate_Report.Age]يوم" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo34" Left="-6.15" Width="41.57" Height="18.9" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo35" Left="55.39" Width="94.49" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[MatExpireDate_Report.DayesCount]يوم" Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo36" Left="36.02" Width="60.47" Height="18.9" Border.Lines="Left, Top, Bottom" GrowToBottom="true" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo33" Left="150.57" Width="102.05" Height="18.9" Border.Lines="Right, Top, Bottom" GrowToBottom="true" Text="[IIf([MatExpireDate_Report.ProductDate]==ToDateTime( &quot;1-1-1980&quot;),null,[MatExpireDate_Report.ProductDate])]" Padding="2, 1, 2, 1" HorzAlign="Right" RightToLeft="true" Font="Times New Roman, 10pt"/>
      </DataBand>
      <GroupFooterBand Name="GroupFooter2" Top="255.78" Width="1047.06" Height="15.12">
        <TextObject Name="Memo40" Left="652.42" Width="379.85" Height="15.12" Border.Lines="All" Fill.Color="186, 211, 254" Text="الإجمالي" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
        <TextObject Name="Memo38" Left="354.99" Width="107.72" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Text="[Total_Remaining_Data2]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo39" Left="564.52" Width="92.6" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Text="[Total_QTY_Data2]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo54" Left="463.27" Width="102.05" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo55" Left="254.01" Width="100.16" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo57" Left="55.87" Width="94.49" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo58" Left="36.5" Width="60.47" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo59" Left="-5.67" Width="41.57" Height="15.12" Border.Lines="All" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo56" Left="150.57" Width="102.05" Height="15.12" Border.Lines="Right, Top, Bottom" Fill.Color="186, 211, 254" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
      </GroupFooterBand>
    </GroupHeaderBand>
    <ReportSummaryBand Name="ReportSummary1" Top="274.9" Width="1047.06" Height="38.07">
      <TextObject Name="Memo43" Left="718.57" Top="19.17" Width="313.7" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" Text="مجموع الكميات المتبقية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo42" Left="718.57" Top="0.35" Width="313.7" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" Text="إجمالي الكمية المشتراة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo14" Left="455.49" Top="0.05" Width="264.57" Height="18.9" Border.Lines="Left, Top, Bottom" Text="[Total_QTY_Data2]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo15" Left="455.49" Top="19.17" Width="264.57" Height="18.9" Border.Lines="Left, Top, Bottom" Text="[Total_Remaining_Data2]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo16" Left="726.57" Top="0.05" Width="304.25" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="187, 210, 244" Text="إجمالي الكمية المشتراة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo17" Left="726.57" Top="19.17" Width="304.25" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" Text="مجموع الكميات المتبقية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo37" Left="463.49" Width="264.57" Height="18.9" Border.Lines="Left, Top, Bottom" Text="[Total_QTY_Summary]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo41" Left="463.49" Top="19.17" Width="264.57" Height="18.9" Border.Lines="Left, Bottom" Text="[Total_Remaining_Summary]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="316.97" Width="1047.06" Height="41.57">
      <TextObject Name="Memo1" Left="957.78" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Arial, 10pt"/>
      <TextObject Name="Memo21" Left="68.83" Width="83.15" Height="11.34" Text="[Date]" Padding="2, 1, 2, 1" Format="Date" Format.Format="d" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo28" Left="9.57" Width="56.69" Height="11.34" Text="Printed on:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Tahoma, 8pt"/>
      <TextObject Name="Memo29" Left="158.32" Width="30.24" Height="11.34" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Tahoma, 8pt"/>
      <TextObject Name="Memo30" Left="191.33" Width="56.69" Height="11.34" Text="[Date]" Padding="2, 1, 2, 1" Format="Time" Format.Format="t" VertAlign="Center" Font="Arial, 8pt, style=Bold"/>
      <TextObject Name="Memo18" Left="902.58" Top="25.62" Width="185.17" Height="13.34" Border.Lines="All" Border.Color="White" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Blue"/>
    </PageFooterBand>
  </ReportPage>
</Report>
