Hitachi Vantara Pentaho Community Forums
Results 1 to 11 of 11

Thread: Eclipse BIRT Reports

  1. #1

    Default Eclipse BIRT Reports

    Hi,
    In which tool (report designer) i can design Eclipse BIRT Reports.

    Thanks,
    Poonam

  2. #2
    Join Date
    Mar 2003
    Posts
    8,085

    Default

    The BIRT Project provides its own report designer.
    Head over to http://download.eclipse.org/birt/downloads/ to grab it.

    Have fun,
    said Thomas

  3. #3

    Post

    Hi,
    I download birt-report-designer-all-in-one-2.1.2 from the site provided by you. But I am facing problems in integrating the report in Pentaho. As by using the above tool you can not publish the report in Pentaho directly. It gives you only .rptdesign only. Action Sequence (.xaction) file you have to write by your own. Again Pentaho used BIRT 1.0.0 version and by using above tool i am able to create BIRT 2.1.2 version. So in this i am getting this errors. Can you provide any solution for my this problem.



    10:26:04,705 ERROR [BIRTReportComponent] Error Start: Pentaho 1.0.0.0 build 156
    10:26:04,705 ERROR [BIRTReportComponent] 24aa670d-d11f-11db-94cc-975e2828f88a:CO
    MPONENT:context-7696990-1173761762721:birt-text-param.xaction BIRT.ERROR_0007 -
    error running report D:\Pentaho\pentaho-demo-BIRT\pentaho-solutions\samples\repo
    rting\birt-text-param.rptdesign
    org.eclipse.birt.report.engine.api.EngineException: The design file D:\Pentaho\p
    entaho-demo-BIRT\pentaho-solutions\samples\reporting\birt-text-param.rptdesign h
    as error and can not be run.
    at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReport
    Design(ReportEngineHelper.java:92)
    at org.eclipse.birt.report.engine.api.ReportEngine.openReportDesign(Repo
    rtEngine.java:216)
    at org.pentaho.birt.BIRTReportComponent.executeAction(Unknown Source)
    at org.pentaho.component.ComponentBase.execute(Unknown Source)
    at org.pentaho.runtime.RuntimeContext.executeComponent(Unknown Source)
    at org.pentaho.runtime.RuntimeContext.executeAction(Unknown Source)
    at org.pentaho.runtime.RuntimeContext.executeLoop(Unknown Source)
    at org.pentaho.runtime.RuntimeContext.executeSequence(Unknown Source)
    at org.pentaho.runtime.RuntimeContext.executeSequence(Unknown Source)
    at org.pentaho.solution.SolutionEngine.execute(Unknown Source)
    at org.pentaho.services.BaseRequestHandler.handleActionRequest(Unknown S
    ource)
    at org.pentaho.ui.servlet.ViewAction.doGet(Unknown Source)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:697)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:810)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:252)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Unknown Sourc
    e)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
    icationFilterChain.java:202)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
    ilterChain.java:173)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
    alve.java:213)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
    alve.java:178)
    at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Unknown Sou
    rce)
    at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Unknown
    Source)
    at org.jboss.web.tomcat.security.JaccContextValve.invoke(Unknown Source)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
    ava:126)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
    ava:105)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
    ve.java:107)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
    a:148)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
    :856)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
    ssConnection(Http11Protocol.java:744)
    at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
    int.java:527)
    at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
    kerThread.java:112)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: Error.DesignFileException.INVALID_XML - 1 errors found!
    1.) ( line = 0, tag = null) org.eclipse.birt.report.model.parser.DesignParserE
    xception (code = Error.DesignParserException.UNSUPPORTED_VERSION, message : The
    report file of version "3.2.6" is not supported.)
    at org.eclipse.birt.report.model.parser.DesignReader.read(DesignReader.j
    ava:101)
    at org.eclipse.birt.report.model.parser.DesignReader.read(DesignReader.j
    ava:153)
    at org.eclipse.birt.report.model.core.DesignSession.openDesign(DesignSes
    sion.java:157)
    at org.eclipse.birt.report.model.api.SessionHandle.openDesign(SessionHan
    dle.java:90)
    at org.eclipse.birt.report.engine.parser.ReportParser.parse(ReportParser
    .java:83)
    at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReport
    Design(ReportEngineHelper.java:87)
    ... 32 more
    10:26:04,705 ERROR [BIRTReportComponent] Error end:
    10:26:04,705 ERROR [RuntimeContext] 24aa670d-d11f-11db-94cc-975e2828f88a:RUNTIME
    :context-7696990-1173761762721:birt-text-param.xaction RuntimeContext.ERROR_0012
    - ActionDefinition for org.pentaho.birt.BIRTReportComponent did not execute suc
    cessfully
    10:26:04,705 ERROR [SolutionEngine] 24aa670d-d11f-11db-94cc-975e2828f88a:SOLUTIO
    N-ENGINE: birt-text-param.xactionSolutionEngine.ERROR_0007 - Action sequence exe
    cution failed

  4. #4

    Default

    You have to update the libraries to use BIRT 2.x

    have a look at this thread: http://forums.pentaho.org/showthread.php?t=50290

  5. #5

    Default

    Hello Bamaer,

    I did the same with BIRT 2.1.1 but I'm experiencing problems with background execution and subscriptions.

    I have some reports with tables and charts; tables content data in strings format, or number (decimal and percent) format.

    When I exceute the action directly (in the solution browser), the report renders properly

    When I run the report in background or in a scheduled job (using scheduler and/or subscriptions), charts render well but in the tables only data in string format are displayed !!!

    I've done a test by changing the formula in the data field : for example, I put Total.sum(..) + " " instead of Total.sum(...) .... in this case, the field is displayed ... it confirms that only text field can be displayed ...

    Had you faced this problem ? can you help me please ?

    Thanks in advance ....

  6. #6
    Join Date
    Oct 2008
    Posts
    5

    Unhappy Help

    has anyone found the solution to this?? This is the only problem still keeping me from having really nice subscription capabilities

  7. #7
    Join Date
    Mar 2008
    Posts
    15

    Default

    You can use Europa version (3.3.x), not the later versions (Ganymede, 3.4.x), and get BIRT stuff via eclipse's update manager. That way, you can build reports using BIRT version, 2.2.1, which is what Pentaho currently supports out of the box.

  8. #8
    Join Date
    Oct 2008
    Posts
    5

    Question

    Quote Originally Posted by jashaffner View Post
    You can use Europa version (3.3.x), not the later versions (Ganymede, 3.4.x), and get BIRT stuff via eclipse's update manager. That way, you can build reports using BIRT version, 2.2.1, which is what Pentaho currently supports out of the box.
    and this fixes the number formatting issue when running reports in the background?

  9. #9
    Join Date
    Mar 2008
    Posts
    15

    Default

    I dont see any formatting issue with my reports. What do you mean about running reports in the background? How do you run them in background and for what purpose?

    I am kinda new to Pentaho. Thanks.

  10. #10
    Join Date
    Oct 2008
    Posts
    5

    Lightbulb

    Pentaho allows you to run reports in the background, which saves the result in your workspace. if you have a report that takes a long time to run, this option could be useful because it allows the user to log out while the report is running and it will still finish and be available the next time the user logs in. Subscriptions allow the Pentaho Admin(s) to create subscription schedules for reports that other users can then subscribe to. Then the report will be run at the scheduled time and be available in the user's workspace. This is useful for making sure data-intensive reports are run at non-peak times, the report is run consistently at the same time every hour/day/month/etc. Now, for whatever rease, when running BIRT reports in either of the above two ways, any field formatted as a number doesn't render and generates a NullPointerException in the runlog.

  11. #11
    Join Date
    Dec 2007
    Posts
    5

    Default

    I was having the same problem when running reports in the background (no numbers output). I tracked the problem down to a problem in the org.eclipse.birt.core.format NumberFormatter. The problem is that the locale is null when running in the background and therefore I got a NullPointerException when attempting to get an instance of NumberFormat (and when attempting to use it).

    I modified the NumberFormatter class and just used the default locale when getting an instance of NumberFormat.

    I changed this:
    Code:
    numberFormat = NumberFormat.getInstance( locale.toLocale() );
    to this:
    Code:
    numberFormat = NumberFormat.getInstance();
    I then built the plugin jar and installed it in ../jboss/server/default/deploy/pentaho.war/WEB-INF/lib as coreapi.jar. I also installed it in ../pentaho-solutions/system/BIRT/plugins (and removed old birt core plugin).

    Possibly a better solution would be to track down why the locale is not instantiated when running in the background or with the scheduler.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.