danysabo

This wiki page helped me: http://jasperforge.org/plugins/mwiki/index.php/Jasperserver/Cascading_input_controls

I fixed this. Problem was with default value for second parameter in JRXML file. When no values found for second combo box, that exception is thrown.

Hi, I have strange problem. I have cascading input controls in my jasper server report. It works with one JRXML file, but not with other. How can it be? I am using Jasper Server 3.7. This is JBoss stack trace: 2010-08-04 19:46:42,878 INFO [sTDOUT] (http-0.0.0.0-8080-64) 2010-08-04 19:46:42,877 WARN DefaultRemoter,http-0.0.0.0-8080-64:67 - Method execution failed: java.lang.IndexOutOfBoundsException: Index: 0, Size: 0 at java.util.ArrayList.RangeCheck(ArrayList.java:547) at java.util.ArrayList.get(ArrayList.java:322) at com.jaspersoft.jasperserver.war.cascade.token.TokenControlLogic.executeQuery(TokenControlLogic.java:381) at com.jaspersoft.jasperserver.war.cascade.token.TokenControlLogic.processEnvelope(TokenControlLogic.java:151) at com.jaspersoft.jasperserver.war.cascade.token.TokenControlLogic.handleEvents(TokenControlLogic.java:131) at com.jaspersoft.jasperserver.war.cascade.token.TokenControlLogic.initialize(TokenControlLogic.java:107) at com.jaspersoft.jasperserver.war.cascade.ControlLogicDelegator.initialize(ControlLogicDelegator.java:100) at com.jaspersoft.jasperserver.war.cascade.CascadeDirector.initialize(CascadeDirector.java:40) at com.jaspersoft.jasperserver.war.cascade.CascadeDirector$$FastClassByCGLIB$$cb78188c.invoke(<generated>) at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:700) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.aop.support.DelegatingIntroductionInterceptor.doProceed(DelegatingIntroductionInterceptor.java:131) at org.springframework.aop.support.DelegatingIntroductionInterceptor.invoke(DelegatingIntroductionInterceptor.java:119) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:635) at com.jaspersoft.jasperserver.war.cascade.CascadeDirector$$EnhancerByCGLIB$$d735f4cf.initialize(<generated>) at sun.reflect.GeneratedMethodAccessor3012.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) at java.lang.reflect.Method.invoke(Method.java:597) at org.directwebremoting.impl.ExecuteAjaxFilter.doFilter(ExecuteAjaxFilter.java:34) at org.directwebremoting.impl.DefaultRemoter$1.doFilter(DefaultRemoter.java:428) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:431) at org.directwebremoting.impl.DefaultRemoter.execute(DefaultRemoter.java:283) at org.directwebremoting.servlet.PlainCallHandler.handle(PlainCallHandler.java:52) at org.directwebremoting.servlet.UrlProcessor.handle(UrlProcessor.java:101) at org.directwebremoting.spring.DwrSpringServlet.doPost(DwrSpringServlet.java:158) 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 com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) 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 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 org.springframework.security.ui.basicauth.BasicProcessingFilter.doFilterHttp(BasicProcessingFilter.java:174) 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 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:236) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96) 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:235) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at o2010-08-04 19:46:42,879 INFO [sTDOUT] (http-0.0.0.0-8080-64) rg.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190) at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525) at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126) at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:619)

@mdjj I tried to change that, but no effect. @Gaby38 It works only for main menu, not for popup menu.

I fixed this temporary using with adding the following parts in file reportJobs.jsp: <%@ taglib uri="http://www.springframework.org/security/tags" prefix="authz"%>...<authz:authorize ifAllGranted="ROLE_ADMINISTRATOR">...</authz:authorize> and user can't see 'Schedule Job' and 'Run Now' buttons. But I would like to remove menu item 'Schedule...' from popup menu when user is not administrator. Any idea?

I'm sorry, but I really need to disable scheduling option for some users. Any guess? Thanks, Daniel

