manshack_one

Should I enter a bug tracker for this one?

http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=69137 I'm having the same problem. Hopefully one of the admins will take a look at the problem. Be sure to post back if you figure it out. Thanks.

does anyone have a list working that goes past the end of the page it starts on?

Bump I really need help getting this one figured out. I just don't see any good reason why it rounds .005 up in some cases but not in others.

I'm having a similar rounding issue as another user here. Attached is a sample report. I ran this query against my database: select Rate, CallDate, Minutes, Revenue, Commission, call2, call1 from call_detail where CallDate between '2009-12-01' and '2009-12-15' and Minutes between 1 and 15 and call2 = 'Complete' and call1 = 'Debit' group by Minutes, Rate order by Minutes, Rate; Revenue and Commission are formatted Double(6,3) in MySQL. Using iReport 3.7 with Groovy as the default language. In the attached report you will see that it's not always rounding correctly. The first Revenue and Commission columns are straight values from the database without any formatting. The second two are formatted using the pattern in iReport for Currency with 2 decimal places. Compare "Interstate 1 minute Commission" with it's formatted commission against "Interstate 15 minutes Revenue" with it's formatted revenue. .155 becomes $0.16 but 5.805 becomes $5.80 instead of $5.81. Double is accurate enough for me since the beginning calculations are small since at most I'm mulitplying 43 cents by 15 minutes. But if it's not rounding correctly then by the time it adds up 15,000 records or so it can be a problem. Please see the attached report to see what I'm talking about. I've attached the jrxml also if it would help with any troubleshooting regardless of being able to actually fill it on your end. Thanks in advance.

I've seen that link but I'm interested in more than just putting it on the screen. I'd like to know about adding groups, bands, etc. and about the technical specs of the component.

I'm on iReport 3.7 but still curious about the List Component.

bump anyone? i'm on iReport 3.7 now also.

I need to create some cascading input controls. I'm running JS 3.7 RC. Basically I have units (locations) that are broken down like this: System > Division > District > Units. The goal is to have 4 input controls that change as selections are made. For instance a user could select a certain System and the corresponding Division, Districts and Units would populate, then by going further and choosing the Division they want the District and Unit lists would repopulate with the corresponding Units and finally by choosing the District the Unit list would repopulate again with the correct units. Here's what I've done so far: Queries: HCD-system-select: select distinct(system) from UNITS order by system;[/code]HCD-divreg-select: select distinct(divreg) from UNITS where $X{IN,system,HCD-system} order by divreg;[/code]HCD-district-select: select distinct(district) from UNITS where $X{IN,divreg,HCD-divreg} order by district;[/code]HCD-unit-select: select unitdesc from UNITS where $X{IN,system,HCD-system} and $X{IN,divreg,HCD-divreg} and $X{IN,district,HCD-district} order by unitdesc;[/code]Input Controls (all multi-select queries, none are mandatory): HCD-system, uses HCD-system-select HCD-divreg, uses HCD-divreg-select HCD-district, uses HCD-district-select HCD-units, uses HCD-unit-select (only parameter in iReport, declared as collection)Report Query: Select tblUnit, vitals from CAD where $X{IN,tblUnit,HCD-units};[/code]My theory was that by using $X{IN} for each subsequent Input control that it would filter down as each was selected. If a user wanted to see all Units (including all systems) they shouldn't have to choose any of the units. I already have an input control that grabs the unit descriptions as a multiselect query and this works fine. I built a test report in iReport and included HCD-units as a parameter. I didn't include the other ones since they're only meant to be used in JS as filters for the HCD-units input control. I uploaded the report to JS and added the other input controls in but when I try and run the report I get the following before seeing any input controls on the screen: java.lang.NullPointerException java.lang.NullPointerException at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:487) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:401) at com.jaspersoft.jasperserver.war.action.ReportParametersAction.createWrappers(ReportParametersAction.java:106) at com.jaspersoft.jasperserver.war.action.ViewReportAction.checkForParams(ViewReportAction.java:171) 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:585) at org.springframework.webflow.action.DispatchMethodInvoker.invoke(DispatchMethodInvoker.java:98) at org.springframework.webflow.action.MultiAction.doExecute(MultiAction.java:123) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.action.EvaluateAction.doExecute(EvaluateAction.java:79) at org.springframework.webflow.action.AbstractAction.execute(AbstractAction.java:188) at org.springframework.webflow.execution.AnnotatedAction.execute(AnnotatedAction.java:145) at org.springframework.webflow.execution.ActionExecutor.execute(ActionExecutor.java:51) at org.springframework.webflow.engine.ActionState.doEnter(ActionState.java:101) at org.springframework.webflow.engine.State.enter(State.java:194) at org.springframework.webflow.engine.Flow.start(Flow.java:535) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:364) at org.springframework.webflow.engine.impl.FlowExecutionImpl.start(FlowExecutionImpl.java:222) at org.springframework.webflow.executor.FlowExecutorImpl.launchExecution(FlowExecutorImpl.java:140) at sun.reflect.GeneratedMethodAccessor293.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.launchExecution(Unknown Source) at org.springframework.webflow.mvc.servlet.FlowHandlerAdapter.handle(FlowHandlerAdapter.java:193) 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) Let me know what I'm doing wrong. I've tried to follow the samples and the instructions on the wiki but can't seem to make this work. Thanks in advance! Robert P.S. I've attached the jrxml from iReport and the table showing the breakdown on units so you can see how they lay out.

