<?xml version="1.0" encoding="utf-8"?>
<Report DataSourceName="DetailsDS" Width="27.69950680297cm" Culture="fr-FR" UnitOfMeasure="Cm" Name="retro" SnapGridSize="0.1cm" ShowDimensions="False" xmlns="http://schemas.telerik.com/reporting/2012/3.9">
  <DataSources>
    <SqlDataSource QueryDesignerState="null" ConnectionString="crystalall5" SelectCommand="dbo.p_rep_cl_bdx_details" SelectCommandType="StoredProcedure" Name="DetailsDS" ParameterValues="{&quot;@user_code&quot;:&quot;admin&quot;,&quot;@bordereau_id&quot;:&quot;1&quot;}">
      <Parameters>
        <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>
  </DataSources>
  <Items>
    <PageHeaderSection Height="0.629882017771403in" Name="pageHeaderSection">
      <Items>
        <TextBox Width="4.69021665242705cm" Height="0.599999697208413cm" Left="21.7096852430988cm" 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="16.3987401851369cm" 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="0cm" Top="0.600199943377973cm" Value="= Fields.branch_display_name" Name="textBox2" />
        <TextBox Width="12.799899069471cm" Height="0.600000100930529cm" Left="0cm" Top="0cm" Value="= Fields.branch_name" Name="textBox32" />
      </Items>
    </PageHeaderSection>
    <DetailSection Height="0.600199993843235cm" Name="detailSection1">
      <Style>
        <Font Size="11pt" />
      </Style>
      <Items>
        <TextBox Width="5.50000005046526cm" Height="0.599999697208413cm" Left="0.045833764390801cm" Top="0cm" Value="= Fields.adr_complete_name" Name="textBox15">
          <Style Color="Black" VerticalAlign="Middle">
            <BorderStyle Default="None" />
            <BorderColor Default="224, 224, 224" />
          </Style>
        </TextBox>
        <TextBox Width="3.45376518815217cm" Height="0.599999697208413cm" Left="5.54603406102563cm" Top="0cm" Value="= Fields.pols_number" Name="textBox16">
          <Style Color="Black" VerticalAlign="Middle">
            <BorderStyle Default="None" />
            <BorderColor Default="224, 224, 224" />
          </Style>
        </TextBox>
        <TextBox Width="4.09999994953473cm" Height="0.599999697208413cm" Left="8.99999949534736cm" Top="0cm" Value="= Fields.cl_internal_reference" Name="textBox17">
          <Style Color="Black" VerticalAlign="Middle">
            <BorderStyle Default="None" />
            <BorderColor Default="224, 224, 224" />
          </Style>
        </TextBox>
        <TextBox Width="6.70816027410517cm" Height="0.599999725818634cm" Left="13.1002013059401cm" Top="0cm" Value="= Fields.nmpv_l2" Name="textBox10">
          <Style Color="Black" VerticalAlign="Middle">
            <BorderStyle Default="None" />
            <BorderColor Default="224, 224, 224" />
          </Style>
        </TextBox>
        <TextBox Width="3.59376220623965cm" Height="0.599999725818634cm" Left="19.8085610284013cm" Top="0cm" Value="= Fields.rec" Format="{0:N2}" Name="textBox12">
          <Style Color="Black" TextAlign="Right" VerticalAlign="Middle">
            <BorderStyle Default="None" />
            <BorderColor Default="224, 224, 224" />
          </Style>
        </TextBox>
        <TextBox Width="3.39031205107431cm" Height="0.599999725818634cm" Left="23.4025243734611cm" Top="0.00040049233912052cm" Value="= Fields.rev" Format="{0:N2}" Name="textBox18">
          <Style Color="Black" TextAlign="Right" VerticalAlign="Middle">
            <BorderStyle Default="None" />
            <BorderColor Default="224, 224, 224" />
          </Style>
        </TextBox>
      </Items>
    </DetailSection>
    <PageFooterSection Height="0.704158691052156cm" Name="pageFooterSection1">
      <Items>
        <TextBox Width="3.00000010093053cm" Height="0.6cm" Left="24.6995075094837cm" Top="0cm" Value="Page {[PageNumber]} / {[PageCount]}" Name="textBox23">
          <Style TextAlign="Right" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="8.55416593281761cm" Height="0.6cm" Left="0.045833764390801cm" Top="0cm" Value="= &quot;Montants en &quot; + Fields.clb_currency_code" Name="textBox1" />
      </Items>
    </PageFooterSection>
    <ReportHeaderSection Height="1.7000996688974cm" Name="reportHeaderSection">
      <Style>
        <Padding Top="0.5cm" />
      </Style>
      <Items>
        <TextBox Width="13.5460332535814cm" Height="0.6999003311026cm" Left="0cm" Top="0.173541566472089cm" Value="= &quot;BORDEREAU CREDIT SINISTRES&quot;" Name="txtTitle">
          <Style>
            <Font Size="14pt" Bold="True" />
          </Style>
        </TextBox>
        <TextBox Width="5.50000005046527cm" Height="0.600000100930529cm" Left="0.045833764390801cm" Top="0.87364214374425cm" Value="= &quot;N°&quot; + Parameters.id.Value" Name="textBox33" />
        <TextBox Width="8cm" Height="0.599999725818634cm" Left="5.54603406102563cm" Top="0.87364214374425cm" Value="Référence: {Fields.clb_reference}" Name="textBox34" />
        <TextBox Width="2.15376624792272cm" Height="0.599999725818634cm" Left="19.2002002461696cm" Top="0.173541566472089cm" Value="Période de:" Name="textBox19" />
        <TextBox Width="0.608161144730416cm" Height="0.599999725818634cm" Left="20.7458067654743cm" Top="0.87364214374425cm" Value="à:" Name="textBox20" />
        <TextBox Width="4.69021654129028cm" Height="0.599999725818634cm" Left="21.7096852430988cm" Top="0.173541566472089cm" Value="= IsNull(Fields.clb_date_from, &quot;&quot;)" Format="{0:d}" Culture="fr-FR" Name="textBox21">
          <Style TextAlign="Right" VerticalAlign="Middle" />
        </TextBox>
        <TextBox Width="4.69021654129028cm" Height="0.599999725818634cm" Left="21.7096852430988cm" Top="0.873642547466366cm" Value="= IsNull(Fields.clb_date_to, &quot;&quot;)" Format="{0:d}" Culture="fr-FR" Name="textBox22">
          <Style TextAlign="Right" VerticalAlign="Middle" />
        </TextBox>
      </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>
    <StyleRule>
      <Style Color="Black">
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="9pt" />
      </Style>
      <Selectors>
        <StyleSelector Type="Table" StyleName="Normal.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="Normal.TableBody" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <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="Normal.SubTotal" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style>
        <BorderStyle Default="Solid" />
        <BorderColor Default="Black" />
        <BorderWidth Default="1px" />
        <Font Name="Tahoma" Size="10pt" Bold="True" Italic="False" Underline="False" Strikeout="False" />
      </Style>
      <Selectors>
        <DescendantSelector>
          <Selectors>
            <TypeSelector Type="Table" />
            <StyleSelector Type="ReportItem" StyleName="Normal.GrandTotal" />
          </Selectors>
        </DescendantSelector>
      </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="Normal.TableGroup" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
    <StyleRule>
      <Style 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="Normal.TableHeader" />
          </Selectors>
        </DescendantSelector>
      </Selectors>
    </StyleRule>
  </StyleSheet>
  <PageSettings>
    <PageSettings PaperKind="A4" Landscape="True">
      <Margins>
        <MarginsU Left="1cm" Right="1cm" Top="1cm" Bottom="1cm" />
      </Margins>
    </PageSettings>
  </PageSettings>
  <Sortings>
    <Sorting Expression="= Fields.adr_complete_name" Direction="Asc" />
    <Sorting Expression="= Fields.pols_number" Direction="Asc" />
    <Sorting Expression="= Fields.cl_internal_reference" Direction="Asc" />
    <Sorting Expression="= Fields.nmpv_l2" Direction="Asc" />
  </Sortings>
  <Groups>
    <Group Name="group">
      <GroupHeader>
        <GroupHeaderSection PageBreak="None" Height="3.29999994953474cm" Name="groupHeaderSection">
          <Items>
            <TextBox Width="5.54583381485606cm" Height="0.599999697208413cm" Left="0cm" Top="2.70000025232632cm" Value="Assuré" Name="textBox11" StyleName="Corporate.TableHeader">
              <Style BackgroundColor="28, 58, 112" Color="White" TextAlign="Center">
                <BorderStyle Default="Solid" />
                <BorderColor Default="Black" />
              </Style>
            </TextBox>
            <TextBox Width="3.45376523345173cm" Height="0.599999725818634cm" Left="5.54603406102563cm" Top="2.70000025232632cm" Value="Contrat" Name="textBox4" StyleName="Corporate.TableHeader">
              <Style BackgroundColor="28, 58, 112" Color="White" TextAlign="Center">
                <BorderStyle Default="Solid" />
                <BorderColor Default="Black" />
              </Style>
            </TextBox>
            <TextBox Width="4.09999999483429cm" Height="0.599999725818634cm" Left="8.99999949534736cm" Top="2.70000025232632cm" Value="Sinistre" Name="textBox5" StyleName="Corporate.TableHeader">
              <Style BackgroundColor="28, 58, 112" Color="White" TextAlign="Center">
                <BorderStyle Default="Solid" />
                <BorderColor Default="Black" />
              </Style>
            </TextBox>
            <TextBox Width="6.70816113647969cm" Height="0.599999725818634cm" Left="13.1001996910517cm" Top="2.70000025232632cm" Value="Garantie" Name="textBox6" StyleName="Corporate.TableHeader">
              <Style BackgroundColor="28, 58, 112" Color="White" TextAlign="Center">
                <BorderStyle Default="Solid" />
                <BorderColor Default="Black" />
              </Style>
            </TextBox>
            <TextBox Width="3.59376152930132cm" Height="0.599999725818634cm" Left="19.8085610284013cm" Top="2.70000025232632cm" Value="Récupération" Name="textBox8" StyleName="Corporate.TableHeader">
              <Style BackgroundColor="28, 58, 112" Color="White" TextAlign="Center">
                <BorderStyle Default="Solid" />
                <BorderColor Default="Black" />
              </Style>
            </TextBox>
            <TextBox Width="3.39031303591656cm" Height="0.599999725818634cm" Left="23.4025243734612cm" Top="2.70000025232632cm" Value="Reversion" Name="textBox9" StyleName="Corporate.TableHeader">
              <Style BackgroundColor="28, 58, 112" Color="White" TextAlign="Center">
                <BorderStyle Default="Solid" />
                <BorderColor Default="Black" />
              </Style>
            </TextBox>
            <Panel Width="11.0999027534353cm" Height="2.47887438236824cm" Left="15.6929338031986cm" Top="0cm" Name="panel1">
              <Style>
                <BorderStyle Default="Solid" />
              </Style>
              <Items>
                <TextBox Width="11.0998026303505cm" Height="0.600000504652645cm" Left="0cm" Top="0cm" Value="= Fields.cie_display_name" Name="textBox7" />
                <TextBox Width="11.0997049295984cm" Height="0.600000100930529cm" Left="0.00010012308478013cm" Top="0.600300873906986cm" Value="= Fields.cie_addr1" Name="textBox13" />
                <TextBox Width="11.0997047424316cm" Height="0.600000083446503cm" Left="0cm" Top="1.20050122100707cm" Value="= Fields.cie_addr2" Name="textBox14" />
                <TextBox Width="11.0996062922587cm" Height="0.600000083446503cm" Left="0.00010012308478013cm" Top="1.80070156810716cm" Value="= Fields.cie_postal_code + &quot; &quot; + Fields.cie_city" Name="textBox31" />
              </Items>
            </Panel>
          </Items>
        </GroupHeaderSection>
      </GroupHeader>
      <GroupFooter>
        <GroupFooterSection PageBreak="After" Height="0.799800157552556cm" Name="groupFooterSection">
          <Items>
            <TextBox Width="19.762527017841cm" Height="0.600000504652645cm" Left="0.0458337643908013cm" Top="0cm" Value="= &quot;Total &quot; + Fields.cie_display_name" Name="textBox25">
              <Style TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Top="Solid" />
                <BorderColor Top="224, 224, 224" />
                <Font Bold="True" />
              </Style>
            </TextBox>
            <TextBox Width="3.59376238101298cm" Height="0.600199937820435cm" Left="19.8085626432898cm" Top="0cm" Value="= SUM(Fields.rec)" Format="{0:N2}" Name="textBox26">
              <Style Color="Black" TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Default="None" Top="Solid" />
                <BorderColor Default="224, 224, 224" Top="224, 224, 224" />
                <Font Bold="True" />
              </Style>
            </TextBox>
            <TextBox Width="3.39031225035511cm" Height="0.600199937820435cm" Left="23.4025243734611cm" Top="0.00040049233912052cm" Value="= SUM(Fields.rev)" Format="{0:N2}" Name="textBox27">
              <Style Color="Black" TextAlign="Right" VerticalAlign="Middle">
                <BorderStyle Default="None" Top="Solid" />
                <BorderColor Default="224, 224, 224" Top="224, 224, 224" />
                <Font Bold="True" />
              </Style>
            </TextBox>
          </Items>
        </GroupFooterSection>
      </GroupFooter>
      <Groupings>
        <Grouping Expression="= Fields.cie_internal_reference" />
      </Groupings>
      <Sortings>
        <Sorting Expression="= Fields.cie_display_name" Direction="Asc" />
      </Sortings>
    </Group>
  </Groups>
  <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>1</String>
      </Value>
    </ReportParameter>
    <ReportParameter Name="UserCode" Text="UserCode">
      <Value>
        <String>admin</String>
      </Value>
    </ReportParameter>
  </ReportParameters>
</Report>