srikanth1229

Hi Is it possible to integrate the fusion charts in IReport ?? i have one requirement that i need to use the fusion charts in IReport. please let me know if any possibility ??? Thanks in advance...

Please help me to solve this issue...

Hi CaptnTony Thanks for replying. we tried the same , but the data is populating for first sub report only. For example: if i have 3 children. the subreport with data is generating for only one child. please do the needful. Thanks in advance.

Hi Friends, We are currently Jasper IReports 3.5.1 version,we have a requirement to generate Sub Reports that are dynamic in nature,ie for example in a Financial planing report ,the education planning subreport is dependend on the number of children,this section should be repeated for each child. Could anyone please let us know how this could be achieved using Jasper. Highly appreciate your quick response! Thanks very much in Advance! Please find the attached doc for your reference.

could some one please look into the above query ... Thanks in advance.

HI Friends, Is it possible to generate password protected PDF using IReport 3.X versions? If yes, please tell me how it is achievable? Thanks in advance.. :-)

I Got it Guilio. Thanks a lot for your support.

HI Giulio Thanks for replying. Could you please tell me how to add the foreground to the condition.

i am using IReport 3.5.1

Hi, We have a requirement to develop interactive PDF's,we are currently using Jasper IReport 3.5.1,could let us know if the same can achieved using Jasper. Can we use ITEXT 5.0 with the above version of IReport,if yes please let us know how this can be achieved. Appreciate your quick response! Thanks in Advance!!!

please help me to resolve this issue... Thanks in advance.

HI When i am trying to run the job in JAsper ETL, i am getting this error. Could anyone please help me to resolve this issue. My job name is FundMigration1. Error:: ---------- Starting job Fundmigration1 at 20:59 17/12/2009. Exception in thread "main" java.lang.Error: Unresolved compilation problem: at fund_migration.fundmigration1.Fundmigration1.main(Fundmigration1.java:1787) Job Fundmigration1 ended at 20:59 17/12/2009. [exit code=1] Help would be highly appreciated.

Nice one... :-)

Please some one help me to fill the color dynamically

