shivamadagani
-
Posts
11 -
Joined
-
Last visited
Content Type
Profiles
Forum
Events
Featured Visualizations
Knowledge Base
Documentation (PDF Downloads)
Blog
Documentation (Test Area)
Documentation
Dr. Jaspersoft Webinar Series
Downloads
Posts posted by shivamadagani
-
-
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 requestwhen 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
ShivaCode:
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
ShivaCode: <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">
Jasper reports problem with huge data
in Products
Posted
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