PDA

View Full Version : Eclipse BIRT Reports



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

Thanks,
Poonam

Taqua
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

poonamm
03-13-2007, 12:57 AM
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

bamaer
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

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

add
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

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

add
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?

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

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

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