svedec

I've had this issue bothering me for quite some time now. When I leave whitespace underneath a list, the list will push this downwards, instead of overwritig it. Sometimes while doing so, pushing content onto the next page ! I've tried to illustrate the situation - see attached. In the first image, the chart at the bottom left has position type "float", hence it's positioned underneath the whitespace. When I change it to "relative to top", it's positioned at the correct place, but still the whitespace will be present underneath it (between the chart and the footer) Can this be solved, and how ?! It's a real problem when trying to get a decent layout. Thanks in advance.

I've had this issue bothering me for quite some time now. When I leave whitespace underneath a list, the list will push this downwards, instead of overwritig it. Sometimes while doing so, pushing content onto the next page ! I've tried to illustrate the situation - see attached. In the first image, the chart at the bottom left has position type "float", hence it's positioned underneath the whitespace. When I change it to "relative to top", it's positioned at the correct place, but still the whitespace will be present underneath it (between the chart and the footer) Can this be solved, and how ?! It's a real problem when trying to get a decent layout. Thanks in advance. Post Edited by svedec at 06/19/2012 10:06

Thanks for your reply, but that's not entirely what I meant. I make sure indeed the text field height is the same as list height. It's about the white space left beneath the list (in design modus). You would think the list fills that whitespace when data is returned, but in stead it pushes the white space, and the content beneath, down, onto the other page. Is there no way to let the list 'eat' this white space ?!

Hi all, I'm having another weirdy thing with iReport. When I put a list next to a chart near the bottom of the page, I get the impression that the whitespace under the list is being preserved and printed after the list has ended. In my case, this pushes my footer to the 2nd page, which I do not want. I would like the page to end where the list ends. Is there any way to disable this whitespace being printed ? Thanks in advance. Sven. Post Edited by svedec at 03/14/2012 12:39

solved Post Edited by svedec at 02/06/2012 10:01

Hi all, and a happy new year :) I have 4 series in 1 chart : a number of clients (Y-axis) who fit into certain blocks of salefigures (x-axis). These are the blue bars. I want to personalise my report, and highlight where my client sits, and where the average and the median are located. These are resp. the orange, yellow and green bars. Now, as you can see, every blue bar keeps an open spot for another series, even if there isn't. How can I avoid this ? I would like the blue bars to be bigger when there's no other series in the way. Also, as you can see, the x-axis is normally cut into 50-unit blocks. I want to display my client bar (the orange one) on the precise spot, but not break the consistency of the x-axis. So what I'd like is for the x-axis to go 350-400-450 and so on, but have the orange bar positioned at 413, without making seperate block for this. Is that somewhat clearly explained ? I hope so :) The extra 413-slice pushes extra space in between 400 and 450, thus making the block divisions on the x-axis inconsistent. Can I avoid this ? Thanks on beforehand, Sven.

Hi everyone, I am facing this difficulty : I want to indicate where my user is in a range of data in a chart, as well as where the average is. That's not too difficult, that part I figured out already :) However, if I have several charts in 1 report, my "user bar'" sometimes gets a different color, according whether it's below or above average. This is very confusing for my users, because they can't think, let's say, "the yellow bar is always me". The legend always has to be read, and that's not so user-friendly. I'll illustrate the problem in an attachment. I know how to have the same series color, but within this series, I want 1 particular color to always represent the value of the average, another to represent my user, etc. Is this possible ?! Thanks a lot in advance. Post Edited by svedec at 12/21/2011 12:59

