Bonjour
j'ai un problème d'affichage des paramètres mat et le mois
voila mon bout code :
Code :
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| String mat= (String) this.getParameterValue("mat");
String mois= (String) this.getParameterValue("mois");
params.put("mois",this.getParameterValue("PÉRIODE"));
PreparedStatement Statementrs6 = con.prepareStatement("SELECT distinct code FROM system.type_ind where code_chapitre='"+chap+"' and code_article='"+art+"'");
ResultSet rs6 = Statementrs6.executeQuery();
while(rs6.next()){
System.out.println(this.getFieldValue("CODE_CHAPITRE"));
PreparedStatement Statementrs07 = con.prepareStatement("SELECT montant FROM system.arch_ind_m where période='"+mois+"' and mat='"+mat+"' and rownum <= 10 and code_ind="+rs6.getInt(1)+"order by mat");
ResultSet rs07 = Statementrs07.executeQuery();
System.out.println(this.getParameterValue("PÉRIODE"));
while(rs07.next()){
System.out.println("fdfkslfkslfkofiosdifosifdopi");
some+= rs07.getDouble(1);
}Statementrs07.close();rs07.close();
}Statementrs6.close();rs6.close();
}catch(Exception e){
}
}
return some; |
........................
et le ireport 3.6 m'affiche le message d'erreur suivant
Citation:
Error*filling*print...*Error*evaluating*expression*:* ****Source*text*:*$P{REPORT_SCRIPTLET}.getParameterValue(*$P{mois}*)
net.sf.jasperreports.engine.fill.JRExpressionEvalException:*Error*evaluating*expression*:* ****Source*text*:*$P{REPORT_SCRIPTLET}.getParameterValue(*$P{mois}*)* ****at*net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:195)* ****at*net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:589)* ****at*net.sf.jasperreports.engine.fill.JRCalculator.evaluate(JRCalculator.java:557)* ****at*net.sf.jasperreports.engine.fill.JRFillElement.evaluateExpression(JRFillElement.java:929)* ****at*net.sf.jasperreports.engine.fill.JRFillTextField.evaluateText(JRFillTextField.java:383)* ****at*net.sf.jasperreports.engine.fill.JRFillTextField.evaluate(JRFillTextField.java:368)* ****at*net.sf.jasperreports.engine.fill.JRFillElementContainer.evaluate(JRFillElementContainer.java:258)* ****at*net.sf.jasperreports.engine.fill.JRFillBand.evaluate(JRFillBand.java:499)* ****at*net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:326)* ****at*net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:262)* ****at*net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:128)* ****at*net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:946)* ****at*net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:845)* ****at*net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:58)* ****at*net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417)* ****at*net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247)* ****at*com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:877)* ****at*org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572)* ****at*org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)* Caused*by:*net.sf.jasperreports.engine.JRScriptletException:*Parameter*not*found*:*2011/04* ****at*net.sf.jasperreports.engine.JRAbstractScriptlet.getParameterValue(JRAbstractScriptlet.java:98)* ****at*net.sf.jasperreports.engine.JRAbstractScriptlet.getParameterValue(JRAbstractScriptlet.java:84)* ****at*sun.reflect.NativeMethodAccessorImpl.invoke0(Native*Method)* ****at*sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)* ****at*sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)* ****at*java.lang.reflect.Method.invoke(Method.java:597)* ****at*org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite$PojoCachedMethodSite.invoke(PojoMetaMethodSite.java:188)* ****at*org.codehaus.groovy.runtime.callsite.PojoMetaMethodSite.call(PojoMetaMethodSite.java:52)* ****at*org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:40)* ****at*org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:116)* ****at*org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:124)* ****at*example_1306762022553_81898.evaluate(calculator_example_1306762022553_81898:165)* ****at*net.sf.jasperreports.engine.fill.JREvaluator.evaluate(JREvaluator.java:182)* ****...*18*more*
Print not filled. Try to use an EmptyDataSource...
|
aidez moi SVP c 'est urgent
* Merci *