<?xml version="1.0" encoding="UTF-8"?>
<report xmlns="http://www.eclipse.org/birt/2005/design" version="3.2.23" id="1">
    <property name="createdBy">Eclipse BIRT Designer Version 4.7.0.v201706222054</property>
    <list-property name="propertyBindings">
        <structure>
            <property name="name">odaURL</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["DBName"].value</expression>
        </structure>
        <structure>
            <property name="name">odaUser</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["UserName"].value</expression>
        </structure>
        <structure>
            <property name="name">odaPassword</property>
            <property name="id">209</property>
            <expression name="value" type="javascript">params["Password"].value</expression>
        </structure>
    </list-property>
    <property name="units">in</property>
    <property name="iconFile">/templates/blank_report.gif</property>
    <property name="layoutPreference">fixed layout</property>
    <property name="bidiLayoutOrientation">ltr</property>
    <property name="imageDPI">96</property>
    <parameters>
        <scalar-parameter name="AccountingReportId" id="896">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="isRequired">true</property>
            <property name="dataType">decimal</property>
            <property name="distinct">true</property>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="DBName" id="1046">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">jdbc:postgresql://localhost:5432/axelor-open-suite</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="UserName" id="1047">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <simple-property-list name="defaultValue">
                <value type="constant">axelor</value>
            </simple-property-list>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
        <scalar-parameter name="Password" id="1048">
            <property name="hidden">true</property>
            <property name="valueType">static</property>
            <property name="dataType">string</property>
            <property name="distinct">true</property>
            <list-property name="selectionList"/>
            <property name="paramType">simple</property>
            <property name="controlType">text-box</property>
            <structure name="format">
                <property name="category">Unformatted</property>
            </structure>
        </scalar-parameter>
    </parameters>
    <data-sources>
        <oda-data-source extensionID="org.eclipse.birt.report.data.oda.jdbc" name="Data Source" id="209">
            <list-property name="privateDriverProperties">
                <ex-property>
                    <name>disabledMetadataBidiFormatStr</name>
                </ex-property>
                <ex-property>
                    <name>disabledContentBidiFormatStr</name>
                </ex-property>
                <ex-property>
                    <name>contentBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
                <ex-property>
                    <name>metadataBidiFormatStr</name>
                    <value>ILYNN</value>
                </ex-property>
            </list-property>
            <property name="odaDriverClass">org.postgresql.Driver</property>
            <property name="odaURL">jdbc:postgresql://localhost:5432/axelor-open-suite</property>
            <property name="odaUser">axelor</property>
        </oda-data-source>
    </data-sources>
    <data-sets>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="PaymentVoucherDS" id="210">
            <property name="nullsOrdering">nulls lowest</property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">PaymentVoucherRef</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">PaymentVoucherRef</text-property>
                    <text-property name="heading">PaymentVoucherRef</text-property>
                </structure>
                <structure>
                    <property name="columnName">PaymentVoucherId</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">PaymentVoucherId</text-property>
                    <text-property name="heading">PaymentVoucherId</text-property>
                </structure>
                <structure>
                    <property name="columnName">Global</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">Global</text-property>
                    <text-property name="heading">Global</text-property>
                </structure>
                <structure>
                    <property name="columnName">PartnerFullName</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">PartnerFullName</text-property>
                    <text-property name="heading">PartnerFullName</text-property>
                </structure>
                <structure>
                    <property name="columnName">AmountPaid</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">AmountPaid</text-property>
                    <text-property name="heading">AmountPaid</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">AccountingReportId</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                    <property name="position">1</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">PaymentVoucherRef</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">PaymentVoucherId</property>
                        <property name="dataType">decimal</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">Global</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">PartnerFullName</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">AmountPaid</property>
                        <property name="dataType">decimal</property>
                    </structure>
                </list-property>
            </structure>
            <property name="rowFetchLimit">0</property>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">PaymentVoucherRef</property>
                    <property name="nativeName">PaymentVoucherRef</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">PaymentVoucherId</property>
                    <property name="nativeName">PaymentVoucherId</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">Global</property>
                    <property name="nativeName">Global</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-7</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">PartnerFullName</property>
                    <property name="nativeName">PartnerFullName</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">AmountPaid</property>
                    <property name="nativeName">AmountPaid</property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">2</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select PaymentVoucher.ref as "PaymentVoucherRef", PaymentVoucher.id as "PaymentVoucherId", 
