﻿<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="11/26/2022 16:14:25" ReportInfo.Modified="03/29/2023 14:07:34" 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 ReportOnStartReport(TfrxComponent Sender)
{  
  if( &lt;CollectByMat&gt; == &quot;1&quot;)
  {
       ShowMessage( &quot;�� ���� ��� ������� �� ������� ��� ���� ������&quot;);

       TfrxReport( Sender).Terminated = true;
  }           
 }

{

}
*/</ScriptText>
  <Dictionary>
    <MsSqlDataConnection Name="ADODatabase" ConnectionString="rijcmlqJUrEa/KIcQqhhcfnlqC6PHTn0L44W7TQfS6RmUJOGDIuc+knUePlrDTYQkz8WhBi+/eEENRi2jncLgF6AYFfnxi5TQ05ZIo09TPRMd9nylipGCHJuT4P6CmAmUnkPqsMzrn+ncn0KrMaishF5xOlOBpnwyPOGcxVYW0Xl45KzI8Iccnx2P3kyo7WfWzndXXEcidFvz4yjaqHHGVME6UprEKxr73BXmINWNlI5+BZlmIrOTRQXg2XVXR7luWNxLRoKZVk2J2Po59ui3A46U1s8nvPosLiMomdE3twOk32k+DHivMcDq1HkhOi/0Qbm7Xislwmlw7O3d4zXZI96CHae2TE5QOEx5w+/lmRl+4Xk779bPIrZ+nv2piboZeJSlBlpsmECeMeSIeJ3bMPNS8zUnX6isdsk6nMONP2+IrAxU8EFqU8IxRDIKZCCAbUjq9kw0iV1symAnG9tIx/S2H4bPu9Cn5p/s72Td87gTzTLCEwDh2hx9U1T7oJxHjfWHA5fi4lXpGFkoiL4DFYlATByOv+5uvi/oaEPREsqbE9Wfp42FmkUqfjz4UmPjX7C9ZqWLSf3eu6ZB60VI9F1Tt3UMMT+uqGeKc+MHp6clv9VDLaKmfDtvTFremdxlCZTdTm">
      <TableDataSource Name="Acc_MatInventory_Report" DataType="System.Int32" Enabled="true" TableName="Acc_MatInventory_Report" SelectCommand="exec [mnrPrcRepMatInventory] '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , 0 , '{00000000-0000-0000-0000-000000000000}' , 0 , '{00000000-0000-0000-0000-000000000000}' , '{00000000-0000-0000-0000-000000000000}' , '' , '' , '{2BA41B06-BB81-42b6-AE85-D5F83D6D4C40}' , '{CAD9AC8F-4573-4400-B263-0382129C869F}' , '1-1-2020' , '3-29-2023' , 0 , 1 , 0 , 0 , 0 , 0 , '' , 12 , 1 , 0 , 1 , 0 , '' , '' , 0, 2, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '{00000000-0000-0000-0000-000000000000}',0, 0">
        <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="GrID" DataType="System.Guid"/>
        <Column Name="GrCode" DataType="System.String"/>
        <Column Name="GrName" DataType="System.String"/>
        <Column Name="GrLatinName" DataType="System.String"/>
        <Column Name="Path" DataType="System.String"/>
        <Column Name="StoreID" DataType="System.Guid"/>
        <Column Name="StoreCode" DataType="System.String"/>
        <Column Name="StoreName" DataType="System.String"/>
        <Column Name="StoreLatinName" 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="DefUnit" DataType="System.Int32"/>
        <Column Name="Unity1" DataType="System.String"/>
        <Column Name="Unity2" DataType="System.String"/>
        <Column Name="Unity3" DataType="System.String"/>
        <Column Name="Unity4" DataType="System.String"/>
        <Column Name="Unity5" DataType="System.String"/>
        <Column Name="Price" DataType="System.Double"/>
        <Column Name="Level" DataType="System.Int32"/>
        <Column Name="Type" DataType="System.Int32"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Parameter Name="CurUserID" DataType="System.String" Expression="&quot;{26DF719A-ECB1-4abc-B856-790DB31E7A86}&quot;"/>
    <Parameter Name="FromDate" DataType="System.String" Expression="&quot;1/1/2020&quot;"/>
    <Parameter Name="ToDate" DataType="System.String" Expression="&quot;29/3/2023&quot;"/>
    <Parameter Name="CurrName" DataType="System.String" Expression="&quot;ريال سعودي&quot;"/>
    <Parameter Name="LevelGrp" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="LevelStore" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bShowGroup" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="CostByStore" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="DetailStore" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="FldGroup" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="PriceType" DataType="System.String" Expression="&quot;12&quot;"/>
    <Parameter Name="PolicyType" DataType="System.String" Expression="&quot;1&quot;"/>
    <Parameter Name="UseUnit" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="SellMan" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="Vendor" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="Length" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="Heigh" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="Expiredate" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="Notes" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="ShowBonus" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="bDetailQtyInUnitDetail" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="StoreName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="CostJobName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="SellManName" DataType="System.String" Expression="&quot;&quot;"/>
    <Parameter Name="GrpName" DataType="System.String" Expression="&quot;0&quot;"/>
    <Parameter Name="CollectByMat" DataType="System.String" Expression="&quot;0&quot;"/>
    <Total Name="Total" Expression="IIf([Acc_MatInventory_Report.Type]==0,[Acc_MatInventory_Report.Qty]*[Acc_MatInventory_Report.Price],0)" Evaluator="MasterData1"/>
    <Total Name="Total1" Expression="IIf([Acc_MatInventory_Report.Qty] &lt;0,[Acc_MatInventory_Report.Qty]*[Acc_MatInventory_Report.Price],0)" Evaluator="MasterData1"/>
    <Total Name="Total2" Expression="IIf([Acc_MatInventory_Report.Qty] &gt;=0,[Acc_MatInventory_Report.Qty]*[Acc_MatInventory_Report.Price],0) " Evaluator="MasterData1"/>
    <Total Name="Total3" Expression="IIf([Acc_MatInventory_Report.Qty] &lt;0,Abs([Acc_MatInventory_Report.Qty]*[Acc_MatInventory_Report.Price]),0)" Evaluator="MasterData1"/>
    <Total Name="Total4" Expression="IIf([Acc_MatInventory_Report.Qty] &lt;=0,0,IIf([Acc_MatInventory_Report.Type]==0,[Acc_MatInventory_Report.Qty],0))" Evaluator="MasterData1"/>
    <Total Name="Total5" Expression="IIf([Acc_MatInventory_Report.Qty] &gt;0,0,IIf([Acc_MatInventory_Report.Type]==0,[Acc_MatInventory_Report.Qty],0))" Evaluator="MasterData1"/>
    <Total Name="Total6" Expression="IIf([Acc_MatInventory_Report.Qty] &gt;=0,[Acc_MatInventory_Report.Qty],0)" Evaluator="MasterData1"/>
    <Total Name="Total7" Expression="IIf([Acc_MatInventory_Report.Qty] &lt;0,Abs([Acc_MatInventory_Report.Qty]),0)" Evaluator="MasterData1"/>
    <Total Name="Total-QTY*Price" Expression="IIf([Acc_MatInventory_Report.Qty] &lt;0,[Acc_MatInventory_Report.Qty]*[Acc_MatInventory_Report.Price],0)" Evaluator="MasterData1"/>
  </Dictionary>
  <ReportPage Name="Page1" LeftMargin="2.5" RightMargin="2.5" Watermark.Font="Arial, 60pt">
    <ReportTitleBand Name="ReportTitle1" Width="774.9" Height="188.43">
      <TextObject Name="Memo8" Left="332.52" Top="101.22" Width="109.76" Height="27.9" Text="جرد المواد" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 14pt, style=Bold"/>
      <PictureObject Name="Company_Logo" Left="13.23" Top="3.78" Width="748.35" Height="79.37" Fill.Color="White" ImageLocation="D:\05- Vertex Cart\7.jpg" SizeMode="CenterImage"/>
      <TextObject Name="Memo23" Left="697.32" Top="150.17" Width="66.14" Height="18.9" Text=":إعتباراً من" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo24" Left="614.72" Top="150.17" Width="90.71" Height="18.9" Text="[FromDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo25" Left="562.14" Top="150.17" Width="43.47" Height="18.9" Text=":ولغاية" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo26" Left="480.32" Top="150.17" Width="90.71" Height="18.9" Text="[ToDate]" Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo27" Left="143.29" Top="150.17" Width="43.47" Height="18.9" Text=":العملة" Padding="2, 1, 2, 1" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo31" Left="18.9" Top="150.17" Width="132.28" Height="18.9" Text=" [CurrName] " Padding="2, 1, 2, 1" HorzAlign="Right" VertAlign="Center" Font="Times New Roman, 10pt"/>
    </ReportTitleBand>
    <PageHeaderBand Name="PageHeader1" Top="192.43" Width="774.9" Height="22.68">
      <TextObject Name="Memo3" Left="463.27" Width="177.64" Height="22.68" 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="274.73" Width="98.27" Height="22.68" 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="160.86" Width="113.39" Height="22.68" 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="Memo7" Left="39.61" Width="120.94" Height="22.68" 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="Memo5" Left="641.25" Width="102.05" Height="22.68" 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="Memo22" Left="373.17" Width="90.71" Height="22.68" 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>
    <DataBand Name="MasterData1" Top="219.11" Width="774.9" Height="18.9" CanGrow="true" CanShrink="true" DataSource="Acc_MatInventory_Report">
      <TextObject Name="Acc_MatInventory_ReportPrice" Left="160.86" Width="113.39" Height="18.9" Border.Lines="All" GrowToBottom="true" Text="[IIf([Acc_MatInventory_Report.Type]==1,[Acc_MatInventory_Report.Price]/[Acc_MatInventory_Report.Qty],[Acc_MatInventory_Report.Price])]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text1" Left="463.27" Width="177.64" Height="18.9" Border.Lines="All" Text="[Acc_MatInventory_Report.MatName]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt">
        <Highlight>
          <Condition Expression="[Acc_MatInventory_Report.Qty] &lt;0" Font="Arial, 10pt"/>
        </Highlight>
      </TextObject>
      <TextObject Name="Text2" Left="274.73" Width="98.27" Height="18.9" Border.Lines="All" Text="[Acc_MatInventory_Report.Qty]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt">
        <Highlight>
          <Condition Expression="[Acc_MatInventory_Report.Qty] &lt;0" Font="Arial, 10pt"/>
        </Highlight>
      </TextObject>
      <TextObject Name="Text3" Left="39.61" Width="120.94" Height="18.9" Border.Lines="All" Text="[IIf([Acc_MatInventory_Report.Type]==1,[Acc_MatInventory_Report.Price],[Acc_MatInventory_Report.Qty]*[Acc_MatInventory_Report.Price])]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt">
        <Formats>
          <NumberFormat/>
          <GeneralFormat/>
        </Formats>
        <Highlight>
          <Condition Expression="[Acc_MatInventory_Report.Qty] &lt;0" Font="Arial, 10pt"/>
        </Highlight>
      </TextObject>
      <TextObject Name="Text4" Left="373.17" Width="90.71" Height="18.9" Border.Lines="All" Text="[IIf([Acc_MatInventory_Report.DefUnit]==1,[Acc_MatInventory_Report.Unity1],IIf([Acc_MatInventory_Report.DefUnit]==2,[Acc_MatInventory_Report.Unity2],IIf([Acc_MatInventory_Report.DefUnit]==3,[Acc_MatInventory_Report.Unity3],IIf([Acc_MatInventory_Report.DefUnit]==4,[Acc_MatInventory_Report.Unity4],IIf([Acc_MatInventory_Report.DefUnit]==5,[Acc_MatInventory_Report.Unity5],&quot;&quot;)))))]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt">
        <Highlight>
          <Condition Expression="[Acc_MatInventory_Report.Qty] &lt;0" Font="Arial, 10pt"/>
        </Highlight>
      </TextObject>
      <TextObject Name="Text5" Left="641.25" Width="102.05" Height="18.9" Border.Lines="All" Text="[Acc_MatInventory_Report.MatCode]" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt"/>
    </DataBand>
    <ReportSummaryBand Name="ReportSummary1" Top="242.01" Width="774.9" Height="89.24">
      <TextObject Name="Memo9" Left="131.06" Top="11.34" Width="200.32" Height="18.9" Border.Lines="Left, 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="560.87" Top="11.34" Width="132.28" Height="18.9" Border.Lines="All" Fill.Color="187, 210, 244" Padding="2, 1, 2, 1" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo11" Left="330.58" Top="11.34" Width="230.55" 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="Memo12" Left="131.06" Top="30.34" Width="200.32" Height="18.9" Border.Lines="All" Text="[Total4]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo13" Left="560.87" Top="30.34" Width="132.28" 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="330.58" Top="30.34" Width="230.55" Height="18.9" Border.Lines="Right, Top, Bottom" Text="[Total]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo16" Left="560.87" Top="49.34" Width="132.28" 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="Memo18" Left="131.06" Top="68.34" Width="200.32" Height="18.9" Border.Lines="All" Text="[[Total4]+[Total5]]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo19" Left="560.87" Top="68.34" Width="132.28" 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="Memo20" Left="330.58" Top="68.34" Width="230.55" Height="18.9" Border.Lines="Right, Top, Bottom" Text="[[Total]+[Total1]]" Padding="2, 1, 2, 1" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Times New Roman, 10pt"/>
      <TextObject Name="Text6" Left="131.06" Top="49.34" Width="200.32" Height="18.9" Border.Lines="All" Text="[Total5]" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt">
        <Highlight>
          <Condition Expression="[Acc_MatInventory_Report.Qty]&lt;0" Font="Arial, 10pt"/>
        </Highlight>
      </TextObject>
      <TextObject Name="Text7" Left="330.58" Top="49.34" Width="230.55" Height="18.9" Border.Lines="All" Text="[Total1]" Format="Number" Format.UseLocale="true" Format.DecimalDigits="2" HorzAlign="Center" VertAlign="Center" Font="Arial, 10pt">
        <Highlight>
          <Condition Expression="[Total-QTY*Price]&lt;0" Font="Arial, 10pt"/>
        </Highlight>
      </TextObject>
    </ReportSummaryBand>
    <PageFooterBand Name="PageFooter1" Top="335.25" Width="774.9" Height="50.34">
      <TextObject Name="Memo1" Left="669.42" Width="75.59" Height="18.9" Text="[Page#]" Padding="2, 1, 2, 1" HorzAlign="Right" Font="Times New Roman, 10pt"/>
      <TextObject Name="Memo21" Left="72.25" Top="5.62" 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="Memo28" Left="13" Top="5.62" 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="Memo29" Left="161.74" Top="5.62" Width="30.24" Height="15.12" Text="Time:" Padding="2, 1, 2, 1" AutoWidth="true" VertAlign="Center" Font="Times New Roman, 8pt"/>
      <TextObject Name="Memo32" Left="614.96" Top="31.24" Width="151.18" 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>
