hahagal

Hi, I need to know if iReport 5.1.0 work with WebSphere 8. I put some of the iReport jar files into lib/ext folder. But when I navigate the WebSphere 8 admin console, I get errors. [5/20/13 16:51:05:343 com.ibm.websphere.servlet.error.ServletErrorReport: java.lang.NoSuchMethodError: org/apache/commons/beanutils/PropertyUtils.removeBidiChars(Ljava/lang/String;)Ljava/lang/String;[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1320)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97)[5/20/13 16:51:05:344 at com.ibm.ws.console.core.servlet.WSCUrlFilter.setUpCommandAssistance(WSCUrlFilter.java:950)[5/20/13 16:51:05:344 at com.ibm.ws.console.core.servlet.WSCUrlFilter.continueStoringTaskState(WSCUrlFilter.java:499)[5/20/13 16:51:05:344 at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFilter(WSCUrlFilter.java:320)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:908)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662)[5/20/13 16:51:05:344 at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195)[5/20/13 16:51:05:344 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453)[5/20/13 16:51:05:344 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515)[5/20/13 16:51:05:344 at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306)[5/20/13 16:51:05:344 at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83)[5/20/13 16:51:05:344 at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:166)[5/20/13 16:51:05:344 at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217)[5/20/13 16:51:05:345 at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161)[5/20/13 16:51:05:345 at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138)[5/20/13 16:51:05:345 at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204)[5/20/13 16:51:05:345 at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775)[5/20/13 16:51:05:345 at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905)[5/20/13 16:51:05:345 at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1691)[5/20/13 16:51:05:345 Caused by: java.lang.NoSuchMethodError: org/apache/commons/beanutils/PropertyUtils.removeBidiChars(Ljava/lang/String;)Ljava/lang/String;[5/20/13 16:51:05:345 at com.ibm.ws.console.core.servlet.WSCUrlFilter$HttpServletRequestWrapperConsole.getParameter(WSCUrlFilter.java:1147)[5/20/13 16:51:05:345 at com.ibm.ws.console.core.servlet.CSRFUtils.verifyCSRFTokenInRequest(CSRFUtils.java:56)[5/20/13 16:51:05:345 at com.ibm.ws.console.core.ConfigFileHelper.isSessionValid(ConfigFileHelper.java:1100)[5/20/13 16:51:05:345 at com.ibm.ws.console.core.action.NavigatorAction.execute(NavigatorAction.java:29)[5/20/13 16:51:05:345 at org.apache.struts.action.RequestProcessor.processActionPerform(Unknown Source)[5/20/13 16:51:05:345 at org.apache.struts.action.RequestProcessor.process(Unknown Source)[5/20/13 16:51:05:345 at org.apache.struts.action.ActionServlet.process(Unknown Source)[5/20/13 16:51:05:345 at org.apache.struts.action.ActionServlet.doGet(Unknown Source)[5/20/13 16:51:05:345 at javax.servlet.http.HttpServlet.service(HttpServlet.java:575)[5/20/13 16:51:05:345 at javax.servlet.http.HttpServlet.service(HttpServlet.java:668)[5/20/13 16:51:05:345 at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1225)[5/20/13 16:51:05:345 ... 28 more[5/20/13 16:51:05:343 SGT] 0000002f servlet E com.ibm.ws.webcontainer.servlet.ServletWrapper service Uncaught service() exception thrown by servlet action: java.lang.NoSuchMethodError: org/apache/commons/beanutils/PropertyUtils.removeBidiChars(Ljava/lang/String;)Ljava/lang/String; at com.ibm.ws.console.core.servlet.WSCUrlFilter$HttpServletRequestWrapperConsole.getParameter(WSCUrlFilter.java:1147) at com.ibm.ws.console.core.servlet.CSRFUtils.verifyCSRFTokenInRequest(CSRFUtils.java:56) at com.ibm.ws.console.core.ConfigFileHelper.isSessionValid(ConfigFileHelper.java:1100) at com.ibm.ws.console.core.action.NavigatorAction.execute(NavigatorAction.java:29) at org.apache.struts.action.RequestProcessor.processActionPerform(Unknown Source) at org.apache.struts.action.RequestProcessor.process(Unknown Source) at org.apache.struts.action.ActionServlet.process(Unknown Source) at org.apache.struts.action.ActionServlet.doGet(Unknown Source) at javax.servlet.http.HttpServlet.service(HttpServlet.java:575) at javax.servlet.http.HttpServlet.service(HttpServlet.java:668) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1225) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:775) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:457) at com.ibm.ws.webcontainer.servlet.ServletWrapperImpl.handleRequest(ServletWrapperImpl.java:178) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.invokeTarget(WebAppFilterChain.java:136) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:97) at com.ibm.ws.console.core.servlet.WSCUrlFilter.setUpCommandAssistance(WSCUrlFilter.java:950) at com.ibm.ws.console.core.servlet.WSCUrlFilter.continueStoringTaskState(WSCUrlFilter.java:499) at com.ibm.ws.console.core.servlet.WSCUrlFilter.doFilter(WSCUrlFilter.java:320) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:195) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:91) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.doFilter(WebAppFilterManager.java:928) at com.ibm.ws.webcontainer.filter.WebAppFilterManager.invokeFilters(WebAppFilterManager.java:1025) at com.ibm.ws.webcontainer.servlet.CacheServletWrapper.handleRequest(CacheServletWrapper.java:87) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:908) at com.ibm.ws.webcontainer.WSWebContainer.handleRequest(WSWebContainer.java:1662) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:195) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:453) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewRequest(HttpInboundLink.java:515) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.processRequest(HttpInboundLink.java:306) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:83) at com.ibm.ws.tcp.channel.impl.AioReadCompletionListener.futureCompleted(AioReadCompletionListener.java:166) at com.ibm.io.async.AbstractAsyncFuture.invokeCallback(AbstractAsyncFuture.java:217) at com.ibm.io.async.AsyncChannelFuture.fireCompletionActions(AsyncChannelFuture.java:161) at com.ibm.io.async.AsyncFuture.completed(AsyncFuture.java:138) at com.ibm.io.async.ResultHandler.complete(ResultHandler.java:204) at com.ibm.io.async.ResultHandler.runEventProcessingLoop(ResultHandler.java:775) at com.ibm.io.async.ResultHandler$2.run(ResultHandler.java:905) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1691)[5/20/13 16:51:05:343 SGT] 0000002f SystemOut O WSCUrlFilter exception using CSRFResponseWrapper: com.ibm.websphere.servlet.error.ServletErrorReport: java.lang.NoSuchMethodError: org/apache/commons/beanutils/PropertyUtils.removeBidiChars(Ljava/lang/String;)Ljava/lang/String;

Hi, I have a textfield with text "Today is: " + $F{DATE}. I wants to bold the text "Today is: ". How can it be done? I am using ireport 3.7.1. Pls advise me. Quite urgent. Thanks! (:

Hi, I need to subtract two dates. One of the date is $P{DATE_1} String format. Another date is $F{DATE_2} java.sql.Date format. How can I subtract these two dates?

Thanks. Setting the bottom line to fix relative to bottom also works.

Hi, I have this problem. I have a couple of figures fields. All I set to stretch with overflow. In some cases, one of the fields might be overflow. If this happens, the lines will not in position. I have attached the screenshots. Please help. Thanks!

Does your subreport contains image? For my case when I export to xls, there is always a space at the first row. And managed to get rid of it by setting the properties IS_IGNORE_GRAPHICS to true.

My requirement is to have a subreport to print page x of y and add this subreport to the main report. Currently, I putting the page x of y directly on the main report itself. Hoping to see if there is any solution to my requirement.

Maybe try to set IS_IGNORE_PAGINATION to true and see?

During RTF export, textfields are not showing full text even though I have the properties keep full text. Xls export works.. but not for RTF.

I set them at the jrxml itself. Just hope if there is some solutions to this and meanwhile I will still continue to try things out.

What do you mean by report by report basis? Or do you have any suggestion to totally exclude the page footer when exporting to xls?

Hi, I need to exclude the page footer when exporting to xls. My page footer has a subreport and 2 textfields. I able to exclude the subreport.. but unable to exclude the 2 textfields. I have the followings set. <property name="net.sf.jasperreports.export.xls.exclude.origin.band.2" value="pageFooter"/> <property name="net.sf.jasperreports.export.xls.exclude.origin.report.2" value="footer_landscape_A4"/>

I need to pass the page number x of y from main report to subreport. But couldn't seems to get the y number correct. Most of my reports need this.

Hi Matt, Thanks! It works for me now. (:

Hi, How to display tick in PDF report? Currently is displaying as ? for tick. I'm using Arial with CP1252

Hi, The example in the link seems to be in Java language. Is there one for groovy? I'm still stuck on this.

Hi, Yes, am using stored procedures. When I try to print the subreports individually, it is ok. If the subreport is putted at the summary section, it is ok as well. Only when the subreport is been putted at other section then will have problems.

Hi, Just to also check if subreports can be placed in any section of the main report like Page Header, Column Header, Details and etc. I have tried to put the subreport in the Summary section and seems no error.

Hi, When a report is exported to excel, it seems to "appeared to be like a printscreen from the pdf format". However still able to edit the data. Is it possible to export with gridlines and also if the report is more than one page, don't repeat the title?

Hi, Where can I find commons-lang jar for the DateUtils? I can't seems to find it in the ext directory of ireport. FYI, I'm using ireport 3.7.1.

Hi, I have attached the mainreport and subreport jrxml here. Using the followings: - ireport 3.7.1 - JDBC connection - Use the same connection use to fill the master report Post Edited by hahagal at 07/22/2011 01:15

Anyone out there encounter the same problem as me or is there any solutions to this issue?

Hi, Thanks mdahlman, I have tried Arial Unicode MS to replaced Arial font and it works. It works without iTextAsian.jar file as well. In what circumstances will this jarfile come into use? Is there any documentation whereby it will describe the use of each jarfile?

Hi, I am not able to use Serif font in PDF. When it printed, the font is displayed in Arial font. I noticed Serif is from a read-only extension. What does that means?

In the report, I am using groovy language. Is it possible to add one month to a parameter datestring? I would like the output to be a date format.