johann60280

Hello everyone!! I have an issue in my jasper report.I have a parameter ($P{Mois}) which give me data like this "201901, 201902, 201903, etc" from my input control I try to display a month with a condition like this: ($V{month} == "01")? "Janvier "+$P{Mois}.substring(0,4) : "test"[/code]But he give me "test" whereas I selected the good month in my input control. My variable month contains this: $P{Mois}.substring($P{Mois}.length()-2) //this give me the month like "01, 02, 03, etc"[/code]Someone have an idea of my problem ? Because I don't found the solution. If someone can help me it will be great! Thank in advance.

Someone have an idea ? Because it's become urgent :(.

Hi everyone!! I have an issue in my report. I wanted to know if it's possible to create a button or use Hyperlink to display or hide some component in my report like Table or Subreport ? Because I begin to see with Hyperlink but no success :(. I have no other idea to do that. Someone have an idea for this issue or can help me ? If you want some detail you can ask me :). Thank in advance :).

Hello Everybody!! I always work on my kind of organization chart. And I have an issue on my Jasper report in Ireport. I have two line horizontally. The first has 6 height and the second has 36 height with a display condition. My problem is the first line is display with a big height (not this one I fixed on the report). I mean she takes all the report with a shift in the beginning. You can see in this capture: But when I put in line properly PrintRepeatedValues= false all is correct but my little line is completely missing. This is an exemple: How can I solve my problem ? I don't want the line is repeated in the report I want she is displayed like I want. I hope I'm clear in my explanation. But If you don't understand tell me :). It's really important I don't know how I can solve this.

Oh thank you for your help!! Yes it work but not completely.. Indeed my variable is of type java.lang.integer. I use what you give me with a modification: $V{affiche}.intValue() != 0 ? Boolean.TRUE : Boolean.FALSE But the line is misssing when my variable return not 0. Can you tell me why ?

Hello everybody!! I have a problem on Ireport. I try to display a line from a result of subreport. So I have a subreport who contains some result (or not). I use a parameter in this subreport who called "Return values". I affect this parameter in a variable called "affiche". So this variable contains "1" if there is one result in the subreport or "0" if there is nany result. So I try to hide a line who are next to the subreport if my variable contain "0". This is my condition in line (on a parameter "Print When Expression"): $V{affiche} != "0" ? Boolean.TRUE : Boolean.FALSE But unfortunately it doesn't work. I put an image to show mu problem. I hope my case is clear but if you want more explanation I will can give you. Thank you to help me :)

Have you an example to give me for my case ?

I have a problem with my parameter who are an input control in Ireport. My parameter is a boolean. And I try to set a default value because I need to modify my sql request with parameter. By example if my parameter is true so I put on my request a like with an other parameters else I put nothing. But my problem is my parameters is always true or false and not the value I define in default value. This is my try with default value of my parameter: $P{choix_repere_depart}=="true"? " AND d.cellule like '%$P{mot_cle}%'": " "[/code]And this my sql request: SELECT r.designation as designation, l.nom as nom, e.gare as gare, b.intitule as intitule, a.code_mire as code_mire, af.codegmao as codegmaoAF, ap.codegmao as codegmaoAP, d.cellule as repere, d.observation as observation, m.appareil as appareilFROM armoireprincipale apLEFT JOIN armoire a ON a.idbranchement = ap.idbranchementLEFT JOIN armoirefille af ON af.idbranchement = a.idbranchementLEFT JOIN branchement b ON b.idbranchement = a.idbranchementLEFT JOIN ligne l ON l.id_ligne = b.id_ligneLEFT JOIN reseau r ON r.id_reseau = l.id_reseauLEFT JOIN edifice e ON e.indic = b.indicLEFT JOIN depart d ON d.idbranchement = a.idbranchementLEFT JOIN materiel m ON m.id_materiel = d.id_materielWHERE a.idbranchement IN (SELECT b.idbranchement FROM branchement b0 LEFT JOIN cable c ON c.idbranchement = b0.idbranchement LEFT JOIN cable_depart cb ON cb.id = c.id LEFT JOIN depart d0 ON d0.iddepart = cb.iddepart LEFT JOIN armoire a0 ON a0.idbranchement = d0.idbranchement LEFT JOIN armoireprincipale ap0 ON ap0.idbranchement = a0.idbranchement WHERE ap0.ug_pef= $P{id_pef}) $P{choix_repere_depart};[/code]So I need help to understand what is wrong on my report. If someone has an idea please help me!!! Thank!!

