prashantckc

Thanks a ton It Worked :-)

Hi All We have created the report in TEXT Format using the TEXTExporter. However there is strange behaviour, say in the table I have 10 records. So after 3 records I am getting a Blank Line. This is happening for many reports and also the GAP of One line is not consistent, in some reports it comes after 3 records and then after 4 and in some it comes after 2 records. Kindly guide us on the same.

Hi All I need to pass the Entire SQL query as a parameter. Kindly Suggest how can we acheive the same?

Hi All When generating the report in XLS form I am getting the diffrent sizes of Cells with White Background The Code is shown Below Kindly let me know if I missed some property? Code:exporter = xlsExporter;exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, outputFile.getCanonicalPath());exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);exporter.exportReport();

Hi All I have just started using the Jasper Report 3.6 version. There are two ways of creating the report say I need to generate the PDF report. 1. I can create it using the JasperExportManager 2. Directly using the Corresponding Exporter. say JRPdfExporter. Can you please guide me as to which approach we need to use?

How we are going to set these value in Java COde? Regarding the Query its a simple SELECT * FROM TABLE

Hi All I am trying to generate the PDF file with 10Laks record and its taking huge amount of time. Can you please help in how can we improve the performance? Are there any guidelines in Jasper for performance setting?

Code:Hi All I created a sample Jasper Report with 3.7.6. and it runs successfully in my local machine. Now I have set the same up in linux machine. But I am getting the PDF as a corrupted file. To resolve that I have included the following 1. Included pja.jar in the Bootclasspath 2. set the pja.jar in the classpath 3. -Djava.awt.graphicsenv=com.eteks.java2d.PJAGraphicsEnvironment -Djava.awt.fonts=$JAVA_HOME/jre/lib/fonts Now I am getting the following exception java.lang.AbstractMethodError: sun.java2d.SunGraphicsEnvironment.createFontConfiguration()Lsun/awt/FontConfiguration; at sun.java2d.SunGraphicsEnvironment$2.run(SunGraphicsEnvironment.java:226) at java.security.AccessController.doPrivileged(Native Method) at sun.java2d.SunGraphicsEnvironment.<init>(SunGraphicsEnvironment.java:129) at com.eteks.java2d.PJAGraphicsEnvironment.<init>(PJAGraphicsEnvironment.java:66) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27) at java.lang.reflect.Constructor.newInstance(Constructor.java:513) at java.lang.Class.newInstance0(Class.java:355) at java.lang.Class.newInstance(Class.java:308) at java.awt.GraphicsEnvironment.getLocalGraphicsEnvironment(GraphicsEnvironment.java:68) at net.sf.jasperreports.engine.util.JRStyledTextParser.<clinit>(JRStyledTextParser.java:83) at net.sf.jasperreports.engine.fill.JRBaseFiller.<init>(JRBaseFiller.java:182) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:77) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:87) at net.sf.jasperreports.engine.fill.JRVerticalFiller.<init>(JRVerticalFiller.java:57) at net.sf.jasperreports.engine.fill.JRFiller.createFiller(JRFiller.java:142) at net.sf.jasperreports.engine.fill.JRFiller.fillReport(JRFiller.java:52) at net.sf.jasperreports.engine.JasperFillManager.fillReport(JasperFillManager.java:417) at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:199) at net.sf.jasperreports.engine.JasperFillManager.fillReportToFile(JasperFillManager.java:95)

