组合视图 统一视图 树状图
讨论主题 [ 上一个 | 下一个 ]
toggle
Tomek Lipski
Liferay Jasper integration - Aperte Reports
2011年11月30日 上午3:33
答复

Tomek Lipski

等级: Junior Member

帖子: 33

加入日期: 2010年11月17日

最近的帖子

Hi all,

As the tools supplied by JasperSoft or Liferay, although great in itself, haven't met our requirements, we have created an integration between Jasper Reports and Liferay ourselves. The application is named Aperte Reports, and is available under GNU LGPL from Google Code repository: http://code.google.com/p/aperte-reports.

Its main features are:
  • Report dashboarding - you can compose results from different reports as one Liferay page (or even mix it with other portlets!)
  • On demand reporting with report parameters - users can run reports with supplied parameters. Parameter values/controls can be heavily customized.
  • Cyclic/background reporting - for the reports that run too long to be rendered on-line
  • Report drilldown
  • Subreport support

The plugin can be downloaded from Community plugins repository:

http://www.liferay.com/downloads/liferay-portal/community-plugins/-/software_catalog/products/11133217

and there is also a small on-line demo, available at:

https://demo.aperteworkflow.org/aperte-reports

You can also review my presentation given during Lightining Talks at Liferay Europe Symposium 2011: http://www.slideshare.net/tomeklipski/liferay-european-symposium-2011-lightning-talk-liferay-reporting-dashboarding

Please let me know if you have suggestions or feedbacks - it will be greatly appreciated.
Cyprian Gajda
RE: Liferay Jasper integration - Aperte Reports
2012年1月30日 上午4:44
答复

Cyprian Gajda

等级: New Member

帖子: 9

加入日期: 2011年1月21日

最近的帖子

Aperte Reports v2.2.2 has been released on Jan 23rd 2012. Version 2 of Aperte Reports brings many fixes and improvements, including:
  • reworked user interface
  • reworked user interface
  • better error reporting and handling
  • support for Apache Tomcat and JBoss AS
  • support for common RDBMS: MySQL, PostgreSQL, Oracle, Hypersonic
For more information, you can review release notes or go straight to the download page.
Joe Chang
RE: Liferay Jasper integration - Aperte Reports
2012年2月24日 上午4:09
答复

Joe Chang

等级: New Member

帖子: 11

加入日期: 2011年8月14日

最近的帖子

HI Cyprian,

When I try to install it, it shows the below error.

11:59:38,015 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1173)
at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:993)
at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:4350)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4659)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:791)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:771)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:546)
at org.apache.catalina.startup.HostConfig.deployDescriptor(HostConfig.java:637)
at org.apache.catalina.startup.HostConfig.deployDescriptors(HostConfig.java:563)
at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:498)
at org.apache.catalina.startup.HostConfig.check(HostConfig.java:1345)
at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:303)
at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:119)
at org.apache.catalina.core.ContainerBase.backgroundProcess(ContainerBase.java:1337)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1601)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.processChildren(ContainerBase.java:1610)
at org.apache.catalina.core.ContainerBase$ContainerBackgroundProcessor.run(ContainerBase.java:1590)
at java.lang.Thread.run(Thread.java:619)
Caused by: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.processException(BasePersistenceImpl.java:195)
at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findAll(ResourceActionPersistenceImpl.java:1043)
at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findAll(ResourceActionPersistenceImpl.java:962)
at com.liferay.portal.service.impl.ResourceActionLocalServiceImpl.checkResourceActions(ResourceActionLocalServiceImpl.java:47)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:309)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
at com.liferay.portal.dao.jdbc.aop.DynamicDataSourceTransactionInterceptor.invoke(DynamicDataSourceTransactionInterceptor.java:44)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at com.liferay.portal.spring.aop.ChainableMethodAdvice.invoke(ChainableMethodAdvice.java:58)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:89)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:202)
at $Proxy67.checkResourceActions(Unknown Source)
at com.liferay.portal.service.ResourceActionLocalServiceUtil.checkResourceActions(ResourceActionLocalServiceUtil.java:230)
at com.liferay.portal.tools.DBUpgrader.upgrade(DBUpgrader.java:112)
at com.liferay.portal.events.StartupAction.doRun(StartupAction.java:117)
at com.liferay.portal.events.StartupAction.run(StartupAction.java:47)
... 21 more
Caused by: java.lang.NullPointerException
at org.hibernate.cache.impl.bridge.RegionFactoryCacheProviderBridge.nextTimestamp(RegionFactoryCacheProviderBridge.java:93)
at org.hibernate.impl.SessionFactoryImpl.openSession(SessionFactoryImpl.java:650)
at org.hibernate.impl.SessionFactoryImpl.openSession(SessionFactoryImpl.java:659)
at org.springframework.orm.hibernate3.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:318)
at org.springframework.orm.hibernate3.SessionFactoryUtils.doGetSession(SessionFactoryUtils.java:256)
at org.springframework.orm.hibernate3.SpringSessionContext.currentSession(SpringSessionContext.java:60)
at org.hibernate.impl.SessionFactoryImpl.getCurrentSession(SessionFactoryImpl.java:698)
at com.liferay.portal.dao.orm.hibernate.SessionFactoryImpl.openSession(SessionFactoryImpl.java:59)
at com.liferay.portal.service.persistence.impl.BasePersistenceImpl.openSession(BasePersistenceImpl.java:183)
at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findAll(ResourceActionPersistenceImpl.java:1027)
... 44 more
Tomek Lipski
RE: Liferay Jasper integration - Aperte Reports
2012年2月24日 上午4:39
答复

