<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="HeaderDS" Width="24.6012625399874cm" Culture="fr-FR" Name="Invoice1" SnapGridSize="0.1cm" ShowDimensions="False" xmlns="http://schemas.telerik.com/reporting/2012/3.9">
  <DataSources>
    <SqlDataSource ConnectionString="crystalall1" SelectCommand="dbo.p_rep_cie_bdx_header" SelectCommandType="StoredProcedure" Name="HeaderDS" ParameterValues="{&quot;@branch_id&quot;:&quot;4&quot;,&quot;@user_code&quot;:&quot;admin&quot;,&quot;@bordereau_id&quot;:&quot;175&quot;}">
      <Parameters>
        <SqlDataSourceParameter DbType="Int32" Name="@branch_id">
          <Value>
            <String>= Parameters.BranchId.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="AnsiString" Name="@user_code">
          <Value>
            <String>= Parameters.UserCode.Value</String>
          </Value>
        </SqlDataSourceParameter>
        <SqlDataSourceParameter DbType="Int32" Name="@bordereau_id">
          <Value>
            <String>= Parameters.id.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
    <SqlDataSource ConnectionString="CrystalAll" SelectCommand="dbo.p_rep_cie_bdx_details" SelectCommandType="StoredProcedure" Name="DetailsDS" ParameterValues="{&quot;@bordereau_id&quot;:&quot;175&quot;}">
      <Parameters>
        <SqlDataSourceParameter DbType="Int32" Name="@bordereau_id">
          <Value>
            <String>= Parameters.id.Value</String>
          </Value>
        </SqlDataSourceParameter>
      </Parameters>
    </SqlDataSource>
  </DataSources>
  <Items>
    <PageHeaderSection Height="0.629882017771403in" Name="pageHeaderSection">
      <Items>
        <TextBox Width="4.69021665242705cm" Height="0.599999697208413cm" Left="19.9109449570314cm" Top="0.600199943377973cm" Value="= Today()" Format="{0:d}" Culture="fr-FR" Name="textBox3">
          <Style TextAlign="Right" VerticalAlign="Middle" />
        </TextBox>
        <HtmlTextBox Width="10.0011633252774cm" Height="0.599999697208413cm" Left="14.5999998990695cm" Top="0cm" Value="Document généré par &lt;strong&gt;{Fields.usr_name}&lt;/strong&gt;" Name="htmlTextBox1">
          <Style TextAlign="Right" VerticalAlign="Middle" />
        </HtmlTextBox>
        <TextBox Width="12.799899069471cm" Height="0.600000100930529cm" Left="0.00010012308478013cm" Top="0.0971698575012326cm" Value="= Fields.branch_display_name" Name="textBox2" />
      </Items>
    </PageHeaderSection>
    <DetailSection Height="4.00395768790363cm" Name="detailSection1">
      <Style>
        <Font Size="11pt" />
      </Style>
      <Items>
        <Table DataSourceName="DetailsDS" Width="24.6012625399874cm" Height="1.50000004470331cm" Left="0cm" Top="0cm" ColumnHeadersPrintOnEveryPage="True" Docking="Top" Name="table1" StyleName="Corporate.TableNormal">
          <Body>
            <Cells>
              <TableCell RowIndex="0" ColumnIndex="0" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="3.11646415015339cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.client_name" Name="textBox12" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="1" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="3.54539484480183cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.pols_number" Name="textBox13" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="2" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="3.54707381499619cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.nmpv_l1" Name="textBox14" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="3" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="1.79590386982091cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.inv_start_date" Format="{0:d}" Name="textBox15" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="4" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="1.72825016908542cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.inv_end_date" Format="{0:d}" Name="textBox16" StyleName="Corporate.TableBody" />
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="5" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.07643871052365cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.bdrv_ti" Format="{0:N2}" Name="textBox17" StyleName="Corporate.TableBody">
                    <Style TextAlign="Right" />
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="6" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.2661273333913cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.bdrv_comm" Format="{0:N2}" Name="textBox18" StyleName="Corporate.TableBody">
                    <Style TextAlign="Right" />
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="7" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.05904120670623cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.bdrv_taxes" Format="{0:N2}" Name="textBox19" StyleName="Corporate.TableBody">
                    <Style TextAlign="Right" />
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="9" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.34355113764969cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.bdrv_net_a_payer" Format="{0:N2}" Name="textBox21" StyleName="Corporate.TableBody">
                    <Style TextAlign="Right" />
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="1" ColumnIndex="5" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.07643871052365cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="=Sum(Fields.bdrv_ti)" Format="{0:N2}" Name="textBox27" StyleName="Corporate.TableBody">
                    <Style BackgroundColor="224, 224, 224" TextAlign="Right">
                      <Font Bold="True" />
                    </Style>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="1" ColumnIndex="6" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.2661273333913cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="=Sum(Fields.bdrv_comm)" Format="{0:N2}" Name="textBox28" StyleName="Corporate.TableBody">
                    <Style BackgroundColor="224, 224, 224" TextAlign="Right">
                      <Font Bold="True" />
                    </Style>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="1" ColumnIndex="7" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.05904120670623cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="=Sum(Fields.bdrv_taxes)" Format="{0:N2}" Name="textBox29" StyleName="Corporate.TableBody">
                    <Style BackgroundColor="224, 224, 224" TextAlign="Right">
                      <Font Bold="True" />
                    </Style>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="1" ColumnIndex="9" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.34355113764969cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="=Sum(Fields.bdrv_net_a_payer)" Format="{0:N2}" Name="textBox30" StyleName="Corporate.TableBody">
                    <Style BackgroundColor="224, 224, 224" TextAlign="Right">
                      <Font Bold="True" />
                    </Style>
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="1" ColumnIndex="0" RowSpan="1" ColumnSpan="5">
                <ReportItem>
                  <TextBox Width="13.7330868488577cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="Totaux" Name="textBox22" StyleName="Corporate.TableBody">
                    <Style BackgroundColor="224, 224, 224" />
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="0" ColumnIndex="8" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.12301766944617cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="= Fields.bdrv_taxes_broker" Format="{0:N2}" Name="textBox35" StyleName="Corporate.TableBody">
                    <Style TextAlign="Right" />
                  </TextBox>
                </ReportItem>
              </TableCell>
              <TableCell RowIndex="1" ColumnIndex="8" RowSpan="1" ColumnSpan="1">
                <ReportItem>
                  <TextBox Width="2.12301766944617cm" Height="0.49999998509878cm" Left="0cm" Top="0cm" Value="=Sum(Fields.bdrv_taxes_broker)" Format="{0:N2}" Name="textBox36" StyleName="Corporate.TableBody">
                    <Style BackgroundColor="224, 224, 224" TextAlign="Right">
                      <Font Bold="True" />
                    </Style>
                  </TextBox>
                </ReportItem>
              </TableCell>
            </Cells>
            <Columns>
              <Column Width="3.11646415015339cm" />
              <Column Width="3.54539484480183cm" />
              <Column Width="3.54707381499619cm" />
              <Column Width="1.79590386982091cm" />
              <Column Width="1.72825016908542cm" />
              <Column Width="2.07643871052365cm" />
              <Column Width="2.2661273333913cm" />
              <Column Width="2.05904120670623cm" />
              <Column Width="2.12301785273986cm" />
              <Column Width="2.34355113764969cm" />
            </Columns>
            <Rows>
              <Row Height="0.500000029802265cm" />
              <Row Height="0.500000029802265cm" />
            </Rows>
          </Body>
          <Corner />
          <RowGroups>
            <TableGroup Name="detail">
              <Groupings>
                <Grouping />
              </Groupings>
            </TableGroup>
            <TableGroup Name="group1" />
          </RowGroups>
          <ColumnGroups>
            <TableGroup Name="client_name">
              <ReportItem>
                <TextBox Width="3.11646415015339cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="Assuré" Name="textBox4" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup Name="pols_number">
              <ReportItem>
                <TextBox Width="3.54539484480183cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="Contrat" Name="textBox5" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup Name="nmpv_l2">
              <ReportItem>
                <TextBox Width="3.54707381499619cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="Garantie" Name="textBox6" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup Name="inv_start_date">
              <ReportItem>
                <TextBox Width="1.79590386982091cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="Effet" Name="textBox7" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup Name="inv_end_date">
              <ReportItem>
                <TextBox Width="1.72825016908542cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="Fin effet" Name="textBox8" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup Name="bdrv_ti">
              <ReportItem>
                <TextBox Width="2.07643871052365cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="TTC" Name="textBox9" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup Name="bdrv_comm">
              <ReportItem>
                <TextBox Width="2.2661273333913cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="Comm." Name="textBox10" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup Name="bdrv_taxes">
              <ReportItem>
                <TextBox Width="2.05904120670623cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="Taxes" Name="textBox11" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup Name="group2">
              <ReportItem>
                <TextBox Width="2.12301766944617cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="Tx. courtier" Name="textBox34" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
            <TableGroup Name="group">
              <ReportItem>
                <TextBox Width="2.34355113764969cm" Height="0.500000029802265cm" Left="0cm" Top="0cm" Value="Net à payer" Name="textBox20" StyleName="Corporate.TableHeader" />
              </ReportItem>
            </TableGroup>
          </ColumnGroups>
        </Table>
      </Items>
    </DetailSection>
    <PageFooterSection Height="0.704158691052156cm" Name="pageFooterSection1">
      <Items>
        <TextBox Width="3.00000010093053cm" Height="0.6cm" Left="21.3999996972084cm" Top="0cm" Value="Page {[PageNumber]} / {[PageCount]}" Name="textBox23">
          <Style TextAlign="Right" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="7.65416598328288cm" Height="0.6cm" Left="0.045833764390801cm" Top="0cm" Value="= &quot;Montants en &quot; + Fields.bdr_devise_code" Name="textBox1" />
      </Items>
    </PageFooterSection>
    <ReportHeaderSection Height="3.50009965896606cm" Name="reportHeaderSection">
      <Style>
        <Padding Top="0.5cm" />
      </Style>
      <Items>
        <TextBox Width="11.0149337820032cm" Height="0.6999003311026cm" Left="0cm" Top="0.173541566472089cm" Value="BORDEREAU DE REGLEMENT COMPAGNIE" Name="txtTitle">
          <Style>
            <Font Size="14pt" Bold="True" />
          </Style>
        </TextBox>
        <Panel Width="11.5110275182041cm" Height="3.12655810242531cm" Left="13.0901332838101cm" Top="0.173541566472089cm" Name="panel1">
          <Style BackgroundColor="White">
            <BorderStyle Default="Solid" />
          </Style>
          <Items>
            <TextBox Width="11.5110275182041cm" Height="0.600000100930529cm" Left="0cm" Top="0cm" Value="= Fields.cie_name" Docking="Top" Name="textBox24" />
            <TextBox Width="11.5110275182041cm" Height="0.599999697208413cm" Left="0cm" Top="0.600000100930529cm" Value="= Fields.cie_addr1" Docking="Top" Name="textBox25" />
            <TextBox Width="11.5110275182041cm" Height="0.599999697208413cm" Left="0cm" Top="1.19999979813894cm" Value="= Fields.cie_addr2" Docking="Top" Name="textBox26" />
            <TextBox Width="11.5110275182041cm" Height="0.600000100930529cm" Left="0cm" Top="1.79999949534736cm" Value="= Fields.cie_addr3" Docking="Top" Name="textBox31" />
            <TextBox Width="11.5110275182041cm" Height="0.600000100930529cm" Left="0cm" Top="2.39999959627788cm" Value="= Fields.cie_postal_code + &quot; &quot; + Fields.cie_city" Docking="Top" Name="textBox32" />
          </Items>
        </Panel>
        <TextBox Width="4.99999989906947cm" Height="0.600000100930529cm" Left="0cm" Top="0.87364214374425cm" Value="= Fields.bdr_reference" Name="textBox33" />
        <Shape Width="24.6012630462646cm" Height="0.200000002980232cm" Left="0cm" Top="3.30009961128235cm" Docking="Bottom" Name="shape1">
          <Style Color="224, 224, 224" />
          <ShapeType>
            <LineShape Direction="EW" />
          </ShapeType>
        </Shape>
      </Items>
    </ReportHeaderSection>
  </Items>
  <StyleSheet>
    <StyleRule>
      <Style>
        <Padding Left="2pt" Right="2pt" />
      </Style>
      <Selectors>
        <TypeSelector Type="TextItemBase" />
        <TypeSelector Type="HtmlTextBox" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <Padding Left="2pt" Right="2pt" />
      </Style>
      <Selectors>
        <TypeSelector Type="TextItemBase" />
        <TypeSelector Type="HtmlTextBox" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="Gainsboro" Color="DimGray" VerticalAlign="Middle">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Silver" />
        <BorderWidth Default="1px" />
        <Font Name="Arial" Size="8pt" Bold="True" />
        <Padding Left="0.3cm" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Normal.TableHeader" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style VerticalAlign="Middle">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Silver" />
        <BorderWidth Default="1px" />
        <Font Name="Arial" Size="11pt" />
        <Padding Left="0.3cm" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Normal.TableBody" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="Silver" TextAlign="Right" VerticalAlign="Middle">
        <BorderStyle Default="None" Top="Solid" Bottom="Solid" />
        <BorderWidth Default="1pt" />
        <Font Size="11pt" Bold="True" />
        <Padding Right="0.3cm" />
      </Style>
      <Selectors>
        <StyleSelector Type="ReportItemBase" StyleName="Normal.TableTotal" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style Color="Black">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="Table" StyleName="Corporate.TableNormal" />
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Corporate.TableBody" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style BackgroundColor="28, 58, 112" Color="White" VerticalAlign="Middle">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="10pt" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Corporate.TableHeader" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <PageSettings>
    <PageSettings PaperKind="A4" Landscape="True">
      <Margins>
        <MarginsU Left="1in" Right="1in" Top="0.5in" Bottom="1in" />
      </Margins>
    </PageSettings>
  </PageSettings>
  <ReportParameters>
    <ReportParameter Name="BranchId" Type="Integer" Text="BranchId" AllowNull="True">
      <Value>
        <String>4</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="Id" Type="Integer" Text="Id" AllowNull="True">
      <Value>
        <String>175</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="UserCode" Text="UserCode">
      <Value>
        <String>admin</String>
      </Value>
    </ReportParameter>
  </ReportParameters>
</Report>