andysusanto

i found it. thanks

hai, how can i create a group band with ireport 3.71 ? Regards, Andy Susanto

my application CPU usage 100%, every time a lot of use, how can I know the problem exists. Tomcat and MySQL database applications in one box, and the computer uses 2 GB of memory. Use of 512 and Xms and Xmx 256M PermSize only ten computer that connected to my application I use: JasperReport 3.7.1 tomcat 5.x mysql 5.1 how can I find the bottleneck? regards, Andy Susanto Post Edited by andysusanto at 07/14/2010 16:40

hai, i got this error too, when using a subreport. but this error i got after i upgrade to jasperreports-3.5.2 Regards, Andy Susanto

hai, i solved my problem, and i can print my own report Thanks, Andy Susanto

hai, i would like to create a report with custom datasource. but i got a problem while compile my report. I need enligment to solved my problem TIA, Andy Susanto

Hai, why this error raise ? and can i minimized this error ? net.sf.jasperreports.engine.JRException: Error writing to OutputStream writer : Bill_Trans at net.sf.jasperreports.engine.export.JRHtmlExporter.exportReport(JRHtmlExporter.java:416) at mainapp.locker.transaksi.print.PrintOut.InputField(PrintOut.java:178) at mainapp.locker.transaksi.print.PrintOut.handleRequest(PrintOut.java:240) 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.doGet(FrameworkServlet.java:350) at javax.servlet.http.HttpServlet.service(HttpServlet.java:690) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583) at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447) at java.lang.Thread.run(Thread.java:595) Caused by: ClientAbortException: java.net.SocketException: Connection reset by peer: socket write error at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:358) at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:434) at org.apache.catalina.connector.OutputBuffer.doFlush(OutputBuffer.java:309) at org.apache.catalina.connector.OutputBuffer.flush(OutputBuffer.java:288) at org.apache.catalina.connector.CoyoteOutputStream.flush(CoyoteOutputStream.java:98) at sun.nio.cs.StreamEncoder$CharsetSE.implFlush(StreamEncoder.java:410) at sun.nio.cs.StreamEncoder.flush(StreamEncoder.java:152) at java.io.OutputStreamWriter.flush(OutputStreamWriter.java:213) at net.sf.jasperreports.engine.export.JRHtmlExporter.exportReportToWriter(JRHtmlExporter.java:718) at net.sf.jasperreports.engine.export.JRHtmlExporter.exportReport(JRHtmlExporter.java:412) ... 21 more Caused by: java.net.SocketException: Connection reset by peer: socket write error at java.net.SocketOutputStream.socketWrite0(Native Method) at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at org.apache.coyote.http11.InternalOutputBuffer.realWriteBytes(InternalOutputBuffer.java:737) at org.apache.tomcat.util.buf.ByteChunk.flushBuffer(ByteChunk.java:434) at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:349) at org.apache.coyote.http11.InternalOutputBuffer$OutputStreamOutputBuffer.doWrite(InternalOutputBuffer.java:761) at org.apache.coyote.http11.filters.ChunkedOutputFilter.doWrite(ChunkedOutputFilter.java:126) at org.apache.coyote.http11.InternalOutputBuffer.doWrite(InternalOutputBuffer.java:570) at org.apache.coyote.Response.doWrite(Response.java:560) at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java:353) ... 30 more

hai, my aplication work properly. but today i got an error like this one, how can i minimize this error and why this error raise error message : net.sf.jasperreports.engine.JRException: Error loading object from file : C:Program FilesApache Software FoundationTomcat 5.5webappshotelreportsBill_Bar.jasper at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:96) at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:68) at mainapp.transaksi.bar.transaksi.report.Bar_Order_Print.InputField(Bar_Order_Print.java:74) at mainapp.transaksi.bar.transaksi.report.Bar_Order_Print.handleRequest(Bar_Order_Print.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.doGet(FrameworkServlet.java:350) 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 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.io.EOFException at java.io.ObjectInputStream$PeekInputStream.readFully(ObjectInputStream.java:2228) at java.io.ObjectInputStream$BlockDataInputStream.readShort(ObjectInputStream.java:2694) at java.io.ObjectInputStream.readStreamHeader(ObjectInputStream.java:761) at java.io.ObjectInputStream.<init>(ObjectInputStream.java:277) at net.sf.jasperreports.engine.util.JRLoader.loadObject(JRLoader.java:91) ... 24 more

hai, today i just posted into Tracker with Category General Regrads, Andy Susanto

what version of ireport that your used ?, you just copy your classes itu "WEB-INFclasses". After that just put your package classes into Chart Properties Regards, Andy Susanto

hai, yes try to use ireport 3.1.1, only this version you can not all query :) Regards, Andy Susanto