Tomek Lipski

等级: Junior Member

帖子: 33

加入日期: 2010年11月17日

最近的帖子

Joe Chang:
HI Cyprian,

When I try to install it, it shows the below error.

11:59:38,015 ERROR [MainServlet:202] com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
com.liferay.portal.kernel.events.ActionException: com.liferay.portal.kernel.exception.SystemException: java.lang.NullPointerException
at com.liferay.portal.events.StartupAction.run(StartupAction.java:53)
at com.liferay.portal.servlet.MainServlet.processStartupEvents(MainServlet.java:1166)
at com.liferay.portal.servlet.MainServlet.init(MainServlet.java:199)
at javax.servlet.GenericServlet.init(GenericServlet.java:212)
at com.liferay.portal.service.persistence.ResourceActionPersistenceImpl.findAll(ResourceActionPersistenceImpl.java:1027)
... 44 more


Hi,

It would be difficult to diagnose that error without full logs, but it seems like you have misconfigured Aperte Reports datasource (which should be bound to JNDI name jdbc/aperte-reports ).
Please review the Installation Guide for Aperte Reports to see if everything is configured properly.

You can also download Aperte Reports bundled and preconfigured with Liferay CE and app server from SourceForge repository: http://sourceforge.net/projects/aperte-reports/files/bundles/.

Oh, and we have issue tracker for Aperte Reports at google code. Feel free to post issues there: http://code.google.com/p/aperte-reports/issues/list

Best regards,

Tomek Lipski
Cyprian Gajda
RE: Liferay Jasper integration - Aperte Reports
2012年4月4日 上午5:41
答复

Cyprian Gajda

等级: New Member

帖子: 9

加入日期: 2011年1月21日

最近的帖子

Aperte Reports 2.3-RC1 is available now!

Most important highlights and improvements are:
  • support for external JMS provider, e.g. Active MQ
  • fixes in background and cyclic reporting
  • dependency cleanup
  • default JNDI names configuration
  • logging cleanup
  • updated Jasper Reports dependency to the newest (4.5.1) version (resolves number format issues)
  • fixed display problems on LR 6.0EE and LR 6.1CE - application uses current Liferay theme.
For more information, you can review release notes or go straight to the download page.

Also check out a sample of Apert Reports on the demo site http://demo.aperteworkflow.org/aperte-reports
Satish Avhad
RE: Liferay Jasper integration - Aperte Reports
2014年6月18日 上午6:02
答复

Satish Avhad

等级: New Member

帖子: 4

加入日期: 2011年3月29日

最近的帖子

Hi,

Is there a plan to release Aperte Reports for Liferay CE 6.2? When is it expected to be available?

regards,
Satish