View Full Version : Eclipse BIRT Reports

03-09-2007, 05:26 AM
In which tool (report designer) i can design Eclipse BIRT Reports.


03-12-2007, 01:25 PM
The BIRT Project provides its own report designer.
Head over to http://download.eclipse.org/birt/downloads/ to grab it.

Have fun,
said Thomas

03-13-2007, 12:57 AM
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 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
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
at org.eclipse.birt.report.engine.api.ReportEngine.openReportDesign(Repo
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
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
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(Unknown Sourc
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(Unknown Sou
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Unknown
at org.jboss.web.tomcat.security.JaccContextValve.invoke(Unknown Source)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
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
at org.eclipse.birt.report.model.parser.DesignReader.read(DesignReader.j
at org.eclipse.birt.report.model.core.DesignSession.openDesign(DesignSes
at org.eclipse.birt.report.model.api.SessionHandle.openDesign(SessionHan
at org.eclipse.birt.report.engine.parser.ReportParser.parse(ReportParser
at org.eclipse.birt.report.engine.api.impl.ReportEngineHelper.openReport
... 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
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

03-13-2007, 07:29 AM
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

03-23-2007, 07:09 AM
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 ....

10-28-2008, 12:47 PM
has anyone found the solution to this?? This is the only problem still keeping me from having really nice subscription capabilities

10-29-2008, 02:11 PM
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.

10-29-2008, 02:14 PM
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?

10-29-2008, 04:55 PM
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-30-2008, 08:24 AM
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.

12-05-2008, 05:16 PM
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:

numberFormat = NumberFormat.getInstance( locale.toLocale() );to this:

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.