abinabraham

Thank you for your reply. We didnt get any errors while doing the import.But only the folders were created.None of the views,connections are available.All the types were selected. Thanks joe

Hi all, We are facing an issue while importing from 3.1 to 3.5 and even to 3.7.While importing only folders and jrxml files are getting imported.The xml files are not been imported and displays as it already exists. Can anyone please help on this issue Thanks and regards joe

Hi all, We are facing an issue while importing from 3.1 to 3.5 and even to 3.7.While importing only folders and jrxml files are getting imported.The xml files are not been imported and displays as it already exists. Can anyone please help on this issue Thanks and regards joe

Hi all, Do jasper analysis support multiple languages.For example can the caption of a Dimension or Measures can be displayed in a French along with english.(English/French) Thanks in advance joe

Hi all, We are facing an issue while importing from 3.1 to 3.5 and even to 3.7.While importing only folders and jrxml files are getting imported.The xml files are not been imported and displays as it already exists. Can anyone please help on this issue Thanks and regards joe

Hi all, Any difference in the process of import in 3.7? Thanks and regards joe Post Edited by joe77 at 02/15/2010 09:08

Do anybody have an idea abt this?please provide your inputs.

Hi all, Do jasper analysis support multiple languages.For example can the caption of a Dimension or Measures can be displayed in a local language along with english.(English/"Local language") Thanks in advance joe

i am using jasperserver-pro-3.1. The eror trace is given below. Error Trace: java.io.NotSerializableException: com.tonbeller.jpivot.table.span.PropertySpanBuilder$BookmarkStatejava.io.NotSerializableException: com.tonbeller.jpivot.table.span.PropertySpanBuilder$BookmarkState at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1081) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at java.util.HashMap.writeObject(HashMap.java:1039) at sun.reflect.GeneratedMethodAccessor2400.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at java.util.HashMap.writeObject(HashMap.java:1039) at sun.reflect.GeneratedMethodAccessor2400.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1375) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1347) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1375) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1347) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at java.util.HashMap.writeObject(HashMap.java:1039) at sun.reflect.GeneratedMethodAccessor2400.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.defaultWriteFields(ObjectOutputStream.java:1375) at java.io.ObjectOutputStream.defaultWriteObject(ObjectOutputStream.java:391) at org.springframework.webflow.core.collection.LocalAttributeMap.writeObject(LocalAttributeMap.java:307) at sun.reflect.GeneratedMethodAccessor2399.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at org.springframework.webflow.engine.impl.FlowSessionImpl.writeExternal(FlowSessionImpl.java:159) at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1310) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1288) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at java.util.LinkedList.writeObject(LinkedList.java:755) at sun.reflect.GeneratedMethodAccessor2419.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at java.io.ObjectStreamClass.invokeWriteObject(ObjectStreamClass.java:917) at java.io.ObjectOutputStream.writeSerialData(ObjectOutputStream.java:1339) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1290) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at org.springframework.webflow.engine.impl.FlowExecutionImpl.writeExternal(FlowExecutionImpl.java:476) at java.io.ObjectOutputStream.writeExternalData(ObjectOutputStream.java:1310) at java.io.ObjectOutputStream.writeOrdinaryObject(ObjectOutputStream.java:1288) at java.io.ObjectOutputStream.writeObject0(ObjectOutputStream.java:1079) at java.io.ObjectOutputStream.writeObject(ObjectOutputStream.java:302) at org.springframework.webflow.execution.repository.continuation.SerializedFlowExecutionContinuation.serialize(SerializedFlowExecutionContinuation.java:178) at org.springframework.webflow.execution.repository.continuation.SerializedFlowExecutionContinuation.<init>(SerializedFlowExecutionContinuation.java:70) at org.springframework.webflow.execution.repository.continuation.SerializedFlowExecutionContinuationFactory.createContinuation(SerializedFlowExecutionContinuationFactory.java:55) at org.springframework.webflow.execution.repository.continuation.ContinuationFlowExecutionRepository.putFlowExecution(ContinuationFlowExecutionRepository.java:178) at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:210) at sun.reflect.GeneratedMethodAccessor235.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:281) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:187) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:154) at org.acegisecurity.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy17.launch(Unknown Source) at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:131) at org.springframework.webflow.executor.mvc.FlowController.handleRequestInternal(FlowController.java:170) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:45) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:820) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:755) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:396) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:689) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:141) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:97) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.basicauth.BasicProcessingFilter.doFilter(BasicProcessingFilter.java:181) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.AbstractProcessingFilter.doFilter(AbstractProcessingFilter.java:217) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:165) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

