wolfram

Hi Guys, I'm investigating something in creating adhoc view. When I add a prefilter upon creating adhoc view, I see in jasperserver log file the query executed by jasperserver (SELECT TOP 2147483647 field FROM table .....). I just want to know how the jasperserver created the select statement especially where did it get the "TOP 2147483647". The 2147483647 is too big especially the table only have 1000 records. Thanks,

Hi, Please help me on how to setup the jasperserver permission. What I need is that only the user who created the folder will be able to see the folder regardless of the roles. Our users doesn't have the capabilities to set permission on the resources Regards,

Hi, I'm using JasperReport Server 5.1.0, I have a report created using iReport with a date filter. I tried to use the DAY, MONTH and WEEK function in the date input control when I run my report but I get an error stating "Specify a valid value for type Date." below the date input control. Is the DAY, MONTH and WEEK only works in reports created in AdHoc Designer? Regards,

Hi, I'm currently using Jaspersoft 5 and I created an adhoc report with date filter. There's no error when I add the date field in the filter but I always get an error whenever I change the date. The database that I'm using is Oracle 11g, below is the error in the logs. Please help me to solve this. 2013-04-12 11:13:11,481 ERROR AdhocAjaxController,http-28080-1:794 - ad hoc controller exception java.lang.RuntimeException: groovy evaluation failed on string def javaType = args[0].getJavaType(); DateRange date = DateRangeFactory.getInstanceForExpression(sqlArgs[1].replace("'",""), javaType) Range range = eval.getExpressionFactory().getRange() range.setStart(eval.getDate(date == null ? null : date.getStart(), javaType)) range.setEnd(eval.getDate(date == null ? null : date.getEnd(), javaType)) return eval.getOperator(In.IN, args[0], range) and args [AS_OF_DATE, ts'2012-11-01 00:00:00'] at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.generateSQLForFunction(SQLGenerator.java:752) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.function(SQLGenerator.java:701) at com.jaspersoft.commons.dataset.expr.ExpressionWalker.operator(ExpressionWalker.java:114) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.operator(SQLGenerator.java:1001) at com.jaspersoft.commons.dataset.expr.ExpressionWalker.walk(ExpressionWalker.java:50) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.expression(SQLGenerator.java:562) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.getSQL(SQLGenerator.java:174) at com.jaspersoft.commons.semantic.dsimpl.JdbcBaseDataSet.getQueryDataSet(JdbcBaseDataSet.java:103) at com.jaspersoft.commons.semantic.dsimpl.JdbcBaseDataSet.getDatasetKey(JdbcBaseDataSet.java:113) at com.jaspersoft.commons.datarator.AbstractDataSet.getCacheKey(AbstractDataSet.java:206) at com.jaspersoft.commons.semantic.dsimpl.AbstractSemanticLayerDataSet.getCacheKey(AbstractSemanticLayerDataSet.java:1241) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getCachedDataSet(BaseDataSetCacheImpl.java:81) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:136) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:94) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1053) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1025) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.initWorkingDataSet(InteractiveDataLayoutEngine.java:313) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.initWorkingDataSet(InteractiveDataLayoutEngine.java:342) at com.jaspersoft.ji.adhoc.InteractiveTableEngine.initWorkingDataSet(InteractiveTableEngine.java:400) at com.jaspersoft.ji.adhoc.InteractiveTableEngine.populateViewModel(InteractiveTableEngine.java:80) at com.jaspersoft.ji.adhoc.InteractiveTableEngine.generateViewModel(InteractiveTableEngine.java:368) at com.jaspersoft.ji.adhoc.InteractiveEngine.getInteractiveReport(InteractiveEngine.java:124) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.generateReport(AdhocAjaxController.java:1825) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.generateReport(AdhocAjaxController.java:1792) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.editAdhocFilter(AdhocAjaxController.java:1137) 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.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:471) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:408) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.handleRequest(AdhocAjaxController.java:155) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) 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:411) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:95) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:66) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:101) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619) Caused by: net.sf.jasperreports.types.date.InvalidDateRangeExpressionException: Invalid date range expression: TIMESTAMP 2012-11-01 00:00:00 at net.sf.jasperreports.types.date.RelativeDateRange.validateExpression(RelativeDateRange.java:82) at net.sf.jasperreports.types.date.RelativeDateRange.(RelativeDateRange.java:68) at net.sf.jasperreports.types.date.DateRangeBuilder.toDateRange(DateRangeBuilder.java:223) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstance(DateRangeFactory.java:72) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstance(DateRangeFactory.java:58) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstance(DateRangeFactory.java:42) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstanceForExpression(DateRangeFactory.java:81) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory$getInstanceForExpression.call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120) at Script1.run(Script1.groovy:3) at groovy.lang.GroovyShell.evaluate(GroovyShell.java:518) at groovy.lang.GroovyShell.evaluate(GroovyShell.java:556) at groovy.lang.GroovyShell.evaluate(GroovyShell.java:527) at com.jaspersoft.commons.groovy.GroovyRunner.evaluate(GroovyRunner.java:67) at com.jaspersoft.commons.groovy.GroovyRunnerFactory.evaluate(GroovyRunnerFactory.java:29) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.generateSQLForFunction(SQLGenerator.java:733) ... 110 more 2013-04-12 11:13:16,235 ERROR AdhocAjaxController,http-28080-1:794 - ad hoc controller exception java.lang.RuntimeException: groovy evaluation failed on string def javaType = args[0].getJavaType(); DateRange date = DateRangeFactory.getInstanceForExpression(sqlArgs[1].replace("'",""), javaType) Range range = eval.getExpressionFactory().getRange() range.setStart(eval.getDate(date == null ? null : date.getStart(), javaType)) range.setEnd(eval.getDate(date == null ? null : date.getEnd(), javaType)) return eval.getOperator(In.IN, args[0], range) and args [AS_OF_DATE, ts'2012-11-01 00:00:01'] at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.generateSQLForFunction(SQLGenerator.java:752) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.function(SQLGenerator.java:701) at com.jaspersoft.commons.dataset.expr.ExpressionWalker.operator(ExpressionWalker.java:114) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.operator(SQLGenerator.java:1001) at com.jaspersoft.commons.dataset.expr.ExpressionWalker.walk(ExpressionWalker.java:50) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.expression(SQLGenerator.java:562) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.getSQL(SQLGenerator.java:174) at com.jaspersoft.commons.semantic.dsimpl.JdbcBaseDataSet.getQueryDataSet(JdbcBaseDataSet.java:103) at com.jaspersoft.commons.semantic.dsimpl.JdbcBaseDataSet.getDatasetKey(JdbcBaseDataSet.java:113) at com.jaspersoft.commons.datarator.AbstractDataSet.getCacheKey(AbstractDataSet.java:206) at com.jaspersoft.commons.semantic.dsimpl.AbstractSemanticLayerDataSet.getCacheKey(AbstractSemanticLayerDataSet.java:1241) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getCachedDataSet(BaseDataSetCacheImpl.java:81) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:136) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:94) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1053) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1025) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.initWorkingDataSet(InteractiveDataLayoutEngine.java:313) at com.jaspersoft.ji.adhoc.InteractiveDataLayoutEngine.initWorkingDataSet(InteractiveDataLayoutEngine.java:342) at com.jaspersoft.ji.adhoc.InteractiveTableEngine.initWorkingDataSet(InteractiveTableEngine.java:400) at com.jaspersoft.ji.adhoc.InteractiveTableEngine.populateViewModel(InteractiveTableEngine.java:80) at com.jaspersoft.ji.adhoc.InteractiveTableEngine.generateViewModel(InteractiveTableEngine.java:368) at com.jaspersoft.ji.adhoc.InteractiveEngine.getInteractiveReport(InteractiveEngine.java:124) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.generateReport(AdhocAjaxController.java:1825) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.generateReport(AdhocAjaxController.java:1792) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.editAdhocFilter(AdhocAjaxController.java:1137) 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.web.servlet.mvc.multiaction.MultiActionController.invokeNamedMethod(MultiActionController.java:471) at org.springframework.web.servlet.mvc.multiaction.MultiActionController.handleRequestInternal(MultiActionController.java:408) at org.springframework.web.servlet.mvc.AbstractController.handleRequest(AbstractController.java:153) at com.jaspersoft.ji.adhoc.action.AdhocAjaxController.handleRequest(AdhocAjaxController.java:155) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:900) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:827) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789) at javax.servlet.http.HttpServlet.service(HttpServlet.java:637) at javax.servlet.http.HttpServlet.service(HttpServlet.java:717) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:399) at com.jaspersoft.jasperserver.api.security.IPadSupportFilter.doFilter(IPadSupportFilter.java:67) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSSwitchUserProcessingFilter.doFilterHttp(JSSwitchUserProcessingFilter.java:154) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) 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:411) at com.jaspersoft.ji.license.LicenseCheckFilter.doFilter(LicenseCheckFilter.java:95) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:66) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java:139) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.util.RequestParameterAuthenticationFilter.doFilter(RequestParameterAuthenticationFilter.java:96) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilterHttp(MTBasicProcessingFilter.java:180) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at org.springframework.security.ui.AbstractProcessingFilter.doFilterHttp(AbstractProcessingFilter.java:278) at org.springframework.security.ui.SpringSecurityFilter.doFilter(SpringSecurityFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:192) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.logging.filter.BasicLoggingFilter.doFilter(BasicLoggingFilter.java:53) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.JSCsrfGuardFilter.doFilter(JSCsrfGuardFilter.java:101) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.WebAppSecurityFilter.doFilter(WebAppSecurityFilter.java:76) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.war.MultipartRequestWrapperFilter.doFilter(MultipartRequestWrapperFilter.java:90) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) at com.jaspersoft.jasperserver.api.security.encryption.EncryptionFilter.doFilter(EncryptionFilter.java:130) at org.springframework.security.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:411) 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:411) at org.springframework.security.util.FilterChainProxy.doFilter(FilterChainProxy.java:188) at org.springframework.security.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:99) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:67) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at com.jaspersoft.jasperserver.war.P3PFilter.doFilter(P3PFilter.java:43) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:558) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:859) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:579) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1555) at java.lang.Thread.run(Thread.java:619) Caused by: net.sf.jasperreports.types.date.InvalidDateRangeExpressionException: Invalid date range expression: TIMESTAMP 2012-11-01 00:00:01 at net.sf.jasperreports.types.date.RelativeDateRange.validateExpression(RelativeDateRange.java:82) at net.sf.jasperreports.types.date.RelativeDateRange.(RelativeDateRange.java:68) at net.sf.jasperreports.types.date.DateRangeBuilder.toDateRange(DateRangeBuilder.java:223) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstance(DateRangeFactory.java:72) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstance(DateRangeFactory.java:58) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstance(DateRangeFactory.java:42) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory.getInstanceForExpression(DateRangeFactory.java:81) at com.jaspersoft.jasperserver.api.common.util.rd.DateRangeFactory$getInstanceForExpression.call(Unknown Source) at org.codehaus.groovy.runtime.callsite.CallSiteArray.defaultCall(CallSiteArray.java:45) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:108) at org.codehaus.groovy.runtime.callsite.AbstractCallSite.call(AbstractCallSite.java:120) at Script1.run(Script1.groovy:3) at groovy.lang.GroovyShell.evaluate(GroovyShell.java:518) at groovy.lang.GroovyShell.evaluate(GroovyShell.java:556) at groovy.lang.GroovyShell.evaluate(GroovyShell.java:527) at com.jaspersoft.commons.groovy.GroovyRunner.evaluate(GroovyRunner.java:67) at com.jaspersoft.commons.groovy.GroovyRunnerFactory.evaluate(GroovyRunnerFactory.java:29) at com.jaspersoft.commons.semantic.dsimpl.SQLGenerator.generateSQLForFunction(SQLGenerator.java:733) ... 110 more Do I need to configure something in the jasperserver to solve this? Regards,

