Jasper Report + Jsp/Servlet

[sk_shailesh]

Hi Friends,

 

I am new to Jasper Reports. I have developed Jasper Report and i want to call it from the JSP/ Servlet.

 

Would any one provide me hints or examples regarding calling Jasper Reports from Jsp/Servlet.

:P

[s_syed]

Hi,

Check out the following code. It's a .jsp file in my web application, from this file i'm calling my report. If any queries feel free to revert back.

 

 

<%@ page import="java.io.*" %>

<%@ page import="java.sql.*" %>

<%@ page import="java.util.*" %>

<%@ page import="peoplewarejava.*"%>

<%@ page import="net.sf.jasperreports.engine.*" %>

<%@ page import="net.sf.jasperreports.engine.xml.JRXmlLoader"%>

<%@ page import="net.sf.jasperreports.engine.design.JasperDesign"%>

<%@ page import="net.sf.jasperreports.j2ee.servlets.*" %>

<%@ page import="net.sf.jasperreports.view.*"%>

<%@ page import="net.sf.jasperreports.engine.util.*" %>

<%@ page import="net.sf.jasperreports.engine.export.*" %>

<%

JasperDesign jasperDesign= JasperManager.loadXmlDesign(getServletContext().getRealPath("/")+"reports/BirthdayPie.jrxml");

JasperReport jasperReport = JasperManager.compileReport(jasperDesign);

Map parameters = new HashMap();

parameters.put("ReportTitle", "Birth Day Pie Report");

parameters.put("sub",getServletContext().getRealPath("/"));

Class.forName("org.postgresql.Driver");

Connection con1 = DriverManager.getConnection("jdbc:postgresql://localhost:5432/peopleWARE","postgres","postgres");

byte[] bytes = JasperRunManager.runReportToPdf( jasperReport, parameters, con1);

response.setContentType("application/pdf");

response.setContentLength(bytes.length);

ServletOutputStream ouputStream = response.getOutputStream();

ouputStream.write(bytes, 0, bytes.length);

ouputStream.flush();

ouputStream.close();

%>