shivamadagani

Hi, We are trying to export data to excel using jasper reports. The size of data varies from 1 MB to 1 GB. When huge data is to be filled into the jasper report, it is taking much time for the report generation. It took 5-10 mins to generate one of my report. Please help me with a solution where I can optimize this filling process of the jasper report, so that reports can be generated quickly? We are using jasperreports-3.0.0.jar and jdk1.5 in my application. Please provide with any source code if available. Thanks Shiva

Hi, we know excel report bydefault view zoom size is 100%. 1.How can we setup the zoom size of jasper report(Excel file) to 70% ? Also 2.How can we set jasper report(Excel file) to fit 1 page wide when we are having many columns.? Thanks Shiva

try this code by overridding postProcessReport method. Code:@Override protected void postProcessReport(JasperPrint populatedReport, Map model) throws Exception { System.out.println("Inside postProcessReport"); super.postProcessReport(populatedReport, model); System.out.println("start download"); JRPdfExporter exporterPdf = new JRXlsExporter(); exporterPdf.setParameter(JRXlsExporterParameter.JASPER_PRINT, populatedReport); exporterPdf.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE); exporterPdf.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS,Boolean.TRUE); //exporterPdf.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE); exporterPdf.setParameter(JRXlsExporterParameter.OUTPUT_FILE_NAME, "D:/filename.pdf" ); exporterPdf.exportReport(); System.out.println("End download"); }

Hi, can any one tell me how can i add my excel file(jasper report extracted) as attchement, to send an email from spring. Thanks Shiva Code://finalResp is xml data which we ll use to fill excel fileInputStream in = new ByteArrayInputStream(finalResp.getBytes()); org.springframework.core.io.InputStreamSource inputStreamSource=?????JavaMailSenderImpl mailSender = new JavaMailSenderImpl();mailSender.setHost("some host"); MimeMessage message = mailSender.createMimeMessage();MimeMessageHelper helper = new MimeMessageHelper(message, true);helper.setFrom(from);helper.setTo(to);helper.setSubject(sub);helper.addAttachment(attachmentFilename, inputStreamSource, contentType);helper.setText("Please check attachment",true);mailSender.send(message);

After setting the below property in default.jasperreports.properties, we are not able to see any data in excel. net.sf.jasperreports.xpath.executer.factory=net.sf.jasperreports.engine.util.xml.JaxenXPathExecuterFactory But we are getting the data from database and we are passing that data to JRXmlDataSource . Do we need make changes anywhere else? Thanks shiva

Can u explain more on this? What are the changes I can make in the given code. If you can provide me some sample code on this, i ll be very thankful to you.

Hi, We are using jasperreports-3.0.0. Exporting data into excel who's size less than 2MB of xml data is ok, managable. But when we are try to export the data into excel file who's xml data size is more than 2 MB, we are getting the below error. Proxy Error The proxy server received an invalid response from an upstream server. The proxy server could not handle the request when we pass that xml data to JRXmlDataSource class somtimes its failing in production environment. Some how its working in my local system. Do we have any limitations on JRXmlDataSource class with xml data size? Can u plz suggest the solution for this problem. Thanks Shiva Code:InputStream in = new ByteArrayInputStream(finalResp.getBytes()); JRDataSource jSource = null; try { jSource = new JRXmlDataSource(in,"/listResponse/item"); }catch(Exception ex){ logger.error(ex); }finally { //Release resource if(in!=null){ in.close(); } }

Thanks for your reply!!! I tried it with iReport 3.7.6 but did not find any property to check or mark .

Hi, I am using jasperreports 3.0.0, am exporting data into excel file using jasper reports. Excel file is having 30 columns and also having group by some column. When i print Excel, am able to see only few columns on page and remaining columns in next page. Just wondering to know How can i print all columns data in one page. We can do this manually by the following steps. In Excel file menu File -> page setup-> page tab -> scaling section --> Fit to 1 page I will be Thankful if someone can tell me How we can do this in jasper reports. Thanks Shiva

Hi, I am using jasperreports 3.0.0, I am exporting the data into Excel file which is having 30 columns. When i see the print preview pageHeader is displaying only on first page not on every page. Can someone help me on how can i display page header on every page. Thanks Shiva Code: Post Edited by shivamadagani at 12/07/2010 12:16

Hi, I am using jasperreports 3.0.0, I have the following code in my jasper report file. Can someone explain me why page margins are not setting when we see the print preview. Thanks Shiva Code:<jasperReportname="abcToExcel"columnCount="1"printOrder="Vertical"orientation="Landscape"pageWidth="1900" pageHeight="2000" columnWidth="1850"columnSpacing="0"leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"whenNoDataType="NoPages"isTitleNewPage="false"isSummaryNewPage="false">