simple jasper report in java without a database.

[Rajubhai Kotwal]

Dear all,



I hope you are doing good. I would like to know whether we can generate a jasper report in java without using any database connection. I know we can generate jasper report in java with database connection. I have generated few reprts in .pdf and .xls format. Now I want to display some text on the the jasper report in java without database, say "hello jasper". I am using ireport. I have creaated a file and in that file, I have added a title in the title section $P{Report_title} . Now in the program, i am declaring a hashmap and trying put value in the hasmap like, hm.put("Report_title","Hello Report");

Later I am declaring JasperPrint like as follows.

JasperPrint print=JasperFillManager.fillReportToFile(fileName, outFileNamePDF, hm);

Here I am having problem about type mismatch:cannot convert from void to JasperPrint. I am not fully familiar with JasperReport API. I am trying to learn it with some simple examples first.In order to get the data on the report what I am supposed to do? Passing value from hashmap? Or shall use any collections? I would appreciate your suggestions. Thanks in advance. Please find the code. It's vary simple at the moment.

import java.util.HashMap;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRExporter;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperExportManager;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;

@SuppressWarnings("unchecked")
public class JasperSimple {
	String fileName = "C:\Documents and Settings\abhijit\JasperSimpleReport.jasper";
	String outFileNamePDF = "c:\JasperSimpleReport.pdf";
	HashMap hm = new HashMap();
	
	public JasperSimple() {
		super();
	}

	@SuppressWarnings("deprecation")
	
	public void generateReport() throws ClassNotFoundException, InstantiationException, IllegalAccessException {
		try {
			
			System.out.println("Filling report...");
			hm.put("","Hello Report");			
			//JasperReport manager=JasperManager.compileReport(fileName);
			JasperPrint print=JasperFillManager.fillReportToFile(fileName, outFileNamePDF, hm);
JRExporter exporter = new net.sf.jasperreports.engine.export.JRPdfExporter();
			//parameter used for the destined file.
			exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,
					outFileNamePDF);
			exporter.setParameter(JRExporterParameter.JASPER_PRINT, print);
			//export to .pdf
			exporter.exportReport();
			System.out.println("Created file: " + outFileNamePDF);
			System.out.println("Done!");
			
		} catch (JRException e) {
			e.printStackTrace();
		}
	}

	public static void main(String[] args) throws ClassNotFoundException, InstantiationException, IllegalAccessException {
		new JasperSimple().generateReport();
		System.out.println("No. of argumetns are: " + args.length);
	       for(int i= 0;i < args.length;i++)
	          System.out.println("Argument " + i + " is : " + args[i]);

	}
}

Best regards,

[Rajubhai Kotwal]

???
Any suggestions? Any ideas?

Best regards.

[John Bengler]

Hi Abhijit,

yes, you can create Jasper Reports without any database...

