Jump to content

sundar3686

Members
  • Posts

    2
  • Joined

  • Last visited

sundar3686's Achievements

Newbie

Newbie (1/14)

  • Week One Done
  • One Month Later
  • One Year In
  • First Post Rare
  • Conversation Starter Rare

Recent Badges

0

Reputation

  1. Thanks rakeshenoch, Now report display correctly. But alignment problem when convert to html format, in pdf format no issue. I also tried using jasper server web service. But same problem using hrml format. Please help me.
  2. Hi friends, i want to display html view in jsp page from jasper report, i create one page then report loaded but some unwanted image tag also displayed. This is my code please help me. Code:<%-- Document : CallReport Created on : Dec 14, 2010, 2:34:53 AM Author : Admin--%><%@page import="java.io.IOException"%><%@page import="net.sf.jasperreports.engine.JRException"%><%@page import="net.sf.jasperreports.engine.export.JRCsvExporter"%><%@page import="net.sf.jasperreports.engine.export.JRXlsExporter"%><%@page import="net.sf.jasperreports.engine.export.JRHtmlExporterParameter"%><%@page import="net.sf.jasperreports.engine.export.JRHtmlExporter"%><%@page import="net.sf.jasperreports.engine.export.JRRtfExporter"%><%@page import="net.sf.jasperreports.engine.JRExporterParameter"%><%@page import="net.sf.jasperreports.engine.export.JRPdfExporter"%><%@page import="net.sf.jasperreports.engine.JRExporter"%><%@page import="java.io.OutputStream"%><%@page import="net.sf.jasperreports.engine.JasperPrint"%><%@page import="net.sf.jasperreports.engine.JasperFillManager"%><%@page import="java.util.Map"%><%@page import="java.util.HashMap"%><%@page import="java.sql.DriverManager"%><%@page import="java.sql.Connection"%><%@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"><html><head><title>report generation in jsp</title></head><body><%/*String filename = request.getParameter("filename");String reporttype = request.getParameter("reporttype");String Paramtype = request.getParameter("paramtype");;*/String filename = "/Reports/Course.jasper";String reporttype = "html";String Paramtype = "";Class.forName("com.mysql.jdbc.Driver");Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/ecsa","root","Tainn");System.out.println("Connection Established");Map jasperParameter = new HashMap();jasperParameter.put("paramtype",Paramtype);String path = application.getRealPath("/");JasperPrint jasperPrint = JasperFillManager.fillReport(path +"/"+filename, jasperParameter, conn);System.out.println("Report Created... in "+reporttype +" Format");OutputStream ouputStream = response.getOutputStream();JRExporter exporter = null;if( "pdf".equalsIgnoreCase(reporttype) ){response.setContentType("application/pdf");response.setHeader("Content-Disposition", "inline; filename=\"report.pdf\"");exporter = new JRPdfExporter();exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);}else if( "rtf".equalsIgnoreCase(reporttype) ){response.setContentType("application/rtf");response.setHeader("Content-Disposition", "inline; filename=\"report.rtf\"");exporter = new JRRtfExporter();exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);}else if( "html".equalsIgnoreCase(reporttype) ){response.setContentType("application/html");response.setHeader("Content-Disposition", "inline; filename=\"report.html\"");exporter = new JRHtmlExporter();exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI,"image?image=");}else if( "xls".equalsIgnoreCase(reporttype) ){response.setContentType("application/xls");response.setHeader("Content-Disposition", "inline; filename=\"report.xls\"");exporter = new JRXlsExporter();exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);}else if( "csv".equalsIgnoreCase(reporttype) ){response.setContentType("application/csv");response.setHeader("Content-Disposition", "inline; filename=\"report.csv\"");exporter = new JRCsvExporter();exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream);}try{exporter.exportReport();}catch (JRException e){throw new ServletException(e);}finally{if (ouputStream != null){try{ouputStream.close();}catch (IOException ex){}}}%></body></html>
×
×
  • Create New...