hai, i am using ireport 3.1.1. i found that report query can not hold long query because in report query there is not scrollbar you can use my query to see in your development : SELECT A.LOCKERTRANS_ID,A.LOCKERTRANS_FACILITY,A.LOCKERTRANS_TAXFASILITASSPA,A.LOCKERTRANS_JENISPAYMENT,A.LOCKERTRANS_ROOMPRICE, A.LOCKERTRANS_ROOMDISC,A.LOCKERTRANS_TYPE,A.LOCKERTRANS_NO,A.LOCKERTRANS_PAYMENT, A.LOCKERTRANS_PAYMENTINADVANCE,A.LOCKERTRANS_SERVICECHARGE, A.LOCKERTRANS_INFO,DATE_FORMAT(A.LOCKERTRANS_DATEOUT,'%d-%m-%Y')as LOCKERTRANS_DATEOUT, A.LOCKERTRANS_TIMEOUT,DATE_FORMAT(A.LOCKERTRANS_ROOMDATEIN,'%d-%m-%Y') LOCKERTRANS_ROOMDATEIN, DATE_FORMAT(A.LOCKERTRANS_ROOMDATEOUT,'%d-%m-%Y') LOCKERTRANS_ROOMDATEOUT, A.LOCKERTRANS_ROOMTIMEIN,A.LOCKERTRANS_ROOMTIMEOUT,A.LOCKERTRANS_ROOMTAX,A.LOCKERTRANS_NDAYS, A.LOCKERTRANS_HOTEL_STATUS,B.LOCKER_NO, C.ROOM_NO,C.ROOM_NAME, D.USER_NAME,E.MEMBER_NO,DATE_FORMAT(E.MEMBER_EXPIRE_TO,'%d-%m-%Y') MEMBER_EXPIRE_TO, SUM(F.DEPOSIT_VALUE) DEPOSIT FROM LOCKERTRANS A LEFT OUTER JOIN LOCKER B ON B.LOCKER_ID = A.LOCKERTRANS_LOCKERID LEFT OUTER JOIN ROOM C ON C.ROOM_ID = A.LOCKERTRANS_ROOMID INNER JOIN USER D ON D.USER_ID = A.LOCKERTRANS_CASHIERID LEFT OUTER JOIN MEMBER E ON E.MEMBER_ID = A.LOCKERTRANS_MEMBERID LEFT OUTER JOIN DEPOSIT F ON F.DEPOSIT_LOCKERTRANSID = A.LOCKERTRANS_ID WHERE LOCKERTRANS_ID = $P!{LOCKERTRANS_ID} GROUP BY A.LOCKERTRANS_ID,A.LOCKERTRANS_FACILITY,A.LOCKERTRANS_TAXFASILITASSPA,A.LOCKERTRANS_JENISPAYMENT,A.LOCKERTRANS_ROOMPRICE, A.LOCKERTRANS_ROOMDISC,A.LOCKERTRANS_TYPE,A.LOCKERTRANS_NO,A.LOCKERTRANS_PAYMENT, A.LOCKERTRANS_PAYMENTINADVANCE,A.LOCKERTRANS_SERVICECHARGE, A.LOCKERTRANS_INFO,LOCKERTRANS_DATEOUT, A.LOCKERTRANS_TIMEOUT,LOCKERTRANS_ROOMDATEIN, LOCKERTRANS_ROOMDATEOUT, A.LOCKERTRANS_ROOMTIMEIN,A.LOCKERTRANS_ROOMTIMEOUT,A.LOCKERTRANS_ROOMTAX,A.LOCKERTRANS_NDAYS, A.LOCKERTRANS_HOTEL_STATUS,B.LOCKER_NO, C.ROOM_NO,C.ROOM_NAME, D.USER_NAME,E.MEMBER_NO,MEMBER_EXPIRE_TO ORDER BY A.LOCKERTRANS_ID Regards, Andy Susanto

hai, i have a problem sometime print dialog from a web take several minute to display. btw i am use javascript command like window.print() is there any solution or an ide to solve that problem? TIA, andy susanto

hai kchaudhry, your tips i already use. but i just want to know how to use nodata band. nodata band to use automatic show the object that inside that band, i am right ? Regards,

hai, i try your suggestion to change it into All sections, no detail option but still it does not working at all any ide ? TIA,

hai, i try your suggestion to change it into All sections, no detail option but still it does not working at all any ide ? TIA,

hai, i would like to try a nodata band. report properties -> more -> when no data i select no data section but when i run the report my static text does not visible. how to use that band ? TIA,

hai Jason, can you post your information about your OS? like what kind window that you use?, what version java ? Regards,

StringBuffer sbFile = new StringBuffer("C:").append(File.separator).append(jenisLaporan).append(".xls"); JExcelApiExporter exporterAPIXLS = new JExcelApiExporter(); exporterAPIXLS.setParameter(JExcelApiExporterParameter.JASPER_PRINT, jasperPrint); exporterAPIXLS.setParameter(JExcelApiExporterParameter.OUTPUT_FILE_NAME, sbFile.toString()); exporterAPIXLS.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); exporterAPIXLS.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE); exporterAPIXLS.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); exporterAPIXLS.exportReport(); you can use my code to compile xls Regards,

hai, yes you can do it just make sure the you already define the name of paremeter that you want. if you want to check your parameter click View menu than see the Parameter Regards,

hai, select properties of subreport then click subreport(other) put your parameter of subreport on the left side, the right side is master parameter Regards,

hai, if you use field object, just click on tab "Text Field", click on button "Create" beside combobox pattern, just pick want date format after that just edit the value of combobox like this "dd-MM-yyyy" or type the dateformat you like.

hai, can i create a gantt chart from ireport ?, if i look a jfreechart that lib can build a gantt chart. But i cannot find how to create that gantt chart in ireport need enlightment

hai, try your report seperate to see your report work correctly. between your masterreport and subreport after that in subreport component on masterreport click tab subreport pick "use connection expression" and tab subreport(other) put your subreport file (fullpath example c:developmentreportmysubreport.jrxml) i hope this will help you regrads,

hai, you can combine with a javascript to refresh the report