﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <CalculationMode>Interpretation</CalculationMode>
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <XML Ref="2" type="Stimulsoft.Report.Dictionary.StiXmlDatabase" isKey="true">
        <Alias>XML</Alias>
        <Name>XML</Name>
        <PathData>E:\DATA\Demo.xml</PathData>
        <PathSchema>E:\DATA\Demo.xsd</PathSchema>
      </XML>
    </Databases>
    <DataSources isList="true" count="13">
      <Auto Ref="3" type="DataTableSource" isKey="true">
        <Alias>Auto</Alias>
        <Columns isList="true" count="5">
          <value>Country,System.String</value>
          <value>Rank,System.Double</value>
          <value>Year2000,System.Double</value>
          <value>Year2005,System.Double</value>
          <value>Year2009,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>b0d6e827b91b43d8b4eaafaf8deee15c</Key>
        <Name>Auto</Name>
        <NameInSource>XML.Auto</NameInSource>
      </Auto>
      <Categories Ref="4" type="DataTableSource" isKey="true">
        <Alias>Categories</Alias>
        <Columns isList="true" count="4">
          <value>CategoryID,System.Int32</value>
          <value>CategoryName,System.String</value>
          <value>Description,System.String</value>
          <value>Picture,System.Byte[]</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>bbed6eef95bc46c9bfa7cb87a6347ab4</Key>
        <Name>Categories</Name>
        <NameInSource>XML.Categories</NameInSource>
      </Categories>
      <Countries Ref="5" type="DataTableSource" isKey="true">
        <Alias>Countries</Alias>
        <Columns isList="true" count="3">
          <value>CountriesID,System.Int32</value>
          <value>CountryName,System.String</value>
          <value>Flag,System.Byte[]</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>98c20bd12bd94c0eb6c07f1f2a3315f6</Key>
        <Name>Countries</Name>
        <NameInSource>XML.Countries</NameInSource>
      </Countries>
      <Customers Ref="6" type="DataTableSource" isKey="true">
        <Alias>Customers</Alias>
        <Columns isList="true" count="11">
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>CompanyName,System.String</value>
          <value>ContactName,System.String</value>
          <value>ContactTitle,System.String</value>
          <value>Country,System.String</value>
          <value>CustomerID,System.String</value>
          <value>Fax,System.String</value>
          <value>Phone,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Region,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>9e3edaf3f328439c97ae74c2e9c6f1f6</Key>
        <Name>Customers</Name>
        <NameInSource>XML.Customers</NameInSource>
      </Customers>
      <Employees Ref="7" type="DataTableSource" isKey="true">
        <Alias>Employees</Alias>
        <Columns isList="true" count="17">
          <value>Address,System.String</value>
          <value>BirthDate,System.DateTime</value>
          <value>City,System.String</value>
          <value>Country,System.String</value>
          <value>EmployeeID,System.Int32</value>
          <value>Extension,System.String</value>
          <value>FirstName,System.String</value>
          <value>HireDate,System.DateTime</value>
          <value>HomePhone,System.String</value>
          <value>LastName,System.String</value>
          <value>Notes,System.String</value>
          <value>Photo,System.Byte[]</value>
          <value>PostalCode,System.String</value>
          <value>Region,System.String</value>
          <value>ReportsTo,System.Int32</value>
          <value>Title,System.String</value>
          <value>TitleOfCourtesy,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>aabe35aac7a8417591179d68f310e8bc</Key>
        <Name>Employees</Name>
        <NameInSource>XML.Employees</NameInSource>
      </Employees>
      <GlobalGrowth Ref="8" type="DataTableSource" isKey="true">
        <Alias>GlobalGrowth</Alias>
        <Columns isList="true" count="5">
          <value>Region,System.String</value>
          <value>Year2006,System.Double</value>
          <value>Year2007,System.Double</value>
          <value>Year2008,System.Double</value>
          <value>Year2009,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>44adc32bafe4400d9c203716783e9243</Key>
        <Name>GlobalGrowth</Name>
        <NameInSource>XML.GlobalGrowth</NameInSource>
      </GlobalGrowth>
      <Opec Ref="9" type="DataTableSource" isKey="true">
        <Alias>Opec</Alias>
        <Columns isList="true" count="9">
          <value>Iran,System.Double</value>
          <value>Iraq,System.Double</value>
          <value>Kuwait,System.Double</value>
          <value>Libya,System.Double</value>
          <value>Nigeria,System.Double</value>
          <value>Saudi_x0020_Arabia,System.Double</value>
          <value>UAE,System.Double</value>
          <value>Venezuela,System.Double</value>
          <value>Year,System.Double</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>8a23a429b17c4ddfbd4a4d6c26b6fa8e</Key>
        <Name>Opec</Name>
        <NameInSource>XML.Opec</NameInSource>
      </Opec>
      <Order_x0020_Details Ref="10" type="DataTableSource" isKey="true">
        <Alias>Order Details</Alias>
        <Columns isList="true" count="5">
          <value>Discount,System.Single</value>
          <value>OrderID,System.Int32</value>
          <value>ProductID,System.Int32</value>
          <value>Quantity,System.Int16</value>
          <value>UnitPrice,System.Decimal</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>1dbef0dde6d1415e8b6210dcf361e07c</Key>
        <Name>Order Details</Name>
        <NameInSource>XML.Order Details</NameInSource>
      </Order_x0020_Details>
      <Orders Ref="11" type="DataTableSource" isKey="true">
        <Alias>Orders</Alias>
        <Columns isList="true" count="14">
          <value>CustomerID,System.String</value>
          <value>EmployeeID,System.Int32</value>
          <value>Freight,System.Decimal</value>
          <value>OrderDate,System.DateTime</value>
          <value>OrderID,System.Int32</value>
          <value>RequiredDate,System.DateTime</value>
          <value>ShipAddress,System.String</value>
          <value>ShipCity,System.String</value>
          <value>ShipCountry,System.String</value>
          <value>ShipName,System.String</value>
          <value>ShippedDate,System.DateTime</value>
          <value>ShipPostalCode,System.String</value>
          <value>ShipRegion,System.String</value>
          <value>ShipVia,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>22b12d776b774be4bc1d0370cfa3d4d1</Key>
        <Name>Orders</Name>
        <NameInSource>XML.Orders</NameInSource>
      </Orders>
      <Products Ref="12" type="DataTableSource" isKey="true">
        <Alias>Products</Alias>
        <Columns isList="true" count="10">
          <value>CategoryID,System.Int32</value>
          <value>Discontinued,System.Boolean</value>
          <value>ProductID,System.Int32</value>
          <value>ProductName,System.String</value>
          <value>QuantityPerUnit,System.String</value>
          <value>ReorderLevel,System.Int16</value>
          <value>SupplierID,System.Int32</value>
          <value>UnitPrice,System.Decimal</value>
          <value>UnitsInStock,System.Int16</value>
          <value>UnitsOnOrder,System.Int16</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>8130f8c7a4b945348a5f1edac4e5fcbe</Key>
        <Name>Products</Name>
        <NameInSource>XML.Products</NameInSource>
      </Products>
      <Shippers Ref="13" type="DataTableSource" isKey="true">
        <Alias>Shippers</Alias>
        <Columns isList="true" count="3">
          <value>CompanyName,System.String</value>
          <value>Phone,System.String</value>
          <value>ShipperID,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>509fb8272a47424ca11e73868c8135bc</Key>
        <Name>Shippers</Name>
        <NameInSource>XML.Shippers</NameInSource>
      </Shippers>
      <States Ref="14" type="DataTableSource" isKey="true">
        <Alias>States</Alias>
        <Columns isList="true" count="4">
          <value>Capital,System.String</value>
          <value>Name,System.String</value>
          <value>Population,System.Int32</value>
          <value>USPS,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>5268cb23acb7484989be034543a6e961</Key>
        <Name>States</Name>
        <NameInSource>XML.States</NameInSource>
      </States>
      <Suppliers Ref="15" type="DataTableSource" isKey="true">
        <Alias>Suppliers</Alias>
        <Columns isList="true" count="12">
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>CompanyName,System.String</value>
          <value>ContactName,System.String</value>
          <value>ContactTitle,System.String</value>
          <value>Country,System.String</value>
          <value>Fax,System.String</value>
          <value>HomePage,System.String</value>
          <value>Phone,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Region,System.String</value>
          <value>SupplierID,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>df3c5b6201c9487482b983af8cf01fd9</Key>
        <Name>Suppliers</Name>
        <NameInSource>XML.Suppliers</NameInSource>
      </Suppliers>
    </DataSources>
    <Relations isList="true" count="7">
      <Orders Ref="16" type="DataRelation" isKey="true">
        <Alias>Orders</Alias>
        <ChildColumns isList="true" count="1">
          <value>OrderID</value>
        </ChildColumns>
        <ChildSource isRef="10" />
        <Dictionary isRef="1" />
        <Name>Orders</Name>
        <NameInSource>OrdersOrderDetails</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>OrderID</value>
        </ParentColumns>
        <ParentSource isRef="11" />
      </Orders>
      <Products Ref="17" type="DataRelation" isKey="true">
        <Alias>Products</Alias>
        <ChildColumns isList="true" count="1">
          <value>ProductID</value>
        </ChildColumns>
        <ChildSource isRef="10" />
        <Dictionary isRef="1" />
        <Name>Products</Name>
        <NameInSource>ProductsOrderDetails</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>ProductID</value>
        </ParentColumns>
        <ParentSource isRef="12" />
      </Products>
      <Customers Ref="18" type="DataRelation" isKey="true">
        <Alias>Customers</Alias>
        <ChildColumns isList="true" count="1">
          <value>CustomerID</value>
        </ChildColumns>
        <ChildSource isRef="11" />
        <Dictionary isRef="1" />
        <Name>Customers</Name>
        <NameInSource>CustomersOrders</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>CustomerID</value>
        </ParentColumns>
        <ParentSource isRef="6" />
      </Customers>
      <Employees Ref="19" type="DataRelation" isKey="true">
        <Alias>Employees</Alias>
        <ChildColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ChildColumns>
        <ChildSource isRef="11" />
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <NameInSource>EmployeesOrders</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ParentColumns>
        <ParentSource isRef="7" />
      </Employees>
      <Shippers Ref="20" type="DataRelation" isKey="true">
        <Alias>Shippers</Alias>
        <ChildColumns isList="true" count="1">
          <value>ShipVia</value>
        </ChildColumns>
        <ChildSource isRef="11" />
        <Dictionary isRef="1" />
        <Name>Shippers</Name>
        <NameInSource>ShippersOrders</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>ShipperID</value>
        </ParentColumns>
        <ParentSource isRef="13" />
      </Shippers>
      <Categories Ref="21" type="DataRelation" isKey="true">
        <Alias>Categories</Alias>
        <ChildColumns isList="true" count="1">
          <value>CategoryID</value>
        </ChildColumns>
        <ChildSource isRef="12" />
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <NameInSource>CategoriesProducts</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>CategoryID</value>
        </ParentColumns>
        <ParentSource isRef="4" />
      </Categories>
      <Suppliers Ref="22" type="DataRelation" isKey="true">
        <Alias>Suppliers</Alias>
        <ChildColumns isList="true" count="1">
          <value>SupplierID</value>
        </ChildColumns>
        <ChildSource isRef="12" />
        <Dictionary isRef="1" />
        <Name>Suppliers</Name>
        <NameInSource>SuppliersProducts</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>SupplierID</value>
        </ParentColumns>
        <ParentSource isRef="15" />
      </Suppliers>
    </Relations>
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <UserFunctions isList="true" count="0" />
    <Variables isList="true" count="1">
      <value>,Variable1,Variable1,,System.String,,False,False,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>6daced61c54a4b70945a4e4dd63dfca8</Key>
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="23" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="3">
        <GroupHeaderBand1 Ref="24" type="GroupHeaderBand" isKey="true">
          <Border>All;Black;1;Solid;False;4;Black</Border>
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="2">
            <Text1 Ref="25" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,7.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Name>Text1</Name>
              <Page isRef="23" />
              <Parent isRef="24" />
              <Text>{Products.Categories.CategoryName}</Text>
              <TextBrush>Black</TextBrush>
            </Text1>
            <Text2 Ref="26" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>10.2,0,5.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Name>Text2</Name>
              <Page isRef="23" />
              <Parent isRef="24" />
              <Text>{Variable1 = ""}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text2>
          </Components>
          <Condition>{Products.Categories.CategoryID}</Condition>
          <Conditions isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Name>GroupHeaderBand1</Name>
          <Page isRef="23" />
          <Parent isRef="23" />
        </GroupHeaderBand1>
        <DataProducts Ref="27" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2,19,0.4</ClientRectangle>
          <Components isList="true" count="4">
            <DataProducts_CategoryID Ref="28" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,4.4,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Name>DataProducts_CategoryID</Name>
              <Page isRef="23" />
              <Parent isRef="27" />
              <Text>{Products.ProductName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>DataColumn</Type>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_CategoryID>
            <DataProducts_ProductID Ref="29" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>14.6,0,2.2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Name>DataProducts_ProductID</Name>
              <Page isRef="23" />
              <Parent isRef="27" />
              <Text>{Products.ProductID}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ProductID>
            <DataProducts_ProductName Ref="30" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>16.8,0,2.2,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Name>DataProducts_ProductName</Name>
              <Page isRef="23" />
              <Parent isRef="27" />
              <Text>{Products.CategoryID}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>DataColumn</Type>
              <VertAlignment>Center</VertAlignment>
            </DataProducts_ProductName>
            <Text4 Ref="31" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>6.4,0,0,0.4</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Name>Text4</Name>
              <Page isRef="23" />
              <Parent isRef="27" />
              <Text>{Variable1 = Variable1 + Products.ProductName + "\r\n"}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text4>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>Products</DataSourceName>
          <Expressions isList="true" count="0" />
          <Filters isList="true" count="0" />
          <Name>DataProducts</Name>
          <Page isRef="23" />
          <Parent isRef="23" />
          <Sort isList="true" count="0" />
        </DataProducts>
        <GroupFooterBand1 Ref="32" type="GroupFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.2,19,2</ClientRectangle>
          <Components isList="true" count="1">
            <Text3 Ref="33" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,13.2,2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Expressions isList="true" count="0" />
              <Font>Arial,8</Font>
              <GrowToHeight>True</GrowToHeight>
              <Name>Text3</Name>
              <Page isRef="23" />
              <Parent isRef="32" />
              <Text>{Variable1}</Text>
              <TextBrush>Black</TextBrush>
            </Text3>
          </Components>
          <Conditions isList="true" count="0" />
          <Expressions isList="true" count="0" />
          <Name>GroupFooterBand1</Name>
          <Page isRef="23" />
          <Parent isRef="23" />
        </GroupFooterBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Expressions isList="true" count="0" />
      <Guid>291fd5a8f6be4a31814ffbf3c23217b2</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
    </Page1>
  </Pages>
  <ReferencedAssemblies isList="true" count="8">
    <value>System.Dll</value>
    <value>System.Drawing.Dll</value>
    <value>System.Windows.Forms.Dll</value>
    <value>System.Data.Dll</value>
    <value>System.Xml.Dll</value>
    <value>Stimulsoft.Controls.Dll</value>
    <value>Stimulsoft.Base.Dll</value>
    <value>Stimulsoft.Report.Dll</value>
  </ReferencedAssemblies>
  <ReportAlias>Report</ReportAlias>
  <ReportChanged>4/29/2024 11:01:00 AM</ReportChanged>
  <ReportCreated>4/29/2024 10:55:03 AM</ReportCreated>
  <ReportFile>E:\VariableJoinList.mrt</ReportFile>
  <ReportGuid>db73fb00ffe840ee9027587be44f486d</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2024.2.3.0</ReportVersion>
  <Script>using System;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using Stimulsoft.Controls;
using Stimulsoft.Base.Drawing;
using Stimulsoft.Report;
using Stimulsoft.Report.Dialogs;
using Stimulsoft.Report.Components;

namespace Reports
{
    public class Report : Stimulsoft.Report.StiReport
    {
        public Report()        {
            this.InitializeComponent();
        }

        #region StiReport Designer generated code - do not modify
        #endregion StiReport Designer generated code - do not modify
    }
}
</Script>
  <ScriptLanguage>CSharp</ScriptLanguage>
  <Styles isList="true" count="0" />
</StiSerializer>