Code:I created Jasper report with the latest release and tested on ecllipse and every thing was fine. Now as soon as I checked it on Linux machine I am getting the following error Report is not generated for - FXSTP_CONTRACT net.sf.jasperreports.engine.JRRuntimeException: Error creating SAX parser at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.createParser(JRReportSaxParserFactory.java:108) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createParser(JRXmlDigesterFactory.java:1332) at net.sf.jasperreports.engine.xml.JRXmlDigesterFactory.createDigester(JRXmlDigesterFactory.java:1307) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:205) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:170) at net.sf.jasperreports.engine.xml.JRXmlLoader.load(JRXmlLoader.java:154) at net.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:85) at com.orbitreasury.common.reports.GenerateReportJrprint.generateReport(GenerateReportJrprint.java:159) at com.orbitreasury.common.reports.TreasuryRpt.<init>(TreasuryRpt.java:110) at com.citi.quantumfx.test.UnitTest.testUnit(UnitTest.java:131) at com.citi.quantumfx.infrastructure.server.QFXStartUpService.handleEvent(QFXStartUpService.java:117) at com.citigroup.get.quantum.lifecycle.LifeCycleManager.postEvent(LifeCycleManager.java:201) at com.citigroup.get.quantum.lifecycle.LifeCycleManager.processEvent(LifeCycleManager.java:219) at com.citigroup.get.quantum.lifecycle.LifeCycleManager.onRunning(LifeCycleManager.java:332) at com.citigroup.get.quantum.lifecycle.LifeCycleManager.startLifecycle(LifeCycleManager.java:635) at com.citigroup.get.quantum.server.Server.main(Server.java:21) Caused by: org.xml.sax.SAXNotRecognizedException: http://java.sun.com/xml/jaxp/properties/schemaLanguage at org.apache.xerces.framework.XMLParser.setProperty(XMLParser.java:1626) at org.apache.xerces.parsers.SAXParser.setProperty(SAXParser.java:770) at org.apache.xerces.jaxp.SAXParserImpl.setProperty(SAXParserImpl.java:183) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.configureParser(JRReportSaxParserFactory.java:139) at net.sf.jasperreports.engine.xml.JRReportSaxParserFactory.createParser(JRReportSaxParserFactory.java:103) ... 15 more I have following JARS in my classpath 1. xerces-J_1.4.0.jar 2. j2ee.jar apart from them the commons-* and jasperreport 3.5 jar Kindly suggestthe solution

Hi All, I have integrated the Jasper with Spring and also tested a sample report, which is working fine. These are the components which are used 1. Web.xml {Having the Servlet Mapping} 2. jasperSpring-servlet.xml {This contains the Data Souce and the Source Name} 3. Simple JSP with Submit Button. The Code is show below Can you please let me know how we can use the File Virtualizer in this case as I am not able to understand where exactly the filling is taking place. This code is from the example of integrating Spring with Jasper (From the Book Java Reports for Java Developers) Code:package net.ensode.jasperbook.spring;import java.io.IOException;import java.sql.Connection;import java.sql.ResultSet;import java.sql.SQLException;import java.sql.Statement;import java.util.HashMap;import java.util.Map;import javax.servlet.ServletException;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.sql.DataSource;import net.sf.jasperreports.engine.JRParameter;import net.sf.jasperreports.engine.JRResultSetDataSource;import net.sf.jasperreports.engine.fill.JRFileVirtualizer;import org.springframework.web.servlet.ModelAndView;import org.springframework.web.servlet.mvc.Controller;public class JasperSpringController implements Controller { private DataSource dataSource; public ModelAndView handleRequest(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException, ClassNotFoundException, SQLException { return new ModelAndView("report", getModel()); } private Map getModel() throws ClassNotFoundException, SQLException { Connection connection; Statement statement; ResultSet resultSet; HashMap model = new HashMap(); String query = "select * from tb_fxstp_contracts"; System.out.println(" Getting the DataBase Connection....................."); connection = dataSource.getConnection(); statement = connection.createStatement(); resultSet = statement.executeQuery(query); JRResultSetDataSource resultSetDataSource = new JRResultSetDataSource( resultSet); model.put("dataSource", resultSetDataSource); return model; } public void setDataSource(DataSource dataSource) { this.dataSource = dataSource; }}

Hi ...Any updates on the same?

Hi All, First of all thanks for this great platform where users from diffrent parts share things and provide solutions. I am relatively new to this forum however I have been using Jasper for generating Reports in PDF EXCEL and TEXT forms. I need to generate the reports in in diffrent languages say Spanish ,Vietnam Language (etc). Can anyone guide me how I can achieve this by using jasper? Also if this feature has been included from aparticular build of jasper than please let me know the build number. Many thanks and waiting for positive replies