Hi While i am loading the report through java.. i am getting the below error. JaspserSampleReport! before jasper>>>>>>>>>>>>>>>>>> connection>>>>>>>>>>oracle.jdbc.driver.OracleConnection@12f6684 before jasper Design>>>>>>>>>>>>>>>> Main Exception 1111111----->net.sf.jasperreports.engine.JRException: org.xml.sax.SAXException: http://java.sun.com/xml/jaxp/properties/schemaSource net.sf.jasperreports.engine.JRException: org.xml.sax.SAXException: http://java.sun.com/xml/jaxp/properties/schemaSource at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:243) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:226) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:214) at net.sf.jasperreports.engine.JasperManager.loadXmlDesign(JasperManager.java:980) at com.polaris.intellect.reports.sampleReport.main(sampleReport.java:56) Caused by: org.xml.sax.SAXException: http://java.sun.com/xml/jaxp/properties/schemaSource at weblogic.apache.xerces.parsers.AbstractSAXParser.parse(AbstractSAXParser.java:1203) at weblogic.xml.jaxp.WebLogicXMLReader.parse(WebLogicXMLReader.java:135) at weblogic.xml.jaxp.RegistryXMLReader.parse(RegistryXMLReader.java:152) at org.apache.commons.digester.Digester.parse(Digester.java:1647) at net.sf.jasperreports.engine.xml.JRXmlLoader.loadXML(JRXmlLoader.java:239) please find the below code for ur reference. please help me to resolve this issue. Thanks in advance. Regards Srikanth Code:package com.sample.intelligent.reports;import java.sql.Connection;import java.sql.DriverManager;import java.util.HashMap;import java.util.Map;import java.io.FileInputStream;import net.sf.jasperreports.engine.JasperFillManager;import net.sf.jasperreports.engine.JasperManager;import net.sf.jasperreports.engine.JasperPrint;import net.sf.jasperreports.engine.JasperPrintManager;import net.sf.jasperreports.engine.JasperReport;import net.sf.jasperreports.engine.design.JasperDesign;import net.sf.jasperreports.engine.util.JRLoader;import net.sf.jasperreports.view.JasperViewer;import org.xml.sax.SAXParseException;public class sampleReport {static Connection conn=null; public static void getConnection(){ try { String driver="oracle.jdbc.driver.OracleDriver"; Class.forName(driver); String url="jdbc:oracle:thin:@172.16.2.89:1521:INTELINV"; String user="WKSAMPIUT"; String password="WKSAMPIUT"; conn =DriverManager.getConnection(url, user, password); System.out.println("connection>>>>>>>>>>"+conn); } catch (ClassNotFoundException ex1) { System.out.println("ClassNotFoundException != null-->"+ex1); } catch (Exception ex) { System.out.println("Exception != null-->"+ex); } } public static void main(String[] args) { System.out.println("JapserSampleReport!"); // First, load JasperDesign from XML and compile it into JasperReport try{ System.out.println("before jasper>>>>>>>>>>>>>>>>>>"); getConnection(); Map parameters = new HashMap(); System.out.println("before jasper Design>>>>>>>>>>>>>>>>"); FileInputStream inp = new FileInputStream("D:/AMERIPRISE_REPORTS/report4.xml") ; //JasperDesign jasperDesign = JasperManager.loadXmlDesign("D:/AMERIPRISE_REPORTS/report4.xml"); JasperDesign jasperDesign = JasperManager.loadXmlDesign(inp); System.out.println("after loading>>>>>>>>>>>>>>>"); JasperReport jasperReport = JasperManager.compileReport(jasperDesign); JasperPrint jasperPrint = JasperManager.fillReport(jasperReport, parameters, conn); JasperManager.printReportToPdfFile(jasperPrint, "D:/AMERIPRISE_REPORTS/report4.pdf"); JasperViewer.viewReport(jasperPrint); System.out.println("before loading>>>>>>>>>>>"); /*JasperReport jasperReport = (JasperReport)JRLoader.loadObject("D:/AMERIPRISE_REPORTS/report4.jasper"); System.out.println("After loading>>>>>>>>"); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport,parameters,conn); JasperPrintManager.printReportToPdfFile(jasperPrint,"D:/AMERIPRISE_REPORTS/report4.pdf");*/ //JasperViewer.viewReport(jasperPrint); } catch(Exception exp){ System.out.println("Main Exception 1111111----->"+exp); exp.printStackTrace(); } }}

please some one help me out.

Hi Actually, we are using the JRBeanset datasource as a connection to ireport. while connecting , it is asking for one static method. but we have multiple subreports and multiple methods in JAVA DAO. so we are not able to give the multiple methods while connecting the ireport. For example, we have two static methods familydetails and personaldetails. while connecting the JRBeanDatasource to Ireport we are giving the familydatails method as input. we need to use the personal details method also. How to use all the methods in ireport and how we need to take the connection from JRBeansetDataSource? Request your suggestions in this Regard. Help would be appreciated. Thanks in Advance.

