christmoney1 Posted September 11, 2021 Share Posted September 11, 2021 Hello, When i launch my repport on JasperStudion version 6.10, i've this error message: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : $P{Langue_francais} ? $F{appreciations_fr}!=null && !$F{appreciations_fr}.equals("") : $F{appreciations_an}!=null && !$F{appreciations_an}.equals("") There is someon who could help me with this? ..<?xml version="1.0" encoding="UTF-8"?><br><!-- Created with Jaspersoft Studio version 6.10.0.final using JasperReports Library version 6.10.0-unknown --><br><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="pno40_transcript_main" language="groovy" pageWidth="551" pageHeight="681" columnWidth="551" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isSummaryNewPage="true" uuid="b208425f-87db-4ffa-8029-1f495f921972"><br> <property name="com.jaspersoft.studio.unit." value="pixel"/><br> <property name="com.jaspersoft.studio.unit.pageHeight" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.pageWidth" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.topMargin" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.bottomMargin" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.leftMargin" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.rightMargin" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.columnWidth" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.columnSpacing" value="pixel"/><br> <property name="ireport.callouts" value="callouts.4.bounds=570,270,198,33nnnnnnnnnnnnncallouts.4.text=Guide du transcriptnnnnnnnnnnnnnncallouts.2.fg=0,0,0nnnnnnnnnnnnnnnnnnnnnnnnnnnnnncallouts.3.bg=255,255,0ncallouts.3.bounds=570,150,270,80ncallouts.2.text=Notes par parcoursnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnnncallouts.2.bg=255,255,0nnnnnnnnnnnnnnnnnnnnnnnnnnnnnncallouts.2.bounds=570,114,198,31nnnnnnnnnnnnnnnnnnnnnnnnnnnnnncallouts.4.fg=0,0,0nnnnnnnnnnnnncallouts.3.text=Groupe est nu00E9cessaire pour pouvoir rnforcer le footer en bas de pagennnnnnnnnnnnnnnnnnnncallouts.3.fg=0,0,0ncallouts.4.bg=255,255,0nnnnnnnnnnnnn"/><br> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="ESCP PROD"/><br> <style name="Style_title" mode="Opaque" forecolor="#FFFFFF" backcolor="#240085" hTextAlign="Left" hImageAlign="Left" vTextAlign="Middle" vImageAlign="Middle" rotation="None" markup="none" fontName="Arial" fontSize="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica"><br> <box leftPadding="5"/><br> </style><br> <style name="Style_libelle" mode="Transparent" forecolor="#000000" backcolor="#FFFFFF" hTextAlign="Left" hImageAlign="Left" vTextAlign="Middle" vImageAlign="Middle" rotation="None" markup="none" isBlankWhenNull="false" fontName="Arial" fontSize="10" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica"><br> <box leftPadding="10"/><br> </style><br> <style name="Style_texte" mode="Transparent" forecolor="#000000" backcolor="#FFFFFF" hTextAlign="Left" hImageAlign="Left" vTextAlign="Middle" vImageAlign="Middle" rotation="None" markup="none" isBlankWhenNull="false" fontName="Arial" fontSize="9" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica"><br> <box leftPadding="10"/><br> </style><br> <parameter name="Master_Object_Id" class="java.lang.String" isForPrompting="false"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[183342]]></defaultValueExpression><br> </parameter><br> <parameter name="Repository" class="java.lang.String" isForPrompting="false"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA["C:/Users/smidepani/Downloads/Jasper/MyReports/Aurion_Jasper/"]]></defaultValueExpression><br> </parameter><br> <parameter name="img_logo" class="java.lang.String" isForPrompting="false"><br> <defaultValueExpression><![CDATA["ESCP_Europe_logo.png"]]></defaultValueExpression><br> </parameter><br> <parameter name="report_code" class="java.lang.String" isForPrompting="false"><br> <defaultValueExpression><![CDATA["pno40-transcript"]]></defaultValueExpression><br> </parameter><br> <parameter name="report_name" class="java.lang.String" isForPrompting="false"><br> <defaultValueExpression><![CDATA["transcript cycle master nprogramme grande ecole"]]></defaultValueExpression><br> </parameter><br> <parameter name="print_id" class="java.lang.Boolean" isForPrompting="false"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[true]]></defaultValueExpression><br> </parameter><br> <parameter name="Langue_id" class="java.lang.Integer" isForPrompting="false"><br> <parameterDescription><![CDATA[Valeur héritée de la variable Langue_id du modèle]]></parameterDescription><br> <defaultValueExpression><![CDATA[45148]]></defaultValueExpression><br> </parameter><br> <parameter name="Langue_francais" class="java.lang.Boolean" isForPrompting="false"><br> <parameterDescription><![CDATA[Valeur héritée de la variable Langue_id du modèle]]></parameterDescription><br> <defaultValueExpression><![CDATA[false]]></defaultValueExpression><br> </parameter><br> <parameter name="print_provisoire" class="java.lang.Boolean" isForPrompting="false"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[true]]></defaultValueExpression><br> </parameter><br> <parameter name="programme" class="java.lang.String" isForPrompting="false"><br> <parameterDescription><![CDATA[utilisé pour conditionner le profil de notation dans le sous rapport "guide"]]></parameterDescription><br> <defaultValueExpression><![CDATA["EMBA"]]></defaultValueExpression><br> </parameter><br> <parameter name="modele" class="java.lang.String" isForPrompting="false"><br> <defaultValueExpression><![CDATA["EMBA"]]></defaultValueExpression><br> </parameter><br> <parameter name="print_failed" class="java.lang.Boolean" isForPrompting="false"><br> <parameterDescription><![CDATA[impression des cours échoués]]></parameterDescription><br> <defaultValueExpression><![CDATA[true]]></defaultValueExpression><br> </parameter><br> <parameter name="print_all_validated_courses" class="java.lang.Boolean" isForPrompting="false"><br> <parameterDescription><![CDATA[Afficher tous les cours validés, quelque soit l'état de visibilité du cours (réponse au questionnaire...)]]></parameterDescription><br> <defaultValueExpression><![CDATA[true]]></defaultValueExpression><br> </parameter><br> <parameter name="programme_id" class="java.lang.Integer" isForPrompting="false"><br> <defaultValueExpression><![CDATA[1509106]]></defaultValueExpression><br> </parameter><br> <parameter name="NoP_Colonne" class="java.lang.Boolean" isForPrompting="false"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[false]]></defaultValueExpression><br> </parameter><br> <parameter name="Only_CFX" class="java.lang.Boolean" isForPrompting="false"><br> <parameterDescription><![CDATA[]]></parameterDescription><br> <defaultValueExpression><![CDATA[false]]></defaultValueExpression><br> </parameter><br> <queryString language="SQL"><br> <![CDATA[select <br> v.apprenant_id, <br> v.ind_nom, <br> v.ind_prenom,<br> v.numelv,<br> v.numero_ine,<br> v.programme_code,<br> v.modele_code,<br> v.date_entree,<br> v.date_sortie, <br> v.annee_entree,<br> v.promo,<br> v.statut_inscription_code, <br> v.mode_admission_code,<br> v.diplome_libelle_fr, <br> v.diplome_libelle_an, <br> v.signataire_modele_nom, <br> v.signataire_modele_titre_fr, <br> v.signataire_modele_titre_an, <br> v.signataire_programme_nom, <br> v.signataire_programme_titre_fr,<br> v.signataire_programme_titre_an,<br> v.appreciations_fr,<br> v.appreciations_an,<br> v.statut_GMSC,<br> v.campus_entree,<br> v.campus_partenaire,<br> v.othernam_transcript<br>from escp.v_pno40_transcript_main v<br>where v.apprenant_id = cast($P{Master_Object_Id} as Integer)<br>and v.programme_id=$P{programme_id}]]><br> </queryString><br> <field name="apprenant_id" class="java.lang.Integer"/><br> <field name="ind_nom" class="java.lang.String"/><br> <field name="ind_prenom" class="java.lang.String"/><br> <field name="numelv" class="java.lang.String"/><br> <field name="numero_ine" class="java.lang.String"/><br> <field name="programme_code" class="java.lang.String"/><br> <field name="modele_code" class="java.lang.String"/><br> <field name="date_entree" class="java.lang.String"/><br> <field name="date_sortie" class="java.lang.String"/><br> <field name="annee_entree" class="java.lang.Integer"/><br> <field name="promo" class="java.lang.Integer"/><br> <field name="statut_inscription_code" class="java.lang.String"/><br> <field name="mode_admission_code" class="java.lang.String"/><br> <field name="diplome_libelle_fr" class="java.lang.String"/><br> <field name="diplome_libelle_an" class="java.lang.String"/><br> <field name="signataire_modele_nom" class="java.lang.String"/><br> <field name="signataire_modele_titre_fr" class="java.lang.String"/><br> <field name="signataire_modele_titre_an" class="java.lang.String"/><br> <field name="signataire_programme_nom" class="java.lang.String"/><br> <field name="signataire_programme_titre_fr" class="java.lang.String"/><br> <field name="signataire_programme_titre_an" class="java.lang.String"/><br> <field name="appreciations_fr" class="java.lang.String"/><br> <field name="appreciations_an" class="java.lang.String"/><br> <field name="statut_gmsc" class="java.lang.String"/><br> <field name="campus_entree" class="java.lang.String"/><br> <field name="campus_partenaire" class="java.lang.String"/><br> <field name="othernam_transcript" class="java.lang.String"/><br> <variable name="print_felicitations" class="java.lang.Boolean"><br> <variableExpression><![CDATA[$P{Langue_francais} ? $F{appreciations_fr}!=null && !$F{appreciations_fr}.equals("") : $F{appreciations_an}!=null && !$F{appreciations_an}.equals("")]]></variableExpression><br> </variable><br> <variable name="MEB_MSC" class="java.lang.Boolean"><br> <variableExpression><![CDATA[$F{statut_gmsc}!=null && !$F{statut_gmsc}.trim().equals("")]]></variableExpression><br> </variable><br> <variable name="mode_affichage" class="java.lang.String"><br> <variableExpression><![CDATA[// Pour la formation EMBA : on découpe l'affichage par obligations<br>// Pour les MS et le PMY : on affiche une seule liste simple<br>// Pour les autres formations : on affiche par période<br>$F{programme_code}.equals("EMBA") ? "oblig":<br>(<br> ($F{modele_code}.equals("MS") || $F{programme_code}.equals("PMY")) ? "liste":<br> "periode"<br>)]]></variableExpression><br> </variable><br> <variable name="percentile" class="java.lang.Boolean"><br> <variableExpression><![CDATA[// Affichage des percentiles à la place des notes ECTS<br>// Au 18/07/2018, Bachelor uniquement<br>//$P{modele}.equals("BACHELOR")<br>//|| ($P{modele}.equals("PMY_MIM") && $F{promo}>=2019)<br>//? <br>//true :<br>//false<br>//Au 15/01/2019 Percentile pour tt le monde à partir de la promo2019<br>//($P{modele}.equals("BACHELOR") || (!$P{modele}.equals("BACHELOR") && $F{promo}>=2019)) ? true : false<br>($P{modele}.equals("BACHELOR") || ($F{promo}>=2019)) ? true : false]]></variableExpression><br> </variable><br> <variable name="uncap" class="java.lang.Boolean"><br> <variableExpression><![CDATA[// Déplafonnement des notes de rattrapage<br>// Au 18/07/2018, MBAM uniquement<br>// ($P{modele}.equals("MBAM") <br>// || ($P{modele}.equals("PMY_MIM") && $F{promo}>=2019)<br>// || $P{modele}.equals("BACHELOR"))<br>// ? <br>// true :<br>// false<br>true]]></variableExpression><br> </variable><br> <group name="apprenant" isStartNewPage="true" minHeightToStartNewPage="50" footerPosition="CollateAtBottom"><br> <groupFooter><br> <band height="5"><br> <property name="local_mesure_unitheight" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> </band><br> </groupFooter><br> </group><br> <pageHeader><br> <band height="80" splitType="Stretch"><br> <subreport><br> <reportElement x="0" y="0" width="551" height="80" uuid="f9e62b3b-372c-4f43-819f-71d1ec6e557f"/><br> <subreportParameter name="Master_objet_id"><br> <subreportParameterExpression><![CDATA[$F{apprenant_id}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Repository"><br> <subreportParameterExpression><![CDATA[$P{Repository}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="report_name"><br> <subreportParameterExpression><![CDATA[$P{programme}==null ? "" : <br>$P{programme}.equalsIgnoreCase("BIM") ? "transcriptnbachelor in management"<br>: $P{programme}.equalsIgnoreCase("MIM") ? ($P{Langue_francais} ? "TRANSCRIPT CYCLE MASTER IN MANAGEMENTnPROGRAMME GRANDE ECOLE" : "MASTER CYCLE TRANSCRIPTnMASTER IN MANAGEMENT")<br>: $P{programme}.equalsIgnoreCase("PMY") ? ($P{Langue_francais} ? "TRANSCRIPT ANNEE PRE MASTERnPROGRAMME GRANDE ECOLE" : "PRE MASTER YEAR TRANSCRIPTnMASTER IN MANAGEMENT")<br>: $P{programme}.equalsIgnoreCase("MEB") ? ("transcriptnmaster in european business"+($F{statut_gmsc}!=null && !$F{statut_gmsc}.trim().equals("")?"nM.Sc. in European Business":""))<br>: $P{programme}.equalsIgnoreCase("EMBA") ?("transcriptnExecutive " + ($F{mode_admission_code}.contains( "GMP" )? "GMP" : "MBA"))<br>: $P{modele}.equalsIgnoreCase("MS") ? ("transcriptn"+($P{Langue_francais} ? "Mastères Spécialisés":"Specialised Masters"))<br>: $P{modele}.equalsIgnoreCase("MSC") ? ("transcriptn"+($P{Langue_francais} ? $F{diplome_libelle_fr}:$F{diplome_libelle_an})+"(M.Sc.)")<br>: $P{modele}.equalsIgnoreCase("EMS") ? ("transcriptn"+($P{Langue_francais} ? "Exécutive Mastères Spécialisés":"Executive Specialised Masters"))<br>: ("transcriptn"+($P{Langue_francais} ? $F{diplome_libelle_fr}:$F{diplome_libelle_an}))]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="print_id"><br> <subreportParameterExpression><![CDATA[$P{print_provisoire}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="report_code"><br> <subreportParameterExpression><![CDATA[$P{report_code}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="img_logo"><br> <subreportParameterExpression><![CDATA[$P{img_logo}]]></subreportParameterExpression><br> </subreportParameter><br> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><br> <subreportExpression><![CDATA[$P{Repository}+"Bibliotheque/entete_standard.jasper"]]></subreportExpression><br> </subreport><br> </band><br> </pageHeader><br> <detail><br> <band height="30" splitType="Stretch"><br> <property name="local_mesure_unitheight" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> <textField><br> <reportElement mode="Opaque" x="0" y="0" width="551" height="16" forecolor="#FFFFFF" backcolor="#240085" uuid="1ec560f0-b823-48e6-a0b1-54e3a220942e"><br> <property name="local_mesure_unitheight" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> </reportElement><br> <textElement textAlignment="Center" markup="none"><br> <font fontName="Arial" size="12" isBold="true" pdfFontName="Helvetica"/><br> </textElement><br> <textFieldExpression><![CDATA[$F{othernam_transcript}==null? $F{ind_nom}.toUpperCase()+" "+$F{ind_prenom}:$F{ind_nom}.toUpperCase()+" "+$F{ind_prenom}+" "+$F{othernam_transcript}]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true" isBlankWhenNull="false"><br> <reportElement style="Style_texte" x="0" y="18" width="160" height="12" uuid="867b6a3c-d430-46c5-b923-eca3e1980e8a"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <property name="local_mesure_unitheight" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> </reportElement><br> <textElement textAlignment="Left" verticalAlignment="Middle" markup="styled"/><br> <textFieldExpression><![CDATA[// HH 02/10/2017 Pour les EMBA on n'affiche pas le numéro INE<br>($F{numero_ine}==null || $F{programme_code}.equals("EMBA")? "" : ($P{Langue_francais} ? "Numéro INE : " : "INE number: ")+$F{numero_ine})<br><br>//HH 08/01/2018 Pour les premaster on affiche le campus d'entrée<br>+($F{programme_code}.equals("PMY") && $F{campus_entree}!=null && !$F{campus_entree}.equals("")? ($P{Langue_francais} ? "Campus ESCP : " : "ESCP Campus: ")+$F{campus_entree} : "")<br>//HH 08/01/2018 Pour les visitants on affiche l'université partenaire<br>+($F{programme_code}.equals("MIM") && $F{mode_admission_code}.equals("VISITANT") && $F{campus_partenaire}!=null && !$F{campus_partenaire}.equals("") ? $F{campus_partenaire} : "")<br><br>+($P{Langue_francais} ? ($F{appreciations_fr}!=null && !$F{appreciations_fr}.equals("") ? "n<b>"+$F{appreciations_fr}+"</b>" : "") : ($F{appreciations_an}!=null && !$F{appreciations_an}.equals("") ? "n<b>"+$F{appreciations_an}+"</b>" : ""))]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true" isBlankWhenNull="false"><br> <reportElement style="Style_texte" x="390" y="18" width="150" height="12" uuid="3f99ea9e-11bb-4f50-8872-94e4125dbd96"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <property name="local_mesure_unitheight" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> </reportElement><br> <textElement textAlignment="Right" verticalAlignment="Middle"/><br> <textFieldExpression><![CDATA[// HH 02/10/2017 : Modification des libellés anglais<br>// "Entry date / Leaving date" --> "Start date / End date"<br>($P{Langue_francais} ? "Date d'entrée : " : "Start date: ")+$F{date_entree}<br>+($F{date_sortie}==null ? "" : ("n"+($P{Langue_francais} ? "Date de sortie : " : "End date: ")+$F{date_sortie}))]]></textFieldExpression><br> </textField><br> <textField isStretchWithOverflow="true" isBlankWhenNull="false"><br> <reportElement style="Style_texte" x="160" y="18" width="230" height="12" uuid="24c34486-9179-4e90-b9cb-26526c32abed"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <property name="local_mesure_unitheight" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"><br> <font isBold="true"/><br> </textElement><br> <textFieldExpression><![CDATA[// Pour les EMBA, le programme est affiché uniquement dans l'entête<br>(!$P{programme}.equals("EMBA") ?<br> ($P{Langue_francais} ? ($F{diplome_libelle_fr}!=null ? $F{diplome_libelle_fr} + "n" : "") : ($F{diplome_libelle_an}!=null ? $F{diplome_libelle_an} + "n" : "")) : ""<br>)<br>+ (($F{statut_inscription_code}.equals("DIPLOME") || $F{statut_inscription_code}.equals("NON_DIPLOME")) ? ($P{Langue_francais} ? "Transcript final" : "Final transcript") :<br> $F{date_sortie}!=null ? ($P{Langue_francais} ? "Transcript final" : "Final transcript") :<br> ($P{Langue_francais} ? "Transcript provisoire" : "Provisional transcript")<br> )]]></textFieldExpression><br> </textField><br> </band><br> <band height="163"><br> <subreport><br> <reportElement positionType="Float" x="0" y="5" width="551" height="34" uuid="e1086795-eb9b-450e-99bd-ecdaabfd31d3"><br> <property name="local_mesure_unitwidth" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> </reportElement><br> <subreportParameter name="Master_Object_Id"><br> <subreportParameterExpression><![CDATA[$P{Master_Object_Id}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Repository"><br> <subreportParameterExpression><![CDATA[$P{Repository}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="print_provisoire"><br> <subreportParameterExpression><![CDATA[$P{print_provisoire}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Langue_id"><br> <subreportParameterExpression><![CDATA[$P{Langue_id}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Langue_francais"><br> <subreportParameterExpression><![CDATA[$P{Langue_francais}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="programme"><br> <subreportParameterExpression><![CDATA[$P{programme}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="modele"><br> <subreportParameterExpression><![CDATA[$P{modele}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="mode_affichage"><br> <subreportParameterExpression><![CDATA[$V{mode_affichage}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="print_failed"><br> <subreportParameterExpression><![CDATA[$P{print_failed}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="print_all_validated_courses"><br> <subreportParameterExpression><![CDATA[$P{print_all_validated_courses}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="programme_id"><br> <subreportParameterExpression><![CDATA[$P{programme_id}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="percentile"><br> <subreportParameterExpression><![CDATA[$V{percentile}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="uncap"><br> <subreportParameterExpression><![CDATA[$V{uncap}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="annee_entree"><br> <subreportParameterExpression><![CDATA[$F{annee_entree}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="NoP_Colonne"><br> <subreportParameterExpression><![CDATA[$P{NoP_Colonne}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Only_CFX"><br> <subreportParameterExpression><![CDATA[$P{Only_CFX}]]></subreportParameterExpression><br> </subreportParameter><br> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><br> <subreportExpression><![CDATA[$P{Repository}+"SubReports/Apprenants/pno40-transcript/pno40-transcript_parcours_sans_percentil.jasper"]]></subreportExpression><br> </subreport><br> <image hAlign="Center" vAlign="Middle"><br> <reportElement positionType="Float" x="365" y="83" width="140" height="80" isRemoveLineWhenBlank="true" uuid="ae1f0e11-83ca-4c56-a79f-7defa6448fc2"><br> <printWhenExpression><![CDATA[!$F{modele_code}.equalsIgnoreCase( "EMS" ) && !$F{modele_code}.equalsIgnoreCase( "EPHD" ) && !$F{modele_code}.equalsIgnoreCase( "EXECUTIVE" ) && !$F{modele_code}.equalsIgnoreCase( "LABEX" ) && !$F{modele_code}.equalsIgnoreCase( "DOCT" )]]></printWhenExpression><br> </reportElement><br> <imageExpression><![CDATA[$P{Repository}+"Bibliotheque/Signatures/tampon_escp_signature_directeur"<br>+<br>($F{programme_code}==MIM" || $F{programme_code} =="PMY" ? "_MIM":<br> ($F{modele_code}=="MSC" ? (($F{programme_code}=="MHM" || $F{programme_code} =="MBP" || $F{programme_code} =="MDM") ? "_Madrid" : "_MS") :<br> (($F{programme_code}=="MBA" || $F{programme_code} =="EMBA") ? "_MBA" :<br> (($F{programme_code}=="MEB" || $F{programme_code} =="MBAM") ? "_MEB" :<br> ($F{programme_code}=="BACHELOR" ? "_BIM": "_"+$F{modele_code})<br>))))<br>+".png]]></imageExpression><br> </image><br> <textField isStretchWithOverflow="true" isBlankWhenNull="false"><br> <reportElement style="Style_texte" positionType="Float" x="323" y="43" width="225" height="35" uuid="5ea9e4a2-4206-4012-b7f2-09e2e4eb7750"><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> <property name="local_mesure_unitheight" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> <property name="local_mesure_unity" value="pixel"/><br> </reportElement><br> <textElement textAlignment="Center" verticalAlignment="Middle"/><br> <textFieldExpression><![CDATA["ESCP, "+new SimpleDateFormat("dd/MM/yyyy").format(new Date())<br>+"n"<br>+($F{signataire_programme_nom}!=null ? $F{signataire_programme_nom} : $F{signataire_modele_nom})<br>+"n"<br>+($F{signataire_programme_nom}!=null ? ($P{Langue_francais} ? $F{signataire_programme_titre_fr} : $F{signataire_programme_titre_an}) : ($P{Langue_francais} ? $F{signataire_modele_titre_fr} : $F{signataire_modele_titre_an}))]]></textFieldExpression><br> </textField><br> <rectangle><br> <reportElement positionType="Float" x="230" y="78" width="318" height="5" uuid="4698a54f-8a58-47c7-951c-2bfcada0ee38"><br> <property name="local_mesure_unitheight" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.height" value="px"/><br> </reportElement><br> <graphicElement><br> <pen lineWidth="0.0"/><br> </graphicElement><br> </rectangle><br> </band><br> </detail><br> <summary><br> <band height="34"><br> <subreport><br> <reportElement positionType="Float" x="0" y="0" width="551" height="34" uuid="bf4e6253-de31-409d-9d77-cdf79b0be535"><br> <property name="local_mesure_unitwidth" value="pixel"/><br> <property name="com.jaspersoft.studio.unit.width" value="px"/><br> </reportElement><br> <subreportParameter name="Master_Object_Id"><br> <subreportParameterExpression><![CDATA[$P{Master_Object_Id}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Repository"><br> <subreportParameterExpression><![CDATA[$P{Repository}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Langue_francais"><br> <subreportParameterExpression><![CDATA[$P{Langue_francais}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Langue_id"><br> <subreportParameterExpression><![CDATA[$P{Langue_id}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="programme"><br> <subreportParameterExpression><![CDATA[$P{programme}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="print_felicitations"><br> <subreportParameterExpression><![CDATA[$V{print_felicitations}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="MEB_MSC"><br> <subreportParameterExpression><![CDATA[$V{MEB_MSC}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="modele"><br> <subreportParameterExpression><![CDATA[$P{modele}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Promo"><br> <subreportParameterExpression><![CDATA[$F{promo}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="AnneeEntree"><br> <subreportParameterExpression><![CDATA[$F{annee_entree}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="percentile"><br> <subreportParameterExpression><![CDATA[$V{percentile}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="mode_admission_code"><br> <subreportParameterExpression><![CDATA[$F{mode_admission_code}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="NoP_Colonne"><br> <subreportParameterExpression><![CDATA[$P{NoP_Colonne}]]></subreportParameterExpression><br> </subreportParameter><br> <subreportParameter name="Only_CFX"><br> <subreportParameterExpression><![CDATA[$P{Only_CFX}]]></subreportParameterExpression><br> </subreportParameter><br> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression><br> <subreportExpression><![CDATA[$P{Repository}+"SubReports/Apprenants/pno40-transcript/pno40-transcript_guide.jasper"]]></subreportExpression><br> </subreport><br> </band><br> </summary><br></jasperReport><br>..[/code]Sincerely Link to comment Share on other sites More sharing options...
gustavofarias Posted September 11, 2021 Share Posted September 11, 2021 To be helped, you can start giving more context. Whats is the type you expect your expression to evaluate to?Is it not working recently after some change or it never worked?What are the types of yout fields? Link to comment Share on other sites More sharing options...
christmoney1 Posted September 11, 2021 Author Share Posted September 11, 2021 Hi, Thank you for your help.I've a main report with differents sub reports.Each sub reports work fine.But when i call the main report it provide me the issue i've mentioned.it's not working recently after some change in sub report which work fine.I' ve attached my code source on jasper and the JRXML where you will find this evaluation. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now