﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="11/26/2022 13:27:09" ReportInfo.Modified="04/28/2023 15:02:42" 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
  {
  }
}
/*
{

}
*/</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBieCxotcH2hUtyMN3HKcJlMnIc573nib6FlxDbWckCUdNG2nFnYXef/888mBOr3VwlTsvr/KtnrXJMDiOvBhXmCV4VCJvSs3ndrLSWLJEU/5ejlw0WobaBCW8oZCkfddVQmzUFOCHleUyEbIWg/JgbZJ9xalo1VD7Wfq/DX5ejAYlH4E3VHLCQI2I05j3GJYgN4s86QsUdYiFprXFMu3OyHeJiKyvcrpSXZbxtmMQUmMwd8dQ6KqZX1va26DH41Hlqm8JboKzOF32CdUO/ZYv3KHLjAIdmeiPvTjv1R3UpZKKmHPEHPSbQf0ZUsDRtF5TopWeOX6McV7aF79kjJj7qCeBsPDXmIA7gTKRyCeTZcB79IudtlTn/MT84HXHDsj1d/uGiDa/6kKjRMkS7iLSB1HhmEXU7Xrg//zY/t5PGxSyAtwq4driEF1YpmTK6ZhdSEYfYy1sv+u2ffBOHK+190Vy1rvYnOavPe9WLnSJoon1Du0wGgQKcUpAfzqKPzNoV6imfBPp6XDupbqyYU6A+0HLT4xy0GG7JXyw9sD+z/pLDx97twsuTuXcF1HFLUUvb8/N72AefqZYri7u2sjX2ig==">
      <TableDataSource Name="RepMatMoveByExpireDate_Report" DataType="System.Int32" Enabled="true" TableName="RepMatMoveByExpireDate_Report" SelectCommand="exec mnrPrcRepMatMoveByExpireDate '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '{8461AA7C-F8FF-43e7-AB90-A32E42CA5782}' , '{EE3F83A3-C3F0-482a-AC0E-125226EDD2FA}' , '{00000000-0000-0000-0000-000000000000}' , '1-1-2022' , '10-1-2022' , 1 , 3 , '' , 3 , '4-28-2023'">
        <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="GpID" DataType="System.Guid"/>
        <Column Name="GpCode" DataType="System.String"/>
        <Column Name="GpName" DataType="System.String"/>
        <Column Name="GpLatinName" DataType="System.String"/>
        <Column Name="MatUnit" DataType="System.String"/>
        <Column Name="Quantity" DataType="System.Double"/>
        <Column Name="VALUE" DataType="System.Double"/>
        <Column Name="PeriodNum" DataType="System.Int32"/>
        <Column Name="PeriodStartDate" DataType="System.DateTime"/>
        <Column Name="PeriodEndDate" DataType="System.DateTime"/>
        <Column Name="ExpireDate" DataType="System.DateTime"/>
        <Column Name="type" DataType="System.Int32"/>
        <Column Name="BillTypeID" DataType="System.Guid"/>
        <Column Name="BillType" DataType="System.String"/>
        <Column Name="BillLatinType" DataType="System.String"/>
        <Column Name="BillNumb" DataType="System.Double"/>
        <Column Name="BillID" DataType="System.Guid"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{1D9649A7-6D5B-436d-A486-8A8C13EC1791}&quot;"/>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;1/1/2022&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;1/10/2022&quot;"/>
    <Parameter Name="CurrName" DataType="System.String"/>
    <Parameter Name="Currency" DataType="System.String" Expression="&quot;دولار أمريكي&quot;"/>
    <Parameter Name="Unit" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="Duration" DataType="System.String" Expression="&quot;3&quot;"/>
    <Total Name="Total" Expression="IIf([RepMatMoveByExpireDate_Report.type]==1,[RepMatMoveByExpireDate_Report.Quantity],-[RepMatMoveByExpireDate_Report.Quantity])" Evaluator="MasterData1"/>
    <Total Name="Total1" Expression="IIf([RepMatMoveByExpireDate_Report.type]==1,[RepMatMoveByExpireDate_Report.VALUE],-[RepMatMoveByExpireDate_Report.VALUE])" Evaluator="MasterData1"/>
  </Dictionary>
  <ReportPage Name="Page1" LeftMargin="0.1" TopMargin="2.5" RightMargin="0.1" BottomMargin="2.5" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="793.04" Height="181.42">
      <TextObject Name="Memo19" Left="290.65" Top="105.94" Width="211.65" Height="26.99" Text="حركة المواد حسب تاريخ الصلاحية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 12pt, style=Bold"/>
      <PictureObject Name="Company_Logo" Left="27.97" Width="737.01" Height="95.69" Fill.Color="White" SizeMode="CenterImage" Image=""/>
      <TextObject Name="Memo24" Left="719.31" Top="145.62" Width="66.14" Height="18.9" Text="إعتبارا من:" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo26" Left="634.18" Top="145.62" Width="94.49" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo27" Left="589.25" Top="145.62" Width="41.57" Height="18.9" Text="ولغاية:" Padding="2, 1, 2, 1" HorzAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo28" Left="494" Top="145.62" Width="94.49" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo71" Left="404.07" Top="145.62" Width="41.57" Height="18.9" Text=":العملة " Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo72" Left="303.25" Top="145.62" Width="100.38" Height="18.9" Text=" [Currency] " Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo2" Left="152.94" Top="145.62" Width="37.8" Height="18.9" Text=": الفترة" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo3" Left="8.56" Top="145.62" Width="143.62" Height="18.9" Text="[IIf([Duration]==&quot;1&quot;,&quot;يومي&quot;,IIf([Duration]=='2&quot;,&quot;أسبوعي&quot;,IIf([Duration]=='3',&quot;شهري&quot;,IIf([Duration]=='4',&quot;ربعي&quot;,IIf([Duration]==&quot;5&quot;,&quot;نصفي&quot;,IIf([Duration]==&quot;6&quot;,&quot;سنوي&quot;,&quot;null&quot;))))))]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="185.42" Width="793.04" Height="19.68">
      <TextObject Name="Memo6" Left="492.56" Top="0.78" Width="94.49" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="151, 189, 253" Text="تاريخ الصلاحية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo7" Left="412.41" Top="0.78" Width="79.37" Height="18.9" Border.Lines="All" Fill.Color="151, 189, 253" Text="الفواتير" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo8" Left="318.04" Top="0.78" Width="94.49" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="151, 189, 253" Text="الكمية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo9" Left="230.67" Top="0.78" Width="86.93" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="151, 189, 253" Text="القيمة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo10" Left="121.74" Top="0.78" Width="109.61" Height="18.9" Border.Lines="All" Fill.Color="151, 189, 253" Text="إعتباراً من" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo11" Left="22.93" Top="0.78" Width="102.05" Height="18.9" Border.Lines="All" Fill.Color="151, 189, 253" Text="لغاية" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo5" Left="586.83" Top="0.78" Width="98.27" Height="18.9" Border.Lines="All" Fill.Color="151, 189, 253" Text="المجموعة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
      <TextObject Name="Memo4" Left="681.76" Top="0.78" Width="102.05" Height="18.9" Border.Lines="All" Fill.Color="151, 189, 253" Text="اسم المادة" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold"/>
    </PageHeaderBand>
    <GroupHeaderBand Name="GroupHeader1" Top="209.1" Width="793.04" Condition="[RepMatMoveByExpireDate_Report.ExpireDate]" SortOrder="None" KeepTogether="true">
      <DataBand Name="MasterData1" Top="213.1" Width="793.04" Height="18.9" CanGrow="true" CanShrink="true" DataSource="RepMatMoveByExpireDate_Report">
        <TextObject Name="Memo12" Left="681.52" Width="102.05" Height="18.9" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[[RepMatMoveByExpireDate_Report.MatCode]] - [[RepMatMoveByExpireDate_Report.MatName]]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo13" Left="587.15" Width="94.49" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="White" GrowToBottom="true" Text="[[RepMatMoveByExpireDate_Report.GpCode]] - [[RepMatMoveByExpireDate_Report.GpName]]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo14" Left="492.31" Width="94.49" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="White" GrowToBottom="true" Text="[RepMatMoveByExpireDate_Report.ExpireDate]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo15" Left="412.16" Width="79.37" Height="18.9" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[RepMatMoveByExpireDate_Report.BillType]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo16" Left="318.04" Width="94.49" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="White" GrowToBottom="true" Text="[IIf([RepMatMoveByExpireDate_Report.type]==1,[RepMatMoveByExpireDate_Report.Quantity],-[RepMatMoveByExpireDate_Report.Quantity])]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo17" Left="230.67" Width="86.93" Height="18.9" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[RepMatMoveByExpireDate_Report.VALUE]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo18" Left="121.74" Width="109.61" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="White" GrowToBottom="true" Text="[RepMatMoveByExpireDate_Report.PeriodStartDate]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo20" Left="22.93" Width="102.05" Height="18.9" Border.Lines="All" Fill.Color="White" GrowToBottom="true" Text="[RepMatMoveByExpireDate_Report.PeriodEndDate]" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      </DataBand>
      <GroupFooterBand Name="GroupFooter1" Top="236" Width="793.04" Height="18.9">
        <TextObject Name="Memo25" Left="681.52" Width="102.05" Height="18.9" Border.Lines="All" Fill.Color="255, 235, 155" Text="الرصيد" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo30" Left="587.15" Width="94.49" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="255, 235, 155" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" RightToLeft="true" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo35" Left="492.31" Width="94.49" Height="18.9" Border.Lines="Right, Top, Bottom" Fill.Color="255, 235, 155" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo36" Left="412.16" Width="79.37" Height="18.9" Border.Lines="All" Fill.Color="255, 235, 155" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo37" Left="318.04" Width="94.49" Height="18.9" Border.Lines="All" Fill.Color="255, 235, 155" Text="[Total]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
        <TextObject Name="Memo39" Left="121.74" Width="109.61" Height="18.9" Border.Lines="All" Fill.Color="255, 235, 155" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo40" Left="22.93" Width="102.05" Height="18.9" Border.Lines="All" Fill.Color="255, 235, 155" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
        <TextObject Name="Memo21" Left="230.67" Width="86.93" Height="18.9" Border.Lines="All" Fill.Color="255, 235, 155" Text="[Total1]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt, style=Bold" TextFill.Color="Red"/>
      </GroupFooterBand>
    </GroupHeaderBand>
    <PageFooterBand Name="PageFooter1" Top="258.9" Width="793.04" Height="56.69">
      <TextObject Name="Memo34" Left="665.2" Top="38.2" Width="185.17" Height="13.34" Border.Lines="All" Border.Color="White" Text="www.almanarasoft.com" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 8pt, style=Bold" TextFill.Color="Blue"/>
      <TextObject Name="Memo1" Left="710.55" Top="4.78" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo29" Left="62.49" Top="4.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="Memo31" Left="3.24" Top="4.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="Memo32" Left="151.98" Top="4.78" Width="30.24" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
    </PageFooterBand>
  </ReportPage>
</Report>
