﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.0" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <Databases isList="true" count="0" />
    <DataSources isList="true" count="3">
      <Orders Ref="2" 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>
      <Orders2 Ref="3" type="DataTableSource" isKey="true">
        <Alias>Orders2</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>Orders2</Name>
        <NameInSource>Demo.Orders</NameInSource>
      </Orders2>
      <Orders3 Ref="4" type="DataTableSource" isKey="true">
        <Alias>Orders3</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>Orders3</Name>
        <NameInSource>Demo.Orders</NameInSource>
      </Orders3>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="2">
      <value>,FirstDate,FirstDate,System.String,_x0030_7_x002F_04_x002F_1996,False,False</value>
      <value>,LastDate,LastDate,System.String,_x0030_7_x002F_23_x002F_1996,False,False</value>
    </Variables>
  </Dictionary>
  <GlobalizationStrings isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="5" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="4">
        <ReportTitle1 Ref="6" type="ReportTitleBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,3.6</ClientRectangle>
          <Components isList="true" count="5">
            <Text7 Ref="7" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0.2,1.6,5.8,2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>When the week starts 
according to 
the Calendar</Text>
              <TextBrush>SaddleBrown</TextBrush>
              <TextFormat Ref="8" type="GeneralFormat" isKey="true" />
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text7>
            <Text8 Ref="9" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>12.8,1.6,6,2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <Name>Text8</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>When the week ends  
the Last Date with (the Last
date of the week = LastDate)</Text>
              <TextBrush>SaddleBrown</TextBrush>
              <TextFormat Ref="10" type="GeneralFormat" isKey="true" />
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text8>
            <Text12 Ref="11" type="Text" isKey="true">
              <Border>All;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>6.4,1.6,6,2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,12,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <Name>Text12</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>When the week Starts  
