﻿<?xml version="1.0" encoding="utf-8" standalone="yes"?>
<StiSerializer version="1.02" type="Net" application="StiReport">
  <Dictionary Ref="1" type="Dictionary" isKey="true">
    <BusinessObjects isList="true" count="0" />
    <Databases isList="true" count="0" />
    <DataSources isList="true" count="2">
      <QueryResults Ref="2" type="DataTableSource" isKey="true">
        <Alias>QueryResults</Alias>
        <Columns isList="true" count="13">
          <value>Policy_x0020_Type_x0020_Of_x0020_Business_x0020_Description,System.String</value>
          <value>Policy_x0020_Account_x0020_Rep_x0020_Employee_x0020_First_x0020_Name,System.String</value>
          <value>Policy_x0020_Parent_x0020_Company_x0020_Name,System.String</value>
          <value>Customer_x0020_Name_x0020_w_x002F_Sp_x0020_Char,System.String</value>
          <value>Invoice_x0020_Transaction_x0020_Agency_x0020_Commission_x0020_Amount,System.Decimal</value>
          <value>Invoice_x0020_Production_x0020_Reporting_x0020_Date_x0020_with_x0020_Invoice_x0020_Transaction_x0020_GL_x0020_Date,System.DateTime</value>
          <value>Invoice_x0020_Transaction_x0020_Type_x0020_Description,System.String</value>
          <value>Policy_x0020_Effective_x0020_Date,System.DateTime</value>
          <value>Customer_x0020_Name_x0020_First_x0020_Letter,System.String</value>
          <value>Invoice_x0020_Transaction_x0020_Premium_x0020_Volume,System.Decimal</value>
          <value>Policy_x0020_Account_x0020_Rep_x0020_Employee_x0020_Last_x0020_Name,System.String</value>
          <value>Policy_x0020_Line_x0020_of_x0020_Business,System.String</value>
          <value>Policy_x0020_Account_x0020_Rep_x0020_Name,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>QueryResults</Name>
        <NameInSource>QueryPlusDataSet.QueryResults</NameInSource>
      </QueryResults>
      <Table Ref="3" type="DataTableSource" isKey="true">
        <Alias>Table</Alias>
        <Columns isList="true" count="9">
          <value>AgencyName,System.String</value>
          <value>addr1,System.String</value>
          <value>addr2,System.String</value>
          <value>city,System.String</value>
          <value>state,System.String</value>
          <value>zipcode,System.String</value>
          <value>divdeptname,System.String</value>
          <value>email,System.String</value>
          <value>webaddr,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Table</Name>
        <NameInSource>QueryPlusMetaDataSet.Table</NameInSource>
      </Table>
    </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="1">
    <Page1 Ref="4" type="Page" isKey="true">
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="8">
        <ReportTitleBand1 Ref="5" type="ReportTitleBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.72,0.7</ClientRectangle>
          <Components isList="true" count="1">
            <Text1 Ref="6" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,7.7,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,19</Font>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text1</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>SSD - PL Dashboard