Code:(I'm sorry, the text editor in the Message row is not rendered in FF 7, so I have to type my question here). It seems I'm getting a rounding error in the custom field "% of column Group" with Ad Hoc Reporting. When I calculate the percentage myself, I get fi. 18900/1034 = 18.27%. But the custom field tells me 18.44%. I've illustrated more examples. Is this a bug ?

Code:Right, I've cracked it ! I just made a domain report through iReport, and uploaded it to the main organisation (with the login of the main organisation) and connected our domain. Then, also through iReport, I uploaded the same report to the sub organisation (with the login of the sub organisation !) and connected the right domain. You have to upload everything for the sub organisation with the login for that organisation, otherwise you get a permission denied error. So for one server, I now have 2 connections in my Repository Navigator (see attached). That's how it works. (normal message field is broken again ??)

I had the same problem, and solved it. Nevermind the "missing" errors you get in the iReport Problems Window. Instead, look in your iReport Output Window when compiling, it will tell you which classes you're missing. Then search in your jasperserver-pro-3.7.1/scripts/lib directory for *.jar files containing the name of the class, fi : find . -exec grep -il AclObjectIdentity {} \; and you will be pointed to the jars you need to include in the iReport classpath. You will need : ji-semantic-layer-3.7.1.jar jasperserver-api-metadata-3.7.1.jar jasperserver-api-common3.7.1.jar spring-security-core-2.0.4.jar before you can begin to compile your domain report. Hope that helps, Sven.

I had the same problem, and solved it. Nevermind the "missing" errors you get in the iReport Problems Window. Instead, look in your iReport Output Window when compiling, it will tell you which classes you're missing. Then search in your jasperserver-pro-3.7.1/scripts/lib directory for *.jar files containing the name of the class, fi : find . -exec grep -il AclObjectIdentity {} \; and you will be pointed to the jars you need to include in the iReport classpath. You will need : ji-semantic-layer-3.7.1.jar jasperserver-api-metadata-3.7.1.jar jasperserver-api-common3.7.1.jar spring-security-core-2.0.4.jar before you can begin to compile your domain report. Hope that helps, Sven.

Hi, thanks for your reply and sorry about the messy topic - it seems fine now (I can add text where I'm supposed to :)) The strange thing is, when editing a JRXML through the web interface of Jasperserver Pro, I can choose the datasource from a dropdown list, which includes datasources AND domains ... It would be a mighty feature for a next release then maybe. I could design the same report for different sub-organisations, and just link to the respective domains. Where can I submit such proposal ?

Code:anyone any idea of this is possible ?Code:[code]anyone any idea if this is possible ? Post Edited by svedec at 08/22/2011 10:59

I have the exact same problem with Jasperserver Pro 3.7.1 Is it still present in the latest version too ?

I'm sorry, it seems I can only add text in the CODE area ?

Code:Can I use a domain as a datasource for my reports on Jasperserver Pro 3.7.1 ? I've tried and gotten an empty report, maybe I'm overlooking something. Thing is, I have a domain for a sub-company of ours. I want to re-use the reports of the parent company for the sub-company, and just link it to the right domain, so the sub-company will only see it's own data, not including the parent company's data of course. Otherwise, I'd have to adjust every query of every report of the sub-company to ensure this. Thanks in advance !

found it myself, but I will post the solution for future reference. JRProperties.setProperty("com.jaspersoft.jasperreports.fusion.charts.context.swf.url", "/jasperserver/statjaarrapport/charts"); JRProperties.setProperty("com.jaspersoft.jasperreports.fusion.charts.base.swf.url", "/jasperserver/statjaarrapport/charts"); JRProperties.setProperty("com.jaspersoft.jasperreports.fusion.maps.context.swf.url", "/jasperserver/statjaarrapport/maps"); JRProperties.setProperty("com.jaspersoft.jasperreports.fusion.maps.base.swf.url", "/jasperserver/statjaarrapport/maps"); JRProperties.setProperty("com.jaspersoft.jasperreports.fusion.widgets.context.swf.url", "/jasperserver/statjaarrapport/widgets"); JRProperties.setProperty("com.jaspersoft.jasperreports.fusion.widgets.base.swf.url", "/jasperserver/statjaarrapport/widgets");

Hi everyone, I hope someone can help my quickly, and that this isn't too fancy a problem. I'm trying to export a JR Pro file (with charts) from a JAVA class, on Linux. I understand from this topic (http://jasperforge.org/plugins/espforum/view.php?group_id=102&forumid=103&topicid=65016&page=1) that I need to set the properties-file and the URL where the swf files for the charts are located. So I have this in my .properties file: com.jaspersoft.jasperreports.fusion.charts.context.swf.url=/jasperserver/statjaarrapport/chartscom.jaspersoft.jasperreports.fusion.charts.base.swf.url=/jasperserver/statjaarrapport/chartscom.jaspersoft.jasperreports.fusion.maps.context.swf.url=/jasperserver/statjaarrapport/mapscom.jaspersoft.jasperreports.fusion.maps.base.swf.url=/jasperserver/statjaarrapport/mapscom.jaspersoft.jasperreports.fusion.widgets.context.swf.url=/jasperserver/statjaarrapport/widgetscom.jaspersoft.jasperreports.fusion.widgets.base.swf.url=/jasperserver/statjaarrapport/widgets I run my JAVA class as such: java -classpath "lib/jasperreports.properties:lib/mysql-connector-java-5.1.6-bin.jar:..." RunReports My JAVA class (RunReports) has this in the source: Properties sysprops = System.getProperties();Properties jasprops = JRProperties.loadProperties("lib/jasperreports.properties", sysprops);JasperExportManager.exportReportToPdfFile(jasperprint, "/tmp/pg01.pdf"); (jasperprint is successfully filled, as I can do this, giving the right output : System.out.println(jasperprint.getName());) Now, when executing the command exportReportToPdfFile, I get this error : java.lang.RuntimeException: java.lang.NullPointerException at com.jaspersoft.jasperreports.fusion.BasePdfHandler.exportElement(BasePdfHandler.java:126) at net.sf.jasperreports.engine.export.JRPdfExporter.exportGenericElement(JRPdfExporter.java:2687) at net.sf.jasperreports.engine.export.JRPdfExporter.exportElements(JRPdfExporter.java:758) at net.sf.jasperreports.engine.export.JRPdfExporter.exportPage(JRPdfExporter.java:710) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReportToStream(JRPdfExporter.java:599) at net.sf.jasperreports.engine.export.JRPdfExporter.exportReport(JRPdfExporter.java:381) at net.sf.jasperreports.engine.JasperExportManager.exportReportToPdfFile(JasperExportManager.java:122) at RunReports.main(RunReports.java:59)Caused by: java.lang.NullPointerException at java.io.File.<init>(File.java:222) at net.sf.jasperreports.engine.util.JRResourcesUtil.resolveFile(JRResourcesUtil.java:257) at net.sf.jasperreports.engine.util.JRLoader.loadBytesFromLocation(JRLoader.java:458) at net.sf.jasperreports.engine.util.JRLoader.loadBytesFromLocation(JRLoader.java:416) at com.jaspersoft.jasperreports.fusion.BasePdfHandler.readSwf(BasePdfHandler.java:132) at com.jaspersoft.jasperreports.fusion.BasePdfHandler.exportElement(BasePdfHandler.java:74) ... 7 more I guess he can't find the SWF files, but I've tried everything I think to pinpoint their location to my JAVA code. I also believe my JAVA_HOME is properly set. Can anyone tell me what I am doing wrong please ? (I need these reports out by Monday at the latest, and I still have to generate all of them (700 6-page reports ...). Thanks on beforehand !! Sven.

I have the exact same problem. When I uncheck "Inspect new tables and automatically generate joins", I don't get the error, but then I have to join the tables myself, and sooner or later, that gives an error too. My foreign keys are defined and all, can someone indicate where to add this metadata ? The full error is : com.jaspersoft.commons.semantic.metaapi.MetaDataException: Cannot get database meta info : /organizations/organization_1/datasources/CodisMIX com.jaspersoft.commons.semantic.metaapi.MetaDataException: Cannot get database meta info : /organizations/organization_1/datasources/CodisMIX at com.jaspersoft.commons.semantic.metaapi.impl.jdbc.BaseJdbcMetaDataFactoryImpl.buildRelations(BaseJdbcMetaDataFactoryImpl.java:502) at com.jaspersoft.commons.semantic.metaapi.impl.jdbc.JdbcMetaDataImpl.setRelationsScope(JdbcMetaDataImpl.java:29) at com.jaspersoft.ji.semantic.action.DomainDesignerAction.autoGenerateJoins(DomainDesignerAction.java:2353) at com.jaspersoft.ji.semantic.action.DomainDesignerAction.processParameters(DomainDesignerAction.java:1439) at sun.reflect.GeneratedMethodAccessor277.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.ActionList.execute(ActionList.java:160) at org.springframework.webflow.engine.TransitionableState.exit(TransitionableState.java:137) at org.springframework.webflow.engine.Transition.execute(Transition.java:218) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:224) at org.springframework.webflow.engine.support.TransitionExecutingStateExceptionHandler.handle(TransitionExecutingStateExceptionHandler.java:120) at org.springframework.webflow.engine.FlowExecutionExceptionHandlerSet.handleException(FlowExecutionExceptionHandlerSet.java:120) at org.springframework.webflow.engine.Flow.handleException(Flow.java:618) at org.springframework.webflow.engine.impl.FlowExecutionImpl.tryFlowHandlers(FlowExecutionImpl.java:347) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleException(FlowExecutionImpl.java:315) at org.springframework.webflow.engine.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:218) at org.springframework.webflow.executor.FlowExecutorImpl.resume(FlowExecutorImpl.java:238) at sun.reflect.GeneratedMethodAccessor267.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 $Proxy22.resume(Unknown Source) at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:115) 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.doPost(FrameworkServlet.java:360) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java: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 com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:182) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178) 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:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Caused by: java.sql.SQLException: A syntax error has occurred. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1340) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1313) at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:216) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:839) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:164) at com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:4821) at com.jaspersoft.commons.semantic.metaapi.impl.jdbc.BaseJdbcMetaDataFactoryImpl.buildRelations(BaseJdbcMetaDataFactoryImpl.java:467) ... 93 more java.sql.SQLException: A syntax error has occurred. java.sql.SQLException: A syntax error has occurred. at com.informix.util.IfxErrMsg.getSQLException(IfxErrMsg.java:355) at com.informix.jdbc.IfxSqli.addException(IfxSqli.java:3086) at com.informix.jdbc.IfxSqli.receiveError(IfxSqli.java:3396) at com.informix.jdbc.IfxSqli.dispatchMsg(IfxSqli.java:2259) at com.informix.jdbc.IfxSqli.receiveMessage(IfxSqli.java:2179) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1340) at com.informix.jdbc.IfxSqli.executeStatementQuery(IfxSqli.java:1313) at com.informix.jdbc.IfxResultSet.executeQuery(IfxResultSet.java:216) at com.informix.jdbc.IfxStatement.executeQueryImpl(IfxStatement.java:839) at com.informix.jdbc.IfxStatement.executeQuery(IfxStatement.java:164) at com.informix.jdbc.IfxDatabaseMetaData.getImportedKeys(IfxDatabaseMetaData.java:4821) at com.jaspersoft.commons.semantic.metaapi.impl.jdbc.BaseJdbcMetaDataFactoryImpl.buildRelations(BaseJdbcMetaDataFactoryImpl.java:467) at com.jaspersoft.commons.semantic.metaapi.impl.jdbc.JdbcMetaDataImpl.setRelationsScope(JdbcMetaDataImpl.java:29) at com.jaspersoft.ji.semantic.action.DomainDesignerAction.autoGenerateJoins(DomainDesignerAction.java:2353) at com.jaspersoft.ji.semantic.action.DomainDesignerAction.processParameters(DomainDesignerAction.java:1439) at sun.reflect.GeneratedMethodAccessor277.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.ActionList.execute(ActionList.java:160) at org.springframework.webflow.engine.TransitionableState.exit(TransitionableState.java:137) at org.springframework.webflow.engine.Transition.execute(Transition.java:218) at org.springframework.webflow.engine.impl.RequestControlContextImpl.execute(RequestControlContextImpl.java:224) at org.springframework.webflow.engine.support.TransitionExecutingStateExceptionHandler.handle(TransitionExecutingStateExceptionHandler.java:120) at org.springframework.webflow.engine.FlowExecutionExceptionHandlerSet.handleException(FlowExecutionExceptionHandlerSet.java:120) at org.springframework.webflow.engine.Flow.handleException(Flow.java:618) at org.springframework.webflow.engine.impl.FlowExecutionImpl.tryFlowHandlers(FlowExecutionImpl.java:347) at org.springframework.webflow.engine.impl.FlowExecutionImpl.handleException(FlowExecutionImpl.java:315) at org.springframework.webflow.engine.impl.FlowExecutionImpl.signalEvent(FlowExecutionImpl.java:218) at org.springframework.webflow.executor.FlowExecutorImpl.resume(FlowExecutorImpl.java:238) at sun.reflect.GeneratedMethodAccessor267.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 $Proxy22.resume(Unknown Source) at org.springframework.webflow.executor.support.FlowRequestHandler.handleFlowRequest(FlowRequestHandler.java:115) 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.doPost(FrameworkServlet.java:360) at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.common.UploadMultipartFilter.doFilter(UploadMultipartFilter.java:86) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:264) at org.acegisecurity.ui.switchuser.SwitchUserProcessingFilter.doFilter(SwitchUserProcessingFilter.java:335) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:107) at org.acegisecurity.intercept.web.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:72) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.ui.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:110) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.ji.license.JILicenseFilter.doFilter(JILicenseFilter.java:107) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.providers.anonymous.AnonymousProcessingFilter.doFilter(AnonymousProcessingFilter.java:125) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.api.metadata.user.service.impl.MetadataAuthenticationProcessingFilter.doFilter(MetadataAuthenticationProcessingFilter.java: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 com.jaspersoft.jasperserver.multipleTenancy.MTBasicProcessingFilter.doFilter(MTBasicProcessingFilter.java:182) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at com.jaspersoft.jasperserver.war.UserPreferencesFilter.doFilter(UserPreferencesFilter.java:178) 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:178) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.context.HttpSessionContextIntegrationFilter.doFilter(HttpSessionContextIntegrationFilter.java:191) at org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:274) at org.acegisecurity.util.FilterChainProxy.doFilter(FilterChainProxy.java:148) at org.acegisecurity.util.FilterToBeanProxy.doFilter(FilterToBeanProxy.java:90) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at com.jaspersoft.jasperserver.war.util.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:70) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:138) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684) at java.lang.Thread.run(Thread.java:595) Kindly appreciated, Sven.

Found an easy workaround : http://fecplanner.com/jasperreports/docs/tips.tricks.html#returnvalues Not an active forum here I'd say. This is the 2nd time I've solved my own problem before anyone replied.

Hi, I am having the same problem. I want to know how many rows a subreport printed, so I can put in my master report "No data found" when this would be 0. So in my MASTER i have a variable "TOTAL_TELECOM" : Calculation type: System Reset & Increment Type: None I define a return value when including the subreport : Subreport variable = REPORT_COUNT Destionation variable = TOTAL_TELECOM Calculation Type: Nothing I want to print the TOTAL_TELECOM variable in a text field : $V{TEL_COUNT} with Evaluation Time: Auto So far I gathered from reading here and there. Still, I'm printing nulls :-( Any ideas ? Thanks on beforehand ! Sven.

ok, found a fix, just turned off pagination ...

I reckon the problem is in the limitation with the "print when" expression. The report keeps printing empty lines, without data. So let's say the query returns 20 results, I limit it to 10 with the "print when" expression, but still he generates the space for 20 results ... So how do I REALLY cut of fafter 10 results?

]http://users.skynet.be/sd/jasper.jpg Hi, I'm still getting this problem. The subreport in the footer makes the report spread over 2 pages, the first being blank in the detail band :dry: My design is : ]http://users.skynet.be/sd/jasper2.jpg But when I make the footer, the page, or the detail a bit larger, it will generate 3 pages, 2 of which being blank. As you can see, I've got a lot of unused space in the detail band on PDF page 2, how can I shrink this and give my footer a bit more place??

Thanks, I get a funny result : I still get a 2nd page, with with footer and header this time.