hahagal

Hi, How about Arial Narrow font? Is there any font to replace with it?

Hi, When previewed on the report, I encounter the following error. I am using subreports in the report, and using DB2 (JDBC connection) Is there any settings needs to be done? Error filling print... Unable to get next record. net.sf.jasperreports.engine.JRException: Unable to get next record. at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:95) at net.sf.jasperreports.engine.fill.JRFillDataset.advanceDataSource(JRFillDataset.java:861) at net.sf.jasperreports.engine.fill.JRFillDataset.next(JRFillDataset.java:779) at net.sf.jasperreports.engine.fill.JRBaseFiller.next(JRBaseFiller.java:1448) at net.sf.jasperreports.engine.fill.JRVerticalFiller.fillReport(JRVerticalFiller.java:112) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:923) at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:826) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:59) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:247) at com.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:857) at org.openide.util.RequestProcessor$Task.run(RequestProcessor.java:572) at org.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:997) Caused by: com.ibm.db2.jcc.am.SqlException: [jcc][t4][10120][10898][3.57.110] Invalid operation: result set is closed. ERRORCODE=-4470, SQLSTATE=null at com.ibm.db2.jcc.am.bd.a(bd.java:660) at com.ibm.db2.jcc.am.bd.a(bd.java:60) at com.ibm.db2.jcc.am.bd.a(bd.java:103) at com.ibm.db2.jcc.am.am.Db(am.java:4219) at com.ibm.db2.jcc.am.am.c(am.java:314) at com.ibm.db2.jcc.am.am.next(am.java:293) at net.sf.jasperreports.engine.JRResultSetDataSource.next(JRResultSetDataSource.java:91) ... 12 more Print not filled. Try to use an EmptyDataSource... Post Edited by hahagal at 07/21/2011 14:36

Hi, In ireport can we offset a datestring of one month? Currently I am doing it this way. I have converted the datestring to a date. How can I add one month to this date?

Hi, Is there any way to store value to a variable and then compare it with the next record? Then display if it is not the same and hide if its the same. If its done this way, I might get the result I wanted. Is the above possible?

Hi David, I am using JDBC Connection for the datasource. We are using stored procedures to make the call to the database. How can we use group on All and group on each value in this case?

Hi, How can I group the report based on All and each value? Do I need to add any expression for it or?

Hi, I am using iReport 3.7.1. I have iTextAsian.jar putted to my server directory. However I am unable to see the chinese character got printed out in PDF format. My report will need to display english and chinese characters. I am using Arial font and with PDF Encoding CP1252 emdedded in the PDF document checked. Would need some help here.

Hi, Seems like it still doesn't give me the results. Is there any way to store value to a variable and then compare it with the next record? Then display if it is not the same and hide if its the same.

Hi, I have tried. Still unable to work. Here is the relavant xml portion. 2 variables to set count <variable name="IntercoCount" class="java.lang.Integer" resetType="Group" resetGroup="INTERCO" calculation="Count"> <variableExpression><![CDATA[new java.lang.Integer(1)]]></variableExpression> <initialValueExpression><![CDATA[new java.lang.Integer(0)]]></initialValueExpression> </variable> <variable name="CcyCount" class="java.lang.Integer" resetType="Group" resetGroup="INTERCO" calculation="Count"> <variableExpression><![CDATA[new java.lang.Integer(1)]]></variableExpression> <initialValueExpression><![CDATA[new java.lang.Integer(0)]]></initialValueExpression> </variable> textfield to display when above 2 variables is 1 <textField evaluationTime="Auto" isBlankWhenNull="true"> <reportElement x="100" y="0" width="63" height="12"/> <textElement textAlignment="Left"> <font fontName="Arial" size="8"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[( (!$V{IntercoCount}.equals(new Integer(1)) && !$V{CcyCount}.equals(new Integer(1))) ? " " : $V{CTPY_Type_Text} )]]></textFieldExpression> </textField>

Hi, Thanks for the reply. I have tried your solution. Seems still not working. I have also try printing out the VARIABLE1 and VARIABLE2 value. It is still not setting to 1 for the first record of each new group.

Hi, I have one VARIABLE1_COUNT and VARIABLE2_COUNT. I would need to reset this 2 variable to 0 when it reached the grouper footer so that it will be resetted to 0 when the new group starts. I did the following and still doesn't seem to be reseted correctly. I have set it the followings respectively for the 2 variables: Variable Class: java.lang.Integer Calculation: Count Reset type: Group Reset group: <The group I want to reset> Increment type: None Variable Expression: $V{VARIABLE1} Initial Value Expression: new java.lang.Integer(0) I have also set the field which I want to print when expression is $V{VARIABLE1}.equals(new java.lang.Integer(1)) && $V{VARIABLE2}.equals(new java.lang.Integer(1)) Apreciate your help here..

Hi, I am using groovy language in ireport and would like to set the initial value expression of a variable of type java.lang.Integer to 0. I tried with new Integer(0), doesn't seems to work. Any ideas on this? Thanks!

Is this possible to be done? Or I have to put it on the main report itself?

Main report does not has Page X of Y. This is in the subreport. And this subreport will be added to the main report so that the main report will have Page X of Y.

Hi, I have a main report with all the details and a subreport with the footer, containing page X of Y. When I add the subreport to the main report, the page numbers are not displaying correctly. Need some help here. Thanks!

