﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.01" type="Net" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="1">
      <Connection Ref="2" type="Stimulsoft.Report.Dictionary.StiSqlDatabase" isKey="true">
        <Alias>Connection</Alias>
        <ConnectionString>Integrated Security=True;Initial Catalog=ReportTest;Data Source=.\sqlexpress</ConnectionString>
        <Name>Connection</Name>
      </Connection>
    </Databases>
    <DataSources isList="true" count="2">
      <MasterData Ref="3" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>MasterData</Alias>
        <Columns isList="true" count="3">
          <value>ASSIGNED_ID,System.Int32</value>
          <value>ASSIGNEE_NAME,System.String</value>
          <value>NumberOfInvoices,System.Int32</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>MasterData</Name>
        <NameInSource>Connection</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>SELECT  I.ASSIGNED_ID
	, ASSIGNEE_NAME
	, NumberOfInvoices = COUNT(I.ID)
	FROM INVOICE I
LEFT OUTER
JOIN SYS_USER_ASSIGNEE U
  ON (U.ID = I.ASSIGNED_ID)
group by I.ASSIGNED_ID, ASSIGNEE_NAME
</SqlCommand>
      </MasterData>
      <INVOICE Ref="4" type="Stimulsoft.Report.Dictionary.StiSqlSource" isKey="true">
        <Alias>INVOICE</Alias>
        <Columns isList="true" count="5">
          <value>ID,System.Int64</value>
          <value>AMOUNT,System.String</value>
          <value>DATE_CREATE,System.DateTime</value>
          <value>DATE_PAID,System.DateTime</value>
          <value>ASSIGNED_ID,System.Int64</value>
        </Columns>
        <CommandTimeout>30</CommandTimeout>
        <Dictionary isRef="1" />
        <Name>INVOICE</Name>
        <NameInSource>Connection</NameInSource>
        <Parameters isList="true" count="0" />
        <SqlCommand>select * from INVOICE</SqlCommand>
      </INVOICE>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="0" />
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="2">
    <Page1 Ref="5" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="1">
        <DataMasterData Ref="6" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.4,19,2.4</ClientRectangle>
          <Components isList="true" count="1">
            <MasterCrossTab Ref="7" type="Stimulsoft.Report.CrossTab.StiCrossTab" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>1.4,0.4,6.8,1.6</ClientRectangle>
              <Components isList="true" count="5">
                <CrossTab1_RowTotal1 Ref="8" type="CrossRowTotal" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:255]</Brush>
                  <ClientRectangle>0,0.9,2.8,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>186254bdeb724988a3b26c35c8acfc04</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_RowTotal1</Name>
                  <Page isRef="5" />
                  <Parent isRef="7" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Total</Text>
                  <TextBrush>Black</TextBrush>
                </CrossTab1_RowTotal1>
                <CrossTab1_Row1_Title Ref="9" type="CrossTitle" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>0,0.05,2.8,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>6286989348ab4a6e918837b0022d93c8</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_Row1_Title</Name>
                  <Page isRef="5" />
                  <Parent isRef="7" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Assigned</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TypeOfComponent>Row:CrossTab1_Row1</TypeOfComponent>
                </CrossTab1_Row1_Title>
                <CrossTab1_Row1 Ref="10" type="CrossRow" isKey="true">
                  <Alias>ASSIGNEE_NAME</Alias>
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>0,0.5,2.8,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <DisplayValue>{MasterData.ASSIGNEE_NAME}</DisplayValue>
                  <Font>Arial,8</Font>
                  <Guid>351183f8f2bf4fc7a453c95c585c9643</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_Row1</Name>
                  <Page isRef="5" />
                  <Parent isRef="7" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>ASSIGNEE_NAME</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TotalGuid>186254bdeb724988a3b26c35c8acfc04</TotalGuid>
                  <Value>{MasterData.ASSIGNEE_NAME}</Value>
                </CrossTab1_Row1>
                <CrossTab1_Sum1 Ref="11" type="CrossSummary" isKey="true">
                  <Alias>NumberOfInvoices</Alias>
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>[255:255:255]</Brush>
                  <ClientRectangle>2.85,0.5,2.8,0.4</ClientRectangle>
                  <Conditions isList="true" count="0" />
                  <Font>Arial,8</Font>
                  <Guid>06656c7cf5d1409f939a863aea639d95</Guid>
                  <HorAlignment>Right</HorAlignment>
                  <Interaction Ref="12" type="Stimulsoft.Report.Components.StiInteraction" isKey="true">
                    <DrillDownEnabled>True</DrillDownEnabled>
                    <DrillDownPageGuid>cc7bbf01045247ed9ba872ad51b01ba4</DrillDownPageGuid>
                  </Interaction>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_Sum1</Name>
                  <Page isRef="5" />
                  <Parent isRef="7" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>0</Text>
                  <TextBrush>Black</TextBrush>
                  <Value>{MasterData.NumberOfInvoices}</Value>
                </CrossTab1_Sum1>
                <CrossTab1_SummaryTitle Ref="13" type="CrossTitle" isKey="true">
                  <Border>All;[155:155:155];1;Solid;False;4;Black</Border>
                  <Brush>White</Brush>
                  <ClientRectangle>2.85,0.05,2.8,0.4</ClientRectangle>
                  <Font>Arial,8</Font>
                  <Guid>8838323df18d4af7b89db5bcffba3338</Guid>
                  <Margins>0,0,0,0</Margins>
                  <Name>CrossTab1_SummaryTitle</Name>
                  <Page isRef="5" />
                  <Parent isRef="7" />
                  <Restrictions>AllowMove, AllowResize, AllowSelect, AllowChange</Restrictions>
                  <Text>Invoices</Text>
                  <TextBrush>[105:105:105]</TextBrush>
                  <TypeOfComponent>SummaryTitle</TypeOfComponent>
                </CrossTab1_SummaryTitle>
              </Components>
              <Conditions isList="true" count="0" />
              <DataRelationName />
              <DataSourceName>MasterData</DataSourceName>
              <EmptyValue />
              <Filters isList="true" count="0" />
              <Name>MasterCrossTab</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Sort isList="true" count="0" />
            </MasterCrossTab>
          </Components>
          <Conditions isList="true" count="0" />
          <DataSourceName>MasterData</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataMasterData</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Sort isList="true" count="0" />
        </DataMasterData>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>e1c08695a9294eb1aef82e7e777d1770</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page1</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="14" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
    <Page2 Ref="15" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <HeaderINVOICE Ref="16" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.4,19,0.8</ClientRectangle>
          <Components isList="true" count="5">
            <HeaderINVOICE_AMOUNT Ref="17" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderINVOICE_AMOUNT</Name>
              <Page isRef="15" />
              <Parent isRef="16" />
              <Text>AMOUNT</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>
            </HeaderINVOICE_AMOUNT>
            <HeaderINVOICE_DATE_CREATE Ref="18" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>3.8,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderINVOICE_DATE_CREATE</Name>
              <Page isRef="15" />
              <Parent isRef="16" />
              <Text>DATE_CREATE</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>
            </HeaderINVOICE_DATE_CREATE>
            <HeaderINVOICE_DATE_PAID Ref="19" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>7.6,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderINVOICE_DATE_PAID</Name>
              <Page isRef="15" />
              <Parent isRef="16" />
              <Text>DATE_PAID</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>
            </HeaderINVOICE_DATE_PAID>
            <HeaderINVOICE_ID Ref="20" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>11.4,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderINVOICE_ID</Name>
              <Page isRef="15" />
              <Parent isRef="16" />
              <Text>ID</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>
            </HeaderINVOICE_ID>
            <HeaderINVOICE_ASSIGNED_ID Ref="21" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>15.2,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,10,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>HeaderINVOICE_ASSIGNED_ID</Name>
              <Page isRef="15" />
              <Parent isRef="16" />
              <Text>ASSIGNED_ID</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>
            </HeaderINVOICE_ASSIGNED_ID>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderINVOICE</Name>
          <Page isRef="15" />
          <Parent isRef="15" />
        </HeaderINVOICE>
        <DataINVOICE Ref="22" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2,19,0.8</ClientRectangle>
          <Components isList="true" count="5">
            <DataINVOICE_AMOUNT Ref="23" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>0,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataINVOICE_AMOUNT</Name>
              <Page isRef="15" />
              <Parent isRef="22" />
              <Text>{INVOICE.AMOUNT}</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>
            </DataINVOICE_AMOUNT>
            <DataINVOICE_DATE_CREATE Ref="24" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>3.8,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataINVOICE_DATE_CREATE</Name>
              <Page isRef="15" />
              <Parent isRef="22" />
              <Text>{INVOICE.DATE_CREATE}</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>
            </DataINVOICE_DATE_CREATE>
            <DataINVOICE_DATE_PAID Ref="25" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>7.6,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataINVOICE_DATE_PAID</Name>
              <Page isRef="15" />
              <Parent isRef="22" />
              <Text>{INVOICE.DATE_PAID}</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>
            </DataINVOICE_DATE_PAID>
            <DataINVOICE_ID Ref="26" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>11.4,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataINVOICE_ID</Name>
              <Page isRef="15" />
              <Parent isRef="22" />
              <Text>{INVOICE.ID}</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>
            </DataINVOICE_ID>
            <DataINVOICE_ASSIGNED_ID Ref="27" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>15.2,0,3.8,0.8</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>DataINVOICE_ASSIGNED_ID</Name>
              <Page isRef="15" />
              <Parent isRef="22" />
              <Text>{INVOICE.ASSIGNED_ID}</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>
            </DataINVOICE_ASSIGNED_ID>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>INVOICE</DataSourceName>
          <Filters isList="true" count="1">
            <value>ASSIGNED_ID,EqualTo,_x007B_MasterData.ASSIGNED_ID_x007D_,,Numeric</value>
          </Filters>
          <Name>DataINVOICE</Name>
          <Page isRef="15" />
          <Parent isRef="15" />
          <Sort isList="true" count="0" />
        </DataINVOICE>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>cc7bbf01045247ed9ba872ad51b01ba4</Guid>
      <Margins>1,1,1,1</Margins>
      <Name>Page2</Name>
      <PageHeight>29.7</PageHeight>
      <PageWidth>21</PageWidth>
      <Report isRef="0" />
      <Watermark Ref="28" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page2>
  </Pages>
  <PrinterSettings Ref="29" 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>9/5/2011 11:55:41 AM</ReportChanged>
  <ReportCreated>9/5/2011 11:11:16 AM</ReportCreated>
  <ReportFile>D:\ReportTest\Report.mrt</ReportFile>
  <ReportGuid>290fc45a8d7f4b7899c7229525958e3e</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Centimeters</ReportUnit>
  <ReportVersion>2011.1.1000</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>