﻿<?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="1">
      <Connection Ref="2" type="Stimulsoft.Report.Dictionary.StiXmlDatabase" isKey="true">
        <Alias>Connection</Alias>
        <Name>Connection</Name>
        <PathData>E:\DOWNLOAD\Test.xml</PathData>
        <PathSchema />
      </Connection>
    </Databases>
    <DataSources isList="true" count="2">
      <Company Ref="3" type="DataTableSource" isKey="true">
        <Alias>Company</Alias>
        <Columns isList="true" count="11">
          <value>Record,System.SByte</value>
          <value>CompanyName,System.String</value>
          <value>State,System.String</value>
          <value>AMBest,System.String</value>
          <value>RenderAMBest,System.SByte</value>
          <value>SandP,System.String</value>
          <value>Moody,System.String</value>
          <value>Fitch,System.String</value>
          <value>Weiss,System.String</value>
          <value>Comdex,System.String</value>
          <value>VS32_Id,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>Company</Name>
        <NameInSource>Connection.Company</NameInSource>
      </Company>
      <VS32 Ref="4" type="DataTableSource" isKey="true">
        <Alias>VS32</Alias>
        <Columns isList="true" count="20">
          <value>RptVersion,System.String</value>
          <value>DataDate,System.String</value>
          <value>RateDate,System.String</value>
          <value>AgentInfo,System.String</value>
          <value>AMBestSkip,System.SByte</value>
          <value>SandPSkip,System.SByte</value>
          <value>MoodySkip,System.SByte</value>
          <value>FitchSkip,System.SByte</value>
          <value>WeissSkip,System.SByte</value>
          <value>ComdexSkip,System.SByte</value>
          <value>CompanyShade,System.SByte</value>
          <value>StateShade,System.SByte</value>
          <value>AMBestShade,System.SByte</value>
          <value>SandPShade,System.SByte</value>
          <value>MoodyShade,System.SByte</value>
          <value>FitchShade,System.SByte</value>
          <value>WeissShade,System.SByte</value>
          <value>ComdexShade,System.SByte</value>
          <value>OutlookFootnote,System.String</value>
          <value>VS32_Id,System.Int32</value>
        </Columns>
        <Dictionary isRef="1" />
        <Name>VS32</Name>
        <NameInSource>Connection.VS32</NameInSource>
      </VS32>
    </DataSources>
    <Relations isList="true" count="0" />
    <Report isRef="0" />
    <Variables isList="true" count="4">
      <value>,Rating1,Rating1,,System.Boolean,true,False,False,True</value>
      <value>,Rating2,Rating2,,System.Boolean,true,False,False,True</value>
      <value>,Rating3,Rating3,,System.Boolean,true,False,False,True</value>
      <value>,Rating4,Rating4,,System.Boolean,true,False,False,True</value>
    </Variables>
  </Dictionary>
  <EngineVersion>EngineV2</EngineVersion>
  <GlobalizationStrings isList="true" count="0" />
  <MetaTags isList="true" count="0" />
  <Pages isList="true" count="1">
    <Page1 Ref="5" type="Page" isKey="true">
      <BeforePrintEvent>headerRating1.Enabled = Rating1;
textRating1.Enabled = Rating1;
headerRating2.Enabled = Rating2;
textRating2.Enabled = Rating2;
headerRating3.Enabled = Rating3;
textRating3.Enabled = Rating3;
headerRating4.Enabled = Rating4;
textRating4.Enabled = Rating4;

