manshack_one

I created a list of values then tied them to a multi-select list of values checkbox input control. When the pop up displays I see the list for a split second then it disappears and I'm left with a blank box. All of my query input controls work fine. For some reason it's the list of value one that's giving me a headache. Any ideas?

I'm not completely familiar with JBoss. Is it the app server on a different box altogether? I'll go try and find the toolkit you're talking about. My Jasperserver installation is using it's own tomcat instance on a suse linux box. Thanks either way for posting.

We've got a mainframe db2 running on an AS400. How do I create the datasource connection for that? When I usually go and query something I have to go through telnet basically and connect to the AS400 first then make the connection to db2. It seems that all the jdbc drivers I've found so far only handle the database side of the connection and not the server side of the connection. Am I missing something obvious? There's a ton of data in there I'd like to start creating reports for and I don't want to have to install DB2Connect on my pc to do it. :) Thanks in advance.

One question if I may. After running the export I'll need to drop the database from my mysql server right? I figure it needs to do this so the 3.7 general release version has a clean database to start off with.

I'm realizing now that I installed JS 3.7 CE RC. I guess it didn't bundle in JR 3.7 until the general release. Well, now I'll have to post on how to get this upgraded without losing all my reports, datasources, input controls, etc.

Is it the 3.6.2 Snapshot that's the issue? Was that the JR version for JS 3.7 CE? If that has to be upgraded I'll need some help getting the jars in the right place on the server. I noticed when I run the report locally in iReport it's coming back as 3.7.

How can they be different versions? I'm using iReport 3.7 and JS 3.7. Here's a jdbc info report that might help. $P{REPORT_CONNECTION}.getMetaData().getDriverVersion() http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px mysql-connector-java-5.1.5 ( Revision: ${svn.Revision} ) http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px net.sf.jasperreports.engine.JasperReport.class.getPackage(). http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px 3.6.2-SNAPSHOT http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px getClass().getResource("/com/mysql/jdbc/Driver.class").toString() http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px http://10.16.200.51:8081/jasperserver/reportimage?jrprint=27833405_1267626545716&image=px jar:file:/opt/jasperserver-ce-3.7.0/apache-tomcat/webapps/jasperserver/WEB- INF/lib/mysql-connector-java-5.1.5.jar!/com/mysql/jdbc/Driver.class

I'm using keepTogether in iReport to keep a group from splitting on the first page. It works perfectly and I get exactly what I need but the following error occurs if I try and run it on JS. It compiles just fine in iReport 3.7. java.lang.Exception: 1 - org.xml.sax.SAXParseException: cvc-complex-type.3.2.2: Attribute 'keepTogether' is not allowed to appear in element 'group'. at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:403) at com.jaspersoft.ireport.jasperserver.ws.WSClient.runReport(WSClient.java:320) at com.jaspersoft.ireport.jasperserver.ReportRunner.run(ReportRunner.java:70) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997)

it was all in the query: select u.system, u.unitcode, u.unitdesc, s1.dentalwro as dental1, s1.dentalnwr as nwr1, s2.dentalwro as dental2, s2.dentalnwr as nwr2, s3.dentalwro as dental3, s3.dentalnwr as nwr3, s1.atc1 as atc11, s2.atc1 as atc12, s3.atc1 as atc13, s1.atc2 as atc21, s2.atc2 as atc22, s3.atc2 as atc23, s1.atc3 as atc31, s2.atc3 as atc32, s3.atc3 as atc33, s1.dentalcs as cs1, s2.dentalcs as cs2, s3.dentalcs as cs3, s1.dentalnsp as nsp1, s2.dentalnsp as nsp2, s3.dentalnsp as nsp3, s1.dentalnpr as npr1, s2.dentalnpr as npr2, s3.dentalnpr as npr3 from UNITS u left outer join SLC s1 on s1.unit = u.unitdesc and s1.auditdate between $P{begindate} and last_day($P{begindate}) left outer join SLC s2 on s2.unit = u.unitdesc and s2.auditdate between DATE_ADD($P{begindate}, interval 1 month) and last_day(date_add($P{begindate}, interval 1 month)) left outer join SLC s3 on s3.unit = u.unitdesc and s3.auditdate between DATE_ADD($P{begindate}, interval 2 month) and last_day(date_add($P{begindate}, interval 2 month)) order by u.system, u.unitdesc;

I'm really needing some help with this one. It's driving me nuts. Here's the properly formatted report that originally came from an Excel spreadsheet and the data as it's being collected now. I need to query my data to look like that report.

Here is how the data comes out from my query: unitdesc auditdate dentalwro atc Bridgeport PPT 9/1/2009 100 98 Bridgeport PPT 10/1/2009 85 97 Bridgeport PPT 11/1/2009 67 96 Mineral Wells PPT 9/1/2009 99 89 Mineral Wells PPT 10/1/2009 89 88 Mineral Wells PPT 11/2/2009 78 87 I need to pivot the data though in the report so it's like this: dentalwro atc 9/1/2009 10/1/2009 11/1/2009 9/1/2009 10/1/2009 11/1/2009 Bridgeport PPT 100 85 67 98 97 96 Mineral Wells PPT 99 89 78 89 88 87 Will I have to script this or are there better options in iReport to pivot the data. It needs to fill horizontally but do so for all the values in the first column (Bridgeport dentalwro values) then the next column (Bridgeport atc) before moving on to Mineral Wells dentalwro then Mineral Wells atc values. Any suggestions would be greatly appreciated.

