SOYHU

Item label of Stacked chart are not showed on stacked bar, i use ireport version 3.5.3 and i've set label expression to chart data but my graph have not showed any label on stacked bar , or i have to implement JRChartCustomizer class? (please tell me how can i plug in implement class to ireport, i can't see approach in the jfreechart-1.0.13-install.pdf and The JFreeChart.Class.Library.Developer.Guide.v1.0.9.Jan.2008.pdf Thank in advanced regard. Soyhu Post Edited by SOYHU at 10/02/2009 09:35 Post Edited by SOYHU at 10/03/2009 14:18

I ever use "Option -->> Complilation and execution " to complie jrxml code and deploy to Websphere work sapce both report and sub report (ireport 2.XX ), it's ok Have you tried its?

my SUBREPORT_DIR is set Default Value Expression = "C:\\honda\\hatc_boss_rep\\Real\\" see my attached file.

Normally when i run and complie main report, main jasper class will be generated before sub report jasper class including csv(output when running) file , because i wanna use csv datasource from subreport to use to main report, so I need csv file from subreport before generate main report . Thank in advanced, Soyhu

I use below statement to some field in my report. ($V{SUM_NET_ORDER_BY_MO_GRP7}.compareTo(new BigDecimal("0")) > 0 )?($F{NET_ORDER_N_7}/ $V{SUM_NET_ORDER_BY_MO_GRP7}) :" " and when I run this report the system will be show " 32.00 " values that it should be " " because my $V{SUM_NET_ORDER_BY_MO_GRP7} is Zero. please help me correct this condition. Thank you, Soyhu.

How can i fix wide of each bar chart . when i have one bar chart then it show very big bar. Post Edited by SOYHU at 08/20/2009 10:11

Can I do Multi chart ? I mean i need to mix about 3 or 4 graphs into the same page. please see an attached file Thank in advanced. Soyhu Post Edited by at 08/13/2009 11:03 Post Edited by SOYHU at 08/13/2009 13:07

Thank you very much for you reply, i've already connect its, this error happen because my connection mistake when i connected to database.

Could you expain me for this error message when i set connection data to oracle by jdbc driver : oracle.jdbc.driver.OracleDriver jdbc url : jdbc:oracle:thin:@gec52db:1521:GEDB_10G and i 've put ojdbc14 into lib folder of jasper already. when click test connection, it shows below error: SQL problems: Io exception: Connection refused(DESCRIPTION=(TMP=)(VSNNUM=169869568)(ERR=12505)(ERROR_STACK=(ERROR=(CODE=12505)(EMFI=4)))) jdbc:oracle:thin:@gec52db:1521:GEDB_10G Thank you for your reccommend. Soyhu

Sorry, i know that sub report can set only some query and i can't find where i can set another database connection ( amm i mean one of them is oracle database and another connection is DB2 Thank you SOYHU.

Could i set two connections of database for using in the same report page? For i can do that .How can i set ? In the past i add two connections by hard code in the servlet file and send that to japer file but they get only first connection and leave another one. Thank in advanced, SOYHU.

