christmoney1

Yes if TOTO is blank, GIRARDIN goes up one line do you know how can i do that?

Hello, I've tree textfielld like that: $F{Rue (ligne 1).Adresse} refere to the "Blank" $F{Rue (ligne 2).Adresse} refere to " TOTO $F{Rue (ligne 3).Adresse} refere to GIRARDIN i would like that when i print my report , if there is a blank in on of the field it delete this line and move up the next valu in the top. but it dont work. i've checked the remove line box for all field and set up them to float. Each textfield are not overlaps. There is someone to help me with this? Sincerely.

Thank you very much Mr bigalex. It's work fine. Sincerely.

Hello everybody, I would like display : This is my first <<Report>> this is my expression "This is my "+ " " + "<b><<Report>><b/>" But it don't work Could you help me please? Sincerely

Sorry My expression work well. Sincerely.

Hello everybody. I would like to display my information like that : 39 north street. 01 hermont 77 This is my expression on jasperstudio. "Adresse permanente: " + ($F{Rue (ligne1) Adresse PERM}== null? "": $F{Rue (ligne1) Adresse PERM}) + "n" + " <br/>" + ($F{Rue (ligne2) Adresse PERM} == null ? "": $F{Rue (ligne2) Adresse PERM})+ "n" + " <br/>" +($F{Rue (ligne3) Adresse PERM} == null? "": $F{Rue (ligne3) Adresse PERM}) + "n" + " <br/>" Where $F{Rue (ligne1) Adresse PERM} = 39 north street. $F{Rue (ligne2) Adresse PERM} = 01 hermont $F{Rue (ligne3) Adresse PERM} = 77 In my database. But when i use the <br/> balise like in my expression it display information in the same line : 39 north street 01 hermont 77 I need some help please. Sincerely.

Dear bigalex, mani thank for your answer but it stil don't work. See attached my jrxml. Sincerely

Hello everybody, May i have your help? I would like to write a condition on jasperstudiosoft to display my phones number like that: Telephone: 339922/440011/882211/contact@emergency.com One of these fields could be empty. for example: if the firste number (339922) is empty this 'll be displayed : Telephone: 440011/882211/contact@emergency.com if the secund number(440011) is empty this 'll be displayed: Telephone: 339922/882211/contact@emergency.com if the mail(conctact@emergency.com) and the first number(339922) are empty this'll be displayed: Telephone: 440011/882211 if all the field are empty the we'll have Telephone: This is my expression to do that: ("Telephone:" + " " + "<u>"+($F{Numéro de téléphone domicile de cette personne.Individu}== null? $F{Numéro de téléphone portable de cette personne.Individu}+ "/" + $F{Numéro de téléphone pro de cette personne.Individu} + "/" +$F{Email de cette personne.Individu} : $F{Numéro de téléphone portable de cette personne.Individu} == null? $F{Numéro de téléphone domicile de cette personne.Individu} + "/" +$F{Numéro de téléphone pro de cette personne.Individu} + "/" + $F{Email de cette personne.Individu}: $F{Numéro de téléphone pro de cette personne.Individu} == null? $F{Numéro de téléphone domicile de cette personne.Individu} + "/" + $F{Numéro de téléphone portable de cette personne.Individu} + "/" + $F{Email de cette personne.Individu}:$F{Email de cette personne.Individu}== null? $F{Numéro de téléphone domicile de cette personne.Individu}+ "/" + $F{Numéro de téléphone portable de cette personne.Individu}+ "/" +$F{Numéro de téléphone pro de cette personne.Individu}: $F{Numéro de téléphone domicile de cette personne.Individu}+ "/"+ $F{Numéro de téléphone portable de cette personne.Individu} + "/" + $F{Numéro de téléphone pro de cette personne.Individu} + "/" + $F{Email de cette personne.Individu})+"</u>") But when i lunch report it don't work very well. For example if all the field are empty it display that: there is someone to help me ? Sincerely.

Thank you very much it's work now. Sincerely

Hello everybody. I hop someone 'll help me with this issue. When i preview my report it work well. But when i try to compil it i've this message error: The detail section, the page and column headers and footers and the margins do not fit the page height. Can i have your help? Sincerely