Ok, I don't know why it picked up 40 on the margins so to fix the issue I went into the subreport and set it's top margin to 0.

I have a report that had been running fine. Not sure what I changed but I'm now getting this error when compiling. Band height validation for subreport "HCD-Diabetes Summary" failed in the current page context (height = 792, top margin = 40, bottom margin = 40) : 1. The summary section and the margins do not fit the page height The main report and subreport are both set to 792. I don't know where it's seeing margins at 40 becuase everything I see shows the margins at 20. The summary sections of both reports are set to 750 but that shouldn't matter since the subreport component is going to use an entire page anyhow. Where do I look to get this error resolved? The subreport runs on it's own without problem. The main report will also run if I don't use this subreport. What happened? -Robert

Using JS 3.7 CE. Report runs fine in iReport. On JS however I get an error when trying to view a larger time frame. Here's the query: Select Unit, Port, DialedNumber, Rate, CallDate, CallStart, CallEnd, Duration, Minutes, Account, PIN, Prepaid, First, Last, call1, call2, TermReason, Blocked, Revenue, Commission From call_detail Where CallDate between $P{begindate} and $P{enddate} and $X{IN,Unit,otsunitselectcontrol} and PIN $P!{OTSPIN} and $X{IN,TermReason,otstermreason} and $X{IN,call1,otscall1} and $X{IN,call2,otscall2} and $X{IN,Blocked,otsblocked} and $X{IN,Rate,otsrate}; Right now I'm only filtering on one TermReason and a the first day of January (365 matches) and it pulls fine. When I expand the date range to the entire month (1/1 - 1/27 and 4687 matches) I get the following error message. I'm only changing the date range. I can get it to pull up to about the 19th right now. Any ideas? java.lang.IllegalStateException: Exception occurred rendering view org.springframework.web.servlet.view.JstlView: name 'ViewReport'; URL [/WEB-INF/jsp/ViewReport.jsp] java.lang.IllegalStateException: Exception occurred rendering view org.springframework.web.servlet.view.JstlView: name 'ViewReport'; URL [/WEB-INF/jsp/ViewReport.jsp] at org.springframework.webflow.mvc.view.AbstractMvcView.render(AbstractMvcView.java:183) at org.springframework.webflow.engine.ViewState.render(ViewState.java:282) at org.springframework.webflow.engine.ViewState.doEnter(ViewState.java:186) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:51) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:163) at sun.reflect.GeneratedMethodAccessor257.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:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy17.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java: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:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 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:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 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: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) Caused by: javax.servlet.ServletException: Filter execution threw an exception at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:226) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:236) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:257) at org.springframework.webflow.mvc.servlet.ServletMvcView.doRender(ServletMvcView.java:50) at org.springframework.webflow.mvc.view.AbstractMvcView.render(AbstractMvcView.java:179) ... 104 more javax.servlet.ServletException: Filter execution threw an exception javax.servlet.ServletException: Filter execution threw an exception at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:226) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:672) at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:463) at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:398) at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301) at org.springframework.web.servlet.view.InternalResourceView.renderMergedOutputModel(InternalResourceView.java:236) at org.springframework.web.servlet.view.AbstractView.render(AbstractView.java:257) at org.springframework.webflow.mvc.servlet.ServletMvcView.doRender(ServletMvcView.java:50) at org.springframework.webflow.mvc.view.AbstractMvcView.render(AbstractMvcView.java:179) at org.springframework.webflow.engine.ViewState.render(ViewState.java:282) at org.springframework.webflow.engine.ViewState.doEnter(ViewState.java:186) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.DecisionState.doEnter(DecisionState.java:51) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:105) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Transition.execute(Transition.java:227) at org.springframework.webflow.engine.impl.FlowExecutionImpl.execute(FlowExecutionImpl.java:391) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:214) at org.springframework.webflow.engine.TransitionableState.handleEvent(TransitionableState.java:119) at org.springframework.webflow.engine.Flow.handleEvent(Flow.java:555) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleEvent(FlowExecutionImpl.java:386) at org.springframework.webflow.engine.impl.RequestControlContextImpl.handleEvent(RequestControlContextImpl.java:210) at org.springframework.webflow.engine.ViewState.handleEvent(ViewState.java:230) at org.springframework.webflow.engine.ViewState.resume(ViewState.java:196) at org.springframework.webflow.engine.Flow.resume(Flow.java:545) at org.springframework.webflow.engine.impl.FlowExecutionImpl.resume(FlowExecutionImpl.java:259) at org.springframework.webflow.executor.FlowExecutorImpl.resumeExecution(FlowExecutorImpl.java:163) at sun.reflect.GeneratedMethodAccessor257.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:307) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149) at org.springframework.security.intercept.method.aopalliance.MethodSecurityInterceptor.invoke(MethodSecurityInterceptor.java:66) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy17.resumeExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:183) at org.springframework.webflow.mvc.servlet.FlowController.handleRequest(FlowController.java:174) at org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:875) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:807) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:571) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:501) at javax.servlet.http.HttpServlet.service(HttpServlet.java: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:83) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 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:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) 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: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 figure this one out yet?