Hi, In the applicationContext-semanticLayer.xml, there is a function distinctCount, but there's always an error in the adhoc designer whenever I use this. Did anyone able to use this function? I'm just thinking if I'm able to use the distinctCount function, I can create a sum function so that the users can create an adhoc report of Average Sales Per Store in an area. for example: City, sum(sales), distinctCount(store), sum(sales)/distinctCount(store) City1, 10000, 2, 5000 City2, 22500, 3, 7500 Regards,

Hi, Is there a way to add a new summary function in the adhoc designer? Regards,

Hi, I'm using maps pro in iReport, and it seems that the maps that can be displayed is limited in the list of maps in the Maps Properties. Is it possible to add a new Map in the list of available maps? and if possible, can someone guide me on how to do this. Thanks, Mel

Hi Is it possible to change the IP address of jasperserver from http://localhost:8080/jasperserver-pro/ to http://jasperbi

Hi, How can I change the width of columns and rows in adhoc crosstab? Is it also possible to change the font size?

Hi, Is there a way to change the default column width of the adhoc crosstab report?

Hi, What’s the difference of passwordExpirationInDays in jasperserver-servlet.xml as against in applicationContext-security-web.xml? Regards,

Hi, How can I make the line smooth in line chart of iReport? Something like what we can do in Excel line chart. Below is my sample. LineChart Smooth LineChart Regards,

