prashant2228

Is there a way to hide rows with NULL (or 0) in measure column in drill-through reports? This is because we want to make the number of displayed rows in the drill-through report same as the measure "value".

Does jasperserver uses simple browser based (client side) cache or the pages are cached on server as well? Can we increase the cache retention time (longer expiration time) by specifying some parameters.

Is it possible to take the advantage of Oracle parallel processing in Jasper Analysis views. This usually needs application of optimizer hints to generated SQL. Can we specify somewhere in Jasper that the SQL should be generated with parallel hints. In other words, can we alter/tweak the SQL that is generated from MDX ?

Any suggestions ? Has anyone been able to make analysis views work on IBM WAS ( websphere )6.1.0.25 ?

Has anyone been able to implement drill through on Charts-pro charts ?

I'm unable to specify settings for sectional drill down on Charts Pro (flash) charts. In normal charts, <sectionHyperlink> and <itemHyperlink> can be used to drill through the individual pie slice and bar respectively. But this doesn't seem to apply for Charts-Pro charts. Please enlighten me on implementing drill down in Charts-Pro charts.

I've installed JasperServer 3.7 WAR file on IBM WAS and followed all the documented instructions. While running the JasperAnalysis views the following error is met. The normal jrxml jasperreports continue to work fine though. java.lang.NoClassDefFoundError: com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel (initialization failure) Code:java.lang.NoClassDefFoundError: com.tonbeller.jpivot.mondrian.MondrianDrillThroughTableModel (initialization failure) at java.lang.J9VMInternals.initialize(J9VMInternals.java:134) at com.jaspersoft.jasperserver.war.control.OlapModelController.viewOlap(OlapModelController.java:250) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:618) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:473) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:410) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java:743) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1146) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1087) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:145) at com.tonbeller.wcf.controller.RequestFilter$MyHandler.normalRequest(RequestFilter.java:141) at com.tonbeller.wcf.controller.RequestSynchronizer.handleRequest(RequestSynchronizer.java:127) at com.tonbeller.wcf.controller.RequestFilter.doFilter(RequestFilter.java:281) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:378) at com.jaspersoft.jasperserver.war.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:146) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:109) at org.springframework.security.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.ExceptionTranslationFilter.doFilterHttp(ExceptionTranslationFilter.java:101) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:92) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.providers.anonymous.AnonymousProcessingFilter.doFilterHttp(AnonymousProcessingFilter.java:105) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:176) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:277) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:175) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.context.HttpSessionContextIntegrationFilter.doFilterHttp(HttpSessionContextIntegrationFilter.java:235) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:390) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:175) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:190) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:130) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:87) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:837) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:680) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:588) at com.ibm.ws.wswebcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:481) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:90) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:748) at com.ibm.ws.wswebcontainer.WebContainer.handleRequest(WebContainer.java:1466) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:122) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:458) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:387) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:102) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:165) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:136) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:196) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:751) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:881) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1497)

Thanks Sheman, that really helped. I modified the jsp to suit us. Note to self: Whenever encountring a <js:xxx> tag, check jasperserver.tld to find the custom tag and then dig into the mapped java class to find what the tag means.

In a JasperReport when "Report Options" icon (in the leftmost corner) is clicked, it shows a parameter form with a vertical list of paramters and their values. The following code snippet in "ViewReportControlsDialog.jsp" is responsible for this. <js:parametersForm reportName="${requestScope.reportUnit}" renderJsp="${requestScope.controlsDisplayForm}" onInputChange="resetReportOptionsSelect()"/> I want to change the appearance of this parameter list. Instead of vertical, need to make it horizonatal list. Is it easily possible ?

It imported super fine into Jasper 3.7 professional edition. Earlier, I was trying to import in Jasper CE 3.7, but it was failing because of differences between the two editions(e.g. dashboards were not getting imported and causing the whole process to fail). Futher, the professional edition was even able to import 3.1 export, without any extra work, error or warning. Unbelievable ! Thanks Tony for your valuable inputs. I agree that the import-export functionality through front end UI will be more convenient and would eliminate the need to log in to the server machine everytime for this action. Will log an enhancement request.

Thanks for pointing to he documentation. I'm sorry that I didn't checked it earlier. Was able to import from 3.1 to 3.5 as instructed in the document. Now I'm trying to import 3.5 export into 3.7. But, stuck with the following error which comes whenever an jasperAnalysis view xml file is encountered in the import . 09:03:37,733 ERROR CastorSerializer:116 - org.exolab.castor.xml.MarshalException : The class for the root element 'semanticLayerDataSource' could not be found.{F ile: [not available]; line: 2; column: 26} 09:03:37,760 ERROR BaseExportImportCommand:45 - com.jaspersoft.jasperserver.api. JSExceptionWrapper: The class for the root element 'semanticLayerDataSource' cou ld not be found. Appreciate your help on this !

Thanks for the very informative reply ! I was able to export 3.1 repo, import into 3.5 and export again from 3.5. This export from 3.5 is what I'm trying to import in 3.7 now. But, stuck with the following error which comes whenever an jasperAnalysis view xml file is encountered in the import . 09:03:37,733 ERROR CastorSerializer:116 - org.exolab.castor.xml.MarshalException : The class for the root element 'semanticLayerDataSource' could not be found.{F ile: [not available]; line: 2; column: 26} 09:03:37,760 ERROR BaseExportImportCommand:45 - com.jaspersoft.jasperserver.api. JSExceptionWrapper: The class for the root element 'semanticLayerDataSource' cou ld not be found. Appreciate your help on this !

We are facing the exact same issue. While following the route 3.1>3.5>3.7. The 3.1 export is not getting imported into 3.5, just the folder structure is created and none of the Analysis views, connections, schemas and datasources are imported. Will reply if I found anything.

I created 3.5 repo, to facilitate the import from 3.1 to 3.7. But the 3.1 export files(Analysis views, connections, schemas, datasources) are not getting imported into 3.5. The js-import process finishes without any error. But none of the Analysis Components are imported, though static jrxml reports are. I have a hunch that this has something to do with Organisations in 3.5. Pls let me know if any ideas/workarounds that might work. Thanks Post Edited by prashant2228 at 02/16/2010 04:47

I'm using iReport 3.6. It came as bundled with JasperServer 3.7. I want to use iReport to develop the flash reports based on OFC (similar to the sample included in 3.7 release). Can anyone help how to get started. The library "jasperreports-ofc-3.6.2-20091111.130517-2.jar" is already included with 3.7 release, but I'm not sure how to use this in iReport.