from the FirstDate (First
Date of the week = FirstDate)</Text>
              <TextBrush>SaddleBrown</TextBrush>
              <TextFormat Ref="12" type="GeneralFormat" isKey="true" />
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text12>
            <Text13 Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.2,1,18.4,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,14</Font>
              <HorAlignment>Center</HorAlignment>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <Name>Text13</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>FirstDate = {FirstDate} LastDate = {LastDate}</Text>
              <TextBrush>SaddleBrown</TextBrush>
              <TextFormat Ref="14" type="GeneralFormat" isKey="true" />
              <Type>Expression</Type>
            </Text13>
            <Text14 Ref="15" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.2,0,18.4,1</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,24,Bold</Font>
              <HorAlignment>Center</HorAlignment>
              <LinesOfUnderline>None</LinesOfUnderline>
              <Margins>0,0,0,0</Margins>
              <Name>Text14</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Dividing a period by weeks</Text>
              <TextBrush>SaddleBrown</TextBrush>
              <TextFormat Ref="16" type="GeneralFormat" isKey="true" />
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </Text14>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>ReportTitle1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </ReportTitle1>
        <Container1 Ref="17" type="Container" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0.2,4.4,5.8,23.2</ClientRectangle>
          <Components isList="true" count="2">
            <GroupHeaderBand1 Ref="18" type="GroupHeaderBand" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0.4,5.8,1</ClientRectangle>
              <Components isList="true" count="1">
                <Text3 Ref="19" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0.4,5.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,14</Font>
                  <LinesOfUnderline>None</LinesOfUnderline>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text3</Name>
                  <Page isRef="5" />
                  <Parent isRef="18" />
                  <Text>Week of {Orders.OrderDate.AddDays(1-(int)Orders.OrderDate.DayOfWeek).ToString("MMMM")}, {Orders.OrderDate.AddDays(1-(int)Orders.OrderDate.DayOfWeek).Day}.</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="20" type="GeneralFormat" isKey="true" />
                  <Type>Expression</Type>
                </Text3>
              </Components>
              <Condition>{Orders.OrderDate.AddDays(1-(int)Orders.OrderDate.DayOfWeek)}</Condition>
              <Conditions isList="true" count="0" />
              <Name>GroupHeaderBand1</Name>
              <Page isRef="5" />
              <Parent isRef="17" />
            </GroupHeaderBand1>
            <DataBand1 Ref="21" type="DataBand" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,2.2,5.8,0.6</ClientRectangle>
              <Components isList="true" count="2">
                <Text2 Ref="22" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,2.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,14</Font>
                  <LinesOfUnderline>None</LinesOfUnderline>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text2</Name>
                  <Page isRef="5" />
                  <Parent isRef="21" />
                  <Text>{Orders.OrderDate.DayOfWeek}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="23" type="GeneralFormat" isKey="true" />
                </Text2>
                <Text1 Ref="24" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>2.8,0,3,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,14</Font>
                  <LinesOfUnderline>None</LinesOfUnderline>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text1</Name>
                  <Page isRef="5" />
                  <Parent isRef="21" />
                  <Text>{Orders.OrderDate.ToString("MM/dd/yyyy")}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="25" type="GeneralFormat" isKey="true" />
                </Text1>
              </Components>
              <Conditions isList="true" count="0" />
              <DataSourceName>Orders</DataSourceName>
              <Filters isList="true" count="1">
                <value>_x007B_Orders.OrderDate_x0020__x003C__x003D__x0020_DateTime.Parse_x0028_LastDate_x0029__x007D_</value>
              </Filters>
              <Name>DataBand1</Name>
              <Page isRef="5" />
              <Parent isRef="17" />
              <Sort isList="true" count="2">
                <value>ASC</value>
                <value>OrderDate</value>
              </Sort>
            </DataBand1>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>Container1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </Container1>
        <Container2 Ref="26" type="Container" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>12.8,4.4,6,23.2</ClientRectangle>
          <Components isList="true" count="2">
            <GroupHeaderBand2 Ref="27" type="GroupHeaderBand" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0.4,6,1</ClientRectangle>
              <Components isList="true" count="1">
                <Text4 Ref="28" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0.4,0.4,5.6,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,14</Font>
                  <LinesOfUnderline>None</LinesOfUnderline>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text4</Name>
                  <Page isRef="5" />
                  <Parent isRef="27" />
                  <Text>Week {4-Line}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="29" type="GeneralFormat" isKey="true" />
                  <Type>Expression</Type>
                </Text4>
              </Components>
              <Condition>{Math.Truncate(((decimal)DateTime.Parse(LastDate).Subtract(Orders3.OrderDate).Days) / 7)}</Condition>
              <Conditions isList="true" count="0" />
              <Name>GroupHeaderBand2</Name>
              <Page isRef="5" />
              <Parent isRef="26" />
              <SortDirection>None</SortDirection>
            </GroupHeaderBand2>
            <DataBand2 Ref="30" type="DataBand" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,2.2,6,0.6</ClientRectangle>
              <Components isList="true" count="2">
                <Text5 Ref="31" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,2.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,14</Font>
                  <LinesOfUnderline>None</LinesOfUnderline>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text5</Name>
                  <Page isRef="5" />
                  <Parent isRef="30" />
                  <Text>{Orders3.OrderDate.DayOfWeek}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="32" type="GeneralFormat" isKey="true" />
                  <Type>Expression</Type>
                </Text5>
                <Text6 Ref="33" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>2.8,0,2.6,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,14</Font>
                  <LinesOfUnderline>None</LinesOfUnderline>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text6</Name>
                  <Page isRef="5" />
                  <Parent isRef="30" />
                  <Text>{Orders3.OrderDate.ToString("MM/dd/yyyy")}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="34" type="GeneralFormat" isKey="true" />
                  <Type>Expression</Type>
                </Text6>
              </Components>
              <Conditions isList="true" count="0" />
              <DataSourceName>Orders3</DataSourceName>
              <Filters isList="true" count="1">
                <value>_x007B_Orders3.OrderDate_x0020__x003C__x003D__x0020_DateTime.Parse_x0028_LastDate_x0029__x007D_</value>
              </Filters>
              <Name>DataBand2</Name>
              <Page isRef="5" />
              <Parent isRef="26" />
              <Sort isList="true" count="0" />
            </DataBand2>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>Container2</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </Container2>
        <Container3 Ref="35" type="Container" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>6.4,4.4,6,23.2</ClientRectangle>
          <Components isList="true" count="2">
            <GroupHeaderBand3 Ref="36" type="GroupHeaderBand" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0.4,6,1</ClientRectangle>
              <Components isList="true" count="1">
                <Text9 Ref="37" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0.4,0.4,5.6,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,14</Font>
                  <LinesOfUnderline>None</LinesOfUnderline>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text9</Name>
                  <Page isRef="5" />
                  <Parent isRef="36" />
                  <Text>Week {Line}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="38" type="GeneralFormat" isKey="true" />
                  <Type>Expression</Type>
                </Text9>
              </Components>
              <Condition>{Math.Abs(Math.Truncate(((decimal)Orders2.OrderDate.Subtract(DateTime.Parse(FirstDate)).Days) / 7))}</Condition>
              <Conditions isList="true" count="0" />
              <Name>GroupHeaderBand3</Name>
              <Page isRef="5" />
              <Parent isRef="35" />
              <SortDirection>None</SortDirection>
            </GroupHeaderBand3>
            <DataBand3 Ref="39" type="DataBand" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,2.2,6,0.6</ClientRectangle>
              <Components isList="true" count="2">
                <Text10 Ref="40" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>0,0,2.8,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,14</Font>
                  <LinesOfUnderline>None</LinesOfUnderline>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text10</Name>
                  <Page isRef="5" />
                  <Parent isRef="39" />
                  <Text>{Orders2.OrderDate.DayOfWeek}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="41" type="GeneralFormat" isKey="true" />
                  <Type>Expression</Type>
                </Text10>
                <Text11 Ref="42" type="Text" isKey="true">
                  <Brush>Transparent</Brush>
                  <ClientRectangle>2.8,0,2.6,0.6</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,14</Font>
                  <LinesOfUnderline>None</LinesOfUnderline>
                  <Margins>0,0,0,0</Margins>
                  <Name>Text11</Name>
                  <Page isRef="5" />
                  <Parent isRef="39" />
                  <Text>{Orders2.OrderDate.ToString("MM/dd/yyyy")}</Text>
                  <TextBrush>Black</TextBrush>
                  <TextFormat Ref="43" type="GeneralFormat" isKey="true" />
                  <Type>Expression</Type>
                </Text11>
              </Components>
              <Conditions isList="true" count="0" />
              <DataSourceName>Orders2</DataSourceName>
              <Filters isList="true" count="1">
                <value>_x007B_Orders2.OrderDate_x0020__x003C__x003D__x0020_DateTime.Parse_x0028_LastDate_x0029__x007D_</value>
              </Filters>
              <Name>DataBand3</Name>
              <Page isRef="5" />
              <Parent isRef="35" />
              <Sort isList="true" count="0" />
            </DataBand3>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>Container3</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </Container3>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>51e1c922e3f54f4f9b92e12a884a604c</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <Page isRef="5" />
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="44" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="45" 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>3/30/2008 5:33:39 AM</ReportChanged>
  <ReportCreated>4/18/2007 9:17:32 AM</ReportCreated>
  <ReportGuid>347f347a5d88446795b9472b96704c40</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2007.3.100</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.ReportControls;
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>