Hi, How can I modify the profile attribute of the user? Is there a property to enable this? Regards,

Hi Is there a better way than using js-export and js-import to backup and restore the jasperserver including the audit trail data? Regards, Mel

Hi I also able to do this in version 4.0 but I wasn't able to do the same thing in 4.7. The screen only display "You do not have permission to view this page." Is there an additional permission that I need to enable this? Regards, Mel

Hi, I'm currently doing a dynamic top10 report, the filter of the report is a date range. I can easily do this using SQL statement but I need to do this using the domain. Can someone help me on how to create a dynamic top 10 report using domain? By the way, the report is a dynamic top 10 total sales per category, I need to acquire a select statement something like this (SELECT category, sum(sales) from tbl_sales WHERE sdate between $P{date1} and $P{date2}) using domain. Thanks in advanced, Mel Post Edited by melandro at 09/14/2012 13:24

Hi, I was having some difficulties in adding a logo in adhoc report in 4.7. I was able to do this in 4.0 by modifying the state2jrxml.js but when I applied the same changes in 4.7, nothing happens, the logo was not displayed when I create an Adhoc report. The funny thing is when I delete the state2jrxml.js and restart the tomcat 6.0, the jasperreport server was still able to generate an adhoc report. I'm expecting an error since I already deleted the file. Please someone help me!!! /tools/fckeditor/editor/images/smiley/msn/sad_smile.gif