I have to set all my subreports and whatever page breaks you manually insert to "Float" in the properties. I could never get it to quit overlapping otherwise. Also, when my subreport prints it doesn't print like it's a brand new page instead starting at whatever the main report left margin is set to which makes it look like the whole subreport is shifted to the right and running off the page. Haven't figured that one out yet either.

bump (just to see all 4 of my posts together) :)

I tried adding a second list on my summary page and they overlap each other instead of printing the first list then the second one. See attached pictures and please advise a work around (hopefully other than use subreports). :)

Is it possible to add a logical grouping band inside a list? I'm needing to use this functionality to create group variables for getting the sum of a group of values.

Now that I've figured out how to make the list component pull data finally I'd like to learn some more about it's capabilities. Is there any documentation on it freely available? I'm sure it's probably covered in the jaspersoft books you have to buy but there's a reason I'm using the community version. :) Some of the basic things I'm looking for is the ability to create a logical grouping so I can add variables. I'm also still having issues with the list not filling past the end of the page it starts on. I'm using iReport 3.6.2

Do I need to enter a bug tracker for this issue? I'm using iReport 3.6.2. Post Edited by manshack_one at 12/17/2009 19:43

By checking 'Ignore Pagination' on the report properties it will show the rest of the list. This is only a temp workaround since we rely on page counts for certain information. I need it to paginate properly when there's a list involved that is longer than the summary page.

I've created a list component in the summary section of my main report. The list will fill but cuts off at the bottom of the summary page and a blank page is created after the summary. Is this a bug? Why won't the report create a new page and contiue the list?

I very eagerly await this release. :) The timing couldn't be better. I just got the nested subreport thing figured out and now I need to make nested input controls.

Tracker items 4419 and 4421 have been created for problems publishing from iReport using the repository navigator. The first problem I've already described about "nested subreport awareness". The other tracker is for a problem with not being asked to change the relative path if you're just updating a report that included a subreport. That being said here's what I ended up doing: 1) from iReport using repository navigator upload master report that includes nested subreports (see first post for example) 2) from JS edit master report and add in nested subreports as a resource on the resources and input control section. 3) from iReport, navigate to report you just uploaded and expand the resources section. 4) double click to open temp copy of first level subreport (2A in the example). 5) from iReport designer click the XML button to view the jrxml file in the designer window 6) scroll to bottom of file and look for subreport expression 7) alter subreport expression by dropping the subreport directory parameter and changing the part inside the quotes to read something similar to this depending on your installation "repo:/reports/main_files/2B.jrxml" 8) click the save icon then the designer icon. 9) navigate back to the subreport "2A" in the repository navigator and right click it choosing "update file from current jrxml". 10) repeat steps 4-9 for each additional first level subreport that contains a nested subreport. I ended up finding the "main_files" part inside the actual mysql jasperserver tables from just poking around. Nice trick using a hidden flag to have them not show up in the JS report screen. :) Since I was adding the subreports as resources to the master report I had to use it's "main_files" directory instead of just "/reports/" since the subreport wasn't added separately in JS. It never dawned on me that you might be storing the files in the actual database. I'd been trying to create a literal path based off the directories on the server hard drive.

