Hola a Todos queria rpeguntar si alguien decubrio
Quisiera preguntar si alguien sabe si se puede enviar como parametros al reporte el ancho y alto de la pagina o los margenes, esto para el iReport.. porfavor..... contesten..
adjunto un ejempolo completo de bajada a Excel.
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.engine.export.JRXlsExporter;
import java.lang.Boolean;
import java.io.*;
import java.sql.*;
import java.util.*;
import javax.naming.*;
import javax.servlet.*;
import javax.servlet.http.*;
import net.sf.jasperreports.engine.export.JRXlsExporterPa rameter;
public class XGVE003 extends HttpServlet {
private Connection con;
public void doPost (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
try{
con = cadeb.componentes.ConeccionBD.makeConnection();
ServletContext context = this.getServletConfig().getServletContext();
File reportFile = new File(context.getRealPath("/Reportes/GVE003.jasper"));
Map parameters = new HashMap();
parameters.put("CMBGESTION", "01/01/05");
parameters.put("CMBGESTION1", "Enero / 2005");
////////////////////
JasperPrint jasperPrint=JasperFillManager.fillReport(reportFil e.getPath(), parameters, con);
String xlsFileName = "GVE003.xls";
JRXlsExporter exporter = new JRXlsExporter();
exporter.setParameter(JRExporterParameter.JASPER_P RINT, jasperPrint);
exporter.setParameter(JRExporterParameter.OUTPUT_F ILE_NAME,reportFile + xlsFileName); // xlsFilesSource
exporter.setParameter(JRXlsExporterParameter.IS_ON E_PAGE_PER_SHEET, Boolean.TRUE);
exporter.exportReport();
File f = new File (reportFile + xlsFileName);
res.setContentType ("application/vnd.ms-excel");
String name = f.getName().substring(f.getName().lastIndexOf("/") + 1,f.getName().length());
res.setHeader ("Content-Disposition", "attachment;filename=\"" + xlsFileName + "\"");
InputStream in = new FileInputStream(f);
ServletOutputStream outs = res.getOutputStream();
int bit = 256;
int i = 0;
while ((bit) >= 0) {
bit = in.read();
outs.write(bit);
}
outs.flush();
outs.close();
in.close();
// llamo a mi metodo de coneccion
cadeb.componentes.ConeccionBD.releaseConnection(co n);
}
catch(JRException exxx){
res.setContentType("text/html");
PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>JasperReports - Web Application Sample</title>");
out.println("<link rel=\"stylesheet\" type=\"text/css\" href=\"../stylesheet.css\" title=\"Style\">");
out.println("</head>");
out.println("<body bgcolor=\"white\">");
out.println("<span class=\"bnew\">JasperReports encountered this error2 :</span>");
out.println(exxx.getMessage());
out.println("<pre>---- * ---<br>");
exxx.printStackTrace(out);
out.println("</pre>");
out.println("</body>");
out.println("</html>");
return;
}
catch(NamingException exxxx){
res.setContentType("text/html");
PrintWriter out = res.getWriter();
out.println("<html>");
out.println("<head>");
out.println("<title>JasperReports - Web Application Sample</title>");
out.println("<link rel=\"stylesheet\" type=\"text/css\" href=\"../stylesheet.css\" title=\"Style\">");
out.println("</head>");
out.println("<body bgcolor=\"white\">");
out.println("<span class=\"bnew\">JasperReports encountered this error :</span>");
out.println(exxxx.getMessage());
out.println("<pre>---- * ---<br>");
exxxx.printStackTrace(out);
out.println("</pre>");
out.println("</body>");
out.println("</html>");
return;
}
}
public void doGet (HttpServletRequest req, HttpServletResponse res)
throws ServletException, IOException
{
doPost(req, res);
}
}