<?xml version="1.0" encoding="utf-8"?>
<Report ScriptLanguage="CSharp" ReportInfo.Created="06/20/2009 22:40:42" ReportInfo.Modified="06/20/2023 16:16:00" ReportInfo.CreatorVersion="2014.3.6.0">
  <Dictionary>
    <MsSqlDataConnection Name="Connection">
      <TableDataSource Name="ENTREPRISE" DataType="System.Int32" Enabled="true" TableName="ENTREPRISE">
        <Column Name="ID" DataType="System.Int32"/>
        <Column Name="Nom" DataType="System.String"/>
        <Column Name="Adresse" DataType="System.String"/>
        <Column Name="RC" DataType="System.String"/>
        <Column Name="IF" DataType="System.String"/>
        <Column Name="AI" DataType="System.String"/>
        <Column Name="NIS" DataType="System.String"/>
        <Column Name="CB" DataType="System.String"/>
        <Column Name="capital" DataType="System.String"/>
        <Column Name="activite" DataType="System.String"/>
        <Column Name="rib" DataType="System.String"/>
        <Column Name="email" DataType="System.String"/>
        <Column Name="siteweb" DataType="System.String"/>
        <Column Name="tel" DataType="System.String"/>
        <Column Name="fax" DataType="System.String"/>
        <Column Name="logo" DataType="System.Byte[]" BindableControl="Picture"/>
        <Column Name="raison_2" DataType="System.String"/>
        <Column Name="Adresse_2" DataType="System.String"/>
        <Column Name="RC_2" DataType="System.String"/>
        <Column Name="IF_2" DataType="System.String"/>
        <Column Name="AI_2" DataType="System.String"/>
        <Column Name="NIS_2" DataType="System.String"/>
        <Column Name="CB_2" DataType="System.String"/>
        <Column Name="capital_2" DataType="System.String"/>
        <Column Name="activite_2" DataType="System.String"/>
        <Column Name="rib_2" DataType="System.String"/>
        <Column Name="email_2" DataType="System.String"/>
        <Column Name="siteweb_2" DataType="System.String"/>
        <Column Name="tel_2" DataType="System.String"/>
        <Column Name="fax_2" DataType="System.String"/>
        <Column Name="logo_2" DataType="System.Byte[]" BindableControl="Picture"/>
      </TableDataSource>
      <TableDataSource Name="TIERS" DataType="System.Int32" Enabled="true" TableName="TIERS">
        <Column Name="TypeTiers" DataType="System.String"/>
        <Column Name="codeAnalytique" DataType="System.String"/>
        <Column Name="codeCompta" DataType="System.String"/>
        <Column Name="nom" DataType="System.String"/>
        <Column Name="adresse" DataType="System.String"/>
        <Column Name="code_postal" DataType="System.String"/>
        <Column Name="pays" DataType="System.String"/>
        <Column Name="ville" DataType="System.String"/>
        <Column Name="mobile" DataType="System.String"/>
        <Column Name="telephone" DataType="System.String"/>
        <Column Name="fax" DataType="System.String"/>
        <Column Name="email" DataType="System.String"/>
        <Column Name="site_web" DataType="System.String"/>
        <Column Name="nom_contact" DataType="System.String"/>
        <Column Name="observation" DataType="System.String"/>
        <Column Name="adresseLivraison" DataType="System.String"/>
        <Column Name="Solde" DataType="System.Double"/>
        <Column Name="SoldeInitiale" DataType="System.Double"/>
        <Column Name="rc" DataType="System.String"/>
        <Column Name="nif" DataType="System.String"/>
        <Column Name="ai" DataType="System.String"/>
        <Column Name="ComptBan" DataType="System.String"/>
        <Column Name="RIB" DataType="System.String"/>
        <Column Name="Nis" DataType="System.String"/>
        <Column Name="ID" DataType="System.Int32"/>
      </TableDataSource>
      <TableDataSource Name="Operations" DataType="System.Int32" PropName="ViewTiersTransations" Enabled="true" TableName="Operations">
        <Column Name="OPERATIONTYPE" Alias="Opération" DataType="System.String"/>
        <Column Name="idTiers" DataType="System.Int32" PropName="TIERSID"/>
        <Column Name="NOM" DataType="System.String"/>
        <Column Name="TIERSTYPE" Alias="TYPE" DataType="System.String"/>
        <Column Name="Date" DataType="System.DateTime"/>
        <Column Name="Libelle" DataType="System.String"/>
        <Column Name="MONTANT" DataType="System.Double" Format="Number"/>
        <Column Name="OPERSOLDESENS" DataType="System.Int32"/>
        <Column Name="Versement" DataType="System.Double" PropName="Column" Format="Number"/>
        <Column Name="Solde" Enabled="false" DataType="System.Double" PropName="Column"/>
        <Column Name="idEffet" DataType="System.String" PropName="Column"/>
        <Column Name="Solde" DataType="System.Double" PropName="Column"/>
        <Column Name="idReglement" DataType="System.String" PropName="Column"/>
      </TableDataSource>
      <TableDataSource Name="LignesEffet" DataType="System.Int32" PropName="Table" Enabled="true" TableName="LignesEffet">
        <Column Name="num" DataType="System.String" PropName="Column"/>
        <Column Name="Designation" DataType="System.String" PropName="Column"/>
        <Column Name="Quantite" DataType="System.Double" PropName="Column"/>
        <Column Name="Prix" DataType="System.Double" PropName="Column"/>
        <Column Name="EFFETID" DataType="System.String" PropName="Column"/>
        <Column Name="idReglement" DataType="System.String" PropName="Column"/>
        <CommandParameter Name="Designation" DataType="22" Size="255"/>
        <CommandParameter Name="Quantite" DataType="6"/>
        <CommandParameter Name="Prix" DataType="6"/>
      </TableDataSource>
    </MsSqlDataConnection>
    <Relation Name="Operations_LignesEffet1" ParentDataSource="Operations" ChildDataSource="LignesEffet" ParentColumns="idEffet&#13;&#10;idReglement" ChildColumns="EFFETID&#13;&#10;idReglement" Enabled="true"/>
    <Parameter Name="Periode" DataType="System.String"/>
    <Parameter Name="Solde global" DataType="System.Double" Expression="[Total]-[Total Versement]"/>
    <Parameter Name="Parameter" DataType="System.Double" Expression="[Operations.Versement]"/>
    <Parameter Name="EFFETID" DataType="System.String" Expression="[Operations.idEffet]"/>
    <Total Name="Total" Expression="[Operations.MONTANT]" Evaluator="Data1" ResetAfterPrint="false"/>
    <Total Name="Total Versement" Expression="[Operations.Versement]" Evaluator="Data1" PrintOn="GroupFooter1" IncludeInvisibleRows="true"/>
    <Total Name="Nouveau Solde" Expression="[Operations.Solde]" Evaluator="Data1" PrintOn="GroupFooter1" ResetAfterPrint="false" IncludeInvisibleRows="true"/>
    <Total Name="Total Montant" Expression="[Operations.MONTANT]" Evaluator="Data1" PrintOn="GroupFooter1" IncludeInvisibleRows="true"/>
    <Total Name="Total Solde" Expression="[Operations.Solde]" Evaluator="Data1" PrintOn="GroupFooter1" IncludeInvisibleRows="true"/>
    <Total Name="Montant Global" Expression="[Operations.MONTANT]" Evaluator="Data1" ResetAfterPrint="false" IncludeInvisibleRows="true"/>
    <Total Name="Versement Global" Expression="[Operations.Versement]" Evaluator="Data1" ResetAfterPrint="false" IncludeInvisibleRows="true"/>
  </Dictionary>
  <ReportPage Name="Page1" Guides="718.2,718.2">
    <PageHeaderBand Name="PageHeader1" Width="718.2" Height="179.55">
      <PictureObject Name="Picture1" Left="604.8" Top="9.45" Width="75.6" Height="75.6" DataColumn="ENTREPRISE.logo"/>
      <RichObject Name="Rich1" Left="28.35" Top="85.05" Width="359.1" Height="18.9" Text="{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil Times New Roman;}{\f1\fnil Tahoma;}}&#13;&#10;{\colortbl ;\red0\green0\blue0;}&#13;&#10;{\*\generator Riched20 10.0.19041}\viewkind4\uc1 &#13;&#10;\pard\cf1\b\f0\fs24 ETAT DU : [TIERS.nom]\v 1\cf0\b0\v0\f1\fs17\par&#13;&#10;}&#13;&#10;"/>
      <RichObject Name="Rich2" Left="28.35" Top="9.45" Width="453.6" Height="66.15" Text="{\rtf1\ansi\ansicpg1252\deff0\nouicompat\deflang1036{\fonttbl{\f0\fnil Arial;}{\f1\fnil Tahoma;}}&#13;&#10;{\*\generator Riched20 10.0.19041}\viewkind4\uc1 &#13;&#10;\pard\f0\fs20 [\b\fs24 ENTREPRISE.Nom]\b0\fs20\par&#13;&#10;[ENTREPRISE.Adresse]\par&#13;&#10;[ENTREPRISE.tel]\f1\fs17\par&#13;&#10;}&#13;&#10;"/>
      <LineObject Name="Line1" Left="9.45" Top="85.05" Width="708.75"/>
      <TableObject Name="Table2" Left="7.56" Top="160.65" Width="691.74" Height="18.9">
        <TableColumn Name="Column6" Width="94.5"/>
        <TableColumn Name="Column7" Width="219.24"/>
        <TableColumn Name="Column8" Width="94.5"/>
        <TableColumn Name="Column15" Width="94.5"/>
        <TableColumn Name="Column23" Width="94.5"/>
        <TableColumn Name="Column24" Width="94.5"/>
        <TableRow Name="Row2">
          <TableCell Name="Cell6" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Date" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell7" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Opération" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell8" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Montant" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell15" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Versement" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell23" Border.Lines="All" Fill.Color="WhiteSmoke" Text="S. total" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell24" Border.Lines="All" Fill.Color="WhiteSmoke" Text="N. Solde" Font="Arial, 10pt, style=Bold"/>
        </TableRow>
      </TableObject>
      <TextObject Name="Text1" Left="567" Top="94.5" Width="151.2" Height="18.9" Text="[Date]" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text2" Left="567" Top="122.85" Width="151.2" Height="18.9" Text="Page [Page#]/[TotalPages#]" HorzAlign="Right" VertAlign="Center" Font="Arial, 9pt"/>
      <TextObject Name="Text3" Left="28.35" Top="103.95" Width="538.65" Height="47.25" Text="Adrèsse: [TIERS.adresse]&#13;&#10;Solde à la date [Date] : [TIERS.Solde]&#13;&#10;[Periode]" Font="Arial, 8pt">
        <Formats>
          <GeneralFormat/>
          <DateFormat/>
          <NumberFormat UseLocale="false" DecimalSeparator="," GroupSeparator=" " NegativePattern="2"/>
          <GeneralFormat/>
        </Formats>
      </TextObject>
    </PageHeaderBand>
    <GroupHeaderBand Name="GroupHeader1" Top="181.72" Width="718.2" Height="18.9" Visible="false" Condition="[Operations.idEffet]" SortOrder="None">
      <GroupHeaderBand Name="GroupHeader2" Top="202.8" Width="718.2" Height="18.9" Visible="false" Condition="[Operations.Date]" SortOrder="None">
        <DataBand Name="Data1" Top="223.87" Width="718.2" Height="18.9" Visible="false" DataSource="Operations">
          <TableObject Name="Table4" Left="7.56" Width="691.74" Height="18.9" Border.Lines="All">
            <TableColumn Name="Column17" Width="94.5"/>
            <TableColumn Name="Column18" Width="255.15"/>
            <TableColumn Name="Column19" Width="111.51"/>
            <TableColumn Name="Column20" Width="115.29"/>
            <TableColumn Name="Column21" Width="115.29"/>
            <TableRow Name="Row4">
              <TableCell Name="Cell17" Border.Lines="All" Text="[Operations.Date]" Format="Date" Format.Format="d"/>
              <TableCell Name="Cell18" Border.Lines="All" Text="[Operations.Libelle]"/>
              <TableCell Name="Cell19" Border.Lines="All" Text="[Operations.MONTANT]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right"/>
              <TableCell Name="Cell20" Border.Lines="All" Text="[Operations.Versement]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right"/>
              <TableCell Name="Cell21" Border.Lines="All" Text="[Operations.idEffet]" HorzAlign="Right"/>
            </TableRow>
          </TableObject>
          <Sort>
            <Sort Expression="[Operations.Date]"/>
            <Sort Expression="[Operations.idEffet]"/>
            <Sort Expression="[Operations.Libelle]" Descending="true"/>
          </Sort>
        </DataBand>
        <GroupFooterBand Name="GroupFooter2" Top="244.95" Width="718.2" Height="28.35" Visible="false"/>
      </GroupHeaderBand>
      <GroupFooterBand Name="GroupFooter1" Top="275.47" Width="718.2" Height="18.9">
        <TableObject Name="Table1" Left="7.56" Width="691.74" Height="18.9" Border.Lines="All">
          <TableColumn Name="Column2" Width="94.5"/>
          <TableColumn Name="Column3" Width="219.24"/>
          <TableColumn Name="Column4" Width="94.5"/>
          <TableColumn Name="Column14" Width="94.5"/>
          <TableColumn Name="Column22" Width="94.5"/>
          <TableColumn Name="Column16" Width="94.5"/>
          <TableRow Name="Row1">
            <TableCell Name="Cell2" Border.Lines="All" Text="[Operations.Date]" Format="Date" Format.Format="d"/>
            <TableCell Name="Cell3" Border.Lines="All" Text="[Operations.Libelle]"/>
            <TableCell Name="Cell4" Border.Lines="All" Text="[Total Montant]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right"/>
            <TableCell Name="Cell14" Border.Lines="All" Text="[Total Versement]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right"/>
            <TableCell Name="Cell22" Border.Lines="All" Text="[Total Solde]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right"/>
            <TableCell Name="Cell16" Border.Lines="All" Text="[Nouveau Solde]" Format="Number" Format.UseLocale="false" Format.DecimalDigits="2" Format.DecimalSeparator="," Format.GroupSeparator=" " Format.NegativePattern="1" HorzAlign="Right" Font="Arial, 10pt, style=Bold"/>
          </TableRow>
        </TableObject>
      </GroupFooterBand>
    </GroupHeaderBand>
    <ReportSummaryBand Name="ReportSummary1" Top="296.54" Width="718.2" Height="56.7">
      <TableObject Name="Table3" Left="200.34" Top="9.45" Width="309.96" Height="18.9">
        <TableColumn Name="Column12" Width="120.96"/>
        <TableColumn Name="Column13" Width="94.5"/>
        <TableColumn Name="Column25" Width="94.5"/>
        <TableRow Name="Row3">
          <TableCell Name="Cell12" Border.Lines="All" Fill.Color="WhiteSmoke" Text="Total" Font="Arial, 10pt, style=Bold"/>
          <TableCell Name="Cell13" Border.Lines="All" Text="[Montant Global]" Format="Number" Format.UseLocale="true" HorzAlign="Right"/>
          <TableCell Name="Cell25" Border.Lines="All" Text="[Versement Global]" Format="Number" Format.UseLocale="true" HorzAlign="Right"/>
        </TableRow>
      </TableObject>
    </ReportSummaryBand>
  </ReportPage>
</Report>
