anji.viper

You could try the property keepTogether: <group name="group1" keepTogether="true">

Jasper studio is really only fit for PDF export, since what you see is what you get. The preview is not accurate since it will also show you what's in Jasper studio, it doesn't necessarily mean that's what you'll get when exporting to other formats. For example Excel color codes are very limited, some colours you have created in Jasper studio won't render properly when exporting to Excel, but they show perfectly well in the preview. There are a lot of limitations for Excel export, so I guess it's the same for PowerPoint export as well..

I have only ever added it and set it to true when needed. My logic says that it is false by default, but it doesn't appear in the code if you don't set it manually.

I use pattern "#,##0.00" in Jasper studio but the number will appear as 1,000.00 in certain cases, and in others it will appear as "1 000,00".. Such as France because France uses an empty space as the thousands separator and comma as decimal separator.

Are you using the Table element or directly creating your table in the main report? Where are you placing your "Buyers 1 to 8 as follows"? (Same detail band as the table, another detail band..?)

Hello, Can anyone help me on how to create a simple book report with 2 content pages, to be generated to an Excel file? The book report works well when previewed locally on Jaspersoft Studio (version 6.3.1) when used with the Sample DB. But when I tried running the report with actual sub-reports via my JasperServer, I'm getting this error: cvc-complex-type.3.2.2 : L'attribut 'sectionType' n'est pas autorisé dans l'élément 'jasperReport'. If I remove the sectionType attribute, I get this error: cvc-complex-type.2.4.a : Contenu non valide trouvé à partir de l'élément 'part'. L'une des valeurs '{"http://jasperreports.sourceforge.net/jasperreports":band}' est attendue. Both sub-reports that make up the "content" pages run well when generated via the JasperServer individually. Is it perhaps an error caused by outdated version of JasperServer? I have seen most Book Reports for Jaspersoft Studio 6.7.0 but not on lower versions. Any solution? Any help would be greatly appreciated! Code: <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --> <!-- 2019-02-25T17:24:33 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="Wave_Book" pageWidth="595" pageHeight="842" sectionType="Part" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="30" bottomMargin="30" uuid="8aeb51ad-eabb-4c1a-b4c6-2ba65fcea625"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="New Data Adapter (2)"/> <property name="net.sf.jasperreports.print.create.bookmarks" value="true"/> <property name="com.jaspersoft.studio.book.group.cover.header" value="Cover and Table of Contents"/> <property name="com.jaspersoft.studio.book.group.cover.footer" value="Backcover"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <queryString> <![CDATA[select null as empty from dso.t_organisation limit 1;]]> </queryString> <field name="empty" class="java.lang.String"/> <group name="cover"/> <detail> <part uuid="63a8632b-a2db-4a20-a887-0952e51c8da9"> <partNameExpression><![CDATA["subtest 1"]]></partNameExpression> <p:subreportPart xmlns:p="http://jasperreports.sourceforge.net/jasperreports/parts" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/parts http://jasperreports.sourceforge.net/xsd/parts.xsd"> <subreportParameter name="REPORT_CONNECTION"> <subreportParameterExpression><![CDATA[$P{REPORT_CONNECTION}]]></subreportParameterExpression> </subreportParameter> <subreportExpression><![CDATA["/mnt/tomcat_gfs/data/storage/fileserver/reports/bordereaureversementclientv34testDecembrepart1.jasper"]]></subreportExpression> </p:subreportPart> </part> <part uuid="aa6eba4e-de2b-449d-8785-b0c128fb4222"> <partNameExpression><![CDATA["subtest 2"]]></partNameExpression> <p:subreportPart xmlns:p="http://jasperreports.sourceforge.net/jasperreports/parts" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/parts http://jasperreports.sourceforge.net/xsd/parts.xsd"> <subreportParameter name="REPORT_CONNECTION"> <subreportParameterExpression><![CDATA[$P{REPORT_CONNECTION}]]></subreportParameterExpression> </subreportParameter> <subreportExpression><![CDATA["/mnt/tomcat_gfs/data/storage/fileserver/reports/bordereaureversementclientv34testDecembrepart2.jasper"]]></subreportExpression> </p:subreportPart> </part> </detail> </jasperReport>

