﻿<?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="41">
          <value>Customer_x0020_Number,System.Int32</value>
          <value>Customer_x0020_Name_x0020__x0028_Firm_x0020_or_x0020_Full_x0020_Name_x0029_,System.String</value>
          <value>Policy_x0020_Number,System.String</value>
          <value>Policy_x0020_Effective_x0020_Date,System.DateTime</value>
          <value>Policy_x0020_Expiration_x0020_Date,System.DateTime</value>
          <value>Policy_x0020_Information_x0020_Policy_x0020_ID,System.Guid</value>
          <value>Customer_x0020_Open_x0020_Policy_x0020_Count,System.Int32</value>
          <value>Customer_x0020_State_x0020_Description,System.String</value>
          <value>Invoice_x0020_Number,System.Int32</value>
          <value>Invoice_x0020_Production_x0020_Reporting_x0020_Date,System.DateTime</value>
          <value>Invoice_x0020_Transaction_x0020_Agency_x0020_Commission_x0020_Amount,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Broker_x0020_Commission_x0020_Amount,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Charge_x0020_Category,System.String</value>
          <value>Invoice_x0020_Transaction_x0020_Charge_x0020_Code_x0020_Description,System.String</value>
          <value>Invoice_x0020_Transaction_x0020_Down-Payment_x0020_Volume,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Exec_x0020_Non-Premium_x0020_Commission_x0020_Amount,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Exec_x0020_Premium_x0020_Commission_x0020_Amount,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Financed_x0020_Volume,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Gross_x0020_Amount,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_ID,System.Guid</value>
          <value>Invoice_x0020_Transaction_x0020_Line_x0020_of_x0020_Business,System.String</value>
          <value>Invoice_x0020_Transaction_x0020_Non-Premium_x0020_Volume,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Premium_x0020_Volume,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Rep_x0020_Commission_x0020_Amount,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Sales_x0020_Commission_x0020_Amount,System.Decimal</value>
          <value>Invoice_x0020_Transaction_x0020_Type_x0020_Description,System.String</value>
          <value>Invoice_x0020_Type,System.Int16</value>
          <value>Policy_x0020_Account_x0020_Exec_x0020_Name,System.String</value>
          <value>Policy_x0020_Account_x0020_Rep_x0020_Name,System.String</value>
          <value>Policy_x0020_GL_x0020_Dept_x0020_General_x0020_Ledger_x0020_Department_x0020_Name,System.String</value>
          <value>Policy_x0020_GL_x0020_Div_x0020_General_x0020_Ledger_x0020_Division_x0020_Name,System.String</value>
          <value>Policy_x0020_Line_x0020_of_x0020_Business,System.String</value>
          <value>Policy_x0020_Location_x0020_State,System.String</value>
          <value>Policy_x0020_Parent_x0020_Company_x0020_Name,System.String</value>
          <value>Policy_x0020_Type_x0020_Of_x0020_Business_x0020_Description,System.String</value>
          <value>Policy_x0020_Writing_x0020_Company_x0020_Name,System.String</value>
          <value>Policy_x0020_Production_x0020_Report_x0020_Run_x0020_-_x0020_Internal_x0020_Use_x0020_Only,System.String</value>
          <value>Invoice_x0020_Production_x0020_Display_x0020_Date,System.DateTime</value>
          <value>Invoice_x0020_Transaction_x0020_Type,System.String</value>
          <value>Customer_x0020_Broker_x0020_Name,System.String</value>
          <value>Policy_x0020_Line_x0020_of_x0020_Business_x0020_Code,System.String</value>
        </Columns>
        <Dictionary isRef="1" />
        <Key>e355e88fd5fc4490ba92e7f672a6c768</Key>
        <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" />
        <Key>446c462d79d04be88d62d7f294c5d97c</Key>
        <Name>Table</Name>
        <NameInSource>QueryPlusMetaDataSet.Table</NameInSource>
      </Table>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Resources isList="true" count="0" />
    <Variables isList="true" count="96">
      <value>,VI2,VI2,YTD_x0020_Start,System.String,_x0031__x002F_1_x002F_2022,True,False,False,False</value>
      <value>,VI3,VI3,YTD_x0020_End,System.String,_x0036__x002F_30_x002F_2022,True,False,False,False</value>
      <value>,VI4,VI4,TTM_x0020_Start,System.String,_x0037__x002F_1_x002F_2021,True,False,False,False</value>
      <value>,VI5,VI5,TTM_x0020_End,System.String,_x0036__x002F_30_x002F_2022,True,False,False,False</value>
      <value>,VI6,VI6,LM_x0020_Start,System.String,_x0037__x002F_1_x002F_2022,True,False,False,False</value>
      <value>,VI7,VI7,LM_x0020_End,System.String,_x0037__x002F_1_x002F_2022,True,False,False,False</value>
      <value>,VF4,VF4,tier_x0020_1_x0020_hurdle_x0020_Y,System.Decimal,_x0033_00000,True,False,False,False</value>
      <value>,VF5,VF5,tier_x0020_2_x0020_Hurdle_x0020_Y,System.Decimal,_x0036_00000,True,False,False,False</value>
      <value>,VF7,VF7,tier_x0020_1_x0020_hurle_x0020_M,System.Decimal,_x0032_5000,True,False,False,False</value>
      <value>,VF8,VF8,tier_x0020_2_x0020_hurdle_x0020_M,System.Decimal,_x0035_0000,True,False,False,False</value>
      <value>,VB2,VB2,,System.Decimal,,False,False,False,False</value>
      <value>,VB3,VB3,,System.Double,,True,False,False,False</value>
      <value>,VB4,VB4,,System.Double,,True,False,False,False</value>
      <value>,VB5,VB5,,System.Double,,True,False,False,False</value>
      <value>,VB7,VB7,,System.Double,,True,False,False,False</value>
      <value>,VB8,VB8,,System.Double,,True,False,False,False</value>
      <value>,VB9,VB9,,System.Double,,True,False,False,False</value>
      <value>,VB10,VB10,,System.Double,,True,False,False,False</value>
      <value>,VB12,VB12,,System.Double,,True,False,False,False</value>
      <value>,VB13,VB13,,System.Double,,True,False,False,False</value>
      <value>,VB14,VB14,,System.Double,,True,False,False,False</value>
      <value>,VB15,VB15,,System.Double,,True,False,False,False</value>
      <value>,VC3,VC3,,System.Double,,True,False,False,False</value>
      <value>,VC4,VC4,,System.Double,,True,False,False,False</value>
      <value>,VC8,VC8,,System.Double,,True,False,False,False</value>
      <value>,VC9,VC9,,System.Double,,True,False,False,False</value>
      <value>,VC13,VC13,,System.Double,,True,False,False,False</value>
      <value>,VC14,VC14,,System.Double,,True,False,False,False</value>
      <value>,VB21,VB21,,System.Double,,True,False,False,False</value>
      <value>,VB22,VB22,,System.Double,,True,False,False,False</value>
      <value>,VB23,VB23,,System.Double,,True,False,False,False</value>
      <value>,VB24,VB24,,System.Double,,True,False,False,False</value>
      <value>,VB25,VB25,,System.Double,,True,False,False,False</value>
      <value>,VC21,VC21,,System.Double,,True,False,False,False</value>
      <value>,VC22,VC22,,System.Double,,True,False,False,False</value>
      <value>,VC23,VC23,,System.Double,,True,False,False,False</value>
      <value>,VC24,VC24,,System.Double,,True,False,False,False</value>
      <value>,VD21,VD21,,System.Double,,True,False,False,False</value>
      <value>,VD22,VD22,,System.Double,,True,False,False,False</value>
      <value>,VD23,VD23,,System.Double,,True,False,False,False</value>
      <value>,VD24,VD24,,System.Double,,True,False,False,False</value>
      <value>,VE21,VE21,,System.Double,,True,False,False,False</value>
      <value>,VE22,VE22,,System.Double,,True,False,False,False</value>
      <value>,VE23,VE23,,System.Double,,True,False,False,False</value>
      <value>,VE24,VE24,,System.Double,,True,False,False,False</value>
      <value>,VB32,VB32,,System.Double,,True,False,False,False</value>
      <value>,VB33,VB33,,System.Double,,True,False,False,False</value>
      <value>,VC32,VC32,,System.Double,,True,False,False,False</value>
      <value>,VC33,VC33,,System.Double,,True,False,False,False</value>
      <value>,VD32,VD32,,System.Double,,True,False,False,False</value>
      <value>,VD33,VD33,,System.Double,,True,False,False,False</value>
      <value>,VE32,VE32,,System.Double,,True,False,False,False</value>
      <value>,VE33,VE33,,System.Double,,True,False,False,False</value>
      <value>,VF32,VF32,,System.Double,,True,False,False,False</value>
      <value>,VB39,VB39,,System.Double,,True,False,False,False</value>
      <value>,VB40,VB40,,System.Double,,True,False,False,False</value>
      <value>,VC39,VC39,,System.Double,,True,False,False,False</value>
      <value>,VC40,VC40,,System.Double,,True,False,False,False</value>
      <value>,VD39,VD39,,System.Double,,True,False,False,False</value>
      <value>,VD40,VD40,,System.Double,,True,False,False,False</value>
      <value>,VE39,VE39,,System.Double,,True,False,False,False</value>
      <value>,VE40,VE40,,System.Double,,True,False,False,False</value>
      <value>,VF39,VF39,,System.Double,,True,False,False,False</value>
      <value>,VB46,VB46,,System.Double,,True,False,False,False</value>
      <value>,VB47,VB47,,System.Double,,True,False,False,False</value>
      <value>,VC46,VC46,,System.Double,,True,False,False,False</value>
      <value>,VC47,VC47,,System.Double,,True,False,False,False</value>
      <value>,VD46,VD46,,System.Double,,True,False,False,False</value>
      <value>,VD47,VD47,,System.Double,,True,False,False,False</value>
      <value>,VE46,VE46,,System.Double,,True,False,False,False</value>
      <value>,VE47,VE47,,System.Double,,True,False,False,False</value>
      <value>,VF46,VF46,,System.Double,,True,False,False,False</value>
      <value>,VB53,VB53,,System.Double,,True,False,False,False</value>
      <value>,VB54,VB54,,System.Double,,True,False,False,False</value>
      <value>,VC53,VC53,,System.Double,,True,False,False,False</value>
      <value>,VC54,VC54,,System.Double,,True,False,False,False</value>
      <value>,VD53,VD53,,System.Double,,True,False,False,False</value>
      <value>,VD54,VD54,,System.Double,,True,False,False,False</value>
      <value>,VE53,VE53,,System.Double,,True,False,False,False</value>
      <value>,VE54,VE54,,System.Double,,True,False,False,False</value>
      <value>,VF53,VF53,,System.Double,,True,False,False,False</value>
      <value>,VB30,VB30,_x0031_0_x0025_,System.Double,_x002E_1,True,False,False,False</value>
      <value>,VC30,VC30,_x0033_0_x0025_,System.Double,_x002E_3,True,False,False,False</value>
      <value>,VD30,VD30,_x0033_5_x0025_,System.Double,_x002E_35,True,False,False,False</value>
      <value>,VB37,VB37,_x0031_0_x0025_,System.Double,_x002E_1,True,False,False,False</value>
      <value>,VC37,VC37,_x0033_0_x0025_,System.Double,_x002E_3,True,False,False,False</value>
      <value>,VD37,VD37,_x0033_5_x0025_,System.Double,_x002E_35,True,False,False,False</value>
      <value>,VB44,VB44,_x0031_0_x0025_,System.Double,_x002E_1,True,False,False,False</value>
      <value>,VC44,VC44,_x0033_0_x0025_,System.Double,_x002E_3,True,False,False,False</value>
      <value>,VD44,VD44,_x0033_5_x0025_,System.Double,_x002E_35,True,False,False,False</value>
      <value>,VB51,VB51,_x0031_0_x0025_,System.Double,_x002E_1,True,False,False,False</value>
      <value>,VC51,VC51,_x0033_0_x0025_,System.Double,_x002E_3,True,False,False,False</value>
      <value>,VD51,VD51,_x0033_5_x0025_,System.Double,_x002E_35,True,False,False,False</value>
      <value>,VB19,VB19,,System.Double,,True,False,False,False</value>
      <value>,VC19,VC19,,System.Double,,True,False,False,False</value>
      <value>,VD19,VD19,,System.Double,,True,False,False,False</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <Key>ba709443d94e49d2baafedc92f79ab03</Key>
  <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="3">
        <PageHeaderBand1 Ref="5" type="PageHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.72,0.7</ClientRectangle>
          <Components isList="true" count="1">
            <Text_138 Ref="6" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>3,0,4.7,0.6</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,24,Bold</Font>
              <Guid>6972893c00114473afa69c1f37f3718e</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>Text_138</Name>
              <Page isRef="4" />
              <Parent isRef="5" />
              <Text>COMMISSION STATEMENT</Text>
              <TextBrush>Black</TextBrush>
              <TextOptions>,,,,WordWrap=True,A=0</TextOptions>
              <Type>Expression</Type>
            </Text_138>
          </Components>
          <Conditions isList="true" count="0" />
          <Name>PageHeaderBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
        </PageHeaderBand1>
        <GroupHeaderBand1 Ref="7" type="GroupHeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,1.3,7.72,8.5</ClientRectangle>
          <Components isList="true" count="4">
            <Text_1 Ref="8" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,2.2,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>f56e3f34b69f4854bb1dab54b9869359</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text_1</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>{QueryResults.Policy_Account_Exec_Name}</Text>
              <TextBrush>Black</TextBrush>
              <Type>Expression</Type>
            </Text_1>
            <B3 Ref="9" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.4,0.7,3.8,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>dc8bf454db6b43d2a5c79f6ff9bf2236</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>B3</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>{VB2 = Sum(DataBand1,QueryResults.Invoice_Transaction_Gross_Amount)}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="10" type="CurrencyFormat" isKey="true">
                <DecimalDigits>2</DecimalDigits>
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>0</NegativePattern>
                <PositivePattern>0</PositivePattern>
              </TextFormat>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </B3>
            <Text_3 Ref="11" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.4,1.1,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Margins>0,0,0,0</Margins>
              <Name>Text_3</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>{VB2}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="12" type="NumberFormat" isKey="true">
                <DecimalDigits>2</DecimalDigits>
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>1</NegativePattern>
              </TextFormat>
              <Type>Expression</Type>
            </Text_3>
            <Text_4 Ref="13" type="Text" isKey="true">
              <Brush>Transparent</Brush>
              <ClientRectangle>2.4,0.3,3.5,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,8</Font>
              <Guid>eb726c0c97a043298e21deae4976cf81</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>Text_4</Name>
              <Page isRef="4" />
              <Parent isRef="7" />
              <Text>{Sum(DataBand1,QueryResults.Invoice_Transaction_Gross_Amount)}</Text>
              <TextBrush>Black</TextBrush>
              <TextFormat Ref="14" type="NumberFormat" isKey="true">
                <DecimalDigits>2</DecimalDigits>
                <GroupSeparator>,</GroupSeparator>
                <NegativePattern>1</NegativePattern>
              </TextFormat>
              <Type>Expression</Type>
            </Text_4>
          </Components>
          <Condition>{QueryResults.Policy_Account_Exec_Name}</Condition>
          <Conditions isList="true" count="0" />
          <Name>GroupHeaderBand1</Name>
          <NewPageBefore>True</NewPageBefore>
          <Page isRef="4" />
          <Parent isRef="4" />
        </GroupHeaderBand1>
        <DataBand1 Ref="15" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,10.2,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" />
          <Guid>ce1696da8cb247b0a1550300fa8b5e81</Guid>
          <Name>DataBand1</Name>
          <Page isRef="4" />
          <Parent isRef="4" />
          <Sort isList="true" count="0" />
        </DataBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>093ef69c90dd484eb27bab4aff39f6de</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" />
    </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>1/1/2023 10:20:13 PM</ReportChanged>
  <ReportCreated>6/24/2014 10:33:37 AM</ReportCreated>
  <ReportFile>C:\Users\dd_sm\AppData\Local\Temp\Compensation Report 1.mrt</ReportFile>
  <ReportGuid>621e918b4ca947e4a9e9167b12a88d0d</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2019.3.1.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> 