Hi when i am trying to call the subreport from title. it's getting this error. please help me.... Error filling print... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : new java.lang.Integer(1) net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : new java.lang.Integer(1) at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:667) at net.sf.jasperreports.engine.fill.JRFillElementContainer.prepareElements(JRFillElementContainer.java:346) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:346) at net.sf.jasperreports.engine.fill.JRFillBand.fill(JRFillBand.java:305) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillTitle(JRVerticalFiller.java:313) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReportStart(JRVerticalFiller.java:247) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:113) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:899) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:802) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:251) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:896) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Caused by: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : Source text : new java.lang.Integer(1) at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:257) at net.sf.jasperreports.engine.fill.JRCalculator.evaluateEstimated(JRCalculator.java:565) at net.sf.jasperreports.engine.fill.JRCalculator.estimateVariables(JRCalculator.java:169) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:788) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1413) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:111) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:899) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:802) at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:564) at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63) at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209) at java.lang.Thread.run(Thread.java:595) Caused by: java.lang.RuntimeException: No Context associated with current Thread at org.mozilla.javascript.Context.getContext(Context.java:2206) at org.mozilla.javascript.SecurityController.createLoader(SecurityController.java:136) at org.mozilla.javascript.optimizer.Codegen.defineClass(Codegen.java:143) at org.mozilla.javascript.optimizer.Codegen.createScriptObject(Codegen.java:102) at org.mozilla.javascript.Context.compileImpl(Context.java:2293) at org.mozilla.javascript.Context.compileString(Context.java:1240) at org.mozilla.javascript.Context.compileString(Context.java:1229) at net.sf.jasperreports.compilers.JavaScriptEvaluator.getCompiledExpression(JavaScriptEvaluator.java:319) at net.sf.jasperreports.compilers.JavaScriptEvaluator.evaluateExpression(JavaScriptEvaluator.java:298) at net.sf.jasperreports.compilers.JavaScriptEvaluator.evaluateEstimated(JavaScriptEvaluator.java:280) at net.sf.jasperreports.engine.fill.JREvaluator.evaluateEstimated(JREvaluator.java:246) ... 11 more Print not filled. Try to use an EmptyDataSource...

Hi i want to generate the below table in subreport. I am facing two problems while generating this report. 1) Based on the condition in the percent coverage column, the colored circle should be put in the status column. for Eg: if percent coverage is positive or 100%, green clored circle should genaerate if percent coverage is negative or equal to 75% yellow colored circle dhould generate if percent coverage is less than 40% , red colored circle should generate. 2) In Goal description, every statement is dyanmic. based on values it should generate. it's not possible for me to get the dynamic date from sql query. can i use the java method call for each column ? please suggest me the best possible way. this is ver much required for me. if any one know how to approach, please provide your details . i will get back to you. my mail id is ksrikanthnaidu@gmail.com Please help me. Goal Goal Description Percent Coverage Status Net worth Your current net worth is Rs. 45 lakhs. Positive Green color circle Cash Flow Your current income exceeds your expenses by Rs 45670 per month. Positive Green color circle Cash Reserve You have set aside Rs85000 as cash reserves to meet your cash reserve goal of Rs 67000 100% Green color circle Retirement You and your spouse aim to retire at the ages 65 and 63 respectively and will like to maintain the existing standard of living. 75% Yellow color circle Education Planning: Z You will like to have Rs 8,00,000 in today’s value for Z’s higher education annually for 4 years from 2015 to 2018. 35% Red color circle Life Insurance: X Mr. X would like to maintain the same standard of living for his family in the event of his premature death. 65% Yellow color circle Life Insurance: Y Ms. X would like to maintain the same standard of living for her family in the event of her premature death. 40% Red color circle

Hi matt Thanks for Replying.. :-) Actually, I want to draw the bargraph. for that, category expression is required. Suppose In the table i have the data like this Assets Liabilites Networth 5000 3000 2000 I want to pass the category expression as Assets , Liabilites,Networth. but these are column names. Please find the attached image for clear description.

please help me to acheive this....

Hi I want to display the below data in one report. with out using sub reports. is this possible?? Please help me. Personal Details Your Personal Information Name Date of Birth Age Citizenship Mr. X April 21, 1966 42 UK Ms .Y February 10, 1968 40 UK Family Members Name Date of Birth Age Citizenship Y November 21, 1996 12 Uk Your Address J-120/154, Enclave, US - 110023 Employment Details Mr. X Sr. Manager, UK. Ms. Y Lawyer, UK

hi How to add objects to java.util.list in IREPORT. I want to add the "ASSETS","LIABILITIES","NETWORTH" (these are strings) to util list. i want to pass the util list to barchart as category expression. please help me.. thanks in advance....:-)

hi Is that possible to acheive the table of contents with page numbers for the attached report decument. Please help me to acheive the table of contents with page numbers.

Hello... Please some one help me out to generate attached report. Please tell me the complex areas in that report.?