calling jasperreport from JSP page

[pdd_2003_1]

I can create and view reports using iJasper. I have downloaded the documentation for Jasperreports and also iReports but am finding them tough going. How can I call reports from a JSP page? Can anyone provide some sample code so that I can get an overview of the process.

[aditya_gupta]

Hi,

You can use JasperReports api. Here is the code which i have written in a servlet, you can convert it to jsp.

 

/*-----------------------------------------

import java.io.*;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.HashMap;

import javax.servlet.*;

import javax.servlet.http.*;

import net.sf.jasperreports.engine.JRException;

import net.sf.jasperreports.engine.JRExporter;

import net.sf.jasperreports.engine.JRExporterParameter;

import net.sf.jasperreports.engine.JasperCompileManager;

import net.sf.jasperreports.engine.JasperFillManager;

import net.sf.jasperreports.engine.JasperPrint;

import net.sf.jasperreports.engine.JasperReport;

import net.sf.jasperreports.engine.export.JRPdfExporter;

 

public class servlet_test extends HttpServlet {HttpServletRequest request, HttpServletResponse response)

{

try{

HashMap hm = new HashMap();

Connection con = null;

OutputStream ouputStream = null;

 

JRExporter exporter = null;

try{

Class.forName("net.sourceforge.jtds.jdbc.Driver");

con = DriverManager.getConnection("jdbc:jtds:sqlserver://serverip:portno/Database_name","user",""password");

} catch (SQLException ex) {

ex.printStackTrace();

}catch(ClassNotFoundException cex){

cex.printStackTrace();

}

 

hm.put("report_parameter_name",value);

ouputStream = response.getOutputStream();

JasperPrint jasperPrint = JasperFillManager.fillReport(filename,hm,con);

response.setContentType("application/pdf");

exporter = new JRPdfExporter();

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);

exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);

exporter.exportReport();

} catch (JRException e) {

throw new ServletException(e);

} finally {

if (ouputStream != null) {

try {

ouputStream.close();

} catch (IOException ex) {

}

} else{

response.flushBuffer();

}

}

}

 

Aditya