It works, thank you! Daniel

@Matt, In most cases every user can access only his report, but it is not the case always. You are right, I want that every report unit have his separate logo. And your new proposal work. Thank you! And thanks to Lucian, he give me the same answer. PS. I tried that earlies, but that didn't work. It works now, I don't know what problem was. Thank you both, again!

Hi all, Is there any way to set locale on Jasper server based on logged user? I mean, I don't want to allow user to select locale (and timezone) on login screen, but I want to set locale manually after user is logged in. Thanks, Daniel

Also, I don't want to add new image when adding new user. It could be better to send some parameter based on report unit. Post Edited by danysabo at 04/16/2010 15:12

Thanks Matt for LoggedInUser parameter (I didn't know it exists). Is there some documentation (or javadoc, source code...) about that, and others similar parameters? There is problem when some user is admin. He can see both report units in both folders, but it still need to be different logos. Is there some solution for that?

User can log in to jasper server through browser using his credentials, and he can see only his report. When he press report link, report is generated and displayed (so, there is no direct http request). BTW, I create input controls inside Report Unit when user need to send some parameters. But in this case, user doesn't need to enter anything, I just need to send default value. So, my problem still persists. Thanks, anyway. Daniel

I just don't know how to assign value to the parameter in java, since I'm not using java code. Maybe to set 'Optional JSP location' for input parameters?

Ok, I will explain in details. I have two foders on Jasper server, each one for different user. Both user can access to only his Report Unit inside his folder. I set up two different datasources, one for every user. Since structure for both databases are same (only data differs), I can use same jrxml file for both user. Every user access only to his database. And everything is fine. I just want to set up different logo for every user. I hope it's clear now. Passing parameter will be fine (I am doing that when I'm calling jasperreport from java code), I just don't know how to perform that inside Jasper server. Thank you.

acidcube Wrote: Or just have 2 files with different logos each one.besides a jrxml file its what.. like 300kb each Point is that I dont want to have two files, because they are both equal (only logo differ). I am just refferencing to same jrxml file inside both jasper reports. madarapuv Wrote: you can use Print when expression tag. pass one parameter to jrxml based on the parameter using print when expression you can show or hide the image. I know that I can to use print when expresion, but how can I sent different parameters to report?

Sorry this was mistake, I send same topic twice. Can someone delete this one?

I have two different jasper server reports with same jrxml resource file, and I want for them to use different logo. How can I accomplish that? Thanks a lot!

I have two different jasper server reports with same jrxml resource file, and I want for them to use different logo. How can I accomplished that? Thanks a lot!

How to limit report scheduling on admin only? I found some hints on this subject, but it didn't help. I am using Jasper Server 3.7. Thanks, Daniel

It happens with Jasper Server 3.7.0 also. But I think this is problem with iReport.

Thanks Matt, that helped! I added just one item to excludes tag. Regards, Daniel

How can I made login page to JasperServer nondecorated? I analized decorator.jsp page, and I found that if I pass parameter decorate=no that page will not be decorated. But I don't know how to pass this parameter by default for login page. At first, I wanted to change decorator.jsp page to check what page is decorating, and in case that is login page, to use nondecorated version. But I didn't know how to check what page is decorating, and also, I don't think changing decorator.jsp page is good idea. Thanks!

Hello, I have following sql query inside iReport query window: select ca.* from carassignment cajoin car c on ca.carId = c.id and c.status in ($P!{STATUSES}) I have problem when 'Automatically Retrieve Fields' option is checked, it says that I have error in SQL syntax. But if I compile report with that query, everything is fine. Problem is the mark '!', but I need that mark to avoid inserting single quota character. I think this is bug, iReport need not report that I have error in SQL syntax. I'm sorry if this problem is already reported, I didn't find it searching the forum. Regards, Daniel Sabo

It would be nice to have search option inside query window ;).

I just saw that Jasper Server 3.7.0 final version released, I will try with that version.