grandepapatte

Hi all, I already posted my problem on the forum, but I have not had any response so I represent you my problem: I have a report Ireport that works well, I publish it on JasperServer, and then when I watch it, it puts me this message: ' 1 - java.lang.String cannot be cast to java.util.TimeZone java.lang.Exception: 1 - java.lang.String cannot be cast to java.util.TimeZone at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) ' I do not know how to make my report work. For information, I am in SQLite, and I have 4 subreports. I put you as the XML of my report. Please help me. Is it urgent '<?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="Rapport1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.0000000000000022"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="179"/> <property name="ireport.jasperserver.reportUnit" value="/RAPPORT/FICHE_REGARD"/> <property name="ireport.jasperserver.url" value="http://srvsig:8080/jasperserver/services/repository"/> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["D:\\TEMP\\"]]></defaultValueExpression> </parameter> <parameter name="ASSET_ID" class="java.lang.String"> <defaultValueExpression><![CDATA[]]></defaultValueExpression> </parameter> <parameter name="DATABASE_TIMEZONE" class="java.lang.String" isForPrompting="false"/> <queryString> <![CDATA[sELECT po_regard.*,CONTROL_PROPRIETE_VOIE.*,CONTROL_ACCESSIBILITE_ASST.DESCRIPTION_ACCESSIBILITE AS 'LIBELLE_ACCESSIBILITE',CONTROL_TYPE_REGARD_VISITE.LIBELLE AS 'TYPE_DE_REGARD', CONTROL_GEOMETRIE_TAMPON.LIBELLE AS 'GEOMETRIE_DU_TAMPON',CONTROL_DISPOSITIF_FERMETURE_TAMPON.LIBELLE AS 'LIBELLE_DU_TAMPON', CONTROL_CLASSE_TAMPON.LIBELLE AS 'POIDS_DU_TAMPON', CONTROL_ETAT_TAMPON.LIBELLE AS 'ETAT_DU_TAMPON', CONTROL_TEST_ETANCHEITE.LIBELLE AS 'TEST_DETANCHEITE',CONTROL_COMMUNE.LIBELLE AS 'LIBELLE_COMMUNES', CONTROL_MATERIAU.LIBELLE AS 'LIBELLE_MATERIAU',CONTROL_ETAT_EQUIPEMENT.LIBELLE AS 'ETAT_ECHELLE', CONTROL_NATURE.DESC_NATURE AS 'DESCRIPTION_NATURE',CONTROL_DOMANIALITE.LIBELLE AS 'LIBELLE_DOMANIALITE', case when LENGTH(PO_REGARD.DIAMETRE_REGARD)>1 then PO_REGARD.DIAMETRE_REGARD else '' end AS 'DIAMETRE', case when LENGTH(PO_REGARD.LARGEUR_REGARD)>1 then PO_REGARD.LARGEUR_REGARD else '' end AS 'LARGEUR', case when LENGTH(PO_REGARD.LONGUEUR_REGARD)>1 then PO_REGARD.LONGUEUR_REGARD else '' end AS 'LONGUEUR', case when LENGTH(PO_REGARD.DIAMETRE_TAMPON)>1 then PO_REGARD.DIAMETRE_TAMPON else '' end AS 'DIAMETRE_DU_TAMPON', case when LENGTH(PO_REGARD.LARGEUR_TAMPON)>1 then PO_REGARD.LARGEUR_TAMPON else '' end AS 'LARGEUR_DU_TAMPON', case when LENGTH(PO_REGARD.LONGUEUR_TAMPON)>1 then PO_REGARD.LONGUEUR_TAMPON else '' end AS 'LONGUEUR_DU_TAMPON', case when PO_REGARD.ECHELLE=1 then 'Oui' when PO_REGARD.ECHELLE=0 then 'Non' else '' end AS 'LIBELLE_ECHELLE' FROM po_regard,CONTROL_PROPRIETE_VOIE,CONTROL_ACCESSIBILITE_ASST,CONTROL_TYPE_REGARD_VISITE,CONTROL_GEOMETRIE_TAMPON,CONTROL_DISPOSITIF_FERMETURE_TAMPON,CONTROL_CLASSE_TAMPON, CONTROL_ETAT_TAMPON,CONTROL_TEST_ETANCHEITE,CONTROL_COMMUNE,CONTROL_MATERIAU,CONTROL_ETAT_EQUIPEMENT,CONTROL_NATURE,CONTROL_DOMANIALITE WHERE PO_REGARD.ASSET_ID=$P{ASSET_ID} AND PO_REGARD.PROPRIETE_VOIE = CONTROL_PROPRIETE_VOIE.ID_PROPRIETE_VOIE AND CONTROL_TYPE_REGARD_VISITE.ID_TYPE_REGARD_VISITE = PO_REGARD.ID_TYPE_REGARD_VISITE AND CONTROL_ACCESSIBILITE_ASST.ACCESSIBILITE = PO_REGARD.ACCESSIBILITE AND CONTROL_GEOMETRIE_TAMPON.ID_GEOMETRIE_TAMPON = PO_REGARD.GEOMETRIE_TAMPON AND CONTROL_DISPOSITIF_FERMETURE_TAMPON.ID_DISPOSITIF_FERMETURE_TAMPON = PO_REGARD.ID_DISPOSITIF_FERMETURE_TAMPON AND CONTROL_CLASSE_TAMPON.ID_CLASSE_TAMPON = PO_REGARD.TAMPON_CLASSE AND CONTROL_ETAT_TAMPON.ID_ETAT_TAMPON = PO_REGARD.ID_ETAT_TAMPON AND CONTROL_TEST_ETANCHEITE.ID_TEST_ETANCHEITE = PO_REGARD.TEST_ETANCHEITE AND CONTROL_COMMUNE.ID_COMMUNE = PO_REGARD.ID_COMMUNE AND CONTROL_MATERIAU.ID_MATERIAU = PO_REGARD.ID_MATERIAU AND CONTROL_ETAT_EQUIPEMENT.ID_ETAT_EQUIPEMENT = PO_REGARD.ID_ETAT_ECHELLE AND CONTROL_NATURE.ID_NATURE = PO_REGARD.ID_NATURE AND CONTROL_DOMANIALITE.ID_DOMANIALITE = PO_REGARD.ID_DOMANIALITE]]> </queryString> <field name="ASSET_ID" class="java.lang.Object"/> <field name="GEOMETRY" class="java.lang.Object"/> <field name="CODE_REGARD" class="java.lang.Object"/> <field name="ACCESSIBILITE" class="java.lang.Object"/> <field name="ID_QUARTIER" class="java.lang.Object"/> <field name="ID_COMMUNE" class="java.lang.Object"/> <field name="ID_MATERIAU" class="java.lang.Object"/> <field name="ID_RIVOLI" class="java.lang.Object"/> <field name="ID_DOMANIALITE" class="java.lang.Object"/> <field name="NUMERO_PLAQUE" class="java.lang.Object"/> <field name="ZTN" class="java.lang.Object"/> <field name="ZFE" class="java.lang.Object"/> <field name="DIAMETRE_REGARD" class="java.lang.Object"/> <field name="LARGEUR_REGARD" class="java.lang.Object"/> <field name="LONGUEUR_REGARD" class="java.lang.Object"/> <field name="DIAMETRE_TAMPON" class="java.lang.Object"/> <field name="LARGEUR_TAMPON" class="java.lang.Object"/> <field name="LONGUEUR_TAMPON" class="java.lang.Object"/> <field name="ID_NATURE" class="java.lang.Object"/> <field name="ID_TYPE_REGARD_VISITE" class="java.lang.Object"/> <field name="ID_DISPOSITIF_FERMETURE_TAMPON" class="java.lang.Object"/> <field name="ID_TYPE_TAMPON" class="java.lang.Object"/> <field name="ID_ETAT_TAMPON" class="java.lang.Object"/> <field name="TAMPON_CLASSE" class="java.lang.Object"/> <field name="TAMPON_MODELE" class="java.lang.Object"/> <field name="ANNEE_POSE_TAMPON" class="java.lang.Object"/> <field name="ANNEE_POSE_REGARD" class="java.lang.Object"/> <field name="ID_ENVIRONNEMENT" class="java.lang.Object"/> <field name="ECHELLE" class="java.lang.Object"/> <field name="ID_ETAT_ECHELLE" class="java.lang.Object"/> <field name="CROSSE" class="java.lang.Object"/> <field name="ID_ETAT_CROSSE" class="java.lang.Object"/> <field name="CUNETTE" class="java.lang.Object"/> <field name="EQUIPEMENT" class="java.lang.Object"/> <field name="TYPE_EQUIPEMENT" class="java.lang.Object"/> <field name="ID_ETAT_SIPHON" class="java.lang.Object"/> <field name="CONE_REDUCTION" class="java.lang.Object"/> <field name="ID_ETAT_CONE_REDUCTION" class="java.lang.Object"/> <field name="SIPHON" class="java.lang.Object"/> <field name="RAS" class="java.lang.Object"/> <field name="INFILTRATION" class="java.lang.Object"/> <field name="CASSURE" class="java.lang.Object"/> <field name="RACINE" class="java.lang.Object"/> <field name="ABRASION_CORROSION" class="java.lang.Object"/> <field name="ANOMALIE_COURONNE" class="java.lang.Object"/> <field name="ANOMALIE_VIROLE" class="java.lang.Object"/> <field name="DEPOT_SOLIDE" class="java.lang.Object"/> <field name="HABILLAGE_SS_CADRE" class="java.lang.Object"/> <field name="X" class="java.lang.Object"/> <field name="Y" class="java.lang.Object"/> <field name="ROT" class="java.lang.Object"/> <field name="COMMENTAIRES" class="java.lang.Object"/> <field name="PERSO_1" class="java.lang.Object"/> <field name="PERSO_2" class="java.lang.Object"/> <field name="PERSO_3" class="java.lang.Object"/> <field name="COULEUR" class="java.lang.Object"/> <field name="JOINTURE_DOCUMENT" class="java.lang.Object"/> <field name="CAMERA_DATE" class="java.lang.Object"/> <field name="CAMERA_RAPPORT" class="java.lang.Object"/> <field name="CAMERA_CASSETTE" class="java.lang.Object"/> <field name="TEST_ETANCHEITE" class="java.lang.Object"/> <field name="TEST_ETANCHEITE_DATE" class="java.lang.Object"/> <field name="TESTE_ETANCHEITE_RAPPORT" class="java.lang.Object"/> <field name="PROFONDEUR" class="java.lang.Object"/> <field name="PRECISION_DONNEE" class="java.lang.Object"/> <field name="SITUATION" class="java.lang.Object"/> <field name="DATE_FICHE" class="java.lang.Object"/> <field name="TELEGESTION" class="java.lang.Object"/> <field name="GEOMETRIE_TAMPON" class="java.lang.Object"/> <field name="PROPRIETE_VOIE" class="java.lang.Object"/> <field name="BRANCHEMENT" class="java.lang.Object"/> <field name="NOM_OUVRAGE" class="java.lang.Object"/> <field name="JOINTURE_PT_REGARD" class="java.lang.Object"/> <field name="ID_PROPRIETE_VOIE" class="java.lang.Object"/> <field name="LIBELLE" class="java.lang.Object"/> <field name="LIBELLE_ACCESSIBILITE" class="java.lang.Object"/> <field name="TYPE_DE_REGARD" class="java.lang.Object"/> <field name="GEOMETRIE_DU_TAMPON" class="java.lang.Object"/> <field name="LIBELLE_DU_TAMPON" class="java.lang.Object"/> <field name="POIDS_DU_TAMPON" class="java.lang.Object"/> <field name="ETAT_DU_TAMPON" class="java.lang.Object"/> <field name="TEST_DETANCHEITE" class="java.lang.Object"/> <field name="LIBELLE_COMMUNES" class="java.lang.Object"/> <field name="LIBELLE_MATERIAU" class="java.lang.Object"/> <field name="ETAT_ECHELLE" class="java.lang.Object"/> <field name="DESCRIPTION_NATURE" class="java.lang.Object"/> <field name="LIBELLE_DOMANIALITE" class="java.lang.Object"/> <field name="DIAMETRE" class="java.lang.Object"/> <field name="LARGEUR" class="java.lang.Object"/> <field name="LONGUEUR" class="java.lang.Object"/> <field name="DIAMETRE_DU_TAMPON" class="java.lang.Object"/> <field name="LARGEUR_DU_TAMPON" class="java.lang.Object"/> <field name="LONGUEUR_DU_TAMPON" class="java.lang.Object"/> <field name="LIBELLE_ECHELLE" class="java.lang.Object"/> <background> <band splitType="Stretch"/> </background> <title> <band height="58" splitType="Stretch"> <staticText> <reportElement x="231" y="12" width="100" height="20"/> <textElement/> <text><![CDATA[FICHE DE REGARD]]></text> </staticText> </band> </title> <detail> <band height="684" splitType="Stretch"> <staticText> <reportElement x="153" y="577" width="264" height="20"/> <textElement/> <text><![CDATA[Observations (notamment état du tampon et du regard) :]]></text> </staticText> <staticText> <reportElement x="387" y="373" width="67" height="20"/> <textElement/> <text><![CDATA[FE (m)]]></text> </staticText> <staticText> <reportElement x="164" y="373" width="100" height="20"/> <textElement/> <text><![CDATA[Nature]]></text> </staticText> <staticText> <reportElement x="323" y="373" width="63" height="20"/> <textElement/> <text><![CDATA[Matériaux]]></text> </staticText> <staticText> <reportElement x="454" y="373" width="100" height="20"/> <textElement/> <text><![CDATA[Arrivée/Départ]]></text> </staticText> <staticText> <reportElement x="264" y="373" width="59" height="20"/> <textElement/> <text><![CDATA[Diamètre]]></text> </staticText> <staticText> <reportElement x="277" y="10" width="77" height="20"/> <textElement/> <text><![CDATA[Commune :]]></text> </staticText> <staticText> <reportElement x="13" y="31" width="189" height="20"/> <textElement/> <text><![CDATA[Propriété de la voie ou de la parcelle :]]></text> </staticText> <line> <reportElement x="13" y="51" width="522" height="1"/> </line> <textField isBlankWhenNull="true"> <reportElement x="85" y="52" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{ASSET_ID}]]></textFieldExpression> </textField> <staticText> <reportElement x="13" y="52" width="72" height="20"/> <textElement/> <text><![CDATA[N° de regard :]]></text> </staticText> <staticText> <reportElement x="13" y="72" width="78" height="20"/> <textElement/> <text><![CDATA[Type de regard :]]></text> </staticText> <staticText> <reportElement x="13" y="91" width="116" height="20"/> <textElement/> <text><![CDATA[Géometrie du tampon :]]></text> </staticText> <staticText> <reportElement x="263" y="52" width="114" height="20"/> <textElement/> <text><![CDATA[Dispositif de fermeture :]]></text> </staticText> <staticText> <reportElement x="263" y="71" width="91" height="20"/> <textElement/> <text><![CDATA[Poids du tampon :]]></text> </staticText> <staticText> <reportElement x="13" y="11" width="51" height="20"/> <textElement/> <text><![CDATA[situation :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="202" y="31" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="91" y="71" width="157" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{TYPE_DE_REGARD}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="127" y="91" width="121" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{GEOMETRIE_DU_TAMPON}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="377" y="51" width="177" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_DU_TAMPON}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="354" y="71" width="200" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{POIDS_DU_TAMPON}]]></textFieldExpression> </textField> <staticText> <reportElement x="263" y="91" width="91" height="20"/> <textElement/> <text><![CDATA[Etat du tampon :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="354" y="91" width="200" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{ETAT_DU_TAMPON}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="152" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="160" width="140" height="20"/> <textElement/> <text><![CDATA[inspection caméra ou autre :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="104" y="191" width="127" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{CAMERA_DATE}]]></textFieldExpression> </textField> <staticText> <reportElement x="13" y="191" width="91" height="20"/> <textElement/> <text><![CDATA[Date d'inspection : ]]></text> </staticText> <staticText> <reportElement x="263" y="180" width="77" height="20"/> <textElement/> <text><![CDATA[N° de rapport :]]></text> </staticText> <staticText> <reportElement x="263" y="200" width="88" height="20"/> <textElement/> <text><![CDATA[Caméra cassette : ]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="340" y="180" width="214" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{CAMERA_RAPPORT}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="351" y="200" width="203" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{CAMERA_CASSETTE}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="220" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="229" width="91" height="20"/> <textElement/> <text><![CDATA[Test d'étanchéité :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="104" y="229" width="127" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{TEST_DETANCHEITE}]]></textFieldExpression> </textField> <staticText> <reportElement x="263" y="221" width="88" height="20"/> <textElement/> <text><![CDATA[Date du rapport :]]></text> </staticText> <staticText> <reportElement x="263" y="240" width="88" height="20"/> <textElement/> <text><![CDATA[N° du rapport :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="351" y="221" width="203" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{TEST_ETANCHEITE_DATE}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="351" y="241" width="203" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{TESTE_ETANCHEITE_RAPPORT}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="354" y="10" width="201" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_COMMUNES}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="260" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="261" width="91" height="20"/> <textElement/> <text><![CDATA[Cheminée :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="104" y="261" width="127" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_MATERIAU}]]></textFieldExpression> </textField> <staticText> <reportElement x="263" y="261" width="87" height="20"/> <textElement/> <text><![CDATA[Dimensions :]]></text> </staticText> <staticText> <reportElement x="13" y="281" width="111" height="20"/> <textElement/> <text><![CDATA[Présence d'échelons :]]></text> </staticText> <staticText> <reportElement x="263" y="300" width="100" height="20"/> <textElement/> <text><![CDATA[Etat des échelons :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="363" y="301" width="177" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{ETAT_ECHELLE}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="320" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="321" width="91" height="20"/> <textElement/> <text><![CDATA[Nature du réseau :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="104" y="321" width="127" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{DESCRIPTION_NATURE}]]></textFieldExpression> </textField> <staticText> <reportElement x="262" y="320" width="101" height="20"/> <textElement/> <text><![CDATA[Propriété du réseau :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="363" y="320" width="177" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_DOMANIALITE}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="340" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="341" width="130" height="20"/> <textElement/> <text><![CDATA[Profondeur du regard (m) :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="143" y="341" width="88" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{PROFONDEUR}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="350" y="261" width="64" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LARGEUR}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="351" y="281" width="63" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LONGUEUR}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="414" y="262" width="44" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{DIAMETRE}]]></textFieldExpression> </textField> <staticText> <reportElement x="13" y="111" width="114" height="20"/> <textElement/> <text><![CDATA[Dimension du tampon :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="127" y="111" width="124" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LONGUEUR_DU_TAMPON}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="127" y="131" width="124" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LARGEUR_DU_TAMPON}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="127" y="111" width="124" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{DIAMETRE_DU_TAMPON}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="124" y="281" width="107" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_ECHELLE}]]></textFieldExpression> </textField> <textField> <reportElement x="64" y="10" width="167" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_ACCESSIBILITE}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="104" y="611" width="354" height="53"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{COMMENTAIRES}]]></textFieldExpression> </textField> <subreport> <reportElement x="-17" y="393" width="571" height="40"/> <subreportParameter name="ASSET_ID"> <subreportParameterExpression><![CDATA[$P{ASSET_ID}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="DATABASE_TIMEZONE"/> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "Rapport_collecteur_Arrivee2.jasper"]]></subreportExpression> </subreport> <subreport> <reportElement x="-17" y="433" width="571" height="40"/> <subreportParameter name="DATABASE_TIMEZONE"> <subreportParameterExpression><![CDATA[$P{ASSET_ID}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="ASSET_ID"/> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "Rapport_collecteur_depart2.jasper"]]></subreportExpression> </subreport> <subreport> <reportElement x="2" y="473" width="552" height="43"/> <subreportParameter name="ASSET_ID"> <subreportParameterExpression><![CDATA[$P{ASSET_ID}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="DATABASE_TIMEZONE"/> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "Rapport_Cana_Branch_Arrivee.jasper"]]></subreportExpression> </subreport> <subreport> <reportElement x="0" y="516" width="554" height="42"/> <subreportParameter name="ASSET_ID"> <subreportParameterExpression><![CDATA[$P{ASSET_ID}]]></subreportParameterExpression> </subreportParameter> <subreportParameter name="DATABASE_TIMEZONE"/> <connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression> <subreportExpression class="java.lang.String"><![CDATA[$P{SUBREPORT_DIR} + "Rapport_Cana_Brach_Depart.jasper"]]></subreportExpression> </subreport> </band> </detail> <pageFooter> <band height="54" splitType="Stretch"/> </pageFooter> </jasperReport> '

