1./ Generas por medio de una JSP la solicitud de tus parametros fechas, campos etc.
2. Generas por medio de IREPORT tu reporte, tambien con estos parametros de por medio

3. Envias desde la jsp llamr tu servlet AQUI el ejemplo del SERVLET.

/*
* Reportes.java
*
* Created on 1 de febrero de 2007, 12:53 PM
*/

package ciea.almacen;
import java.io.*;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.sql.DataSource;
import net.sf.jasperreports.engine.JRException;
import net.sf.jasperreports.engine.JasperCompileManager;
import net.sf.jasperreports.engine.JasperRunManager;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.util.JRLoader;
import net.sf.jasperreports.engine.*;

/**
*
* @author pedro
* @version
*/
public class Reportes extends HttpServlet {



/** Processes requests for both HTTP <code>GET</code> and <code>POST</code> methods.
* @param request servlet request
* @param response servlet response
*/
private DataSource ds;

private PreparedStatement pstmt;

private ResultSet resultSet;
public void init() throws ServletException {

super.init();

ServletContext context = getServletContext();
//System.out.println(\"Context \" + context);

}


protected void processRequest(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
Connection conn = null;
Map parameters = new HashMap();
String tipoReporte = request.getParameter(\"tipoReporte\");
String status = request.getParameter(\"kstatus\");
String statusA = request.getParameter(\"kstatusA\");
String finicioS = request.getParameter(\"kperiodoI\");
String ffinalS = request.getParameter(\"kperiodoF\");
String capturo = request.getRemoteUser();
String titulo = null;
String tipoMovto = null;
String reportFileName = null;
String empleado = null;
String sql = null;
java.text.SimpleDateFormat sdf = null;
sdf = new java.text.SimpleDateFormat(\"dd/MM/yyyy\"); // PARA DB2


try {
java.util.Date fechaI = sdf.parse(request.getParameter(\"kperiodoI\"));
java.sql.Date fechaInicial = new java.sql.Date(fechaI.getTime());
java.util.Date fechaF = sdf.parse(request.getParameter(\"kperiodoF\"));
java.sql.Date fechaFinal = new java.sql.Date(fechaF.getTime());

// Get a database connection
conn = getConnection();
ServletContext context = getServletContext();

if (tipoReporte.equals(\"1\")){
titulo = \"CONCENTRADO DE BIENES: \";
if (status.equals(\"A\")){
titulo += \"FÍSICO \" ;
}
if (status.equals(\"B\")){
titulo += \"BAJAS \" ;
}
if (status.equals(\"C\")){
titulo += \"CONSUMO \" ;
}
if (status.equals(\"F\")){
titulo += \"FALTANTES \" ;
}
titulo += \"EN EL PERÍODO \" + finicioS + \" AL \" + ffinalS + \" POR CUENTA CONTABLE.\";

parameters.put(\"status\", status);
parameters.put(\"titulo\", titulo);
parameters.put(\"finicio\", fechaInicial);
parameters.put(\"ffinal\", fechaFinal);

reportFileName = \"acumCtaStatus\";

sql = \"select KARDEX.kcuenta, KARDEX.ksubcta, KARDEX.kssbcta, CUENTAS.ctitcta, Sum(KARDEX.kcosto)\"+
\" AS SumaDeKCOSTO FROM KARDEX INNER JOIN CUENTAS ON (KARDEX.KSSBCTA = CUENTAS.CSSBCTA) AND \"+
\"(KARDEX.KSUBCTA = CUENTAS.CSUBCTA) AND (KARDEX.KCUENTA = CUENTAS.CCUENTA)WHERE \"+
\"kardex.KSTATUS = ? AND kperiodo >=? AND \"+
\"kperiodo <= ? GROUP BY KARDEX.KCUENTA, KARDEX.KSUBCTA, KARDEX.KSSBCTA, CUENTAS.CTITCTA order \"+
\" by kardex.kcuenta,kardex.ksubcta,kardex.kssbcta \";

pstmt = conn.prepareStatement(sql);
pstmt.setString(1,status);
pstmt.setDate(2,fechaInicial);
pstmt.setDate(3,fechaFinal);
resultSet = pstmt.executeQuery();


}


// JasperReport jasperReport = getCompiledReport(reportFileName);
// generatePDFOutput(response, parameters, jasperReport);

JasperReport jasperReport = getCompiledReport(reportFileName);
ServletOutputStream servletOutputStream = response.getOutputStream();
InputStream reportStream = getServletConfig().getServletContext().getResourceAsStream(\"/reportes/\"+reportFileName+\".jasper\");
JRResultSetDataSource resultSetDataSource = new JRResultSetDataSource(resultSet);
JasperRunManager.runReportToPdfStream(reportStream,servletOutputStream,parameters,resultSetDataSource);
resultSet.close();
resultSet= null;
conn.close();
conn = null;
servletOutputStream.flush();
servletOutputStream.close();

} catch (Exception e) {
request.setAttribute(\"exception\", e);
try {
conn.close();
} catch (SQLException ex) {
ex.printStackTrace();
}
conn = null;
getServletContext().getRequestDispatcher( \"/jsp/exception.jsp\").forward(request,response);
} finally {
if (conn != null) {
try {
conn.close();
} catch (SQLException sqle) {
// Ignore
}
}
}


}

// <editor-fold defaultstate=\"collapsed\" desc=\"HttpServlet methods. Click on the + sign on the left to edit the code.\">
/** Handles the HTTP <code>GET</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doGet(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}

/** Handles the HTTP <code>POST</code> method.
* @param request servlet request
* @param response servlet response
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
processRequest(request, response);
}

/** Returns a short description of the servlet.
*/
public String getServletInfo() {
return \"Short description\";
}
// </editor-fold>

private DataSource getDataSource() throws NamingException {
if (ds == null) {
Context ctx = new InitialContext();
Context envContext = (Context)ctx.lookup(\"java:/comp/env\");
ds = (DataSource)envContext.lookup(\"jdbc/poolDB\");
}
return ds;
}
private Connection getConnection() throws SQLException, NamingException {
return getDataSource().getConnection();
}
private JasperReport getCompiledReport(String fileName)
throws JRException {
File reportFile =
new File(
getServletContext().getRealPath(
\"/reportes/\" + fileName + \".jasper\"));

// If compiled file is not found, then
// compile XML template
if (!reportFile.exists()) {
JasperCompileManager.compileReportToFile(
getServletContext().getRealPath(
\"/reportes/\" + fileName + \".jrxml\"));
}

JasperReport jasperReport =
(JasperReport) JRLoader.loadObject(reportFile.getPath());

return jasperReport;
}

private void generatePDFOutput(
HttpServletResponse response,
Map parameters,
JasperReport jasperReport)
throws JRException, NamingException, SQLException, IOException {

byte[] bytes = null;

bytes =
JasperRunManager.runReportToPdf(
jasperReport,
parameters,
getConnection());

response.setContentType(\"application/pdf\");
response.setContentLength(bytes.length);
ServletOutputStream ouputStream = response.getOutputStream();
ouputStream.write(bytes, 0, bytes.length);
ouputStream.flush();
ouputStream.close();


}

}

Responder