HI
I had generate a report with IREPORT 3.7 . I have now a .jasper file.
I would want to be able to execute (show) it with a jsp file or servlet.
My generated report not use sql queries, only it need 2 parameters. i think to pass these parameters from 2 text input in other jsp file.
The code that I am trying is :
<%--
Document : reporte
Created on : 01/09/2010, 01:31:42 PM
Author : JHON
--%>
<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<%@ page import="net.sf.jasperreports.engine.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="net.sf.jasperreports.view.JRViewer" %>
<%@ page import="com.itextpdf.text.*"%>
<%@ page import="com.itextpdf.text.pdf.*"%>
<%@ page import="java.util.HashMap" %>
<%
/*Parametros para realizar la conexión*/
Connection conexion;
Class.forName("com.mysql.jdbc.Driver").newInstance();
conexion = DriverManager.getConnection("jdbc:mysql://localhost:3306/gae", "root", "");
/*Establecemos la ruta del reporte*/
File reportFile = new File(application.getRealPath("reportes//prueba1.jasper"));
/* No enviamos parámetros porque nuestro reporte no los necesita asi que escriba cualquier cadena de texto ya que solo seguiremos el formato del método runReportToPdf*/
Map parameters = new HashMap();
parameters.put("cedula", "cedula");
parameters.put("nombre", "nombre");
/*Enviamos la ruta del reporte, los parámetros y la conexión(objeto Connection)*/
byte[] bytes = JasperRunManager.runReportToPdf(reportFile.getPath(), parameters, conexion);
/*Indicamos que la respuesta va a ser en formato PDF*/
response.setContentType("application/pdf");
response.setContentLength(bytes.length);
ServletOutputStream ouputStream = response.getOutputStream();
ouputStream.write(bytes, 0, bytes.length); /*Limpiamos y cerramos flujos de salida*/
ouputStream.flush();
ouputStream.close();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<title>JSP Page</title>
</head>
<body>
<h1>Hello World!</h1>
</body>
</html>Anyone know other method without to use connection?? This code give me error in the line 32!!!
Muchas Gracias