I accidentally copied the scripts folder in the zip file to the wrong scripts folder on the server and my input controls weren't working. Got them in the right place and my regular reports are running again. Now I'll go play with cascading input controls. Is this version supporting the multi-select input controls or just the single select ones right now? Post Edited by manshack_one at 11/13/2009 17:11

Sorry for the newbie question but to install this do I just stop the server, copy the files from the WAR directory to the corresponding directory letting it overwrite anything already there? Then start it back up and get to cascading I suppose? Also, you said there's been work on the controls that will be in 3.7. Is there not enough functionality now to use it as is?

Sounds like you're looking for cascading input controls. I'm in a similar situation. I read the sticky on it but can't decide if it's working or not by the time I get to the end of the thread. What I'm trying to do is create some different input controls to select by a division or district and have it pass into the collection parameter the associated locations. But i need all the options on the same input control dialog so the users can decide which ones to pick.

Consider this scenario: main >>subreport1A >>subreport2A >>>>subreport2B >>subreport3A To describe this, the main report has 3 subreports. Subreport 2A has a nested subreport (2B). When I publish main from iReport using the repository navigator it includes subreports1A, 2A and 3A but does not include the nested subreport 2B. During the publishing process iReport also edits the main.jrxml altering the first level subreports to include "repo:" in the name. However it does not upload 2B. This leads to an "object could not be loaded from location" error when I run main in JS. In my case each of the subreports are already loaded individually as main reports themselves. The main in this situation I'm describing is a wrapper report that simply includes the others as subreports. Kind of an easy way of merging reports together so you only run 1 versus 7 individual ones. Which brings me to my question. How do I find the location of the existing nested subreport 2B? Since it was included whenever 2A was published separately I should just be able to reference it from this copy of subreport2A that main is including right? I've never had to add subreports as a resource in JS because this ability to publish them from iReport using the repository navigator was much simpler for me. I like working this way so that I can use the report in iReport and on JS without having to worry about changing the jrxml every time it's uploaded. While I'm thinking about it, where does JS store the reports you publish?

When I publish a report containing a subreport from iReport using the repository navigator there is a dialog box that displays the modified path for your subreport. It changes your main.jrxml to contain repo: for the subreport element. That works fine until you change something in the main report and just update it. in that case it doesn't change the jrxml to include repo: and now you get the object could not be loaded error. I'm having to drop the report entirely on JS and republish it each time. Only takes a few seconds but that's my work around. Right now my issue is that it's not aware of a nested subreport when it publishes. That means your main.jrxml is changed to include repo: for the subreport it has but the subreport's jrxml is not modified for it's contained subreport. Does that make sense? I added bugtrackers for both issues. Not sure this helps but just know that you're not alone in this regard.

I've submitted a bug tracker for an issue where iReport is not changing the relative path of the nested subreport. When you publish the master report using the repository navigator there is a dialog box that prompts to upload the subreport and change the path. It's only going one level deep though and not changing the subreport's subreport path. Result is when you go run the report on JS there's an error about not being able to load the subreport's subreport object. Right now I'm running into a different bug. Whenever I choose to print the first subreport everything lines up correctly after that. Each following subreport starts at the top of the new page that the page break is creating. However, If I don't choose to print the 1st subreport, any other subreport chosen starts printing in the position the subreport element was placed on the summary band. To get around this I made every subreport element a height of 1. Then starting at the top I set the first page break to 0, the first subreport to 1, the second page break to 2, the second subreport to 3, etc.... on through the last subreport. I tried just stacking them all on top of each other but they would ignore the page breaks that way and print on top of each other. The way it now works. Each element is only 1 in height and spaced 1 apart vertically. End result is that if I only choose to print the last subreport it will start 15 down from the top. I'm not certain what the measurement actually is meaning pixels, pica, points,etc.