well, lo and behold I went back to my report, added the 3 other input controls then diagnosed an issue with one of the value/display columns and the darn thing started working. I had the queries a little off at first and needed to put a few "and" statements in my where clause for the unit level choice but it works. This is a really cool feature. Sad thing is they'll probably want it on their other 25 reports now. :( Oh well, job security. Thanks again for all the help.

Is there a difference between the JS 3.7 RC and the recently posted JS 3.7 CE on sourceforge?

bump. still need to get this accomplished. let me know if you need more info!

I sometimes drop the collection I'm using in my report onto the page so the user can see later what they chose as parameters. For example I have "showReportList" as a collection. Dropping it on the page gives you a text field with ""+$P{showReportList} as the field expression. This formats the output as: ["report1", "report2"]. Take out the beginning quotes from the expression just leaving $P{showReportList} and you get [report1, report2]. Are there any other formatting options? I'd like to insert a newline after each collection item for instance. What options do you have for formatting the collection output?

My report includes about a dozen subreports. Each one is preceded by a page break (break, sub, break, sub, break, sub,.....). They are layed out vertically in iReport with a little space betwen each one. Each of these subreports and their corresponding page break has a 'print when' expression tied to a boolean that checks an input control collection to see which subreports the user wants to include. Everything lines up ok as long as the first subreport is chosen. However, if the user only chooses a subreport that is positioned in the middle of the page in iReport designer then the resulting output will read the page break correctly but anchor the subreport to the same spot as on the designer. All the subreports and breaks are set to float. Otherwise they all print on top of each other. How do I get the subreports to always anchor to the top of the page? Also, I've noticed that anytime you use a subreport and page break (even if you just have one of them) it will not anchor the subreport to the top of the page but instead to the top margin of the page. If you open the subreport up separately it is sitting at -20 from the top. I'm using the blue template all the way at the bottom of the report wizard screen. I can manually push the subreports to the left -20 but I can't put them all at the top that way because you can't let them overlap or the output overlaps. The only thing that seems to work on subreports is setting everything to float and putting page breaks in front of them also on float but you still have the issue that it's moving the subreport inside the margins of the parent report. Wouldn't it make more sense to use it's own margins and just print as if it was appended to the master report instead of merged in with it?

bump

My details are grouped by the question on a survery form. I have totals at the bottom of each group like so: Question1 (value) >>>>>>>Location1>>>>>10 >>>>>>>Location2>>>>>15 >>>>>>>Location3>>>>>13 >>>>>>>>>>>>Total>>>>38 Question2 (value) >>>>>>>Location1>>>>>20 >>>>>>>Location2>>>>>45 >>>>>>>Location3>>>>>11 >>>>>>>>>>>>Total>>>>76 On the summary page I just want those totals like so: Question 1>>>>>>>>>>>38 Question 2>>>>>>>>>>>76 Can I do this without a subreport, list or separate dataset? I just want to copy those values into a new list. I was able to accomplish it so far by creating a list, copying the report query into the list dataset query, and changing the grouping so I just get the question totals in the resulting dataset. I just feel like it's overkill to run the same query twice for each report (more if I wanted to grab other totals like specific locations. Can I tell the list component to grab the group totals using a variable? I have one report that has to sift through over 7 million records each time it runs. That's without a summary page. As is it takes over a minute to run. I don't want to double the effort of the server to run the same query twice. What do you guys think? -Robert

any other ideas I can try? Basically I just have the location description in the main table but need to search by the attributes in a different table. For example by district, etc. Thanks in advance.

Anybody know how I could make it possible to add a checkbox input control that would make the report print once for each selected item in a multi-select query input control? Ex. I have a multiselect query input control that allows choosing multiple office locations. The report reads that as a collection and utilizes a $X{IN} statement to pull the report. My user is wanting to be able to print that report once for each of the selected locations so that the information in the report is specific to one location only. This needs to be controlled by a checkbox labeled something like "Print Separately?". When it's checked the report will print once for each selected location. When it's not checked the report will print as normal which includes all the locations on the same report. Any suggestions?

Hello again Sherman. The report does work in iReport. After I upload the jrxml I add the input controls though the JasperServer interface. They're all there. System, Divreg, District and Units. I'm wondering though if it wouldn't accomplish the same thing to have 4 separate queries to pull distinct entries for each of those columns in the unit table and present them separately as multi-select input controls. In my report query I'd have to use 4 $X{IN} statements I suppose. My only problem is I have to match the unit description field to the corresponding System, Division and District so it's more of a join.