Hello everybody, I've a question on jasperststudio. I would like to write et condition on the editor expression to check or uncheck a chekbox . For example $F{XVI-Etu : 05}== Yes ? Checkbox checked: Checkbox unchecked And then i'll run the report i need to get this: There is someone who can i help me? Sincerely. Sedrick

Hi, I've main report wich have a detail section called Detail 5 as you can see on the screenshot. This is my report: /sites/default/files/user_uploads/christmoney1/capture.png In this main report i've a subreport which have two (2) Detail: Detail2 and Detail3 section as you may see on the picture beelow: /sites/default/files/user_uploads/christmoney1/capture2.png This is my request: I'would like to display on the main report one of subreport ' section (Detail2 or Detail3 ) when a condition is reached. In Detail2 subreport'section this is the condition : $F{Code.Groupe}.equals("MBAM") and in Detail3 subreport'section this is the condition !($F{Code.Groupe}.equals("MBAM")) /sites/default/files/user_uploads/christmoney1/capture3.png There is someone who can help me with this,?? Sincerely. In

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.

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

Hi, I have to files: The JRXML and JASPER. When i run my report by clickin on preview butom, my report work well with Jaspersoft Studio-6.10.0 But when i run the sames files (report) by cliking on preview butom, i have an issue with Jaspersoft Studio-5.6.2 final This is the issue with Jaspersoft Studio-5.6.2 final : " Type mismatch : cannot convert from string to boolean" I d'ont understand why the same report work well when i use Jaspersoft Studio-6.10.0 but give an issue with previous version Jaspersoft Studio-5.6.2 final I need to run it on Jaspersoft Studio-5.6.2 final There is someone who already facing this problem? Sincerely.

Hello everybody, I've this message error when i launch my report : Attribute 'hTextAlign' is not allowed to appear in element 'style'. This is my xml source: <?xml version="1.0" encoding="UTF-8"?> <!-- Created with Jaspersoft Studio version 5.6.2.final using JasperReports Library version 5.6.2-unknown --> <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"> <property name="com.jaspersoft.studio.unit." value="pixel"/> <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"/> <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"/> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="ESCP_PROD "/> <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"> <box leftPadding="5"/> It's seem that it ligne in red which cause the issue : hTextAlign="Left" My jaspersoftstudio version is: 5.6.2 There is someone who has experiencing with this issu? Thank you very much for your help. Sincerely.

Hi Gustavofarias. Thank you very much for your help. I've changed the class element to the type Object as you may see on the screenshot attached. But the probléme is not resolved. I have the same error: type mismatch: cannot convert from boolean to Object Could you tell me in détail where can i do this? The result of the expression is boolean. But you must be putting it in an element of type object. Sincerely.

Hello everybody, i've this message error type mismatch: cannot convert from boolean to Object from this expression $P{Program}==null || ($P{Program}!=null && $F{programme}.equalsIgnoreCase( $P{Program} )) When i click on the buton preview to see my report. There is someone who can help me for this? Sincerely

Hello Yama818, Its work now. I've changed on the code source the type from java.lang.Integer to java.lang.String and used on the expression (Integer.parseInt($F{annee_entree})+1) Thank you very much Regards

Hello Thank you for your help. Yes it's strange that it does not work. This is the message error when i click on preview button: "The operator + is undefined for the argument type(s) Integer, int.". You says that you've tried with a mock expression how can i do that? Sincerely.

Hi Yama818. Thank you very much for your help. But i've set up $F{annee_entree} as a String. This is my dataset.

Hello all, I need to display year on my report like that: 2020/2021 This is my expression: $F{annee_entree}+"/"+ ($F{annee_entree}+1) But its don't work. There is someone who can i help me with this? Sincerely.

I figure out Jaspersoft Studio and i'am trying to build a report. But when i click on "preview" to launch my report, i've this error: " Type mismatch : cannot convert from string to boolean" then when i click on this error, jasper open my expression editor: "1.3. " + ($P{Langue_francais} ? "Date de naissance" : "Date, Place, Country of Birth") /sites/default/files/user_uploads/christmoney1/capjasper.png The parameter $P{Langue_francais} called in this expression is here: /sites/default/files/user_uploads/christmoney1/capjasper1png.png In this expression there is two another parameter $P{Langue_FR_EN} and $P{Campus_Berlin } which are enter by user when they launch report There is someone who can help me with this. Sincerely