balaji_r

Hi, I am using the following code to limit the rows per sheet in Excel format while export. Report is displayed in several sheet in the excel file. So It works fine. But the issue is, I want to do the same thing when I schedule a job. That is, after scheduling job, I got mail with Excel file Attachment. When I download and open that file, it contains all the rows in a single sheet. How am I set the parameter for this when I schedule a job also? exporter.setParameter(JRXlsExporterParameter.MAXIMUM_ROWS_PER_SHEET,new Integer("100"));

Hi, I am using JasperReport in a webapp. When I export the report in pdf or xls format, it will work fine.Usually it will open a dialog box with Open/Save/Cancel button. Now If I click cancel button that is canceling the report for pdf or xls format, It is also fine. But It will show the following exception in tomcat unfortunately. I am using Windows XP with IE7. Exception: 18:22:06,569 FATAL [FMSAction] SYS Exception caught net.sf.jasperreports.engine.JRException: Error writing to output stream : report7 18:22:09,553 INFO [sTDOUT] net.sf.jasperreports.engine.JRException: Error writing to output stream : report7 18:22:09,553 INFO [sTDOUT] at net.sf.jasperreports.engine.export.JRRtfExporter.exportReport(JRRtfExporter. java:203) 18:22:09,569 INFO [sTDOUT] at com.betasphere.fms.actions.reportnew.ReportNewViewAction.fmsExecute(ReportNe wViewAction.java:455) 18:22:09,569 INFO [sTDOUT] at com.betasphere.fms.actions.FMSAction.execute(FMSAction.java:227) 18:22:09,569 INFO [sTDOUT] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces sor.java:484) 18:22:09,569 INFO [sTDOUT] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) 18:22:09,569 INFO [sTDOUT] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) 18:22:09,584 INFO [sTDOUT] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) 18:22:09,584 INFO [sTDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) 18:22:09,584 INFO [sTDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 18:22:09,584 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:252) 18:22:09,584 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) 18:22:09,584 INFO [sTDOUT] at com.betasphere.utils.SetCharacterEncodingFilter.doFilter(SetCharacterEncodin gFilter.java:106) 18:22:09,600 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:202) 18:22:09,600 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) 18:22:09,600 INFO [sTDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.ja va:81) 18:22:09,600 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:202) 18:22:09,600 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) 18:22:09,616 INFO [sTDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:213) 18:22:09,616 INFO [sTDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:178) 18:22:09,616 INFO [sTDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalVal ve.java:39) 18:22:09,616 INFO [sTDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssoci ationValve.java:153) 18:22:09,616 INFO [sTDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java: 59) 18:22:09,631 INFO [sTDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126 ) 18:22:09,631 INFO [sTDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105 ) 18:22:09,647 INFO [sTDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :107) 18:22:09,647 INFO [sTDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) 18:22:09,647 INFO [sTDOUT] at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307) 18:22:09,647 INFO [sTDOUT] at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) 18:22:09,663 INFO [sTDOUT] at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) 18:22:09,663 INFO [sTDOUT] at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678) 18:22:09,663 INFO [sTDOUT] at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871) 18:22:09,663 INFO [sTDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:684) 18:22:09,678 INFO [sTDOUT] at java.lang.Thread.run(Thread.java:595) 18:22:09,678 INFO [sTDOUT] Caused by: net.sf.jasperreports.engine.JRRuntimeException: ClientAbortException: j ava.net.SocketException: Connection reset by peer: socket write error 18:22:09,678 INFO [sTDOUT] at net.sf.jasperreports.engine.util.FileBufferedWriter.writeData(FileBufferedWr iter.java:95) 18:22:09,694 INFO [sTDOUT] at net.sf.jasperreports.engine.export.JRRtfExporter.exportReportToStream(JRRtfE xporter.java:328) 18:22:26,054 INFO [sTDOUT] at net.sf.jasperreports.engine.export.JRRtfExporter.exportReport(JRRtfExporter. java:200) 18:22:26,054 INFO [sTDOUT] ... 32 more 18:22:26,070 INFO [sTDOUT] Caused by: ClientAbortException: java.net.SocketException: Connection reset by pee r: socket write error 18:22:26,070 INFO [sTDOUT] at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java: 366) 18:22:26,070 INFO [sTDOUT] at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:299) 18:22:26,070 INFO [sTDOUT] at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:392) 18:22:26,070 INFO [sTDOUT] at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:381) 18:22:26,070 INFO [sTDOUT] at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.ja va:76) 18:22:26,085 INFO [sTDOUT] at sun.nio.cs.StreamEncoder$CharsetSE.writeBytes(StreamEncoder.java:336) 18:22:26,085 INFO [sTDOUT] at sun.nio.cs.StreamEncoder$CharsetSE.implWrite(StreamEncoder.java:395) 18:22:26,085 INFO [sTDOUT] at sun.nio.cs.StreamEncoder.write(StreamEncoder.java:136) 18:22:26,085 INFO [sTDOUT] at java.io.OutputStreamWriter.write(OutputStreamWriter.java:191) 18:22:26,085 INFO [sTDOUT] at net.sf.jasperreports.engine.util.FileBufferedWriter.writeData(FileBufferedWr iter.java:88) 18:22:26,085 INFO [sTDOUT] ... 34 more If anybody got this issue or if anybody have d solution for this issue, please reply soon........... "URGENT" Thanks in Advance........... Code: Post Edited by balaji_r at 09/22/2011 13:29 Post Edited by balaji_r at 09/22/2011 13:36