AccountingReport.global as "Global", 
Partner.full_name as "PartnerFullName", PaymentVoucher.paid_amount as "AmountPaid"  
-- Récupération des informations de l'en-tête du reporting comptable passé en paramètre
from public.account_accounting_report as AccountingReport 
left outer join public.account_payment_voucher as PaymentVoucher on (AccountingReport.id = ?) 
left outer join public.base_partner as Partner on (PaymentVoucher.partner  = Partner.id)

left outer join public.account_accounting_report_partner_set as PartnerSet on (PartnerSet.account_accounting_report = AccountingReport.id)

left outer join public.base_company as Company on (AccountingReport.company = Company.id) 

-- Récupération des éléments des saisies paiements
left outer join public.account_payment_mode as PaymentMode on (PaymentVoucher.payment_mode = PaymentMode.id) 

where 

-- Filtre sur les paramètres du reporting comptable
(AccountingReport.date_from IS NULL OR date(PaymentVoucher.payment_date) >= AccountingReport.date_from) AND 
(AccountingReport.date_to IS NULL OR date(PaymentVoucher.payment_date)  <= AccountingReport.date_to) AND
date(PaymentVoucher.payment_date) <= AccountingReport.date_val and 
PaymentVoucher.company = Company.id AND
(PartnerSet.partner_set IS NULL OR PartnerSet.partner_set = Partner.id) AND
PaymentMode.type_select = 7 AND PaymentVoucher.status_select = 2 AND PaymentVoucher.operation_type_select = 3
ORDER BY PaymentVoucher.paid_amount]]></xml-property>
        </oda-data-set>
        <oda-data-set extensionID="org.eclipse.birt.report.data.oda.jdbc.JdbcSelectDataSet" name="AccountingReportDS" id="489">
            <property name="nullsOrdering">nulls lowest</property>
            <list-property name="columnHints">
                <structure>
                    <property name="columnName">CompanyName</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">CompanyName</text-property>
                    <text-property name="heading">CompanyName</text-property>
                </structure>
                <structure>
                    <property name="columnName">ReportDate</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">ReportDate</text-property>
                    <text-property name="heading">ReportDate</text-property>
                </structure>
                <structure>
                    <property name="columnName">Global</property>
                    <property name="analysis">measure</property>
                    <text-property name="displayName">Global</text-property>
                    <text-property name="heading">Global</text-property>
                </structure>
                <structure>
                    <property name="columnName">ReportDateEdition</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">ReportDateEdition</text-property>
                    <property name="onColumnLayout">false</property>
                    <text-property name="heading">ReportDateEdition</text-property>
                </structure>
                <structure>
                    <property name="columnName">PeriodName</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">PeriodName</text-property>
                    <text-property name="heading">PeriodName</text-property>
                </structure>
                <structure>
                    <property name="columnName">DateTo</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">DateTo</text-property>
                    <text-property name="heading">DateTo</text-property>
                </structure>
                <structure>
                    <property name="columnName">DateFrom</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">DateFrom</text-property>
                    <text-property name="heading">DateFrom</text-property>
                </structure>
                <structure>
                    <property name="columnName">currency</property>
                    <property name="analysis">dimension</property>
                    <text-property name="displayName">currency</text-property>
                    <text-property name="heading">currency</text-property>
                </structure>
            </list-property>
            <list-property name="parameters">
                <structure>
                    <property name="name">param_1</property>
                    <property name="paramName">AccountingReportId</property>
                    <property name="nativeName"></property>
                    <property name="dataType">decimal</property>
                    <property name="nativeDataType">-5</property>
                    <property name="position">1</property>
                    <property name="isInput">true</property>
                    <property name="isOutput">false</property>
                </structure>
            </list-property>
            <structure name="cachedMetaData">
                <list-property name="resultSet">
                    <structure>
                        <property name="position">1</property>
                        <property name="name">CompanyName</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">2</property>
                        <property name="name">ReportDate</property>
                        <property name="dataType">date</property>
                    </structure>
                    <structure>
                        <property name="position">3</property>
                        <property name="name">Global</property>
                        <property name="dataType">integer</property>
                    </structure>
                    <structure>
                        <property name="position">4</property>
                        <property name="name">ReportDateEdition</property>
                        <property name="dataType">date-time</property>
                    </structure>
                    <structure>
                        <property name="position">5</property>
                        <property name="name">PeriodName</property>
                        <property name="dataType">string</property>
                    </structure>
                    <structure>
                        <property name="position">6</property>
                        <property name="name">DateTo</property>
                        <property name="dataType">date</property>
                    </structure>
                    <structure>
                        <property name="position">7</property>
                        <property name="name">DateFrom</property>
                        <property name="dataType">date</property>
                    </structure>
                    <structure>
                        <property name="position">8</property>
                        <property name="name">currency</property>
                        <property name="dataType">string</property>
                    </structure>
                </list-property>
            </structure>
            <property name="dataSource">Data Source</property>
            <list-property name="resultSet">
                <structure>
                    <property name="position">1</property>
                    <property name="name">CompanyName</property>
                    <property name="nativeName">CompanyName</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">2</property>
                    <property name="name">ReportDate</property>
                    <property name="nativeName">ReportDate</property>
                    <property name="dataType">date</property>
                    <property name="nativeDataType">91</property>
                </structure>
                <structure>
                    <property name="position">3</property>
                    <property name="name">Global</property>
                    <property name="nativeName">Global</property>
                    <property name="dataType">integer</property>
                    <property name="nativeDataType">-7</property>
                </structure>
                <structure>
                    <property name="position">4</property>
                    <property name="name">ReportDateEdition</property>
                    <property name="nativeName">ReportDateEdition</property>
                    <property name="dataType">date-time</property>
                    <property name="nativeDataType">93</property>
                </structure>
                <structure>
                    <property name="position">5</property>
                    <property name="name">PeriodName</property>
                    <property name="nativeName">PeriodName</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
                <structure>
                    <property name="position">6</property>
                    <property name="name">DateTo</property>
                    <property name="nativeName">DateTo</property>
                    <property name="dataType">date</property>
                    <property name="nativeDataType">91</property>
                </structure>
                <structure>
                    <property name="position">7</property>
                    <property name="name">DateFrom</property>
                    <property name="nativeName">DateFrom</property>
                    <property name="dataType">date</property>
                    <property name="nativeDataType">91</property>
                </structure>
                <structure>
                    <property name="position">8</property>
                    <property name="name">currency</property>
                    <property name="nativeName">currency</property>
                    <property name="dataType">string</property>
                    <property name="nativeDataType">12</property>
                </structure>
            </list-property>
            <xml-property name="queryText"><![CDATA[select Company.name as "CompanyName", AccountingReport.date_val as "ReportDate", 
AccountingReport.global as "Global", 
AccountingReport.publication_date_time as "ReportDateEdition", Period.name as "PeriodName", 
AccountingReport.date_to as "DateTo", AccountingReport.date_from as "DateFrom",
Currency.code as currency
from public.account_accounting_report as AccountingReport
inner join public.base_company as Company  on (AccountingReport.id = ? and AccountingReport.company = Company.id)
left outer join public.base_period as Period on (AccountingReport.period = Period.id)
left outer join base_currency as Currency on AccountingReport.currency = Currency.id]]></xml-property>
        </oda-data-set>
    </data-sets>
    <styles>
        <style name="report" id="4">
            <property name="fontFamily">sans-serif</property>
            <property name="fontSize">10pt</property>
        </style>
        <style name="crosstab-cell" id="5">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
        <style name="crosstab" id="6">
            <property name="borderBottomColor">#CCCCCC</property>
            <property name="borderBottomStyle">solid</property>
            <property name="borderBottomWidth">1pt</property>
            <property name="borderLeftColor">#CCCCCC</property>
            <property name="borderLeftStyle">solid</property>
            <property name="borderLeftWidth">1pt</property>
            <property name="borderRightColor">#CCCCCC</property>
            <property name="borderRightStyle">solid</property>
            <property name="borderRightWidth">1pt</property>
            <property name="borderTopColor">#CCCCCC</property>
            <property name="borderTopStyle">solid</property>
            <property name="borderTopWidth">1pt</property>
        </style>
    </styles>
    <page-setup>
        <simple-master-page name="Simple MasterPage" id="2">
            <property name="type">a4</property>
            <property name="orientation">portrait</property>
            <property name="headerHeight">0.33in</property>
            <property name="footerHeight">0.33in</property>
            <page-header>
                <grid id="3117">
                    <property name="width">7.625in</property>
                    <property name="dataSet">AccountingReportDS</property>
                    <list-property name="boundDataColumns">
                        <structure>
                            <property name="name">CompanyName</property>
                            <text-property name="displayName">CompanyName</text-property>
                            <expression name="expression" type="javascript">dataSetRow["CompanyName"]</expression>
                            <property name="dataType">string</property>
                        </structure>
                        <structure>
                            <property name="name">ReportDate</property>
                            <text-property name="displayName">ReportDate</text-property>
                            <expression name="expression" type="javascript">dataSetRow["ReportDate"]</expression>
                            <property name="dataType">date</property>
                        </structure>
                        <structure>
                            <property name="name">Global</property>
                            <text-property name="displayName">Global</text-property>
                            <expression name="expression" type="javascript">dataSetRow["Global"]</expression>
                            <property name="dataType">integer</property>
                        </structure>
                        <structure>
                            <property name="name">ReportDateEdition</property>
                            <text-property name="displayName">ReportDateEdition</text-property>
                            <expression name="expression" type="javascript">dataSetRow["ReportDateEdition"]</expression>
                            <property name="dataType">date-time</property>
                        </structure>
                        <structure>
                            <property name="name">PeriodName</property>
                            <text-property name="displayName">PeriodName</text-property>
                            <expression name="expression" type="javascript">dataSetRow["PeriodName"]</expression>
                            <property name="dataType">string</property>
                        </structure>
                        <structure>
                            <property name="name">DateTo</property>
                            <text-property name="displayName">DateTo</text-property>
                            <expression name="expression" type="javascript">dataSetRow["DateTo"]</expression>
                            <property name="dataType">date</property>
                        </structure>
                        <structure>
                            <property name="name">DateFrom</property>
                            <text-property name="displayName">DateFrom</text-property>
                            <expression name="expression" type="javascript">dataSetRow["DateFrom"]</expression>
                            <property name="dataType">date</property>
                        </structure>
                    </list-property>
                    <column id="3118">
                        <property name="width">6.291666666666667in</property>
                    </column>
                    <column id="3119">
                        <property name="width">1.3333333333333333in</property>
                    </column>
                    <row id="3120">
                        <cell id="3121">
                            <label id="3123">
                                <property name="fontSize">9pt</property>
                                <property name="textAlign">right</property>
                                <text-property name="text">Date d'édition : </text-property>
                            </label>
                        </cell>
                        <cell id="3122">
                            <data id="3160">
                                <property name="resultSetColumn">ReportDateEdition</property>
                            </data>
                        </cell>
                    </row>
                </grid>
            </page-header>
            <page-footer>
                <grid id="3098">
                    <property name="width">7.633333333333333in</property>
                    <column id="3099">
                        <property name="width">6.622222222222222in</property>
                    </column>
                    <column id="3100">
                        <property name="width">1.011111111111111in</property>
                    </column>
                    <row id="3101">
                        <cell id="3102">
                            <label id="3115">
                                <property name="fontSize">9pt</property>
                                <property name="textAlign">right</property>
                                <text-property name="text">Page</text-property>
                            </label>
                        </cell>
                        <cell id="3103">
                            <grid id="3104">
                                <property name="textAlign">right</property>
                                <property name="height">0.3in</property>
                                <column id="3105"/>
                                <column id="3106"/>
                                <column id="3107"/>
                                <row id="3108">
                                    <property name="height">0.3333333333333333in</property>
                                    <cell id="3109">
                                        <property name="paddingTop">0pt</property>
                                        <property name="paddingLeft">0pt</property>
                                        <property name="paddingBottom">0pt</property>
                                        <property name="paddingRight">0pt</property>
                                        <auto-text id="3110">
                                            <property name="fontSize">9pt</property>
                                            <property name="paddingTop">1pt</property>
                                            <property name="paddingLeft">1pt</property>
                                            <property name="paddingBottom">1pt</property>
                                            <property name="paddingRight">1pt</property>
                                            <property name="type">page-number</property>
                                        </auto-text>
                                    </cell>
                                    <cell id="3111">
                                        <property name="paddingTop">0pt</property>
                                        <property name="paddingLeft">0pt</property>
                                        <property name="paddingBottom">0pt</property>
                                        <property name="paddingRight">0pt</property>
                                        <text id="3112">
                                            <property name="fontSize">9pt</property>
                                            <property name="paddingTop">1pt</property>
                                            <property name="paddingLeft">1pt</property>
                                            <property name="paddingBottom">1pt</property>
                                            <property name="paddingRight">1pt</property>
                                            <property name="contentType">plain</property>
                                            <text-property name="content"><![CDATA[/]]></text-property>
                                        </text>
                                    </cell>
                                    <cell id="3113">
                                        <property name="paddingTop">0pt</property>
                                        <property name="paddingLeft">0pt</property>
                                        <property name="paddingBottom">0pt</property>
                                        <property name="paddingRight">0pt</property>
                                        <auto-text id="3114">
                                            <property name="fontSize">9pt</property>
                                            <property name="paddingTop">1pt</property>
                                            <property name="paddingLeft">1pt</property>
                                            <property name="paddingBottom">1pt</property>
                                            <property name="paddingRight">1pt</property>
                                            <property name="type">total-page</property>
                                        </auto-text>
                                    </cell>
                                </row>
                            </grid>
                        </cell>
                    </row>
                </grid>
            </page-footer>
        </simple-master-page>
    </page-setup>
    <body>
        <grid id="490">
            <property name="width">7.688888888888889in</property>
            <property name="dataSet">AccountingReportDS</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">CompanyName</property>
                    <text-property name="displayName">CompanyName</text-property>
                    <expression name="expression" type="javascript">dataSetRow["CompanyName"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">ReportDate</property>
                    <text-property name="displayName">ReportDate</text-property>
                    <expression name="expression" type="javascript">dataSetRow["ReportDate"]</expression>
                    <property name="dataType">date</property>
                </structure>
                <structure>
                    <property name="name">Global</property>
                    <text-property name="displayName">Global</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Global"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">ReportDateEdition</property>
                    <text-property name="displayName">ReportDateEdition</text-property>
                    <expression name="expression" type="javascript">dataSetRow["ReportDateEdition"]</expression>
                    <property name="dataType">date-time</property>
                </structure>
                <structure>
                    <property name="name">PeriodName</property>
                    <text-property name="displayName">PeriodName</text-property>
                    <expression name="expression" type="javascript">dataSetRow["PeriodName"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">DateTo</property>
                    <text-property name="displayName">DateTo</text-property>
                    <expression name="expression" type="javascript">dataSetRow["DateTo"]</expression>
                    <property name="dataType">date</property>
                </structure>
                <structure>
                    <property name="name">DateFrom</property>
                    <text-property name="displayName">DateFrom</text-property>
                    <expression name="expression" type="javascript">dataSetRow["DateFrom"]</expression>
                    <property name="dataType">date</property>
                </structure>
                <structure>
                    <property name="name">currency</property>
                    <text-property name="displayName">currency</text-property>
                    <expression name="expression" type="javascript">dataSetRow["currency"]</expression>
                    <property name="dataType">string</property>
                </structure>
            </list-property>
            <column id="491">
                <property name="width">0.4888888888888889in</property>
            </column>
            <column id="492">
                <property name="width">1.4in</property>
            </column>
            <column id="493">
                <property name="width">1.6041666666666667in</property>
            </column>
            <column id="494">
                <property name="width">0.53125in</property>
            </column>
            <column id="495">
                <property name="width">1.375in</property>
            </column>
            <column id="517">
                <property name="width">2.3125in</property>
            </column>
            <row id="528">
                <property name="height">0.1in</property>
                <cell id="529"/>
                <cell id="530"/>
                <cell id="531"/>
                <cell id="532"/>
                <cell id="533"/>
                <cell id="534"/>
            </row>
            <row id="496">
                <cell id="497"/>
                <cell id="498">
                    <label id="518">
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">right</property>
                        <text-property name="text">SOCIETE  :</text-property>
                    </label>
                </cell>
                <cell id="499">
                    <data id="3150">
                        <property name="resultSetColumn">CompanyName</property>
                    </data>
                </cell>
                <cell id="500"/>
                <cell id="501">
                    <label id="520">
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">right</property>
                        <text-property name="text">DATE : </text-property>
                    </label>
                </cell>
                <cell id="514">
                    <data id="3153">
                        <property name="resultSetColumn">ReportDate</property>
                    </data>
                </cell>
            </row>
            <row id="502">
                <cell id="503"/>
                <cell id="504">
                    <label id="3305">
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">right</property>
                        <text-property name="text">DEVISE  : </text-property>
                    </label>
                </cell>
                <cell id="505">
                    <text id="4219">
                        <property name="contentType">html</property>
                        <text-property name="content"><![CDATA[<VALUE-OF>row["currency"]</VALUE-OF>]]></text-property>
                    </text>
                </cell>
                <cell id="506"/>
                <cell id="507">
                    <label id="3129">
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">right</property>
                        <text-property name="text">PERIODE : </text-property>
                    </label>
                </cell>
                <cell id="515">
                    <data id="3154">
                        <property name="resultSetColumn">PeriodName</property>
                    </data>
                </cell>
            </row>
            <row id="508">
                <cell id="509"/>
                <cell id="510"/>
                <cell id="511"/>
                <cell id="512"/>
                <cell id="513">
                    <label id="3130">
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">right</property>
                        <text-property name="text">DU : </text-property>
                    </label>
                </cell>
                <cell id="516">
                    <data id="3151">
                        <property name="resultSetColumn">DateFrom</property>
                    </data>
                </cell>
            </row>
            <row id="3131">
                <cell id="3132"/>
                <cell id="3133"/>
                <cell id="3134"/>
                <cell id="3135"/>
                <cell id="3136">
                    <label id="3138">
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">right</property>
                        <text-property name="text">AU : </text-property>
                    </label>
                </cell>
                <cell id="3137">
                    <data id="3152">
                        <property name="resultSetColumn">DateTo</property>
                    </data>
                </cell>
            </row>
            <row id="542">
                <property name="height">0.1in</property>
                <cell id="543"/>
                <cell id="544"/>
                <cell id="545"/>
                <cell id="546"/>
                <cell id="547"/>
                <cell id="548"/>
            </row>
            <row id="535">
                <property name="height">0.375in</property>
                <cell id="536">
                    <property name="colSpan">6</property>
                    <property name="rowSpan">1</property>
                    <label id="549">
                        <property name="fontSize">13pt</property>
                        <property name="fontWeight">bold</property>
                        <property name="textAlign">center</property>
                        <text-property name="text">BORDEREAU DE REMISE DE CHEQUES</text-property>
                    </label>
                </cell>
            </row>
        </grid>
        <table id="897">
            <property name="width">7.7444444444444445in</property>
            <property name="dataSet">PaymentVoucherDS</property>
            <list-property name="boundDataColumns">
                <structure>
                    <property name="name">PaymentVoucherRef</property>
                    <text-property name="displayName">PaymentVoucherRef</text-property>
                    <expression name="expression" type="javascript">dataSetRow["PaymentVoucherRef"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">PaymentVoucherId</property>
                    <text-property name="displayName">PaymentVoucherId</text-property>
                    <expression name="expression" type="javascript">dataSetRow["PaymentVoucherId"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">Global</property>
                    <text-property name="displayName">Global</text-property>
                    <expression name="expression" type="javascript">dataSetRow["Global"]</expression>
                    <property name="dataType">integer</property>
                </structure>
                <structure>
                    <property name="name">PartnerFullName</property>
                    <text-property name="displayName">PartnerFullName</text-property>
                    <expression name="expression" type="javascript">dataSetRow["PartnerFullName"]</expression>
                    <property name="dataType">string</property>
                </structure>
                <structure>
                    <property name="name">AmountPaid</property>
                    <text-property name="displayName">AmountPaid</text-property>
                    <expression name="expression" type="javascript">dataSetRow["AmountPaid"]</expression>
                    <property name="dataType">decimal</property>
                </structure>
                <structure>
                    <property name="name">Total</property>
                    <text-property name="displayName">Total</text-property>
                    <property name="dataType">float</property>
                    <property name="aggregateFunction">SUM</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["AmountPaid"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
                <structure>
                    <property name="name">NbOfRow</property>
                    <text-property name="displayName">NbOfRow</text-property>
                    <property name="dataType">integer</property>
                    <property name="aggregateFunction">COUNT</property>
                    <list-property name="arguments">
                        <structure>
                            <property name="name">Expression</property>
                            <expression name="value" type="javascript">row["PaymentVoucherId"]</expression>
                        </structure>
                    </list-property>
                    <property name="allowExport">true</property>
                </structure>
            </list-property>
            <property name="pageBreakInterval">0</property>
            <column id="944">
                <property name="width">1.9270833333333333in</property>
            </column>
            <column id="945">
                <property name="width">1.7777777777777777in</property>
            </column>
            <column id="946">
                <property name="width">2.888888888888889in</property>
            </column>
            <column id="948">
                <property name="width">1.1458333333333333in</property>
            </column>
            <header>
                <row id="898">
                    <property name="height">0.3020833333333333in</property>
                    <cell id="899">
                        <property name="colSpan">2</property>
                        <property name="rowSpan">1</property>
                        <property name="backgroundColor">#E6E6FA</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <label id="900">
                            <text-property name="text">Tiers Payeur</text-property>
                        </label>
                    </cell>
                    <cell id="2662">
                        <property name="colSpan">1</property>
                        <property name="rowSpan">2</property>
                        <property name="backgroundColor">#E6E6FA</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <label id="907">
                            <text-property name="text">Référence</text-property>
                        </label>
                    </cell>
                    <cell id="901">
                        <property name="colSpan">1</property>
                        <property name="rowSpan">2</property>
                        <property name="backgroundColor">#E6E6FA</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                        <label id="911">
                            <text-property name="text">Montant  Total Règlé</text-property>
                        </label>
                    </cell>
                </row>
                <row id="903">
                    <property name="height">0.2916666666666667in</property>
                    <cell id="904">
                        <property name="colSpan">2</property>
                        <property name="rowSpan">1</property>
                        <property name="backgroundColor">#E6E6FA</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <label id="905">
                            <text-property name="text">Nom Prénom</text-property>
                        </label>
                    </cell>
                </row>
            </header>
            <detail>
                <row id="913">
                    <property name="height">0.25in</property>
                    <cell id="914">
                        <property name="colSpan">2</property>
                        <property name="rowSpan">1</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <data id="3156">
                            <property name="resultSetColumn">PartnerFullName</property>
                        </data>
                    </cell>
                    <cell id="918">
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <data id="3157">
                            <property name="textAlign">center</property>
                            <property name="resultSetColumn">PaymentVoucherRef</property>
                        </data>
                    </cell>
                    <cell id="921">
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <data id="3155">
                            <structure name="numberFormat">
                                <property name="category">Custom</property>
                                <property name="pattern">###,##0.00</property>
                            </structure>
                            <property name="textAlign">right</property>
                            <property name="resultSetColumn">AmountPaid</property>
                        </data>
                    </cell>
                </row>
            </detail>
            <footer>
                <row id="929">
                    <property name="backgroundColor">#EFEFEF</property>
                    <property name="height">0.3958333333333333in</property>
                    <cell id="930">
                        <property name="backgroundColor">#FFFFFF</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                    </cell>
                    <cell id="931">
                        <property name="colSpan">2</property>
                        <property name="rowSpan">1</property>
                        <property name="backgroundColor">#FFFFFF</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <text id="979">
                            <property name="fontSize">9.5pt</property>
                            <property name="fontWeight">bold</property>
                            <property name="fontStyle">italic</property>
                            <property name="textAlign">center</property>
                            <property name="contentType">auto</property>
                            <text-property name="content"><![CDATA[TOTAL REGLEMENTS]]></text-property>
                        </text>
                    </cell>
                    <cell id="935">
                        <property name="backgroundColor">#E5E5E5</property>
                        <property name="borderBottomColor">#000000</property>
                        <property name="borderBottomStyle">solid</property>
                        <property name="borderBottomWidth">thin</property>
                        <property name="borderLeftColor">#000000</property>
                        <property name="borderLeftStyle">solid</property>
                        <property name="borderLeftWidth">thin</property>
                        <property name="borderRightColor">#000000</property>
                        <property name="borderRightStyle">solid</property>
                        <property name="borderRightWidth">thin</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <data id="3159">
                            <property name="fontWeight">bold</property>
                            <structure name="numberFormat">
                                <property name="category">Custom</property>
                                <property name="pattern">###,##0.00</property>
                            </structure>
                            <property name="textAlign">right</property>
                            <property name="resultSetColumn">Total</property>
                        </data>
                    </cell>
                </row>
                <row id="2663">
                    <property name="backgroundColor">#EFEFEF</property>
                    <property name="height">0.2in</property>
                    <cell id="2664">
                        <property name="colSpan">4</property>
                        <property name="rowSpan">1</property>
                        <property name="backgroundColor">#FFFFFF</property>
                        <property name="borderTopColor">#000000</property>
                        <property name="borderTopStyle">solid</property>
                        <property name="borderTopWidth">thin</property>
                        <property name="verticalAlign">middle</property>
                    </cell>
                </row>
                <row id="936">
                    <property name="backgroundColor">#EFEFEF</property>
                    <property name="height">0.3958333333333333in</property>
                    <cell id="937">
                        <property name="colSpan">3</property>
                        <property name="rowSpan">1</property>
                        <property name="backgroundColor">#FFFFFF</property>
                        <property name="verticalAlign">middle</property>
                        <text id="940">
                            <property name="fontSize">9.5pt</property>
                            <property name="textAlign">center</property>
                            <property name="contentType">auto</property>
                            <text-property name="content"><![CDATA[Nombre total de chèques
]]></text-property>
                        </text>
                    </cell>
                    <cell id="942">
                        <property name="backgroundColor">#E5E5E5</property>
                        <property name="verticalAlign">middle</property>
                        <property name="whiteSpace">nowrap</property>
                        <data id="3161">
                            <property name="fontWeight">bold</property>
                            <property name="color">red</property>
                            <property name="textAlign">center</property>
                            <property name="resultSetColumn">NbOfRow</property>
                        </data>
                    </cell>
                </row>
            </footer>
        </table>
        <label id="3304">
            <property name="fontWeight">bold</property>
            <property name="textAlign">right</property>
            <text-property name="text">DEVISE  : </text-property>
        </label>
    </body>
</report>