Hi all, I explain my problem, I make a report and I Ireport publis on JasperServer, the problem is that when I visualize it makes me the following problem: 'java.lang.String cannot be cast to java.util.TimeZone' What is the solution to avoid having this error message. thank you

Hello, Here, I make my report on Ireport jasper, and I have a little problem. In fact when I put a 'CASE' in my query and there are several results, it appears to me as the first. How to fix it, Sincerely, Elliott Foucher

Hello, my problem : I have a report on my server and I'd put it on another server. So I make an export : C: \ Program Files (x86) \ JasperReports-cp-server-4.0.0 \ scripts Then: js-export - everything - output-zip C: \ temp \ FICHE_RAPPORT.zip - skip-access But when I'm here, I get an error which is: 'js-export' is not recognized as internal command or external, operable program or batch file. And when I look in C: \ Program Files (x86) \ JasperReports-cp-server-4.0.0 \ scripts, there are no scripts, where can I find them? Sincerely, Elliott

Hello,Here I have a little problem. I publish my report Ireport on JasperServer, and then he puts me this error: 1 - org.xml.sax.SAXParseException: The processing instruction target matching "[xX][mM][lL]" is not allowed. java.lang.Exception: 1 - org.xml.sax.SAXParseException: The processing instruction target matching "[xX][mM][lL]" is not allowed. at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) How do I avoid this error, or what must change. I guess it's an error in the XML.Info for my report includes four sub-report, it may be that.I put the XML report is this: <?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="Rapport1" language="groovy" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.1000000000000025"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <property name="ireport.jasperserver.reportUnit" value="/RAPPORT/FICHE_REGARD"/> <property name="ireport.jasperserver.url" value="http://srvsig:8080/jasperserver/services/repository"/> <parameter name="SUBREPORT_DIR" class="java.lang.String" isForPrompting="false"> <defaultValueExpression><![CDATA["D:\\TEMP\\"]]></defaultValueExpression> </parameter> <parameter name="ASSET_ID" class="java.lang.String"> <defaultValueExpression><![CDATA[41063]]></defaultValueExpression> </parameter> <parameter name="DATABASE_TIMEZONE" class="java.lang.String"/> <queryString> <![CDATA[sELECT po_regard.*,CONTROL_PROPRIETE_VOIE.*,CONTROL_ACCESSIBILITE_ASST.DESCRIPTION_ACCESSIBILITE AS 'LIBELLE_ACCESSIBILITE',CONTROL_TYPE_REGARD_VISITE.LIBELLE AS 'TYPE_DE_REGARD', CONTROL_GEOMETRIE_TAMPON.LIBELLE AS 'GEOMETRIE_DU_TAMPON',CONTROL_DISPOSITIF_FERMETURE_TAMPON.LIBELLE AS 'LIBELLE_DU_TAMPON', CONTROL_CLASSE_TAMPON.LIBELLE AS 'POIDS_DU_TAMPON', CONTROL_ETAT_TAMPON.LIBELLE AS 'ETAT_DU_TAMPON', CONTROL_TEST_ETANCHEITE.LIBELLE AS 'TEST_DETANCHEITE',CONTROL_COMMUNE.LIBELLE AS 'LIBELLE_COMMUNES', CONTROL_MATERIAU.LIBELLE AS 'LIBELLE_MATERIAU',CONTROL_ETAT_EQUIPEMENT.LIBELLE AS 'ETAT_ECHELLE', CONTROL_NATURE.DESC_NATURE AS 'DESCRIPTION_NATURE',CONTROL_DOMANIALITE.LIBELLE AS 'LIBELLE_DOMANIALITE', case when LENGTH(PO_REGARD.DIAMETRE_REGARD)>1 then PO_REGARD.DIAMETRE_REGARD else '' end AS 'DIAMETRE', case when LENGTH(PO_REGARD.LARGEUR_REGARD)>1 then PO_REGARD.LARGEUR_REGARD else '' end AS 'LARGEUR', case when LENGTH(PO_REGARD.LONGUEUR_REGARD)>1 then PO_REGARD.LONGUEUR_REGARD else '' end AS 'LONGUEUR', case when LENGTH(PO_REGARD.DIAMETRE_TAMPON)>1 then PO_REGARD.DIAMETRE_TAMPON else '' end AS 'DIAMETRE_DU_TAMPON', case when LENGTH(PO_REGARD.LARGEUR_TAMPON)>1 then PO_REGARD.LARGEUR_TAMPON else '' end AS 'LARGEUR_DU_TAMPON', case when LENGTH(PO_REGARD.LONGUEUR_TAMPON)>1 then PO_REGARD.LONGUEUR_TAMPON else '' end AS 'LONGUEUR_DU_TAMPON', case when PO_REGARD.ECHELLE=1 then 'Oui' when PO_REGARD.ECHELLE=0 then 'Non' else '' end AS 'LIBELLE_ECHELLE' FROM po_regard,CONTROL_PROPRIETE_VOIE,CONTROL_ACCESSIBILITE_ASST,CONTROL_TYPE_REGARD_VISITE,CONTROL_GEOMETRIE_TAMPON,CONTROL_DISPOSITIF_FERMETURE_TAMPON,CONTROL_CLASSE_TAMPON, CONTROL_ETAT_TAMPON,CONTROL_TEST_ETANCHEITE,CONTROL_COMMUNE,CONTROL_MATERIAU,CONTROL_ETAT_EQUIPEMENT,CONTROL_NATURE,CONTROL_DOMANIALITE WHERE PO_REGARD.ASSET_ID=$P{ASSET_ID} AND PO_REGARD.PROPRIETE_VOIE = CONTROL_PROPRIETE_VOIE.ID_PROPRIETE_VOIE AND CONTROL_TYPE_REGARD_VISITE.ID_TYPE_REGARD_VISITE = PO_REGARD.ID_TYPE_REGARD_VISITE AND CONTROL_ACCESSIBILITE_ASST.ACCESSIBILITE = PO_REGARD.ACCESSIBILITE AND CONTROL_GEOMETRIE_TAMPON.ID_GEOMETRIE_TAMPON = PO_REGARD.GEOMETRIE_TAMPON AND CONTROL_DISPOSITIF_FERMETURE_TAMPON.ID_DISPOSITIF_FERMETURE_TAMPON = PO_REGARD.ID_DISPOSITIF_FERMETURE_TAMPON AND CONTROL_CLASSE_TAMPON.ID_CLASSE_TAMPON = PO_REGARD.TAMPON_CLASSE AND CONTROL_ETAT_TAMPON.ID_ETAT_TAMPON = PO_REGARD.ID_ETAT_TAMPON AND CONTROL_TEST_ETANCHEITE.ID_TEST_ETANCHEITE = PO_REGARD.TEST_ETANCHEITE AND CONTROL_COMMUNE.ID_COMMUNE = PO_REGARD.ID_COMMUNE AND CONTROL_MATERIAU.ID_MATERIAU = PO_REGARD.ID_MATERIAU AND CONTROL_ETAT_EQUIPEMENT.ID_ETAT_EQUIPEMENT = PO_REGARD.ID_ETAT_ECHELLE AND CONTROL_NATURE.ID_NATURE = PO_REGARD.ID_NATURE AND CONTROL_DOMANIALITE.ID_DOMANIALITE = PO_REGARD.ID_DOMANIALITE]]> </queryString> <field name="ASSET_ID" class="java.lang.Object"/> <field name="GEOMETRY" class="java.lang.Object"/> <field name="CODE_REGARD" class="java.lang.Object"/> <field name="ACCESSIBILITE" class="java.lang.Object"/> <field name="ID_QUARTIER" class="java.lang.Object"/> <field name="ID_COMMUNE" class="java.lang.Object"/> <field name="ID_MATERIAU" class="java.lang.Object"/> <field name="ID_RIVOLI" class="java.lang.Object"/> <field name="ID_DOMANIALITE" class="java.lang.Object"/> <field name="NUMERO_PLAQUE" class="java.lang.Object"/> <field name="ZTN" class="java.lang.Object"/> <field name="ZFE" class="java.lang.Object"/> <field name="DIAMETRE_REGARD" class="java.lang.Object"/> <field name="LARGEUR_REGARD" class="java.lang.Object"/> <field name="LONGUEUR_REGARD" class="java.lang.Object"/> <field name="DIAMETRE_TAMPON" class="java.lang.Object"/> <field name="LARGEUR_TAMPON" class="java.lang.Object"/> <field name="LONGUEUR_TAMPON" class="java.lang.Object"/> <field name="ID_NATURE" class="java.lang.Object"/> <field name="ID_TYPE_REGARD_VISITE" class="java.lang.Object"/> <field name="ID_DISPOSITIF_FERMETURE_TAMPON" class="java.lang.Object"/> <field name="ID_TYPE_TAMPON" class="java.lang.Object"/> <field name="ID_ETAT_TAMPON" class="java.lang.Object"/> <field name="TAMPON_CLASSE" class="java.lang.Object"/> <field name="TAMPON_MODELE" class="java.lang.Object"/> <field name="ANNEE_POSE_TAMPON" class="java.lang.Object"/> <field name="ANNEE_POSE_REGARD" class="java.lang.Object"/> <field name="ID_ENVIRONNEMENT" class="java.lang.Object"/> <field name="ECHELLE" class="java.lang.Object"/> <field name="ID_ETAT_ECHELLE" class="java.lang.Object"/> <field name="CROSSE" class="java.lang.Object"/> <field name="ID_ETAT_CROSSE" class="java.lang.Object"/> <field name="CUNETTE" class="java.lang.Object"/> <field name="EQUIPEMENT" class="java.lang.Object"/> <field name="TYPE_EQUIPEMENT" class="java.lang.Object"/> <field name="ID_ETAT_SIPHON" class="java.lang.Object"/> <field name="CONE_REDUCTION" class="java.lang.Object"/> <field name="ID_ETAT_CONE_REDUCTION" class="java.lang.Object"/> <field name="SIPHON" class="java.lang.Object"/> <field name="RAS" class="java.lang.Object"/> <field name="INFILTRATION" class="java.lang.Object"/> <field name="CASSURE" class="java.lang.Object"/> <field name="RACINE" class="java.lang.Object"/> <field name="ABRASION_CORROSION" class="java.lang.Object"/> <field name="ANOMALIE_COURONNE" class="java.lang.Object"/> <field name="ANOMALIE_VIROLE" class="java.lang.Object"/> <field name="DEPOT_SOLIDE" class="java.lang.Object"/> <field name="HABILLAGE_SS_CADRE" class="java.lang.Object"/> <field name="X" class="java.lang.Object"/> <field name="Y" class="java.lang.Object"/> <field name="ROT" class="java.lang.Object"/> <field name="COMMENTAIRES" class="java.lang.Object"/> <field name="PERSO_1" class="java.lang.Object"/> <field name="PERSO_2" class="java.lang.Object"/> <field name="PERSO_3" class="java.lang.Object"/> <field name="COULEUR" class="java.lang.Object"/> <field name="JOINTURE_DOCUMENT" class="java.lang.Object"/> <field name="CAMERA_DATE" class="java.lang.Object"/> <field name="CAMERA_RAPPORT" class="java.lang.Object"/> <field name="CAMERA_CASSETTE" class="java.lang.Object"/> <field name="TEST_ETANCHEITE" class="java.lang.Object"/> <field name="TEST_ETANCHEITE_DATE" class="java.lang.Object"/> <field name="TESTE_ETANCHEITE_RAPPORT" class="java.lang.Object"/> <field name="PROFONDEUR" class="java.lang.Object"/> <field name="PRECISION_DONNEE" class="java.lang.Object"/> <field name="SITUATION" class="java.lang.Object"/> <field name="DATE_FICHE" class="java.lang.Object"/> <field name="TELEGESTION" class="java.lang.Object"/> <field name="GEOMETRIE_TAMPON" class="java.lang.Object"/> <field name="PROPRIETE_VOIE" class="java.lang.Object"/> <field name="BRANCHEMENT" class="java.lang.Object"/> <field name="NOM_OUVRAGE" class="java.lang.Object"/> <field name="JOINTURE_PT_REGARD" class="java.lang.Object"/> <field name="ID_PROPRIETE_VOIE" class="java.lang.Object"/> <field name="LIBELLE" class="java.lang.Object"/> <field name="LIBELLE_ACCESSIBILITE" class="java.lang.Object"/> <field name="TYPE_DE_REGARD" class="java.lang.Object"/> <field name="GEOMETRIE_DU_TAMPON" class="java.lang.Object"/> <field name="LIBELLE_DU_TAMPON" class="java.lang.Object"/> <field name="POIDS_DU_TAMPON" class="java.lang.Object"/> <field name="ETAT_DU_TAMPON" class="java.lang.Object"/> <field name="TEST_DETANCHEITE" class="java.lang.Object"/> <field name="LIBELLE_COMMUNES" class="java.lang.Object"/> <field name="LIBELLE_MATERIAU" class="java.lang.Object"/> <field name="ETAT_ECHELLE" class="java.lang.Object"/> <field name="DESCRIPTION_NATURE" class="java.lang.Object"/> <field name="LIBELLE_DOMANIALITE" class="java.lang.Object"/> <field name="DIAMETRE" class="java.lang.Object"/> <field name="LARGEUR" class="java.lang.Object"/> <field name="LONGUEUR" class="java.lang.Object"/> <field name="DIAMETRE_DU_TAMPON" class="java.lang.Object"/> <field name="LARGEUR_DU_TAMPON" class="java.lang.Object"/> <field name="LONGUEUR_DU_TAMPON" class="java.lang.Object"/> <field name="LIBELLE_ECHELLE" class="java.lang.Object"/> <background> <band splitType="Stretch"/> </background> <title> <band height="58" splitType="Stretch"> <staticText> <reportElement x="231" y="12" width="100" height="20"/> <textElement/> <text><![CDATA[FICHE DE REGARD]]></text> </staticText> <image> <reportElement x="23" y="11" width="68" height="40"/> <imageExpression class="java.lang.String"><![CDATA["D:\\geomap\\Geomap2012\\WebExt\\Clientjs\\sample\\logoTopToolbar\\Logo_AnnemasseAgglo2.png"]]></imageExpression> </image> </band> </title> <detail> <band height="684" splitType="Stretch"> <staticText> <reportElement x="277" y="10" width="77" height="20"/> <textElement/> <text><![CDATA[Commune :]]></text> </staticText> <staticText> <reportElement x="13" y="31" width="189" height="20"/> <textElement/> <text><![CDATA[Propriété de la voie ou de la parcelle :]]></text> </staticText> <line> <reportElement x="13" y="51" width="522" height="1"/> </line> <textField isBlankWhenNull="true"> <reportElement x="85" y="52" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{ASSET_ID}]]></textFieldExpression> </textField> <staticText> <reportElement x="13" y="52" width="72" height="20"/> <textElement/> <text><![CDATA[N° de regard :]]></text> </staticText> <staticText> <reportElement x="13" y="72" width="78" height="20"/> <textElement/> <text><![CDATA[Type de regard :]]></text> </staticText> <staticText> <reportElement x="13" y="91" width="116" height="20"/> <textElement/> <text><![CDATA[Géometrie du tampon :]]></text> </staticText> <staticText> <reportElement x="263" y="52" width="114" height="20"/> <textElement/> <text><![CDATA[Dispositif de fermeture :]]></text> </staticText> <staticText> <reportElement x="263" y="71" width="91" height="20"/> <textElement/> <text><![CDATA[Poids du tampon :]]></text> </staticText> <staticText> <reportElement x="13" y="11" width="51" height="20"/> <textElement/> <text><![CDATA[situation :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="202" y="31" width="100" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="91" y="71" width="157" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{TYPE_DE_REGARD}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="127" y="91" width="121" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{GEOMETRIE_DU_TAMPON}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="377" y="51" width="177" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_DU_TAMPON}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="354" y="71" width="200" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{POIDS_DU_TAMPON}]]></textFieldExpression> </textField> <staticText> <reportElement x="263" y="91" width="91" height="20"/> <textElement/> <text><![CDATA[Etat du tampon :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="354" y="91" width="200" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{ETAT_DU_TAMPON}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="152" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="160" width="140" height="20"/> <textElement/> <text><![CDATA[inspection caméra ou autre :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="104" y="191" width="127" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{CAMERA_DATE}]]></textFieldExpression> </textField> <staticText> <reportElement x="13" y="191" width="91" height="20"/> <textElement/> <text><![CDATA[Date d'inspection : ]]></text> </staticText> <staticText> <reportElement x="263" y="180" width="77" height="20"/> <textElement/> <text><![CDATA[N° de rapport :]]></text> </staticText> <staticText> <reportElement x="263" y="200" width="88" height="20"/> <textElement/> <text><![CDATA[Caméra cassette : ]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="340" y="180" width="214" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{CAMERA_RAPPORT}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="351" y="200" width="203" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{CAMERA_CASSETTE}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="220" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="229" width="91" height="20"/> <textElement/> <text><![CDATA[Test d'étanchéité :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="104" y="229" width="127" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{TEST_DETANCHEITE}]]></textFieldExpression> </textField> <staticText> <reportElement x="263" y="221" width="88" height="20"/> <textElement/> <text><![CDATA[Date du rapport :]]></text> </staticText> <staticText> <reportElement x="263" y="240" width="88" height="20"/> <textElement/> <text><![CDATA[N° du rapport :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="351" y="221" width="203" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{TEST_ETANCHEITE_DATE}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="351" y="241" width="203" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{TESTE_ETANCHEITE_RAPPORT}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="354" y="10" width="201" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_COMMUNES}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="260" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="261" width="91" height="20"/> <textElement/> <text><![CDATA[Cheminée :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="104" y="261" width="127" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_MATERIAU}]]></textFieldExpression> </textField> <staticText> <reportElement x="263" y="261" width="87" height="20"/> <textElement/> <text><![CDATA[Dimensions :]]></text> </staticText> <staticText> <reportElement x="13" y="281" width="111" height="20"/> <textElement/> <text><![CDATA[Présence d'échelons :]]></text> </staticText> <staticText> <reportElement x="263" y="300" width="100" height="20"/> <textElement/> <text><![CDATA[Etat des échelons :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="363" y="301" width="177" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{ETAT_ECHELLE}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="320" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="321" width="91" height="20"/> <textElement/> <text><![CDATA[Nature du réseau :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="104" y="321" width="127" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{DESCRIPTION_NATURE}]]></textFieldExpression> </textField> <staticText> <reportElement x="262" y="320" width="101" height="20"/> <textElement/> <text><![CDATA[Propriété du réseau :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="363" y="320" width="177" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LIBELLE_DOMANIALITE}]]></textFieldExpression> </textField> <line> <reportElement x="13" y="340" width="522" height="1"/> </line> <staticText> <reportElement x="13" y="341" width="130" height="20"/> <textElement/> <text><![CDATA[Profondeur du regard (m) :]]></text> </staticText> <textField isBlankWhenNull="true"> <reportElement x="143" y="341" width="88" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{PROFONDEUR}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="350" y="261" width="64" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LARGEUR}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="351" y="281" width="63" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{LONGUEUR}]]></textFieldExpression> </textField> <textField isBlankWhenNull="true"> <reportElement x="414" y="262" width="44" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[""+$F{DIAMETRE}]]></textFieldExpression> </textField> <staticText> <reportElement x="13" y="111" width="114" height="20"/> <textElement/> <text><![CDATA[Dimension du tampon :]]></text> </staticText> &

Hi all,I have a report based on iReport, and I want to publish it on JasperServer.So first, I created my repository, and then I 'Add' and 'JasperServer Report'.So then I get to the window 'Naming' I filled, then the next page 'Main JRXML' and Ichose 'Locally Defined', and then after I get to the window 'Locate Data Source',and there I chose 'locally Defined' and 'Edit local datasource', then I fill the info in the first tab (General) and in the second tab (Data source Details) I check JDBCData source, I import from iReport and I chose my JDBC Data source.But the worry is that the save is grayed out, it expects a 'username', gold is SQLITEmy base, and a SQLite database does not have a username or password.So how to override this to post my report.Thank you in advance for your help, Elliott