Hello, I'm trying to treat 2 sheets separately in the same excel. I need to align all the elements or else excel will break some columns into 2 or more and merge them for larger columns. In the example I have attached, I had to enlarge the column "Reference DSO" in order to cater for the large text in the column "Libelle du virement". The first one should instead be small and the 2nd be large. Any idea how I can achieve this? Is there a way to size both columns small and make the 2nd expand horizontally dynamically depending on the longer text inside it? Thank you. <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1 --> <!-- 2019-02-11T10:10:47 --> <jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="bord_revers" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="0" bottomMargin="0" uuid="5253a652-bb29-48d9-ba8b-0dac86952ac5"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <property name="net.sf.jasperreports.export.xls.one.page.per.sheet" value="true"/> <property name="net.sf.jasperreports.page.break.no.pagination" value="apply"/> <property name="net.sf.jasperreports.export.xls.freeze.row" value="5"/> <property name="net.sf.jasperreports.export.xls.show.gridlines" value="false"/> <property name="com.jaspersoft.studio.unit." value="pixel"/> <property name="net.sf.jasperreports.export.xls.sheet.names.all" value="DETAIL_DOSSIERS/DETAIL_VIREMENTS"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="One Empty Record"/> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/> <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/> <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/> <import value="net.sf.jasperreports.engine.*"/> <import value="com.dso.utils.file.FileManager"/> <style name="table"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 2"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 2_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 2_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 2_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 3_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3_CH" mode="Opaque" backcolor="#BFE1FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 3_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 4"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 4_TH" mode="Opaque" backcolor="#4682B4"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 4_CH" mode="Opaque" backcolor="#BFE2FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 4_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 5"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 5_TH" mode="Opaque" backcolor="#4682B4"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 5_CH" mode="Opaque" backcolor="#BFE2FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 5_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 6"> <box> <pen lineWidth="1.0" lineColor="#000000"/> </box> </style> <style name="table 6_TH" mode="Opaque" backcolor="#4682B4"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 6_CH" mode="Opaque" backcolor="#BFE2FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 6_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 7_TH" mode="Opaque" backcolor="#4682B4"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 7_CH" mode="Opaque" backcolor="#BFE2FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="table 7_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_CH" mode="Opaque" backcolor="#0D3364"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_CH" mode="Opaque" backcolor="#0D3364"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 1_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 2_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 2_CH" mode="Opaque" backcolor="#0D3364"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 2_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 3_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 3_CH" mode="Opaque" backcolor="#003366"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 3_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 4_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 4_CH" mode="Opaque" backcolor="#003366"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 4_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 6_TH" mode="Opaque" backcolor="#F0F8FF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 6_CH" mode="Opaque" backcolor="#003366"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 6_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="TableAddRowBorder"> <box> <topPen lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <conditionalStyle> <conditionExpression><![CDATA[$F{period}.length() > 1]]></conditionExpression> <style mode="Opaque" backcolor="#FFFFFF"> <box> <topPen lineWidth="0.5"/> </box> </style> </conditionalStyle> </style> <style name="Table 5_TH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 5_CH" mode="Opaque" backcolor="#033660"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 5_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 7_CH" mode="Opaque" backcolor="#033660"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 7_TH" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <style name="Table 7_TD" mode="Opaque" backcolor="#FFFFFF"> <box> <pen lineWidth="0.5" lineColor="#000000"/> <topPen lineWidth="0.5" lineColor="#000000"/> <leftPen lineWidth="0.5" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineColor="#000000"/> <rightPen lineWidth="0.5" lineColor="#000000"/> </box> </style> <subDataset name="tenant image" uuid="9eb15873-8c42-4d92-8b30-58a422925617"> <parameter name="FILE_MANAGER" class="com.dso.utils.file.FileManager"/> <parameter name="TENANT" class="java.lang.String"/> <parameter name="ID_CURRENT_ORGANISATION" class="java.lang.String"/> <queryString> <![CDATA[select checksum from t_fichier where id_fichier = (select id_fichier from t_organisation where id_organisation = (select id_operateur_metier from t_tenant))]]> </queryString> <field name="checksum" class="java.lang.String"/> </subDataset> <subDataset name="ClientImage" uuid="ff84e10b-f31c-44b9-aa8f-d61dba207603"> <parameter name="FILE_MANAGER" class="com.dso.utils.file.FileManager"/> <parameter name="TENANT" class="java.lang.String"/> <parameter name="ID_CURRENT_ORGANISATION" class="java.lang.String"/> <queryString> <![CDATA[select checksum from t_fichier where id_fichier = (select id_fichier from t_organisation where id_organisation = $P{ID_CURRENT_ORGANISATION})]]> </queryString> <field name="checksum" class="java.lang.String"/> </subDataset> <subDataset name="Tableau1" uuid="707682db-5330-4ba4-b323-01351641a31e"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="migration-adapter"/> <parameter name="NUMBER_ADAPTER" class="com.dso.utils.culture.NumberAdapter"/> <parameter name="DEVISE" class="java.lang.String"/> <parameter name="CULTURE" class="com.dso.model.user.Culture"/> <parameter name="LANGUAGE" class="java.lang.String"/> <parameter name="ID_CURRENT_ORGANISATION" class="java.lang.String"/> <queryString language="SQL"> <![CDATA[select serie, ref_do, ref_dso, nom_debiteur, date_enc, mode_paiement, dat_reversement, round(case when lib_code like '%GENERALI%' then mnt_reverse/* - montant_TTC::numeric*/ else mnt_reverse + montant_TTC::numeric end,2) as mnt_reverse, round(mnt_direct,2) as mnt_direct, round(case when lib_code like '%GENERALI%' then mnt_total/* - montant_TTC::numeric*/ else mnt_total + montant_TTC::numeric end,2) as mnt_total from ( select o.lib_code, s.lib_nom as serie, d.cod_tech_ref_client as ref_do, d.cod_tech_ref_interne as ref_dso, coalesce(ccpp.lib_nom||' '||ccpp.lib_prenom, ccpm.lib_raison_sociale) as nom_debiteur, date_trunc('day', v.dat_create) as date_enc, case when v.id_type_versement = '4028b8815607410d0156074150e402c3' then tmrt.lib_traduction else vtt.lib_traduction end as mode_paiement, date_trunc('day', rv.dat_reversement) as dat_reversement, case when v.id_type_versement = '4028b8815607410d0156074150e402c3' then 0 else v.num_montant - ( select coalesce(sum(vi.num_montant) ,0) from dso.t_imputation vi inner join dso.t_creance c on c.id_creance = vi.id_creance and c.boo_supprime = false and c.boo_en_migration = false inner join dso.t_creance_type ct on ct.id_creance_type = c.id_creance_type and ct.boo_supprime = false and ct.boo_en_migration = false and ct.cod_tech_creance_type||c.cod_beneficiaire = 'FRAISOPERATEUR_METIER' where vi.id_versement = v.id_versement ) end as mnt_reverse, case when v.id_type_versement = '4028b8815607410d0156074150e402c3' then v.num_montant else 0 end as mnt_direct, case when v.id_type_versement = '4028b8815607410d0156074150e402c3' then 0 else v.num_montant - ( select coalesce(sum(vi.num_montant) ,0) from dso.t_imputation vi inner join dso.t_creance c on c.id_creance = vi.id_creance and c.boo_supprime = false and c.boo_en_migration = false inner join dso.t_creance_type ct on ct.id_creance_type = c.id_creance_type and ct.boo_supprime = false and ct.boo_en_migration = false and ct.cod_tech_creance_type||c.cod_beneficiaire = 'FRAISOPERATEUR_METIER' where vi.id_versement = v.id_versement ) end + case when v.id_type_versement = '4028b8815607410d0156074150e402c3' then v.num_montant else 0 end as mnt_total, coalesce((t.num_tva/100)*v.num_montant_honoraire_opm,0) + coalesce(v.num_montant_honoraire_opm,0) as montant_TTC from dso.t_dossier d inner join dso.t_organisation o on o.id_organisation = d.id_client and d.id_client = $P{ID_CURRENT_ORGANISATION} and o.boo_en_migration = false and o.boo_supprime = false inner join dso.t_versement v on v.id_dossier = d.id_dossier and v.lib_statut = 'REVERSE' and v.boo_en_migration = false and v.boo_supprime = false inner join dso.t_reversement rv on rv.id_reversement = v.id_reversement and rv.boo_en_migration = false and rv.boo_supprime = false and to_char(date_trunc('day', rv.dat_reversement),'yyyyMMdd') = to_char(to_date('20181227','yyyyMMdd'),'yyyyMMdd') inner join dso.t_dossier_serie s on s.id_dossier_serie = d.id_serie and s.boo_en_migration = false and s.boo_supprime = false inner join dso.t_compte_client_personne ccp on ccp.id_compte_client_personne = d.id_compte_debiteur and ccp.boo_en_migration = false and ccp.boo_supprime = false left join dso.t_compte_client_personne_physique ccpp on ccpp.id_compte_client_personne = ccp.id_compte_client_personne and ccpp.boo_en_migration = false and ccpp.boo_supprime = false left join dso.t_compte_client_personne_morale ccpm on ccpm.id_compte_client_personne = ccp.id_compte_client_personne and ccpm.boo_en_migration = false and ccpm.boo_supprime = false left join dso.t_type_versement tv on tv.id_type_versement = v.id_type_versement and tv.boo_supprime = false and tv.boo_en_migration = false left join dso.t_type_versement_type_traductions vtt on vtt.id_type_versement = tv.id_type_versement and vtt.id_language = '4028b8815607410d01560741429c0001' left join dso.t_mode_reglement_traductions tmrt on tmrt.id_type = v.id_mode_reglement and tmrt.id_language = '4028b8815607410d01560741429c0001' inner join dso.t_tenant t on t.id_operateur_metier = '4028b8815607410d015607415bbd04d7' order by date_trunc('day',v.dat_create), d.cod_tech_ref_interne ) x]]> </queryString> <field name="serie" class="java.lang.String"/> <field name="ref_do" class="java.lang.String"/> <field name="ref_dso" class="java.lang.String"/> <field name="nom_debiteur" class="java.lang.String"/> <field name="date_enc" class="java.sql.Timestamp"/> <field name="mode_paiement" class="java.lang.String"/> <field name="mnt_reverse" class="java.math.BigDecimal"/> <field name="mnt_direct" class="java.math.BigDecimal"/> <field name="mnt_total" class="java.math.BigDecimal"/> <field name="dat_reversement" class="java.sql.Timestamp"/> <variable name="SUM_REVERS" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{mnt_reverse}]]></variableExpression> </variable> <variable name="SUM_TOTALS" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{mnt_total}]]></variableExpression> </variable> <variable name="SUM_VDI" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{mnt_direct}]]></variableExpression> </variable> </subDataset> <subDataset name="Tableau2" uuid="f68fe728-23a7-40af-96f1-5f1b2d142227"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="migration-adapter"/> <parameter name="ID_CURRENT_ORGANISATION" class="java.lang.String"/> <queryString language="SQL"> <![CDATA[select distinct tl.cod_type,tl.lib_type_reversement, date_trunc('day', rv.dat_reversement) as dat_reversement, date_trunc('day', tsd.dat_exec) as dat_exec_vir, tsd.payment_identification as ref_vir, tsd.ref_virement as lib_vir, round(tsd.amount,2) as mnt_vir, tsd.cre_bic as bic, tsd.cre_iban as iban, case when tl.lib_type_reversement = 'DETAILLE' then d.cod_tech_ref_interne else '' end as ref_dso, case when tl.lib_type_reversement = 'DETAILLE' then coalesce(ccpp.lib_nom||' '||ccpp.lib_prenom, ccpm.lib_raison_sociale) else '' end as nom_debiteur ,tsd.id_transfer_sepa_header, tsd.id_transfer_sepa_details, round(case when o.lib_code like '%GENERALI%' then coalesce(rv.num_hono_opm,0) + coalesce(rv.num_vat,0) else coalesce(ttc.montant_ttc::numeric,0) end,2) as hono_ttc, round(case when o.lib_code like '%GENERALI%' then coalesce(rv.num_hono_opm,0) + coalesce(rv.num_vat,0) + coalesce(tsd.amount,0) else coalesce(rv.num_hono_opm,0) + coalesce(rv.num_vat,0) + coalesce(tsd.amount,0) + coalesce(ttc.montant_ttc::numeric,0) end,2) as mnt_rev_dso, rv.id_reversement from dso.t_dossier d inner join dso.t_organisation o on o.id_organisation = d.id_client and d.id_client = $P{ID_CURRENT_ORGANISATION} and o.boo_en_migration = false and o.boo_supprime = false inner join dso.t_versement v on v.id_dossier = d.id_dossier and v.lib_statut = 'REVERSE' and v.boo_en_migration = false and v.boo_supprime = false inner join dso.t_compte_client_personne ccp on ccp.id_compte_client_personne = d.id_compte_debiteur and ccp.boo_en_migration = false and ccp.boo_supprime = false inner join dso.t_reversement rv on rv.id_reversement = v.id_reversement and rv.boo_en_migration = false and rv.boo_supprime = false and to_char(date_trunc('day', rv.dat_reversement),'yyyyMMdd') = to_char(to_date('20181227','yyyyMMdd'),'yyyyMMdd') inner join dso.t_transfer_log tl on tl.id_reversement = rv.id_reversement and tl.cod_type like '%TO_CLIENT_ACCOUNT%' and tl.boo_en_migration = false and tl.boo_supprime = false inner join public.t_transfer_sepa_details tsd on tsd.id_transfer_log = tl.id_transfer_log and tsd.ref_virement like '%HUISSIERS%' and tsd.boo_en_migration = false and tsd.boo_supprime = false left join dso.t_compte_client_personne_physique ccpp on ccpp.id_compte_client_personne = ccp.id_compte_client_personne and ccpp.boo_en_migration = false and ccpp.boo_supprime = false left join dso.t_compte_client_personne_morale ccpm on ccpm.id_compte_client_personne = ccp.id_compte_client_personne and ccpm.boo_en_migration = false and ccpm.boo_supprime = false left join (select rv.id_reversement, coalesce(sum((t.num_tva/100)*v.num_montant_honoraire_opm),0) + coalesce(sum(v.num_montant_honoraire_opm),0) as montant_TTC from dso.t_dossier d inner join dso.t_organisation o on o.id_organisation = d.id_client and d.id_client = $P{ID_CURRENT_ORGANISATION} and o.boo_en_migration = false and o.boo_supprime = false inner join dso.t_versement v on v.id_dossier = d.id_dossier and v.lib_statut = 'REVERSE' and v.boo_en_migration = false and v.boo_supprime = false inner join dso.t_reversement rv on rv.id_reversement = v.id_reversement and rv.boo_en_migration = false and rv.boo_supprime = false inner join dso.t_tenant t on t.id_operateur_metier = '4028b8815607410d015607415bbd04d7' and to_char(date_trunc('day', rv.dat_reversement),'yyyyMMdd') = to_char(to_date('20181227','yyyyMMdd'),'yyyyMMdd') group by rv.id_reversement ) ttc on ttc.id_reversement = rv.id_reversement where d.boo_en_migration = false and d.boo_supprime = false]]> </queryString> <field name="dat_reversement" class="java.sql.Timestamp"/> <field name="dat_exec_vir" class="java.sql.Timestamp"/> <field name="ref_vir" class="java.lang.String"/> <field name="lib_vir" class="java.lang.String"/> <field name="mnt_vir" class="java.math.BigDecimal"/> <field name="bic" class="java.lang.String"/> <field name="iban" class="java.lang.String"/> <field name="ref_dso" class="java.lang.String"/> <field name="nom_debiteur" class="java.lang.String"/> <field name="id_transfer_sepa_header" class="java.lang.String"/> <field name="id_transfer_sepa_details" class="java.lang.String"/> <field name="hono_ttc" class="java.math.BigDecimal"/> <field name="mnt_rev_dso" class="java.math.BigDecimal"/> <field name="id_reversement" class="java.lang.String"/> <variable name="SUM_VIREMENTS" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{mnt_vir}]]></variableExpression> </variable> <variable name="SUM_HONO_TTC" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{hono_ttc}]]></variableExpression> </variable> <variable name="SUM_ENC" class="java.math.BigDecimal" calculation="Sum"> <variableExpression><![CDATA[$F{mnt_rev_dso}]]></variableExpression> </variable> </subDataset> <subDataset name="titre" uuid="5998d628-bb0b-475c-a2fe-ed075a444d22"> <property name="com.jaspersoft.studio.data.sql.tables" value=""/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="migration-adapter"/> <parameter name="ID_CURRENT_ORGANISATION" class="java.lang.String"/> <queryString language="SQL"> <![CDATA[select distinct mc.lib_nom as mandat_ccial, o.lib_code as nom_client, to_char(rv.dat_reversement, 'dd/MM/yyyy') as date_rev from dso.t_dossier d inner join dso.t_organisation o on o.id_organisation = d.id_client and d.id_client = $P{ID_CURRENT_ORGANISATION} and o.boo_en_migration = false and o.boo_supprime = false inner join dso.t_versement v on v.id_dossier = d.id_dossier and v.lib_statut = 'REVERSE' and v.boo_en_migration = false and v.boo_supprime = false inner join dso.t_reversement rv on rv.id_reversement = v.id_reversement and rv.boo_en_migration = false and rv.boo_supprime = false and to_char(date_trunc('day', rv.dat_reversement),'yyyyMMdd') = to_char(to_date('20181227','yyyyMMdd'),'yyyyMMdd') inner join dso.t_mandat mc on mc.id_mandat = d.id_mandat_comercial and mc.boo_en_migration = false and mc.boo_supprime = false where d.id_client = $P{ID_CURRENT_ORGANISATION}]]> </queryString> <field name="mandat_ccial" class="java.lang.String"/> <field name="nom_client" class="java.lang.String"/> <field name="date_rev" class="java.lang.String"/> <variable name="DO" class="java.lang.String"> <variableExpression><![CDATA[$F{nom_client}]]></variableExpression> <initialValueExpression><![CDATA[$F{nom_client}]]></initialValueExpression> </variable> <variable name="MANDAT" class="java.lang.String"> <variableExpression><![CDATA[$F{mandat_ccial}]]></variableExpression> <initialValueExpression><![CDATA["mndt"]]></initialValueExpression> </variable> <variable name="DATE_REVERS" class="java.lang.String"> <variableExpression><![CDATA[$F{date_rev}]]></variableExpression> </variable> </subDataset> <parameter name="ID_CURRENT_ORGANISATION" class="java.lang.String"/> <parameter name="FILE_MANAGER" class="com.dso.utils.file.FileManager"/> <parameter name="TENANT" class="java.lang.String"/> <parameter name="DATE_ADAPTER" class="com.dso.utils.culture.DateAdapter"/> <parameter name="NUMBER_ADAPTER" class="com.dso.utils.culture.NumberAdapter"/> <parameter name="DEVISE" class="java.lang.String"/> <parameter name="CULTURE" class="com.dso.model.user.Culture" isForPrompting="false"/> <parameter name="LANGUAGE" class="java.lang.String"/> <queryString> <![CDATA[]]> </queryString> <background> <band splitType="Stretch"/> </background> <pageHeader> <band height="89" splitType="Stretch"> <textField> <reportElement x="0" y="0" width="430" height="15" uuid="29da0065-6346-4321-883e-4e304df10a94"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle" markup="styled"> <font fontName="SansSerif" size="8" isBold="true" isItalic="false"/> </textElement> <textFieldExpression><![CDATA["DSO GROUP - PLATEFORME MARS"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="572" y="0" width="230" height="15" uuid="ba8cdc6d-8d7a-4d81-800f-042d2bf1eeb3"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$P{DATE_ADAPTER}.marshal(new java.util.Date())]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="0" y="16" width="802" height="40" forecolor="#FFFFFF" backcolor="#808080" uuid="ca848b74-e219-428d-98e4-f4ddb11a6d81"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> <pen lineWidth="2.0" lineStyle="Solid" lineColor="#3B3A3A"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="styled"> <font fontName="SansSerif" size="16" isBold="true" isItalic="false"/> </textElement> <textFieldExpression><![CDATA["DETAIL DES SOMMES RECOUVREES PAR DOSSIER"]]></textFieldExpression> </textField> </band> </pageHeader> <detail> <band height="145"> <componentElement> <reportElement mode="Transparent" x="0" y="60" width="802" height="85" forecolor="#FFFFFF" uuid="da8048fa-4a8d-45ca-a5ba-45fdbfeb2911"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 7_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 7_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table 7_TD"/> <property name="net.sf.jasperreports.export.xls.break.after.row" value="TRUE"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="Tableau1" uuid="f764f704-bb16-410a-90e0-59394eae4d94"> <datasetParameter name="ID_CURRENT_ORGANISATION"> <datasetParameterExpression><![CDATA[$P{ID_CURRENT_ORGANISATION}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="135" uuid="84cc3174-d97c-42a1-b39b-4f053de6556e"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="135" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="47470f88-cfd1-4abf-b6e5-7dbf9764896a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[série de dossiers]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="135" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="01827f37-09d8-437b-9756-f5b4c3624fa9"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement x="0" y="0" width="135" height="15" uuid="396faa8e-9cb3-4f9a-8314-587fcf2db1f2"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$F{serie}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="60" uuid="ffb3024a-6e40-40b5-86d4-4fe5c974113e"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="60" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="a5889ef3-c3c2-4154-9c83-41ff17c3e42f"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Référence du Donneur d'Ordre]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="5c68560f-5bf3-4566-9c64-f80df8c92a76"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement x="0" y="0" width="60" height="15" uuid="5f053f11-3c09-4983-b3d7-25bc28d67890"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$F{ref_do}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="200" uuid="b11ce6d2-eb42-4e0f-9a6d-62919d551c95"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <box> <rightPen lineWidth="0.0"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="200" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="b84a7608-6573-4d22-b27e-f1334a30d020"> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> </reportElement> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Référence DSO]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="200" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="9a97e6a2-a220-4449-b17a-8e85ff6af773"> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> </reportElement> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0"> <reportElement x="0" y="0" width="200" height="15" uuid="e2e1cb94-b9fa-462c-b950-b7ea46dc9007"> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> </reportElement> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$F{ref_dso}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="135" uuid="7adafb4b-d9eb-4e91-9717-ac50fd7360be"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="135" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="984e8763-6ff5-438b-8d51-d19aa856312c"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Nom du débiteur]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="135" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="03b119bc-bf88-4ad3-a551-63537d7b2b3c"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0"> <reportElement x="0" y="0" width="135" height="15" uuid="d323a2a4-cd94-4258-bef6-9c47f41da087"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0"/> </textElement> <textFieldExpression><![CDATA[$F{nom_debiteur}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="60" uuid="2d3732c3-11aa-434f-9c96-a797d3403ef5"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="60" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="e8a62a28-fd57-4673-ab6e-b00f24051aa4"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Date d'encaiss.]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="f4854cd7-6543-4f83-84e4-2c9eddf7a693"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="dd/MM/yyyy"> <reportElement x="0" y="0" width="60" height="15" uuid="b65267c3-4470-4a22-a269-abbab16209e2"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="10"/> </textElement> <textFieldExpression><![CDATA[$F{date_enc}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="160" uuid="6dc02404-dea4-46c4-bff6-7d3ab7697f09"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="160" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="074e805a-b716-487b-a847-e429fe8953a3"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Mode de paiement]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="160" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="3ee0d164-6a15-4102-9a68-179386999231"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0"> <reportElement x="0" y="0" width="160" height="15" uuid="0e91efae-d610-45be-90cc-8d34e9d1d1ff"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="10"/> </textElement> <textFieldExpression><![CDATA[$F{mode_paiement}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="140" uuid="c01374f0-c4fa-4b26-bcce-b8bb4b1907ca"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <staticText> <reportElement mode="Opaque" x="0" y="0" width="140" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="09bd8bed-969e-44aa-a980-4768d9a1868b"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Montant reversé par DSO]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="com.jaspersoft.studio.unit.width" value="cm"/> <textField pattern="#,##0.00"> <reportElement mode="Opaque" x="0" y="0" width="140" height="20" forecolor="#000000" backcolor="#D1D1D1" uuid="8003115a-53b9-4227-a031-0c14c35a1a73"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$V{SUM_REVERS}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0.00"> <reportElement x="0" y="0" width="140" height="15" uuid="3b922434-ec52-460a-b1cd-8a385c7608af"> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="10"/> </textElement> <textFieldExpression><![CDATA[$F{mnt_reverse}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="140" uuid="774ca744-689e-4db9-890e-a56d4479abfa"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column8"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="140" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="5beb1df4-bb8e-472a-b3ae-395516a248e6"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Montant encaissé en direct (pour info.)]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <textField pattern="#,##0.00"> <reportElement mode="Opaque" x="0" y="0" width="140" height="20" forecolor="#000000" backcolor="#D1D1D1" uuid="51393a05-c50c-4b25-92cc-d2e17cf83682"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$V{SUM_VDI}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0.00"> <reportElement x="0" y="0" width="140" height="15" uuid="ddcd2591-6913-49c1-b991-edef1324a4e1"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0"/> </textElement> <textFieldExpression><![CDATA[$F{mnt_direct}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="140" uuid="1f9a0af1-b9e2-42ba-8157-975107e568c6"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column9"/> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <staticText> <reportElement mode="Opaque" x="0" y="0" width="140" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="c9e0748c-c5d6-45c9-9931-82998740271a"/> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Montant total recouvré]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <textField pattern="#,##0.00"> <reportElement mode="Opaque" x="0" y="0" width="140" height="20" forecolor="#000000" backcolor="#D1D1D1" uuid="bbb820f8-31e7-4b2e-9f2b-ff9e7f854c34"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$V{SUM_TOTALS}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0.00"> <reportElement x="0" y="0" width="140" height="15" uuid="b16dfa56-2550-49f1-a55e-235326ac0e1e"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0"/> </textElement> <textFieldExpression><![CDATA[$F{mnt_total}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <componentElement> <reportElement mode="Opaque" x="0" y="-10" width="802" height="25" forecolor="#000000" uuid="a58986f0-14ec-429f-a262-4bb78ff0c517"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 7_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 7_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table 7_TD"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="titre" uuid="d88867a1-fa50-4b6b-ac6a-bcbb1fd5055a"> <datasetParameter name="ID_CURRENT_ORGANISATION"> <datasetParameterExpression><![CDATA[$P{ID_CURRENT_ORGANISATION}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="752" uuid="f9afcb97-ea62-466d-831f-73bbea3cd1e3"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:detailCell style="Table 7_TD" height="25"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement x="0" y="0" width="752" height="25" uuid="31ef77d9-23a7-4e2f-a185-7179f03c8eee"/> <box> <pen lineWidth="0.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="12" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA["Donneur d'Ordre : "+ $F{nom_client} + " - Mandat : "+$F{mandat_ccial} + " - Reversement du : "+$F{date_rev}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> </band> <band height="20"> <textField> <reportElement x="0" y="0" width="430" height="20" uuid="d3c712b9-10de-472c-9d46-1d6d77bf8b0b"> <property name="net.sf.jasperreports.export.xls.break.after.row" value="TRUE"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <textElement> <font fontName="DejaVu Sans"/> </textElement> <textFieldExpression><![CDATA[""]]></textFieldExpression> </textField> </band> <band height="225"> <componentElement> <reportElement mode="Transparent" x="0" y="100" width="802" height="125" forecolor="#FFFFFF" uuid="c63d2b27-45c4-4a36-9ce6-c5bcb1cd1c0e"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 7_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 7_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table 7_TD"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="Tableau2" uuid="7a9436d3-63e8-4c5a-992d-69d0bff2b3f3"> <datasetParameter name="ID_CURRENT_ORGANISATION"> <datasetParameterExpression><![CDATA[$P{ID_CURRENT_ORGANISATION}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="135" uuid="5046a679-91fe-4b3c-bac2-9fca20ce43e0"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:tableFooter style="Table 7_TH" height="40" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </jr:tableFooter> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="135" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="1d8b7073-96fc-4b74-b482-1ee462cfc42a"/> <box> <pen lineWidth="2.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Date d'émission du virement]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="135" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="8d417daf-f0e7-40c9-9a25-81c8cab1dc7b"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="dd/MM/yyyy"> <reportElement x="0" y="0" width="135" height="15" uuid="652f14f5-07a9-4cf1-9c48-a798b088dac9"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="10"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$F{dat_reversement}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="60" uuid="0b98440f-678c-4c1c-8940-22f4a57fef6e"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column2"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:tableFooter style="Table 7_TH" height="40" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </jr:tableFooter> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="60" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="4b65f3f3-fbc1-49be-9217-7de15708d1f3"/> <box> <pen lineWidth="2.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Référence du virement]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="f9407620-585f-436a-95e4-860972173d11"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="dd/MM/yyyy"> <reportElement x="0" y="0" width="60" height="15" uuid="7c70bee3-eb42-42a8-a5ac-1f469aa20b43"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$F{ref_vir}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="200" uuid="714c9ce6-2646-4b48-9b87-bdd9a06554e1"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column3"/> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:tableFooter style="Table 7_TH" height="40" rowSpan="1"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.unit.width" value="px"/> <textField> <reportElement mode="Opaque" x="0" y="0" width="200" height="20" backcolor="#D1D1D1" uuid="54b37b8a-59c7-4f66-a0b3-e891fb70a8e4"> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> </reportElement> <box> <bottomPen lineWidth="0.5"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <textFieldExpression><![CDATA["Honoraires retenus par DSO GROUP (TTC)"]]></textFieldExpression> </textField> <textField> <reportElement mode="Opaque" x="0" y="20" width="200" height="20" backcolor="#D1D1D1" uuid="53616aaf-1641-49f7-9144-4cc2ea7d9f32"> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> </reportElement> <box> <bottomPen lineWidth="0.5"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <textFieldExpression><![CDATA["Montant encaissé par DSO GROUP (rappel)"]]></textFieldExpression> </textField> </jr:tableFooter> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="200" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="f3539535-5ffb-4463-97e5-7f4d089c424f"> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> </reportElement> <box> <pen lineWidth="2.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Libellé du virement]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement mode="Opaque" x="0" y="0" width="200" height="20" forecolor="#000000" backcolor="#D1D1D1" uuid="a5df33d5-bcda-4efb-a2de-ff40b0944c74"> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> </reportElement> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA["Montant total reversé par DSO GROUP"]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0"> <reportElement x="0" y="0" width="200" height="15" uuid="d23404bd-eb4b-46ee-9410-4575abfcf573"> <property name="net.sf.jasperreports.export.xls.auto.fit.column" value="true"/> </reportElement> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0"/> </textElement> <textFieldExpression><![CDATA[$F{lib_vir}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="135" uuid="5c363ae5-4baf-46cb-b212-e4c56a5883e1"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column4"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:tableFooter style="Table 7_TH" height="40" rowSpan="1"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <textField pattern="#,##0.00"> <reportElement mode="Opaque" x="0" y="0" width="135" height="20" forecolor="#000000" backcolor="#D1D1D1" uuid="387f6446-386f-4b3e-b98b-a23f422aa83b"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$V{SUM_HONO_TTC}]]></textFieldExpression> </textField> <textField pattern="#,##0.00"> <reportElement mode="Opaque" x="0" y="20" width="135" height="20" forecolor="#000000" backcolor="#D1D1D1" uuid="2ff9be93-ee09-4e09-a2fd-959bacc168bd"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$V{SUM_ENC}]]></textFieldExpression> </textField> </jr:tableFooter> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="135" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="180aea92-edd8-4f95-91ac-0e9474b809b3"/> <box> <pen lineWidth="2.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Montant du virement]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="com.jaspersoft.studio.unit.width" value="px"/> <textField pattern="#,##0.00"> <reportElement mode="Opaque" x="0" y="0" width="135" height="20" forecolor="#000000" backcolor="#D1D1D1" uuid="79f31709-447c-437c-b34d-684b3ba1d244"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA[$V{SUM_VIREMENTS}]]></textFieldExpression> </textField> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0.00"> <reportElement x="0" y="0" width="135" height="15" uuid="e6efa19e-696b-4400-9886-52338db63bf7"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="10"/> </textElement> <textFieldExpression><![CDATA[$F{mnt_vir}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="60" uuid="3f140d9f-1ae0-4f8a-ab38-e7842e62767c"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column5"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:tableFooter style="Table 7_TH" height="40" rowSpan="1"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </jr:tableFooter> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="60" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="f443eb2c-9995-4e8c-9a6d-901155781ca7"/> <box> <pen lineWidth="2.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[bIC du compte crédité]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="60" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="ad5835bf-c8cb-47f6-ac2c-23eea3a94422"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0"> <reportElement x="0" y="0" width="60" height="15" uuid="387ed378-cc7a-4d91-8342-7a1ae6b0abe5"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="10"/> </textElement> <textFieldExpression><![CDATA[$F{bic}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="160" uuid="4c2befd6-b697-44ea-a440-296af526756b"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column6"/> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <jr:tableFooter style="Table 7_TH" height="40" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </jr:tableFooter> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <staticText> <reportElement mode="Opaque" x="0" y="0" width="160" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="228f9306-7dcd-4904-8581-3ac44303aa1f"/> <box> <pen lineWidth="2.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[iBAN du compte crédité]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="160" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="189bb1ec-d3dd-4073-895d-009daba13496"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <text><![CDATA[]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0"> <reportElement x="0" y="0" width="160" height="15" uuid="d23dfb4a-4974-49fb-8de4-164e6f31e571"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="10"/> </textElement> <textFieldExpression><![CDATA[$F{iban}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="140" uuid="5e3ed5d6-d214-45c1-9e74-429b7549ee46"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column7"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:tableFooter style="Table 7_TH" height="40" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </jr:tableFooter> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="com.jaspersoft.studio.unit.width" value="px"/> <staticText> <reportElement mode="Opaque" x="0" y="0" width="140" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="8a0ba34b-b6ea-4912-893e-a1398a39b308"/> <box> <pen lineWidth="2.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Référence DSO (*)]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="140" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="b7b5ec08-86d3-4f73-aa02-9e6a55266a77"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0" tabStopWidth="40"/> </textElement> <text><![CDATA[(*) pour les virements]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern="#,##0"> <reportElement x="0" y="0" width="140" height="15" uuid="ba2bfd69-8666-4f06-9033-a20704c6e38f"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0"/> </textElement> <textFieldExpression><![CDATA[$F{ref_dso}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> <jr:column width="140" uuid="850ceac9-3b21-44d6-83ee-299274908563"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column8"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:tableFooter style="Table 7_TH" height="40" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> </jr:tableFooter> <jr:columnHeader style="Table 7_CH" height="50" rowSpan="1"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <property name="com.jaspersoft.studio.unit.height" value="px"/> <staticText> <reportElement mode="Opaque" x="0" y="0" width="140" height="50" forecolor="#000000" backcolor="#99CCFF" uuid="11830512-0196-48a8-b64e-f3db0066b057"/> <box> <pen lineWidth="2.0" lineStyle="Solid"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <text><![CDATA[Nom du débiteur (*)]]></text> </staticText> </jr:columnHeader> <jr:columnFooter style="Table 7_CH" height="20" rowSpan="1"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.FreeLayout"/> <box> <topPen lineWidth="0.5" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <staticText> <reportElement mode="Opaque" x="0" y="0" width="140" height="20" forecolor="#000000" backcolor="#FFFFFF" uuid="27749505-0bf2-4d3f-88d1-9f292862d143"/> <box> <pen lineWidth="1.0"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0" tabStopWidth="40"/> </textElement> <text><![CDATA[nominatifs]]></text> </staticText> </jr:columnFooter> <jr:detailCell style="Table 7_TD" height="15"> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField pattern=""> <reportElement x="0" y="0" width="140" height="15" uuid="194b9361-7e48-497f-9c4f-ecede515cd31"/> <box> <pen lineWidth="0.5"/> </box> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8"/> <paragraph rightIndent="0"/> </textElement> <textFieldExpression><![CDATA[$F{nom_debiteur}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <textField> <reportElement mode="Opaque" x="0" y="35" width="802" height="40" forecolor="#FFFFFF" backcolor="#808080" uuid="859c01f7-b40d-4923-ba1c-632218790179"/> <box topPadding="0" leftPadding="0" bottomPadding="0" rightPadding="0"> <pen lineWidth="2.0" lineStyle="Solid" lineColor="#3B3A3A"/> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle" markup="styled"> <font fontName="SansSerif" size="16" isBold="true" isItalic="false"/> </textElement> <textFieldExpression><![CDATA["DETAIL DES VIREMENTS EMIS"]]></textFieldExpression> </textField> <componentElement> <reportElement mode="Opaque" x="0" y="75" width="802" height="25" forecolor="#000000" uuid="3e9edeaa-4160-40d4-a8ba-b69c8db8232e"> <property name="com.jaspersoft.studio.layout" value="com.jaspersoft.studio.editor.layout.VerticalRowLayout"/> <property name="com.jaspersoft.studio.table.style.table_header" value="Table 7_TH"/> <property name="com.jaspersoft.studio.table.style.column_header" value="Table 7_CH"/> <property name="com.jaspersoft.studio.table.style.detail" value="Table 7_TD"/> </reportElement> <jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd"> <datasetRun subDataset="titre" uuid="76510b93-4238-4043-b27b-7449f85b1ab6"> <datasetParameter name="ID_CURRENT_ORGANISATION"> <datasetParameterExpression><![CDATA[$P{ID_CURRENT_ORGANISATION}]]></datasetParameterExpression> </datasetParameter> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> </datasetRun> <jr:column width="802" uuid="e6e8d3a4-1a31-4a30-86da-4fc4a765a943"> <property name="com.jaspersoft.studio.components.table.model.column.name" value="Column1"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> <jr:detailCell style="Table 7_TD" height="25"> <property name="com.jaspersoft.studio.unit.height" value="px"/> <property name="com.jaspersoft.studio.unit.width" value="px"/> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textField> <reportElement x="0" y="0" width="802" height="25" uuid="f53337b0-0242-4cb4-aaff-27fa7e6aee69"/> <box> <pen lineWidth="0.0"/> </box> <textElement textAlignment="Center" verticalAlignment="Middle"> <font fontName="SansSerif" size="12" isBold="true"/> <paragraph rightIndent="0" spacingAfter="0"/> </textElement> <textFieldExpression><![CDATA["Donneur d'Ordre : "+ $F{nom_client} + " - Mandat : "+$F{mandat_ccial} + " - Reversement du : "+$F{date_rev}]]></textFieldExpression> </textField> </jr:detailCell> </jr:column> </jr:table> </componentElement> <textField> <reportElement x="0" y="20" width="430" height="15" uuid="167d1021-84a7-4364-bea1-e23598ca5c6b"> <property name="com.jaspersoft.studio.unit.width" value="pixel"/> <property name="com.jaspersoft.studio.unit.height" value="pixel"/> </reportElement> <box> <topPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <leftPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <bottomPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> <rightPen lineWidth="0.0" lineStyle="Solid" lineColor="#000000"/> </box> <textElement textAlignment="Left" verticalAlignment="Middle" markup="styled"> <font fontName="SansSerif" size="8" isBold="true" isItalic="false"/> </textElement> <textFieldExpression><![CDATA["DSO GROUP - PLATEFORME MARS"]]></textFieldExpression> </textField> <textField isStretchWithOverflow="true" isBlankWhenNull="true"> <reportElement x="572" y="20" width="230" height="15" uuid="4f246f5e-1d7c-46f5-ad98-a7a5471eb2da"/> <textElement textAlignment="Right" verticalAlignment="Middle"> <font fontName="SansSerif" size="8" isBold="true"/> </textElement> <textFieldExpression><![CDATA[$P{DATE_ADAPTER}.marshal(new java.util.Date())]]></textFieldExpression> </textField> </band> </detail> </jasperReport>

Hi Mariano, thanks for the answer.. But I don't quite understand how to use it in the WHERE clause.. CASE statement does not let us return more than 1 value, which is what's causing the SQL error. This is what I want to bypass.

Hello guys, I would like to know whether it is possible to use a CASE condition in my WHERE clause using a parameter. For example, I have a query which takes the ID of the organisation as parameter: SELECT org_name, org_addressFROM t_organisationWHERE id_org = $P{ID_ORGANISATION}[/code]But it turns out that I have some organisations which have multiple rows in the table t_organisation and I want to use all their IDs in the query using the parameter.. What I want is something like this: SELECT org_name, org_addressFROM t_organisationWHERE id_org in ( CASE when $P{ID_ORGANISATION} = '123' then ('1231','1232','1233','1234') else $P{ID_ORGANISATION} end)[/code]Any help would be greatly appreciated.. Thanks!

You can try with this query.. It may be a bit long but since your data is simple, it should suit your needs well. It basically checks whether there's at least 1 Yes in each event then outputs Yes in the same row for the Fname and Lname in the list. select x.Fname, x.Lname, (case when x.evt1 > 0 then 'Yes' else 'No' end) as event1, (case when x.evt2 > 0 then 'Yes' else 'No' end) as event2from (select Fname, Lname, count(case when Event1 ='Yes' then 1 else 0 end) as evt1, count(case when Event2 ='Yes' then 1 else 0 end) as evt2from table_namegroup by Fname, Lname) as x[/code]

I searched a lot too and finally managed to do it.. Here's the related post for whoever needs it: Merge rows when repeated values table Cheers :)

I searched a lot too and finally managed to do it.. Here's the related post for whoever needs it: Merge rows when repeated values table Cheers :)

I searched a lot too and finally managed to do it.. Here's the related post for whoever needs it: Merge rows when repeated values table Cheers :)

I searched a lot too and finally managed to do it.. Here's the related post for whoever needs it: Merge rows when repeated values table Cheers :)

Hello, I need to create a report with multiple sub-reports. Each sub-report has its own tables with their own dataset and each dataset needs a user-input parameter in order to run. For now, I have all the sub-reports separately. They all run perfectly with the parameters, etc. How can I include those in the main report? The main report also has parameters and maybe one detail band will contain a table with parameters directly, instead of through a sub-report. I want to use sub-reports because I can't put graphs next to a table data (it has to be put in title or summary), so I wanted to put the graph in a sub-report next to another sub-report containing the tables. I have placed the sub-report elements in the main report and "copied parameters from the master report". What else should I do to make it work? If someone can help me place graphs next to tables in the main report instead of via sub-reports, that would be helpful too! Any help will be greatly appreciated. Thanks in advance!

Well, I have managed to do it.. Since it is a fairly common problem, let me just leave my solution here. Crosstabs! This is what I wanted to do. For each Category, there may or may not be an answer yes or no and a total for each yes/no (if any). What I wanted to do is merge the cells for Category so that we don't see blank cells like the table below. Categoryanswertotalxyes14 no2yyes3 no4ayes12 no3bno5It should be like this instead: Category answertotalxyes14no2yyes3no4ayes12no3bno5In order to achieve this in Jaspersoft Studio, I used the Crosstab element. The SQL query I used needed to have a global field returned that i can use as the column. It can be anything that applies to every row of the table. In my case I returned the field for the Organisation name of the data i'm pulling. So when I created the Crosstab, i used the Organisation field as Columns, and Category and Answer as Rows, and for Measures I used a distinct count of the id of the category. The crosstab will be created with a lot of unneeded information, such as total count of organisation and answer.. which i don't need. So in order to remove them without messing up the table, I deleted the unneeded text boxes and set the cell height for the uneeded rows to 0 and the cell width for the unneeded columns to 0. And there you have it :) Since we're grouping it globally by organisation and then breaking it down by category and answer, it will do the sequential grouping like SQL does, but in this case it merges the results that are the same. You can use properties for the text boxes such as "stretch with overflow" to allow text wrapping. Hope this was of any help to people who are stuck on this as I was... -Anji-

Any solution found for this? I see this problem cropping up since 2011 but no solution yet as at 2016 http://community.jaspersoft.com/sites/all/libraries/ckeditor/plugins/smiley/images/cry_smile.gif

Hello.. I am trying to merge rows that have repeated values.. When I uncheck "Print repeated values" I get the repeated value once, but the empty cells are still displayed, which make the table less readable. It is also not a good design to leave the repeated values in the table. I have tried searching for the solution a LOT but to no avail. I even tried by using a crosstab but did not manage to do it properly. Any help would be greatly appreciated.. Thanks! -Anji-

Changed Priority from Normal to Urgent Changed Severity from Major to Minor Changed Reproducibility from Not Attempted to Always Changed Status from New to Feedback Requested