How to coding to send the parameter into jrxml file ? This is my code (// i want to send "SOYHU","SOYHU1","SOYHU2", ... variable parameter to jrxml file how about the coding syntax . ) /* * Created on Nov 27, 2007 * * TODO To change the template for this generated file go to * Window - Preferences - Java - Code Style - Code Templates */ package net.ensode.jasperbook; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.HashMap; import java.util.Map; import net.sf.jasperreports.engine.JasperFillManager; /** * @author admin * * TODO To change the template for this generated type comment go to * Window - Preferences - Java - Code Style - Code Templates */ public class summary { public static void main(String[] args) { Connection conn= null; Connection conn1= null; try{ String host1 = "192.168.0.11"; String user1 = "administrator"; String password1 = "password"; String db1 = "SITBASE"; try { Class.forName("com.ibm.db2.jcc.DB2Driver"); } catch(java.lang.ClassNotFoundException e) { System.err.print("ClassNotFoundException: "); System.err.println(e.getMessage()); } conn = DriverManager.getConnection("jdbc:db2://"+host+":50000/"+db , user,password); conn1 = DriverManager.getConnection("jdbc:db2://"+host1+":50000/"+db1 , user1,password1); Statement stmt = conn1.createStatement(); String sql = "select oir.product_category,oir.product_type_II, oir.actual_payment_date ,oir.order_number ,oir.record_number ,uoi.user_id from user_order_item uoi inner join order_item_ref oir on uoi.record_number = oir.record_number where oir.record_number = 100000057"; ResultSet result =stmt.executeQuery(sql); while (result.next()){ String SOYHU =result.getString(1) ; String SOYHU1 =result.getString(2) ; String SOYHU2 =result.getString(3) ; String SOYHU3 =result.getString(4) ; String SOYHU4 =result.getString(5) ; String SOYHU5 =result.getString(6) ; // i want to send "SOYHU","SOYHU1","SOYHU2", ... variable parameter to jrxml file how about the coding syntax . } System.out.println("Filling report..."); JasperFillManager.fillReportToFile("PC_Report_subreport1.jasper", new HashMap(), conn1); System.out.println("God bless you !"); }catch(Exception ex){ ex.printStackTrace(); } finally{ if (conn != null){ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } please advise me. Thank in advance.

How to coding to send the parameter into jrxml file ? This is my code (// i want to send "SOYHU","SOYHU1","SOYHU2", ... variable parameter to jrxml file how about the coding syntax . ) /* * Created on Nov 27, 2007 * * TODO To change the template for this generated file go to * Window - Preferences - Java - Code Style - Code Templates */ package net.ensode.jasperbook; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.HashMap; import java.util.Map; import net.sf.jasperreports.engine.JasperFillManager; /** * @author admin * * TODO To change the template for this generated type comment go to * Window - Preferences - Java - Code Style - Code Templates */ public class summary { public static void main(String[] args) { Connection conn= null; Connection conn1= null; try{ String host1 = "192.168.0.11"; String user1 = "administrator"; String password1 = "password"; String db1 = "SITBASE"; try { Class.forName("com.ibm.db2.jcc.DB2Driver"); } catch(java.lang.ClassNotFoundException e) { System.err.print("ClassNotFoundException: "); System.err.println(e.getMessage()); } conn = DriverManager.getConnection("jdbc:db2://"+host+":50000/"+db , user,password); conn1 = DriverManager.getConnection("jdbc:db2://"+host1+":50000/"+db1 , user1,password1); Statement stmt = conn1.createStatement(); String sql = "select oir.product_category,oir.product_type_II, oir.actual_payment_date ,oir.order_number ,oir.record_number ,uoi.user_id from user_order_item uoi inner join order_item_ref oir on uoi.record_number = oir.record_number where oir.record_number = 100000057"; ResultSet result =stmt.executeQuery(sql); while (result.next()){ String SOYHU =result.getString(1) ; String SOYHU1 =result.getString(2) ; String SOYHU2 =result.getString(3) ; String SOYHU3 =result.getString(4) ; String SOYHU4 =result.getString(5) ; String SOYHU5 =result.getString(6) ; // i want to send "SOYHU","SOYHU1","SOYHU2", ... variable parameter to jrxml file how about the coding syntax . } System.out.println("Filling report..."); JasperFillManager.fillReportToFile("PC_Report_subreport1.jasper", new HashMap(), conn1); System.out.println("God bless you !"); }catch(Exception ex){ ex.printStackTrace(); } finally{ if (conn != null){ try { conn.close(); } catch (SQLException e) { // TODO Auto-generated catch block e.printStackTrace(); } } } please advise me. Thank in advance.

I want to plotting a chart ( coordinate x and y ) by using a string as a parameter. this is my chart | | | | v v size=332]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/result1.JPG please advise me thank you very much. Post edited by: SOYHU, at: 2007/10/20 12:41

Can i develop the below chart by plot x and y axis as string(not number)values? size=245]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/chart-595d72bc06bc394a5224413853c6edcb.jpg i would like to display string(not number) value on y axis, i fetch string column from database for plotting the graph, while i was running the report the error message be generated as below: | v ------------------------------------------------- ÂCompiling to file... C:YHU2.jasperE-commerce_Reporttest_graph.jasper -> C:YHU2.jasperE-commerce_Reporttest_graph.java Errors compiling C:YHU2.jasperE-commerce_Reporttest_graph.jasper. net.sf.jasperreports.engine.JRException:ÂErrorsÂwereÂencounteredÂwhenÂcompilingÂreportÂexpressionsÂclassÂfile: 1.ÂsoyhucolumnÂcannotÂbeÂresolved ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.Comparable)(soyhucolumn); ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<-----------> 2.ÂCannotÂcastÂfromÂStringÂtoÂNumber ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.Number)(((java.lang.String)field_NAME.getValue())); ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<-----------------------------------------------------------> ------------------------------------------------- please advise me Thanks in advanced. Post edited by: SOYHU, at: 2007/10/19 03:15 Post edited by: SOYHU, at: 2007/10/19 07:48