anyone have any idea abt this issue? Please help.

anyone have any idea abt this issue? Please help.

hi all, I am trying to create a ireport chart using jasperReports-Pro 3.1.2. The query populates 3 rows and 2 fields (Fields=a category expression and a value expression). i am able to create a report but the report is displaying 3 charts(or as many rows the query populates). Do i need to specify any other properties? or do i hav to write the query in any other form? i am attaching the query and code below. thanks in advance joe Code:SELECT TYPE, count(STATUS)FROM TableGROUP BY TYPE-----------------------------------<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="report name" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <style name="style1" isDefault="false"/> <queryString> <![CDATA[sELECT TYPE, count(STATUS)FROM TableGROUP BY TYPE]]> </queryString> <field name="TYPE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="COUNT(STATUS)" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <background> <band/> </background> <title> <band height="37"/> </title> <pageHeader> <band height="35"/> </pageHeader> <columnHeader> <band/> </columnHeader> <detail> <band height="311" isSplitAllowed="false"> <lineChart> <chart isShowLegend="false" hyperlinkType="None"> <reportElement isPrintRepeatedValues="false" x="200" y="10" width="345" height="149"/> <box> <pen lineColor="#FFFF00"/> <topPen lineColor="#FFFF00"/> <leftPen lineColor="#FFFF00"/> <bottomPen lineColor="#FFFF00"/> <rightPen lineColor="#FFFF00"/> </box> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <dataset resetType="None"/> <categorySeries> <seriesExpression><![CDATA["OPEN"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["CLOSED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["ABANDONED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> </categoryDataset> <linePlot> <plot/> </linePlot> </lineChart> <pieChart> <chart isShowLegend="false" hyperlinkType="None"> <reportElement x="11" y="10" width="189" height="149"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <pieDataset> <keyExpression><![CDATA[$F{TYPE}]]></keyExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <sectionHyperlink hyperlinkType="None"/> </pieDataset> <piePlot isCircular="true"> <plot/> </piePlot> </pieChart> <stackedBarChart> <chart isShowLegend="false" hyperlinkType="None"> <reportElement x="329" y="159" width="216" height="141"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["OPEN"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["CLOSED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["ABANDONED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> </categoryDataset> <barPlot isShowLabels="false" isShowTickLabels="true" isShowTickMarks="true"> <plot/> </barPlot> </stackedBarChart> <bar3DChart> <chart isShowLegend="false" hyperlinkType="None"> <reportElement x="11" y="159" width="318" height="141"/> <chartTitle/> <chartSubtitle/> <chartLegend/> </chart> <categoryDataset> <categorySeries> <seriesExpression><![CDATA["OPEN"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["CLOSED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> <categorySeries> <seriesExpression><![CDATA["ABANDONED"]]></seriesExpression> <categoryExpression><![CDATA[$F{TYPE}]]></categoryExpression> <valueExpression><![CDATA[$F{COUNT(STATUS)}]]></valueExpression> <itemHyperlink hyperlinkType="None"/> </categorySeries> </categoryDataset> <bar3DPlot isShowLabels="false"> <plot/> </bar3DPlot> </bar3DChart> </band> </detail> <columnFooter> <band height="40"/> </columnFooter> <pageFooter> <band height="41"/> </pageFooter> <summary> <band height="42"/> </summary></jasperReport>

Japser is displaying 'NaN' when i have a divide by zero error.How can we display zero in place of NaN? Your help is higly appreciated. thanks in advance joe

Whats the difference between XML/A Connection and Mondrian connection? Thanks in Advance joe

Post Edited by joe77 at 10/13/2009 06:49