Hi, I have installed iReport 3.7.1. I am currently using WAS 6.0 and DB2 9.5. Can JasperServer 3.7.1 be used with WAS 6.0 and DB2 9.5?

Hi, How to encrypt the database password when creating the connections/datasources?

Hi, Any idea if this can be done?

Hi, How can I convert .rml and .ds files to work with jasperreports? Any suggestions?

Hi All, Any updates on how can I use ireport with RAD 6.0? What settings or configurations needs to be done?

Hi, I have added the jar files to my Web project, WebContent\WEB-INF\lib folder as well as to the websphere server. I encounter this error. [4/29/11 12:11:39:516 SGT] 0000002a ServletWrappe E SRVE0068E: Could not invoke the service() method on servlet /module/reports/rpt1007.jsp. Exception thrown : javax.servlet.ServletException: java.lang.UnsupportedClassVersionError: net/sf/jasperreports/engine/design/JasperDesign (Unsupported major.minor version 49.0) at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:648) at com.ibm._jsp._rpt1007._jspService(_rpt1007.java:135) at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:93) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1521) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:113) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:759) at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121) at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:215) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:347) at com.ibm.faces.context.MultipartExternalContextImpl.dispatch(MultipartExternalContextImpl.java:411) at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:262) at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87) at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:220) at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1521) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:136) at com.belsize.servlet.filter.RedirectLogin.doFilter(RedirectLogin.java:184) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:759) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3177) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:253) at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:229) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1970) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:114) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952) at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1471) ---- Begin backtrace for Nested Throwables javax.faces.el.EvaluationException: java.lang.UnsupportedClassVersionError: net/sf/jasperreports/engine/design/JasperDesign (Unsupported major.minor version 49.0) at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:186) at com.sun.faces.el.ValueBindingImpl.getValue(ValueBindingImpl.java:137) at com.sun.faces.taglib.jsf_core.ViewTag.setProperties(ViewTag.java:277) at javax.faces.webapp.UIComponentTag.findComponent(UIComponentTag.java:693) at javax.faces.webapp.UIComponentTag.doStartTag(UIComponentTag.java:423) at com.sun.faces.taglib.jsf_core.ViewTag.doStartTag(ViewTag.java:106) at com.ibm._jsp._rpt1007._jspx_meth_f_view_0(_rpt1007.java:481) at com.ibm._jsp._rpt1007._jspService(_rpt1007.java:127) at com.ibm.ws.jsp.runtime.HttpJspBase.service(HttpJspBase.java:93) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1521) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:113) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:759) at com.ibm.wsspi.webcontainer.servlet.GenericServletWrapper.handleRequest(GenericServletWrapper.java:121) at com.ibm.ws.jsp.webcontainerext.JSPExtensionServletWrapper.handleRequest(JSPExtensionServletWrapper.java:215) at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:347) at com.ibm.faces.context.MultipartExternalContextImpl.dispatch(MultipartExternalContextImpl.java:411) at com.sun.faces.application.ViewHandlerImpl.renderView(ViewHandlerImpl.java:262) at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:87) at com.sun.faces.lifecycle.LifecycleImpl.phase(LifecycleImpl.java:220) at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:118) at javax.faces.webapp.FacesServlet.service(FacesServlet.java:198) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1572) at com.ibm.ws.webcontainer.servlet.ServletWrapper.service(ServletWrapper.java:1521) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:136) at com.belsize.servlet.filter.RedirectLogin.doFilter(RedirectLogin.java:184) at com.ibm.ws.webcontainer.filter.FilterInstanceWrapper.doFilter(FilterInstanceWrapper.java:142) at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java:121) at com.ibm.ws.webcontainer.filter.WebAppFilterChain._doFilter(WebAppFilterChain.java:82) at com.ibm.ws.webcontainer.servlet.ServletWrapper.handleRequest(ServletWrapper.java:759) at com.ibm.ws.webcontainer.webapp.WebApp.handleRequest(WebApp.java:3177) at com.ibm.ws.webcontainer.webapp.WebGroup.handleRequest(WebGroup.java:253) at com.ibm.ws.webcontainer.VirtualHost.handleRequest(VirtualHost.java:229) at com.ibm.ws.webcontainer.WebContainer.handleRequest(WebContainer.java:1970) at com.ibm.ws.webcontainer.channel.WCChannelLink.ready(WCChannelLink.java:114) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleDiscrimination(HttpInboundLink.java:472) at com.ibm.ws.http.channel.inbound.impl.HttpInboundLink.handleNewInformation(HttpInboundLink.java:411) at com.ibm.ws.http.channel.inbound.impl.HttpICLReadCallback.complete(HttpICLReadCallback.java:101) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.requestComplete(WorkQueueManager.java:566) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.attemptIO(WorkQueueManager.java:619) at com.ibm.ws.tcp.channel.impl.WorkQueueManager.workerRun(WorkQueueManager.java:952) at com.ibm.ws.tcp.channel.impl.WorkQueueManager$Worker.run(WorkQueueManager.java:1039) at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1471)

Hi, I have installed ireport 4.0.2, and would like to use it with RAD. What are the necessary jar files of ireport 4.0.2 I would need to copy over to RAD?

Hi, Its a query. Thanks for the reply! (:

Hi, I have installed ireport 4.0.2. How can I create a new JDBC driver under database JDBC Connection? Using DB2. Do I need to copy the driver jar files to some location as well?