Hi all, I have Jasperreports running in a web app, and if you click the RTF link or xls link, it'll call the Servlet to export the report to RTF or XLS respectively. When you do that, the usual Open/Save/Cancel dialog box appears. If I Open or Save, everything is fine. However, if I Cancel, well it's fine also, but in Tomcat I get the following error. I am using Windows XP with IE7. ERROR 18:22:06,569 FATAL [FMSAction] SYS Exception caught net.sf.jasperreports.engine.JRException: Error writing to o utput stream : report7 18:22:09,553 INFO [sTDOUT] net.sf.jasperreports.engine.JRException: Error writing to output stream : report7 18:22:09,553 INFO [sTDOUT] at net.sf.jasperreports.engine.export.JRRtfExporter.exportReport(JRRtfExporter. java:203) 18:22:09,569 INFO [sTDOUT] at com.betasphere.fms.actions.reportnew.ReportNewViewAction.fmsExecute(ReportNe wViewAction.java:455) 18:22:09,569 INFO [sTDOUT] at com.betasphere.fms.actions.FMSAction.execute(FMSAction.java:227) 18:22:09,569 INFO [sTDOUT] at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProces sor.java:484) 18:22:09,569 INFO [sTDOUT] at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) 18:22:09,569 INFO [sTDOUT] at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) 18:22:09,584 INFO [sTDOUT] at org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507) 18:22:09,584 INFO [sTDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:697) 18:22:09,584 INFO [sTDOUT] at javax.servlet.http.HttpServlet.service(HttpServlet.java:810) 18:22:09,584 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:252) 18:22:09,584 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) 18:22:09,584 INFO [sTDOUT] at com.betasphere.utils.SetCharacterEncodingFilter.doFilter(SetCharacterEncodin gFilter.java:106) 18:22:09,600 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:202) 18:22:09,600 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) 18:22:09,600 INFO [sTDOUT] at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.ja va:81) 18:22:09,600 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Application FilterChain.java:202) 18:22:09,600 INFO [sTDOUT] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterCh ain.java:173) 18:22:09,616 INFO [sTDOUT] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.ja va:213) 18:22:09,616 INFO [sTDOUT] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.ja va:178) 18:22:09,616 INFO [sTDOUT] at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrincipalVal ve.java:39) 18:22:09,616 INFO [sTDOUT] at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssoci ationValve.java:153) 18:22:09,616 INFO [sTDOUT] at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java: 59) 18:22:09,631 INFO [sTDOUT] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126 ) 18:22:09,631 INFO [sTDOUT] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105 ) 18:22:09,647 INFO [sTDOUT] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java :107) 18:22:09,647 INFO [sTDOUT] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148) 18:22:09,647 INFO [sTDOUT] at org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:307) 18:22:09,647 INFO [sTDOUT] at org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:385) 18:22:09,663 INFO [sTDOUT] at org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:748) 18:22:09,663 INFO [sTDOUT] at org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:678) 18:22:09,663 INFO [sTDOUT] at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:871) 18:22:09,663 INFO [sTDOUT] at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.jav a:684) 18:22:09,678 INFO [sTDOUT] at java.lang.Thread.run(Thread.java:595) 18:22:09,678 INFO [sTDOUT] Caused by: net.sf.jasperreports.engine.JRRuntimeException: ClientAbortException: j ava.net.SocketException: Connection reset by peer: socket write error 18:22:09,678 INFO [sTDOUT] at net.sf.jasperreports.engine.util.FileBufferedWriter.writeData(FileBufferedWr iter.java:95) 18:22:09,694 INFO [sTDOUT] at net.sf.jasperreports.engine.export.JRRtfExporter.exportReportToStream(JRRtfE xporter.java:328) 18:22:26,054 INFO [sTDOUT] at net.sf.jasperreports.engine.export.JRRtfExporter.exportReport(JRRtfExporter. java:200) 18:22:26,054 INFO [sTDOUT] ... 32 more 18:22:26,070 INFO [sTDOUT] Caused by: ClientAbortException: java.net.SocketException: Connection reset by pee r: socket write error 18:22:26,070 INFO [sTDOUT] at org.apache.catalina.connector.OutputBuffer.realWriteBytes(OutputBuffer.java: 366) 18:22:26,070 INFO [sTDOUT] at org.apache.tomcat.util.buf.ByteChunk.append(ByteChunk.java:299) 18:22:26,070 INFO [sTDOUT] at org.apache.catalina.connector.OutputBuffer.writeBytes(OutputBuffer.java:392) 18:22:26,070 INFO [sTDOUT] at org.apache.catalina.connector.OutputBuffer.write(OutputBuffer.java:381) 18:22:26,070 INFO [sTDOUT] at org.apache.catalina.connector.CoyoteOutputStream.write(CoyoteOutputStream.ja va:76) 18:22:26,085 INFO [sTDOUT] at sun.nio.cs.StreamEncoder$CharsetSE.writeBytes(StreamEncoder.java:336) 18:22:26,085 INFO [sTDOUT] at sun.nio.cs.StreamEncoder$CharsetSE.implWrite(StreamEncoder.java:395) 18:22:26,085 INFO [sTDOUT] at sun.nio.cs.StreamEncoder.write(StreamEncoder.java:136) 18:22:26,085 INFO [sTDOUT] at java.io.OutputStreamWriter.write(OutputStreamWriter.java:191) 18:22:26,085 INFO [sTDOUT] at net.sf.jasperreports.engine.util.FileBufferedWriter.writeData(FileBufferedWr iter.java:88) 18:22:26,085 INFO [sTDOUT] ... 34 more Is this something anybody has seen, or is it just something wrong with our web app? "URGENT" Thanks!