Jump to content
We've recently updated our Privacy Statement, available here ×

srikanth1229

Members
  • Posts

    30
  • Joined

  • Last visited

 Content Type 

Profiles

Forum

Events

Featured Visualizations

Knowledge Base

Documentation (PDF Downloads)

Blog

Documentation (Test Area)

Documentation

Dr. Jaspersoft Webinar Series

Downloads

Posts posted by srikanth1229

  1. 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.

     

     

  2. 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!!!

     

     

     

  3.  

    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.

  4. 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();  } }}
  5. 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.

     

     

     

  6. 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...

  7.  

    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



     

     

     

  8. 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.

     

     

     

  9. 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


     


     

     

×
×
  • Create New...