﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.0" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <Demo Ref="2" type="Stimulsoft.Report.Dictionary.StiXmlDatabase" isKey="true">
        <Alias>Demo</Alias>
        <Name>Demo</Name>
        <PathData>E:\Demo.xml</PathData>
        <PathSchema>E:\Demo.xsd</PathSchema>
      </Demo>
    </Databases>
    <DataSources isList="true" count="9">
      <Categories Ref="3" type="DataTableSource" isKey="true">
        <Alias>Categories</Alias>
        <Columns isList="true" count="3">
          <value>CategoryID,System.Int32</value>
          <value>CategoryName,System.String</value>
          <value>Description,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <NameInSource>Demo.Categories</NameInSource>
      </Categories>
      <Countries Ref="4" type="DataTableSource" isKey="true">
        <Alias>Countries</Alias>
        <Columns isList="true" count="3">
          <value>CountriesID,System.Int32</value>
          <value>Flag,System.Byte[]</value>
          <value>CountryName,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Countries</Name>
        <NameInSource>Demo.Countries</NameInSource>
      </Countries>
      <Customers Ref="5" type="DataTableSource" isKey="true">
        <Alias>Customers</Alias>
        <Columns isList="true" count="11">
          <value>CustomerID,System.String</value>
          <value>CompanyName,System.String</value>
          <value>ContactName,System.String</value>
          <value>ContactTitle,System.String</value>
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>Region,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Country,System.String</value>
          <value>Phone,System.String</value>
          <value>Fax,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Customers</Name>
        <NameInSource>Demo.Customers</NameInSource>
      </Customers>
      <Employees Ref="6" type="DataTableSource" isKey="true">
        <Alias>Employees</Alias>
        <Columns isList="true" count="14">
          <value>EmployeeID,System.Int32</value>
          <value>LastName,System.String</value>
          <value>FirstName,System.String</value>
          <value>Title,System.String</value>
          <value>BirthDate,System.DateTime</value>
          <value>HireDate,System.DateTime</value>
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>Region,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Country,System.String</value>
          <value>HomePhone,System.String</value>
          <value>Notes,System.String</value>
          <value>ReportsTo,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <NameInSource>Demo.Employees</NameInSource>
      </Employees>
      <Order_x0020_Details Ref="7" type="DataTableSource" isKey="true">
        <Alias>Order Details</Alias>
        <Columns isList="true" count="5">
          <value>OrderID,System.Int32</value>
          <value>ProductID,System.Int32</value>
          <value>UnitPrice,System.Decimal</value>
          <value>Quantity,System.Int16</value>
          <value>Discount,System.Single</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Order Details</Name>
        <NameInSource>Demo.Order Details</NameInSource>
      </Order_x0020_Details>
      <Orders Ref="8" type="DataTableSource" isKey="true">
        <Alias>Orders</Alias>
        <Columns isList="true" count="14">
          <value>OrderID,System.Int32</value>
          <value>CustomerID,System.String</value>
          <value>EmployeeID,System.Int32</value>
          <value>OrderDate,System.DateTime</value>
          <value>RequiredDate,System.DateTime</value>
          <value>ShippedDate,System.DateTime</value>
          <value>ShipVia,System.Int32</value>
          <value>Freight,System.Decimal</value>
          <value>ShipName,System.String</value>
          <value>ShipAddress,System.String</value>
          <value>ShipCity,System.String</value>
          <value>ShipRegion,System.String</value>
          <value>ShipPostalCode,System.String</value>
          <value>ShipCountry,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Orders</Name>
        <NameInSource>Demo.Orders</NameInSource>
      </Orders>
      <Products Ref="9" type="DataTableSource" isKey="true">
        <Alias>Products</Alias>
        <Columns isList="true" count="7">
          <value>ProductID,System.Int32</value>
          <value>ProductName,System.String</value>
          <value>SupplierID,System.Int32</value>
          <value>CategoryID,System.Int32</value>
          <value>QuantityPerUnit,System.String</value>
          <value>UnitPrice,System.Decimal</value>
          <value>UnitsInStock,System.Int16</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Products</Name>
        <NameInSource>Demo.Products</NameInSource>
      </Products>
      <Shippers Ref="10" type="DataTableSource" isKey="true">
        <Alias>Shippers</Alias>
        <Columns isList="true" count="3">
          <value>ShipperID,System.Int32</value>
          <value>CompanyName,System.String</value>
          <value>Phone,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Shippers</Name>
        <NameInSource>Demo.Shippers</NameInSource>
      </Shippers>
      <Suppliers Ref="11" type="DataTableSource" isKey="true">
        <Alias>Suppliers</Alias>
        <Columns isList="true" count="12">
          <value>SupplierID,System.Int32</value>
          <value>CompanyName,System.String</value>
          <value>ContactName,System.String</value>
          <value>ContactTitle,System.String</value>
          <value>Address,System.String</value>
          <value>City,System.String</value>
          <value>Region,System.String</value>
          <value>PostalCode,System.String</value>
          <value>Country,System.String</value>
          <value>Phone,System.String</value>
          <value>Fax,System.String</value>
          <value>HomePage,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Suppliers</Name>
        <NameInSource>Demo.Suppliers</NameInSource>
      </Suppliers>
    </DataSources>
    <Relations isList="true" count="8">
      <Employees Ref="12" type="DataRelation" isKey="true">
        <Alias>Employees</Alias>
        <ChildColumns isList="true" count="1">
          <value>ReportsTo</value>
        </ChildColumns>
        <ChildSource isRef="6" />
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <NameInSource>EmployeesEmployees</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ParentColumns>
        <ParentSource isRef="6" />
      </Employees>
      <Products Ref="13" type="DataRelation" isKey="true">
        <Alias>Products</Alias>
        <ChildColumns isList="true" count="1">
          <value>ProductID</value>
        </ChildColumns>
        <ChildSource isRef="7" />
        <Dictionary isRef="1" />
        <Name>Products</Name>
        <NameInSource>ProductsOrder_Details</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>ProductID</value>
        </ParentColumns>
        <ParentSource isRef="9" />
      </Products>
      <Orders Ref="14" type="DataRelation" isKey="true">
        <Alias>Orders</Alias>
        <ChildColumns isList="true" count="1">
          <value>OrderID</value>
        </ChildColumns>
        <ChildSource isRef="7" />
        <Dictionary isRef="1" />
        <Name>Orders</Name>
        <NameInSource>OrdersOrder_Details</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>OrderID</value>
        </ParentColumns>
        <ParentSource isRef="8" />
      </Orders>
      <Customers Ref="15" type="DataRelation" isKey="true">
        <Alias>Customers</Alias>
        <ChildColumns isList="true" count="1">
          <value>CustomerID</value>
        </ChildColumns>
        <ChildSource isRef="8" />
        <Dictionary isRef="1" />
        <Name>Customers</Name>
        <NameInSource>CustomersOrders</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>CustomerID</value>
        </ParentColumns>
        <ParentSource isRef="5" />
      </Customers>
      <Shippers Ref="16" type="DataRelation" isKey="true">
        <Alias>Shippers</Alias>
        <ChildColumns isList="true" count="1">
          <value>ShipVia</value>
        </ChildColumns>
        <ChildSource isRef="8" />
        <Dictionary isRef="1" />
        <Name>Shippers</Name>
        <NameInSource>ShippersOrders</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>ShipperID</value>
        </ParentColumns>
        <ParentSource isRef="10" />
      </Shippers>
      <Employees Ref="17" type="DataRelation" isKey="true">
        <Alias>Employees</Alias>
        <ChildColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ChildColumns>
        <ChildSource isRef="8" />
        <Dictionary isRef="1" />
        <Name>Employees</Name>
        <NameInSource>EmployeesOrders</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>EmployeeID</value>
        </ParentColumns>
        <ParentSource isRef="6" />
      </Employees>
      <Categories Ref="18" type="DataRelation" isKey="true">
        <Alias>Categories</Alias>
        <ChildColumns isList="true" count="1">
          <value>CategoryID</value>
        </ChildColumns>
        <ChildSource isRef="9" />
        <Dictionary isRef="1" />
        <Name>Categories</Name>
        <NameInSource>CategoriesProducts</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>CategoryID</value>
        </ParentColumns>
        <ParentSource isRef="3" />
      </Categories>
      <Suppliers Ref="19" type="DataRelation" isKey="true">
        <Alias>Suppliers</Alias>
        <ChildColumns isList="true" count="1">
          <value>SupplierID</value>
        </ChildColumns>
        <ChildSource isRef="9" />
        <Dictionary isRef="1" />
        <Name>Suppliers</Name>
        <NameInSource>SuppliersProducts</NameInSource>
        <ParentColumns isList="true" count="1">
          <value>SupplierID</value>
        </ParentColumns>
        <ParentSource isRef="11" />
      </Suppliers>
    </Relations>
    <Report isRef="0" />
    <Variables isList="true" count="2">
      <value>,PrevValue,PrevValue,System.String,,False,False</value>
      <value>,Formula,Formula,System.String,,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="20" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <HeaderBand1 Ref="21" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="4">
            <Text2 Ref="22" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,4.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Guid>f74ee4350e4b487ca9fb9b1442ec5d61</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="20" />
              <Parent isRef="21" />
              <Text>LastName</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text2>
            <Text3 Ref="23" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>4.8,0,4.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Guid>40278bbd08944ecb8acda69182658cc8</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="20" />
              <Parent isRef="21" />
              <Text>FirstName</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text3>
            <Text4 Ref="24" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>9.2,0,4.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Guid>a80e9ab8e9c24d2c99f9be3c42fd657f</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="20" />
              <Parent isRef="21" />
              <Text>Region</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text4>
            <Text5 Ref="25" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>13.8,0,5.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8,Bold</Font>
              <Guid>37cae3fe161f42399206df7c4da77a56</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="20" />
              <Parent isRef="21" />
              <Text>Formula</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text5>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderBand1</Name>
          <Page isRef="20" />
          <Parent isRef="20" />
        </HeaderBand1>
        <DataEmployees Ref="26" type="DataBand" isKey="true">
          <AfterPrintEvent>PrevValue = Employees.Region</AfterPrintEvent>
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2,19,0.8</ClientRectangle>
          <Components isList="true" count="4">
            <DataEmployees_LastName Ref="27" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,4.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataEmployees_LastName</Name>
              <Page isRef="20" />
              <Parent isRef="26" />
              <Text>{Employees.LastName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataEmployees_LastName>
            <DataEmployees_FirstName Ref="28" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>4.8,0,4.4,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataEmployees_FirstName</Name>
              <Page isRef="20" />
              <Parent isRef="26" />
              <Text>{Employees.FirstName}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataEmployees_FirstName>
            <DataEmployees_Region Ref="29" type="Text" isKey="true">
              <BeforePrintEvent>If (PrevValue &lt;&gt; "") Then
	Formula = "Hello" 
Else
	Formula = ""
End If </BeforePrintEvent>
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>9.2,0,4.6,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataEmployees_Region</Name>
              <Page isRef="20" />
              <Parent isRef="26" />
              <Text>{Employees.Region}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <VertAlignment>Center</VertAlignment>
            </DataEmployees_Region>
            <Text1 Ref="30" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>13.8,0,5.2,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>e4361273dedf412db44cf5ab01b009ff</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="20" />
              <Parent isRef="26" />
              <Text>{Formula}</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>HotkeyPrefix=None, LineLimit=False, RightToLeft=False, Trimming=None, WordWrap=True, Angle=0, FirstTabOffset=40, DistanceBetweenTabs=20,</TextOptions>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>Employees</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataEmployees</Name>
          <Page isRef="20" />
          <Parent isRef="20" />
          <Sort isList="true" count="0" />
        </DataEmployees>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>6f34cf301f244fcfa611b742f09c2618</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="31" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="32" type="Stimulsoft.Report.Print.StiPrinterSettings" isKey="true" />
  <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/11/2011 10:40:36 AM</ReportChanged>
  <ReportCreated>4/11/2011 10:24:41 AM</ReportCreated>
  <ReportFile />
  <ReportGuid>89791524fe39491a8e9541c1f4485b67</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2011.1.1000</ReportVersion>
  <Script>Imports System
Imports System.Drawing
Imports System.Windows.Forms
Imports System.Data
Imports Stimulsoft.Controls
Imports Stimulsoft.Base.Drawing
Imports Stimulsoft.Report
Imports Stimulsoft.Report.Dialogs
Imports Stimulsoft.Report.Components

Namespace Reports
    Public Class Report
        Inherits Stimulsoft.Report.StiReport

        Public Sub New()
            MyBase.New
            Me.InitializeComponent
        End Sub

        #Region "StiReport Designer generated code - do not modify"
        #End Region 'StiReport Designer generated code - do not modify
    End Class
End Namespace
</Script>
  <ScriptLanguage>VB</ScriptLanguage>
  <Styles isList="true" count="0" />
</StiSerializer>