You can pass an XML or even a Java Map (or array) holding your datasource to the report..
(I think the report's datasource is your problem?)

You can download the samples here (see the link: "Download all Sample Source Files" or "Browse Sample Source Files on SVN" if you want just some of the samples):

Jasper Reports - Data Source Samples

If you downloaded the full zip-File you can find the samples under ...\jasperreports-3.7.1\demo\samples. For a demonstration on how to use non-DB-datasources especially the examples in the subfolders csvdatasource, datasource and xmldatasource may be helpful.

When I started using Jasper I used the XMLDatasource because you can easily play with your data and see the effect on the output..


Hope this is what you're looking for..

John

[Rajubhai Kotwal]

@John Bengler

Than you very much for the reply and for the informative link. Well, I was able to find solution. I put

hm.put("Modified_status_code", "1");
JasperPrint print1=JasperFillManager.fillReport(fileName, hm, new JREmptyDataSource());

JREmptyDataSource could be the possible simple solution. Now I am thinking to go even deeper. I wish to put values (data) on the report at run time.
What I mean to say is, I do have a database and connectivity. Now I want to put values dynamically. Therefore, I am doing similar thing. I am not able to add the value anymore. I am writing here my code. Please let me know if you know anything. Suggestions are welcome.

import java.io.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import net.sf.jasperreports.engine.JREmptyDataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JRExporter;
import net.sf.jasperreports.engine.JRExporterParameter;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.export.JRXlsExporter;
import net.sf.jasperreports.engine.export.JRXlsExporterParameter;

public class JasperTest {

	/**
	 * Define connection
	 */
	Connection conn = null;
	String url = "jdbc:mysql://localhost:3306/";
	String dbName = "riamp";
	String driver = "com.mysql.jdbc.Driver";
	String userName = "root";
	String password = "r00t";
	String fileName = "C:\\Documents and Settings\\compaq\\My Documents\\RiampDatabase.jasper";
	String outFileNamePDF = "c:\\RiampDatabase.pdf";
	String outFilenameExcel = "c:\\RiampDatabase.xls";
	HashMap hm = new HashMap();

	public JasperTest() {
		super();
	}

	@SuppressWarnings("deprecation")
	/**
	 * This method is used to connect database with Jasper report Engine and to export
	 * to .pdf and .els files. Jasper's JRExporter and JRXlsExporter are used for the
	 * export.
	 */
	public void generateReport() {
		try {
			byte[] bytes = null;
			Class.forName(driver).newInstance();
			conn = DriverManager
					.getConnection(url + dbName, userName, password);
			System.out.println("Connected to the database");
			System.out.println("Filling report...");
			hm.put("Modified_status_code", "1");
			//used for synchronization between database and source file.
			JasperPrint print = JasperFillManager
					.fillReport(fileName, hm, conn);
			System.out.println(conn);
			//define and initialize jasperreport engine's exporter for .pdf
			JRExporter exporter = new net.sf.jasperreports.engine.export.JRPdfExporter();
			//parameter used for the destined file.
			exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,
					outFileNamePDF);
			exporter.setParameter(JRExporterParameter.JASPER_PRINT, print);
			//export to .pdf
			exporter.exportReport();

			JRXlsExporter exporterXLS = new JRXlsExporter();
			exporterXLS
					.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,
							Boolean.FALSE);
			exporterXLS.setParameter(
					JRXlsExporterParameter.IS_AUTO_DETECT_CELL_TYPE,
					Boolean.TRUE);
			exporterXLS.setParameter(
					JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,
					Boolean.FALSE);
			exporterXLS.setParameter(
					JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,
					Boolean.TRUE);
			//parameter used for the destined file. 
			exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_FILE_NAME,
					outFilenameExcel);
			exporterXLS
					.setParameter(JRXlsExporterParameter.JASPER_PRINT, print);
			//export to .xls
			exporterXLS.exportReport();
			System.out.println("Created file: " + outFileNamePDF);
			System.out.println("Created file: " + outFilenameExcel);
			System.out.println("Done!");
			conn.close();
		} catch (JRException e) {
			e.printStackTrace();
		} catch (ClassNotFoundException e) {
			e.printStackTrace();
		} catch (SQLException e) {
			e.printStackTrace();
		} catch (InstantiationException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.exit(1);
		} catch (IllegalAccessException e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
			System.exit(1);
		}
	}

	public static void main(String[] args) {
		new JasperTest().generateReport();
	}
}

I am getting error.
net.sf.jasperreports.engine.JRException: Unknown column name : Modified_status_code
This is the column name I am trying to add. Please note, now I am using Databse connectivity.

Best regard.

Best regards.

[John Bengler]

Hi Abhijit,

you're welcome!

I think this time your problem doesn't have to do with your java code, but either with your report template or with your database...

Can you add your template?


John

[Rajubhai Kotwal]

@John

Yes. You are right. Issue is resolved. My .jasper was stroed at different location and I was using different one.
Thank you.