foreach (StiComponent comp in DataBand1.Components)
{
	if (!comp.Enabled)
	{
		headerProductName.Width += comp.Width;
		textProductName.Width += comp.Width;
	}
}</BeforePrintEvent>
      <Border>None;Black;2;Solid;False;4;Black</Border>
      <Brush>Transparent</Brush>
      <Components isList="true" count="2">
        <HeaderBand1 Ref="6" type="HeaderBand" isKey="true">
          <Brush>Transparent</Brush>
          <ClientRectangle>0,0.2,7.72,0.3</ClientRectangle>
          <Components isList="true" count="7">
            <headerCategoryID Ref="7" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>0,0,0.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>486b8116a7af429391e541491de9f277</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>headerCategoryID</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Category ID</Text>
              <TextBrush>[193:152:89]</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>
            </headerCategoryID>
            <headerProductID Ref="8" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>0.9,0,0.8,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>29294b3f8e14417ba97376df277e4e45</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>headerProductID</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Product ID</Text>
              <TextBrush>[193:152:89]</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>
            </headerProductID>
            <headerProductName Ref="9" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>1.7,0,2.42,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9,Bold</Font>
              <Guid>e9e60a14bd924ea9831ec065a226656e</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>headerProductName</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Product Name</Text>
              <TextBrush>[193:152:89]</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>
            </headerProductName>
            <headerRating4 Ref="10" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>6.82,0,0.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DockStyle>Right</DockStyle>
              <Font>Arial,9,Bold</Font>
              <Guid>efba7fd170784d988c81ae0c1760932c</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>headerRating4</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Rating 4</Text>
              <TextBrush>[193:152:89]</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>
            </headerRating4>
            <headerRating3 Ref="11" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>5.92,0,0.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DockStyle>Right</DockStyle>
              <Font>Arial,9,Bold</Font>
              <Guid>37e45f5c8f5c4fbe90d883fd4b85e263</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>headerRating3</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Rating 3</Text>
              <TextBrush>[193:152:89]</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>
            </headerRating3>
            <headerRating2 Ref="12" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <ClientRectangle>5.02,0,0.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DockStyle>Right</DockStyle>
              <Font>Arial,9,Bold</Font>
              <Guid>a31a80df6e614cc3850009a8df79743b</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>headerRating2</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>Rating 2</Text>
              <TextBrush>[193:152:89]</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>
            </headerRating2>
            <headerRating1 Ref="13" type="Text" isKey="true">
              <Border>All;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>[242:234:221]</Brush>
              <CanGrow>True</CanGrow>
              <ClientRectangle>4.12,0,0.9,0.3</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DockStyle>Right</DockStyle>
              <Font>Arial,9,Bold</Font>
              <Guid>43294360b601445e8e7bca0c7786ef18</Guid>
              <HorAlignment>Center</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>headerRating1</Name>
              <Page isRef="5" />
              <Parent isRef="6" />
              <Text>{IIF(VS32.AMBestSkip == 1, "", "Rating 1")}</Text>
              <TextBrush>[193:152:89]</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>
            </headerRating1>
          </Components>
          <Conditions isList="true" count="0" />
          <Guid>dac56ebba7374a2db2e90e874ec4b206</Guid>
          <Name>HeaderBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
        </HeaderBand1>
        <DataBand1 Ref="14" type="DataBand" isKey="true">
          <Brush>Transparent</Brush>
          <BusinessObjectGuid isNull="true" />
          <ClientRectangle>0,0.9,7.72,0.2</ClientRectangle>
          <Components isList="true" count="7">
            <textCategoryID Ref="15" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>ed3458bd7363478896e1d9bc97e8b711</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>textCategoryID</Name>
              <Page isRef="5" />
              <Parent isRef="14" />
              <Text>{Company.Record}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </textCategoryID>
            <textProductID Ref="16" type="Text" isKey="true">
              <Border>None;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>0.9,0,0.8,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>0b3f54c640114a66a8e31bc8e1327138</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>textProductID</Name>
              <Page isRef="5" />
              <Parent isRef="14" />
              <Text>{Company.State}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <Type>DataColumn</Type>
              <VertAlignment>Center</VertAlignment>
            </textProductID>
            <textProductName Ref="17" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>1.7,0,2.42,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <Font>Arial,9</Font>
              <Guid>85d60ff83f8a48c4a72d93086b64273f</Guid>
              <Margins>0,0,0,0</Margins>
              <Name>textProductName</Name>
              <Page isRef="5" />
              <Parent isRef="14" />
              <Text>{Company.CompanyName}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <Type>DataColumn</Type>
              <VertAlignment>Center</VertAlignment>
            </textProductName>
            <textRating4 Ref="18" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>6.82,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DockStyle>Right</DockStyle>
              <Font>Arial,9</Font>
              <Guid>6a3485c2df454a01bf88c1fc2b1df8cb</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>textRating4</Name>
              <Page isRef="5" />
              <Parent isRef="14" />
              <Text>{Company.Fitch}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </textRating4>
            <textRating3 Ref="19" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>5.92,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DockStyle>Right</DockStyle>
              <Font>Arial,9</Font>
              <Guid>59d4508942364a859c1d11d14afe3400</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>textRating3</Name>
              <Page isRef="5" />
              <Parent isRef="14" />
              <Text>{Company.Moody}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </textRating3>
            <textRating2 Ref="20" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>5.02,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DockStyle>Right</DockStyle>
              <Font>Arial,9</Font>
              <Guid>4bf9572c2b5e43e09c1f583288bdd605</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>textRating2</Name>
              <Page isRef="5" />
              <Parent isRef="14" />
              <Text>{Company.SandP}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <Type>DataColumn</Type>
              <VertAlignment>Center</VertAlignment>
            </textRating2>
            <textRating1 Ref="21" type="Text" isKey="true">
              <Border>Left, Right;[193:152:89];1;Solid;False;4;Black</Border>
              <Brush>Transparent</Brush>
              <ClientRectangle>4.12,0,0.9,0.2</ClientRectangle>
              <Conditions isList="true" count="0" />
              <DockStyle>Right</DockStyle>
              <Font>Arial,9</Font>
              <Guid>cb6a19917d7b4620810163b64c90a715</Guid>
              <HorAlignment>Right</HorAlignment>
              <Margins>0,0,0,0</Margins>
              <Name>textRating1</Name>
              <Page isRef="5" />
              <Parent isRef="14" />
              <Text>{IIF(VS32.AMBestSkip == 1, "", Company.AMBest)}</Text>
              <TextBrush>[102:77:38]</TextBrush>
              <Type>Expression</Type>
              <VertAlignment>Center</VertAlignment>
            </textRating1>
          </Components>
          <Conditions isList="true" count="0" />
          <DataRelationName isNull="true" />
          <DataSourceName>Company</DataSourceName>
          <Filters isList="true" count="0" />
          <Guid>6a8e9aa1bfc5416199ea5d94f6247b37</Guid>
          <Name>DataBand1</Name>
          <Page isRef="5" />
          <Parent isRef="5" />
          <Sort isList="true" count="0" />
        </DataBand1>
      </Components>
      <Conditions isList="true" count="0" />
      <Guid>0949dcb7a5d44914a85d372b222aca97</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="22" type="Stimulsoft.Report.Components.StiWatermark" isKey="true">
        <Font>Arial,100</Font>
        <TextBrush>[50:0:0:0]</TextBrush>
      </Watermark>
    </Page1>
  </Pages>
  <PrinterSettings Ref="23" 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>8/22/2013 1:35:21 PM</ReportChanged>
  <ReportCreated>8/21/2013 3:12:52 PM</ReportCreated>
  <ReportFile>E:\TestReport_modified.mrt</ReportFile>
  <ReportGuid>abfc53eb51af42b1b4deb3ef0559b28b</ReportGuid>
  <ReportName>Report</ReportName>
  <ReportUnit>Inches</ReportUnit>
  <ReportVersion>2013.2.1615</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>