By Alpha Split</Text>
              <TextBrush>[79:129:189]</TextBrush>
              <Type>Expression</Type>
            </Text1>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>ReportTitleBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </ReportTitleBand1>
        <HeaderBand1 Ref="7" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.3,7.72,0.2</ClientRectangle>
          <Components isList="true" count="4">
            <Text5 Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.5,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold| Underline</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text5</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>Transaction</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text5>
            <Text6 Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>4,0,0.7,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold| Underline</Font>
              <Guid>995e5b9b64b94427b75aa024734966ee</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text6</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>Premium</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text6>
            <Text7 Ref="10" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>5,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold| Underline</Font>
              <Guid>86c98a9942cb4bd1afee5237734398f2</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text7</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>Commission</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text7>
            <Text3 Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.2,0,1.4,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold| Underline</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text3</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>Policy Account Rep Name</Text>
              <TextBrush>Black</TextBrush>
            </Text3>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>HeaderBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </HeaderBand1>
        <GroupHeaderBand1 Ref="12" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.9,7.72,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Condition>{QueryResults.Policy_Account_Rep_Name}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupHeaderBand1>
        <GroupHeaderBand2 Ref="13" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,2.3,7.72,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Condition>{QueryResults.Customer_Name_First_Letter}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand2</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupHeaderBand2>
        <DataBand2 Ref="14" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,2.7,7.72,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>QueryResults</DataSourceName>
          <Filters isList="true" count="0" />
          <Name>DataBand2</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </DataBand2>
        <GroupFooterBand2 Ref="15" type="GroupFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.1,7.72,0</ClientRectangle>
          <Components isList="true" count="0" />
          <Conditions isList="true" count="0" />
          <Name>GroupFooterBand2</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupFooterBand2>
        <GroupFooterBand1 Ref="16" type="GroupFooterBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,3.5,7.72,0.3</ClientRectangle>
          <Components isList="true" count="4">
            <Text2 Ref="17" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0.2,0,1.7,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text2</Name>
              <Page isRef="4" />
              <Parent isRef="16" />
              <Text>{QueryResults.Policy_Account_Rep_Name}</Text>
              <TextBrush>Black</TextBrush>
            </Text2>
            <Text4 Ref="18" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>3.7,0,1.2,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text4</Name>
              <Page isRef="4" />
              <Parent isRef="16" />
              <Text>{QueryResults.Invoice_Transaction_Premium_Volume}</Text>
              <TextBrush>Black</TextBrush>
            </Text4>
            <Text11 Ref="19" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.3,0,1.1,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text11</Name>
              <Page isRef="4" />
              <Parent isRef="16" />
              <Text>{QueryResults.Customer_Name_First_Letter}</Text>
              <TextBrush>Black</TextBrush>
            </Text11>
            <Text12 Ref="20" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>5.3,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text12</Name>
              <Page isRef="4" />
              <Parent isRef="16" />
              <Text>{QueryResults.Invoice_Transaction_Agency_Commission_Amount}</Text>
              <TextBrush>Black</TextBrush>
            </Text12>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>GroupFooterBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupFooterBand1>
        <ReportSummaryBand1 Ref="21" type="ReportSummaryBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,4.2,7.72,0.3</ClientRectangle>
          <Components isList="true" count="3">
            <Text8 Ref="22" type="Text" isKey="true">
              <Border>Top;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>2.9,0,1.2,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>161a2c82c17e4876868f9c94f342d24c</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text8</Name>
              <Page isRef="4" />
              <Parent isRef="21" />
              <Text>{Sum(QueryResults.Invoice_Transaction_Premium_Volume)}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="23" type="NumberFormat" isKey="true">
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>1</NegativePattern>
              </TextFormat>
              <Type>Expression</Type>
            </Text8>
            <Text9 Ref="24" type="Text" isKey="true">
              <Border>Top;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>4.4,0,1.5,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>19af5d8b456e48c7811329570672c3dc</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text9</Name>
              <Page isRef="4" />
              <Parent isRef="21" />
              <Text>{Sum(QueryResults.Invoice_Transaction_Agency_Commission_Amount)}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="25" type="NumberFormat" isKey="true">
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>1</NegativePattern>
              </TextFormat>
              <Type>Expression</Type>
            </Text9>
            <Text10 Ref="26" type="Text" isKey="true">
              <Border>Top;Black;1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0.4,0,0.6,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text10</Name>
              <Page isRef="4" />
              <Parent isRef="21" />
              <Text>Total</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text10>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>ReportSummaryBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </ReportSummaryBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>da26a49ec2a243ce8d8fb6f5df15b1ff</Guid>
      <Margins>0.39,0.39,0.39,0.39</Margins>
      <Name>Page1</Name>
      <PageHeight>11</PageHeight>
      <PageWidth>8.5</PageWidth>
      <PaperSize>Letter</PaperSize>
      <Report isRef="0" />
      <Watermark Ref="27" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="28" 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>7/7/2014 2:23:17 PM</ReportChanged>
  <ReportCreated>6/23/2014 4:50:30 PM</ReportCreated>
  <ReportFile>C:\Users\ksimmons\AppData\Local\Temp\SSD - TEST.mrt</ReportFile>
  <ReportGuid>65466d10d43643f88dffb4b2d751ae46</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2013.3.1800</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> 