[Report in Text Format]

Thanks a ton

It Worked :-)

[Report in Text Format]

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.

[Passing Query as parameter]

Hi All

I need to pass the Entire SQL query as a parameter.

Kindly Suggest how can we acheive the same?

[XLS Format of the Report]

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();

[Exporting Jasper Reports]

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?

[Jasper Performance Parameter]

How we are going to set these value in Java COde?

Regarding the Query its a simple SELECT  * FROM TABLE

[Jasper Performance Parameter]

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?

[Corrupted PDF file in Linux Env]

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)

[Jasper report not generating in LINUX ENV]

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

[Jasper With Spring with REPORT_VIRTUALIZER]

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;	}}

[Reports in Different language]

Hi ...Any updates on the same?

[Reports in Different language]

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