Jump to content
We've recently updated our Privacy Statement, available here ×

rasfeh

Members
  • Posts

    5
  • Joined

  • Last visited

rasfeh's Achievements

Rookie

Rookie (2/14)

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

Recent Badges

0

Reputation

  1. Hi, I need sample code if anybody has ways to format the excel files. My excel file reults using "exporter" are crowded and dont look good at all. it appears that most my exporter.setparameter.. dont work to format generated excel files. I appreciate any help. Code:
  2. Hi, I appreciate if anyboy show me sample code of exporting ireport results to an excel file? Thaks for your elp.
  3. I have a simple crosstab subreport which runs OK in Jasper environment but when I run it in my Jdeveloper java application report does not run and generates some kind of general error. I am missing library files installed? I'm using 3.0 iReport and 10.1.3.3 Jdeveloper.
  4. Hi everyone, We are getting the error "javax.servletexception: getoutputstream(0 has already been called for this response" when we try to call the jasper report. We use Jvedeloper 10.1.33 and ireport 3.0.. We had other java apps calling jasper reports with no problem using the below codes (jdeveloper 10.1.2.0 & ipreport 1.2.3). Thanks, <%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%> <%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%> <%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%> <%@ page import="model.jdbc.SecurityService"%> <%@ page language="java" import="java.sql.*" errorPage=""%> <%@ page import="util.Constants"%> <%@ page import= "java.sql.Connection"%> <%@ page import="util.FADSResourceFactory"%> <%@ page import="net.sf.jasperreports.engine.*" %> <%@ page import="net.sf.jasperreports.engine.util.*" %> <%@ page import="net.sf.jasperreports.engine.export.*" %> <%@ page import="net.sf.jasperreports.j2ee.servlets.*" %> <%@ page import="java.util.*" %> <%@ page import="java.io.*" %> <%@ page import= " java.sql.*" %> <%@ page import= "net.sf.jasperreports.engine.JasperCompileManager" %> <%@ page import= "net.sf.jasperreports.engine.JasperExportManager" %> <%@ page import= "net.sf.jasperreports.engine.JasperFillManager" %> <%@ page import= "net.sf.jasperreports.engine.JasperManager" %> <%@ page import= "net.sf.jasperreports.engine.JasperPrint" %> <%@ page import= "net.sf.jasperreports.engine.JasperReport" %> <%@ page import= "net.sf.jasperreports.engine.design.JasperDesign" %> <%@ page import= "net.sf.jasperreports.engine.xml.JRXmlLoader" %> <%@ page import= "net.sf.jasperreports.view.JasperViewer" %> <% ServletOutputStream servletOutputStream = response.getOutputStream(); byte[] bytes = null; String strWhere = request.getParameter("param"); if (strWhere == null) { strWhere = (String) request.getSession().getAttribute("param"); } //Only needed if report needs to be compiled /* InputStream input= new FileInputStream( request.getSession().getServletContext().getRealPath("/")+"reports/cfcpermitfin.jrxml" ); JasperDesign design = JRXmlLoader.load(input); JasperReport reportFile = JasperCompileManager.compileReport(design); */ //load the jasper file String reportFileName = application.getRealPath("/reports/report1.jasper"); JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFileName); //pass parameters Map parameters = new HashMap(); parameters.put("SUBREPORT_DIR", (request.getSession().getServletContext().getRealPath("/")+"reports/")); // parameters.put("IMAGE_DIR", (request.getSession().getServletContext().getRealPath("/")+"images/")); parameters.put("PARAM_WHERE", strWhere ); //pass the connection Connection conn = FADSResourceFactory.getConnection(); //run the report bytes = JasperRunManager.runReportToPdf(jasperReport , parameters, conn); response.setContentType("application/pdf"); response.setContentLength(bytes.length); servletOutputStream.write(bytes, 0, bytes.length); servletOutputStream.flush(); servletOutputStream.close(); %> <html> <head> <title>JasperReports - Web Application Sample</title> <link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style"> </head> <body bgcolor="white"> <span class="bold">The compiled report design was successfully filled with data.</span> </body> </html> Code:<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html"%><%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean"%><%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic"%><%@ page import="model.jdbc.SecurityService"%><%@ page language="java" import="java.sql.*" errorPage=""%><%@ page import="util.Constants"%><%@ page import= "java.sql.Connection"%><%@ page import="util.FADSResourceFactory"%><%@ page import="net.sf.jasperreports.engine.*" %><%@ page import="net.sf.jasperreports.engine.util.*" %><%@ page import="net.sf.jasperreports.engine.export.*" %><%@ page import="net.sf.jasperreports.j2ee.servlets.*" %><%@ page import="java.util.*" %><%@ page import="java.io.*" %><%@ page import= " java.sql.*" %><%@ page import= "net.sf.jasperreports.engine.JasperCompileManager" %><%@ page import= "net.sf.jasperreports.engine.JasperExportManager" %><%@ page import= "net.sf.jasperreports.engine.JasperFillManager" %><%@ page import= "net.sf.jasperreports.engine.JasperManager" %><%@ page import= "net.sf.jasperreports.engine.JasperPrint" %><%@ page import= "net.sf.jasperreports.engine.JasperReport" %><%@ page import= "net.sf.jasperreports.engine.design.JasperDesign" %><%@ page import= "net.sf.jasperreports.engine.xml.JRXmlLoader" %><%@ page import= "net.sf.jasperreports.view.JasperViewer" %><%ServletOutputStream servletOutputStream = response.getOutputStream(); byte[] bytes = null; String strWhere = request.getParameter("param"); if (strWhere == null) { strWhere = (String) request.getSession().getAttribute("param"); } //Only needed if report needs to be compiled /* InputStream input= new FileInputStream( request.getSession().getServletContext().getRealPath("/")+"reports/cfcpermitfin.jrxml" ); JasperDesign design = JRXmlLoader.load(input); JasperReport reportFile = JasperCompileManager.compileReport(design); */ //load the jasper file String reportFileName = application.getRealPath("/reports/report1.jasper"); JasperReport jasperReport = (JasperReport)JRLoader.loadObject(reportFileName); //pass parameters Map parameters = new HashMap(); parameters.put("SUBREPORT_DIR", (request.getSession().getServletContext().getRealPath("/")+"reports/")); // parameters.put("IMAGE_DIR", (request.getSession().getServletContext().getRealPath("/")+"images/")); parameters.put("PARAM_WHERE", strWhere ); //pass the connection Connection conn = FADSResourceFactory.getConnection(); //run the report bytes = JasperRunManager.runReportToPdf(jasperReport , parameters, conn); response.setContentType("application/pdf"); response.setContentLength(bytes.length); servletOutputStream.write(bytes, 0, bytes.length); servletOutputStream.flush(); servletOutputStream.close();%><html><head><title>JasperReports - Web Application Sample</title><link rel="stylesheet" type="text/css" href="../stylesheet.css" title="Style"></head><body bgcolor="white"><span class="bold">The compiled report design was successfully filled with data.</span></body></html>
  5. I have been trying to find a solution to this problem that seems to be a ireport bug (I'm using version 3.0). I have a main report with subreport displaying returned value in detail band of this report. In my main report group footer i need to total velaues of all subreports and display a subtotal. Subreport is returning the values and displaying all correctly, however the subtotal in footer allways missing the last returned value from subreport. Please help, this is very frustrating.
×
×
  • Create New...