jonathan2260

Ok. I ended up able to get help. Here was the results. I had to convert it to string using toString then use a substring to get rid of anything beyond the date (because it is a timestamp) and end up doing a compareTo the unwanted date to tell it to leave a blank if it is the same and display if anything else. ($F{DATE}.toString().substring(0,10).compareTo("1899-12-30") == 0) ? "" : $F{DATE}.toString().substring(0,10) I can say this was well over my head but hopefully I learned a few things out of this today. I'm posting it here in case it might be useful to others. Also, a correction on what I had said before about Crystal Reports. It`s not able to automatically avoid display a date. There was a formula telling it to not display it. I just didn`t know where to look.

I tried to put it as you wrote and go errors. See code for results. I`m still pretty new at using stuff such as iReport but did try a few things to make it work such as putting new Interger at the beginning. No luck that way unfortunatly. Code:com.jaspersoft.jasperserver.api.JSExceptionWrapper: Errors were encountered when compiling report expressions class file: 1. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getValue()).length()>0?((java.lang.String)field_PHONE_NBR.getValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$ :0); //$JR_EXPR_ID=10$ <--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 2. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getOldValue()).length()>0?((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$ :0); //$JR_EXPR_ID=10$ <--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getValue()).length()>0?((java.lang.String)field_PHONE_NBR.getValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$ :0); //$JR_EXPR_ID=10$ <--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3 errorscom.jaspersoft.jasperserver.api.JSExceptionWrapper: net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:1. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getValue()).length()>0?((java.lang.String)field_PHONE_NBR.getValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$:0); //$JR_EXPR_ID=10$ <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->2. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getOldValue()).length()>0?((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$:0); //$JR_EXPR_ID=10$ <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->3. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getValue()).length()>0?((java.lang.String)field_PHONE_NBR.getValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$:0); //$JR_EXPR_ID=10$ <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->3 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:195) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:219) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:903) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:1271) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.CacheableCompiledReports.getData(CacheableCompiledReports.java:58) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.saveData(HibernateRepositoryCache.java:171) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.getCachedItem(HibernateRepositoryCache.java:110) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.cache(HibernateRepositoryCache.java:70) at sun.reflect.GeneratedMethodAccessor308.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.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at com.jaspersoft.jasperserver.api.common.util.spring.ReattemptMethodInterceptor.invoke(ReattemptMethodInterceptor.java:51) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy6.cache(Unknown Source) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getCompiledReport(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getJasperReport(EngineServiceImpl.java:716) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:1194) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.loadInputControlsInformation(ReportParametersAction.java:409) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:487) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:414) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:123) at com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:148) at sun.reflect.GeneratedMethodAccessor373.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203) at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142) at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Flow.start(Flow.java:557) at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189) at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206) at sun.reflect.GeneratedMethodAccessor305.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 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:142) 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:172) 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:172) 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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)net.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file: 1. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getValue()).length()>0?((java.lang.String)field_PHONE_NBR.getValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$ :0); //$JR_EXPR_ID=10$ <--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 2. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getOldValue()).length()>0?((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$ :0); //$JR_EXPR_ID=10$ <--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getValue()).length()>0?((java.lang.String)field_PHONE_NBR.getValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$ :0); //$JR_EXPR_ID=10$ <--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------> 3 errorsnet.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:1. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getValue()).length()>0?((java.lang.String)field_PHONE_NBR.getValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$:0); //$JR_EXPR_ID=10$ <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->2. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getOldValue()).length()>0?((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getOldValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$:0); //$JR_EXPR_ID=10$ <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->3. Incompatible conditional operand types String and int value = (java.lang.String)(((java.lang.String)field_PHONE_NBR.getValue()).length()>0?((java.lang.String)field_PHONE_NBR.getValue()).substring( 0, 3 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 3, 6 ) + "-" + ((java.lang.String)field_PHONE_NBR.getValue()).substring( 6, 10 ) //$JR_EXPR_ID=10$:0); //$JR_EXPR_ID=10$ <-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------->3 errors at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:195) at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:219) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:903) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.compileReport(EngineServiceImpl.java:1271) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.CacheableCompiledReports.getData(CacheableCompiledReports.java:58) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.saveData(HibernateRepositoryCache.java:171) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.getCachedItem(HibernateRepositoryCache.java:110) at com.jaspersoft.jasperserver.api.metadata.common.service.impl.hibernate.HibernateRepositoryCache.cache(HibernateRepositoryCache.java:70) at sun.reflect.GeneratedMethodAccessor308.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.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:107) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at com.jaspersoft.jasperserver.api.common.util.spring.ReattemptMethodInterceptor.invoke(ReattemptMethodInterceptor.java:51) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:176) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:210) at $Proxy6.cache(Unknown Source) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getCompiledReport(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getJasperReport(EngineServiceImpl.java:716) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.getReportInputControlsInformation(EngineServiceImpl.java:1194) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.loadInputControlsInformation(ReportParametersAction.java:409) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:487) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:414) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:123) at com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:148) at sun.reflect.GeneratedMethodAccessor373.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:585) at org.springframework.webflow.util.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:103) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:136) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:203) at org.springframework.webflow.engine.AnnotatedAction.execute(AnnotatedAction.java:142) at org.springframework.webflow.engine.ActionExecutor.execute(ActionExecutor.java:61) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:180) at org.springframework.webflow.engine.State.enter(State.java:200) at org.springframework.webflow.engine.Flow.start(Flow.java:557) at org.springframework.webflow.engine.impl.RequestControlContextImpl.start(RequestControlContextImpl.java:195) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:189) at org.springframework.webflow.executor.FlowExecutorImpl.launch(FlowExecutorImpl.java:206) at sun.reflect.GeneratedMethodAccessor305.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 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:142) 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:172) 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:172) 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.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:199) at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:282) at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:767) at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:697) at org.apache.jk.common.ChannelSocket$SocketConnection.runIt(ChannelSocket.java:889) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595)

I have a field that is a timestamp. I switch it to a date field so that I only get the date portion. Most returns on the field have a real date and for a reason I don't know, when the customer has never used the services, there is a date in the field of 1899-01-30 (or something close to that, I don't have it in front of me) instead of being empty. I think it has to do with how this database handles the info. Now in Crystal report, it seems that it was smart enough to figure out that this was not a valid date and therefore would not display that date without any special tricks. I'm using iReport 3.5.1 and would like help on a way to keep it from appearing. Leave it blank when that date shows up and display all other dates that appear in the field so that I replicate the report as it was in Crystal format. Thanks for the help.

Well, after bashing my head in a few times. I found a way to resolve it. Here is the content of the variable I ended up creating based on an example I found elsewhere. $F{PHONE_NBR}.replaceFirst("(\\d{3})(\\d{3})(\\d+)", "$1-$2-$3") I was trying to do it using a substring but I keeped getting errors. If someone can give me a substring example of how to do this that would still be good for me on a future report I might need to do but otherwise I solved this one. Thanks to those that took the time to read this.

I have a Crystal report that I am trying to convert to JasperReports. I am using iReport v 3.5.1 The field holds telephone numbers in raw form. Ex: 5145556677 I need to change the field so that it add the - symbol in between like you would normally see when looking at a pohone number so it would look like 514-555-6677. In the Crystal report, this is what was done to make those splits. left({CUSTOMERPHONE.PHONE_NBR},3) & "-" & mid({CUSTOMERPHONE.PHONE_NBR},4,3) & "-" & Mid ({CUSTOMERPHONE.PHONE_NBR},7 ) I don`t know how I would convert that over to do the same with iReport. Can someone please help me? I don`t know if this is important to note but in Jasper Reports, the field is a String. Thank you.

Hi Carl. I ended up using method #3 as it was the best for what I was trying to accomplish. Thanks for the help.

Hello I'm using iReport 3.51 and I have a report with a parameter $P{Limit}. I use it in a text field as such. "Limit of "+ $P{Limit} +" and over" The number I enter in the parameter shows up. So far so good. This is a String class BTW. What I am trying to do now is change the format to be like others text boxes with fields I have on this report that are double classes using a pattern #,##0 I tried a few ways such as: "Limit of "+ (new DecimalFormat("#,##0")).format($P{Limit}) +" and over" I keeps getting errors. Does anyone know what I should be entering to get it to work the way I want it? Thanks.

That seems to be the issue. It's something to do with french accents on the name. When they are taken off, it works well. I wish I had a way around that problem other than manually removing them.

Here is what I have so far. Code:SELECT CUSTOMERMASTER."NAME" AS CUSTOMERMASTER_NAME, SALESMASTER."COMP_NBR" AS SALESMASTER_COMP_NBR, SALESMASTER."CUST_NBR" AS SALESMASTER_CUST_NBR, SALESMASTER."MEMO_TYPE" AS SALESMASTER_MEMO_TYPE, SALESMASTER."MEMO_DATE" AS SALESMASTER_MEMO_DATE, SALESMASTER."MEMO_NBR" AS SALESMASTER_MEMO_NBR, SALESMASTER."TAX_AMT" AS SALESMASTER_TAX_AMT, SALESMASTER."AMT" AS SALESMASTER_AMTFROM "CUSTOMERMASTER" CUSTOMERMASTER INNER JOIN "SALESMASTER" SALESMASTER ON CUSTOMERMASTER."COMP_NBR" = SALESMASTER."COMP_NBR" AND CUSTOMERMASTER."CUST_NBR" = SALESMASTER."CUST_NBR"WHERE SALESMASTER."COMP_NBR" = $P{Region} AND SALESMASTER."MEMO_DATE" >= $P{StartDate} AND SALESMASTER."MEMO_DATE" < $P{EndDate} AND SALESMASTER."MEMO_TYPE" = 'C'ORDER BY SALESMASTER."MEMO_NBR" ASC

Hello I am trying to convert a crystal report to Jasper using iReport 3.5.1 It seems to work but depending on what dates I choose. Sometimes it will return me an error msg. I am still learning but have tried to look around before posting this msg. Thanks for any help you can offer. What should I be looking to correct? Code:  Compiling to file... C:\Documents and Settings\jmarchi\Mes documents\Jasper\notecred.jasperCompilation running time: 703!  Filling report...  Locale: français (Canada)  Time zone: DefaultError filling print... Error executing SQL statement for : Note Credit net.sf.jasperreports.engine.JRException: Error executing SQL statement for : Note Credit     at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:141)     at net.sf.jasperreports.engine.fill.JRFillDataset.createQueryDatasource(JRFillDataset.java:685)     at net.sf.jasperreports.engine.fill.JRFillDataset.initDatasource(JRFillDataset.java:605)     at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:1223)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:853)     at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:802)     at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:63)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:421)     at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:251)     at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:896)     at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561)     at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544321. arithmetic exception, numeric overflow, or string truncation Cannot transliterate character between character sets     at org.firebirdsql.jdbc.FBCachedFetcher.<init>(FBCachedFetcher.java:126)     at org.firebirdsql.jdbc.FBResultSet.<init>(FBResultSet.java:113)     at org.firebirdsql.jdbc.AbstractStatement.getCachedResultSet(AbstractStatement.java:568)     at org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery(AbstractPreparedStatement.java:115)     at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:135)     ... 11 more Print not filled. Try to use an EmptyDataSource...