Yes I check the following thread at StackOverflow but it's not the same library I use. But Thank you for your answer!! Finally I solve my problem!! In my report in jasperserver I just add an "input control" from Ireport. In the view of jasperserver in Ireport I search my report and I add an Input control in directory "Input Control". I just do right click in the directory "Input Control" and I click in "Create a local input control" and after I name my input control like my parameter from Ireport and it's work!!! Now I can send a php variable and I get this variable in my report!! Hope it's help!! :)

I just begin to work on Ireport and jasperserver. My wishes is to generate a jasper report in my php application. I work on Symfony2. Actually I generate my report in my application but the problem is in Ireport I didn't get the php variable I send from my php application. And my report is in Jasperserver when I'm done the report modification. This is my action from my php application: public function result_recherche_googleAction(){ $em = $this->getDoctrine()->getManager (); $request = $this->getRequest(); $id_pef = $request->request->get('id_pef'); if ($request->isXmlHttpRequest()) { $jasperclient=new JasperClient(); $lien=$jasperclient->getUrlManyParams($this->container,"RechercheGoogle",array("id_pef" => $id_pef)); return $this->get('templating')->renderResponse('gideBundle:Edition:res_edition_recherche_google.html.twig',array( //'trans'=>$pefs, 'lien'=>$lien, )); //} } else { //return $this->feuillePEFAction(); return new Response(json_encode($id_pef)); }}[/code]This is the code from my report: <?xml version="1.0" encoding="UTF-8"?><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="RechercheGoogle" language="groovy" pageWidth="595" pageHeight="842" whenNoDataType="AllSectionsNoDetail" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="7e1de1d9-a08e-47ec-8af2-e93dbec288e7"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <parameter name="id_pef" class="java.lang.Integer"/> <background> <band splitType="Stretch"/> </background> <title> <band height="270" splitType="Stretch"> <staticText> <reportElement x="82" y="34" width="100" height="20" uuid="8969389a-851b-44e5-a88c-14a4b217fc47"/> <text><![CDATA[Coucou !!!]]></text> </staticText> <staticText> <reportElement x="252" y="21" width="240" height="58" uuid="1bebe360-cabf-485f-a158-befade8ee7a9"/> <textElement> <font size="14"/> </textElement> <text><![CDATA[iD du PEF: $P{id_pef}]]></text> </staticText> <textField> <reportElement x="322" y="125" width="100" height="20" uuid="eae36fce-573e-484c-8cca-e8b4007d5e2b"/> <textFieldExpression><![CDATA[$P{id_pef}]]></textFieldExpression> </textField> <textField> <reportElement x="224" y="109" width="100" height="20" uuid="2e2db24f-899b-45d0-9434-62cdd0f35171"/> <textFieldExpression><![CDATA[$P{id_pef}]]></textFieldExpression> </textField> </band> </title> <pageHeader> <band height="35" splitType="Stretch"/> </pageHeader> <columnHeader> <band height="61" splitType="Stretch"/> </columnHeader> <detail> <band height="125" splitType="Stretch"/> </detail> <columnFooter> <band height="45" splitType="Stretch"/> </columnFooter> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> <summary> <band height="42" splitType="Stretch"> <textField> <reportElement x="432" y="22" width="100" height="20" uuid="0d41b36b-f441-400c-af62-753fa3cb4b63"/> <textFieldExpression><![CDATA[$V{PAGE_NUMBER}]]></textFieldExpression> </textField> </band> </summary></jasperReport>[/code]I hope I'm clear. I try everything and I search a lot but any information about my problem. I hope someone can help me because It's very important! If you want more information about my problem tell me.