gmadhavi

Hi Friends, Can anyone help me how to provide solution for my requirement We have two queries which return two cursors 1) For returning lines data containing different rows and columns. 2) Only 2 columns(name-value pair) Display would look like column1 column2 column3 column4 -------------------------------------------------------------- value11 value12 value13 value14 value21 value22 value23 value24 value31 value32 value33 value34 Carrier - XYZ Shipmethod - ABC total_weight - 100 Account_number - 12345 The above 2 sections must display in same report How to achieve this in Jasper? Any suggestion please Thanks Madhavi

Hii I tried by adding whole directory path. Its working now.. Thanks a lot :)

Hi Thanks for your reply. This is what I did. 1) Created YourLittleHelperClass.java and compiled it to get YourLittleHelperClass.class 2) Created YourLittleHelperClass.jar by renaming YourLittleHelperClass.class(As I got problem with jar -cf YourLittleHelperClass.jar YourLittleHelperClass.class) 3) From Tools-> Options-> Classpath--> Browsed and selected YourLittleHelperClass.jar 4) Modified .jrxml file <textFieldExpression class="java.lang.String"><![CDATA[YourLittleHelperClass.lpad($F{CUSTOMER_NUMBER},8,'0')]]></textFieldExpression> But I am getting following exception: Please help if i am missing anything Thanks Madhavi Code:CompilationÂexceptions:Âcom.jaspersoft.ireport.designer.compiler.ErrorsCollector@253f58 net.sf.jasperreports.engine.JRException:ÂErrorsÂwereÂencounteredÂwhenÂcompilingÂreportÂexpressionsÂclassÂfile: 1.ÂYourLittleHelperClassÂcannotÂbeÂresolved ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.String)(YourLittleHelperClass.lpad(((java.lang.String)field_CUSTOMER_NUMBER.getValue()),8,'0'));Â//$JR_EXPR_ID=11$ ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<-------------------> 2.ÂYourLittleHelperClassÂcannotÂbeÂresolved ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.String)(YourLittleHelperClass.lpad(((java.lang.String)field_CUSTOMER_NUMBER.getOldValue()),8,'0'));Â//$JR_EXPR_ID=11$ ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<-------------------> 3.ÂYourLittleHelperClassÂcannotÂbeÂresolved ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂvalueÂ=Â(java.lang.String)(YourLittleHelperClass.lpad(((java.lang.String)field_CUSTOMER_NUMBER.getValue()),8,'0'));Â//$JR_EXPR_ID=11$ ÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂÂ<-------------------> 3Âerrors ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:195) ÂÂÂÂatÂcom.jaspersoft.ireport.designer.compiler.IReportCompiler.run(IReportCompiler.java:524) ÂÂÂÂatÂorg.openide.util.RequestProcessor$Task.run(RequestProcessor.java:561) ÂÂÂÂatÂorg.openide.util.RequestProcessor$Processor.run(RequestProcessor.java:986) Compilation running time: 625!

Hi Friends, I have a small problem. I need to append characters on left side of particular field value(which we get from database) and display it in Jasper output/ Eg: Value from database - EMP_NO 12345 Jasper Report Output - EMP_NO 0000012345 i.e length of EMP_NO display field should be 10. But we get 12345 value from database. Note: This is like LPAD string function . lpad function pads the left-side of a string with a specific set of characters lpad('tech', 8, '0'); would return '0000tech' Please help me out how to achieve lpad in Jasper

Hi Friends, Can anyone tell me how to do i18n in iReport I am usinf iReport 3.1.4 I followed following steps,but unable to get required results 1) Created resourse bundle (Testi18n_de_DE.properties.properties) from File-->New Resource Bundle 2) Changed Resource bundle field in Properties to Folderpath/Testi18n 3) Changed report locale to German(Germany) 4) Code in .jrxml changed to <text><![CDATA[$R{Hello}]]></text> <text><![CDATA[$R{DEPTNO}]]></text> Please anyone help Thanks Madhavi Code:Testi18n_de_DE.properties.properties file:# Resource Bundle file.#key=vaulueDEPTNO=APPS deptnoHello=Hello German

Hi Srikanth, Thanks for your reply. It is well known fact that Google is best resource for each and everything. But I thought that people in this forum,are very well known about Jasper reports.So I posted here expecting them to help me.

Hi friends, Can anyone give me PPT on Jasper Reports(implementing through iReport) that is easily understandable and easy to explain. Thanks Madhavi

Hi Lucian, I am also facing same problem. Where should I add -javax.xml.parsers.SAXParserFactory=org.apache.xerces.jaxp.SAXParserFactoryImpl when I am running my application in Jdeveloper 10.1.3 Thanks

Hi friends, I am getting SAXNotRecognizedException when running Jasper reports in Oracle Jdeveloper 10.1.3 I am able to run the same application in Tomcat.But,its becoming tedious for me to develop code and port each time in Tomcat. Please tell me what/s problem with my Jdeveloper. JDeveloper version : 10.1.3.4 Java version : 1.5 Jar files used : jasperreports-3.1.4.jar, classes12.jar, commons-beanutils-1.7.jar, commons-collections-2.1.jar, commons-digester-1.7.jar, commons-logging-1.0.2.jar, iText-2.1.4.jar, xalan.jar, xercesImpl.jar, xml-apis.jar Please anyone help.. Code:Exception is :SEVERE: Digester.getParser: org.xml.sax.SAXNotRecognizedException: http://apache.org/xml/features/validation/dynamic at oracle.xml.jaxp.JXSAXParserFactory.setFeature(JXSAXParserFactory.java:128) at org.apache.commons.digester.parser.XercesParser.configureXerces(XercesParser.java:185) at org.apache.commons.digester.parser.XercesParser.newSAXParser(XercesParser.java:138) at org.apache.commons.digester.ParserFeatureSetterFactory.newSAXParser(ParserFeatureSetterFactory.java:71) at org.apache.commons.digester.Digester.getParser(Digester.java:692) at org.apache.commons.digester.Digester.getXMLReader(Digester.java:899) at org.apache.commons.digester.Digester.parse(Digester.java:1647) at org.apache.struts.action.ActionServlet.parseModuleConfigFile(ActionServlet.java:1006) at org.apache.struts.action.ActionServlet.initModuleConfig(ActionServlet.java:955) at org.apache.struts.action.ActionServlet.init(ActionServlet.java:470) at javax.servlet.GenericServlet.init(GenericServlet.java:256) at com.evermind.server.http.HttpApplication.loadServlet(HttpApplication.java:2379) at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4830) at com.evermind.server.http.HttpApplication.findServlet(HttpApplication.java:4754) at com.evermind.server.http.HttpApplication.initPreloadServlets(HttpApplication.java:4942) at com.evermind.server.http.HttpApplication.initDynamic(HttpApplication.java:1144) at com.evermind.server.http.HttpApplication.<init>(HttpApplication.java:741) at com.evermind.server.ApplicationStateRunning.getHttpApplication(ApplicationStateRunning.java:431) at com.evermind.server.Application.getHttpApplication(Application.java:586) at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.createHttpApplicationFromReference(HttpSite.java:1987) at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.createHttpApplicationFromReference(HttpSite.java:1970) at com.evermind.server.http.HttpSite$HttpApplicationRunTimeReference.getHttpApplication(HttpSite.java:1922) at com.evermind.server.http.HttpSite.getApplication(HttpSite.java:423) at com.evermind.server.http.HttpRequestHandler.resolveApplication(HttpRequestHandler.java:398) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:439) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234) at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:298) at java.lang.Thread.run(Thread.java:595)

Hi Srikanth.. Your code is working fine.. Thankyou very much. If you know anything about this,please help me out. In html format,Unable to get page break for multiple pages

Thanks.. Code:<?xml version="1.0" encoding="UTF-8"?><jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xsd/jasperreport.xsd" name="ShipConsole.jrxml" pageWidth="2000" pageHeight="2000" whenNoDataType="AllSectionsNoDetail" columnWidth="1984" leftMargin="8" rightMargin="8" topMargin="20" bottomMargin="20"> <parameter name="IP_ORG_ID" class="java.lang.Integer"/> <parameter name="IP_INV_ORGANIZATION_ID" class="java.lang.Integer"/> <parameter name="IP_CARRIER_CODE" class="java.lang.Integer"/> <parameter name="IP_FROM_DATE" class="java.util.Date"/> <parameter name="IP_TO_DATE" class="java.util.Date"/> <parameter name="IP_USER_METHOD_MEANING" class="java.lang.String"/> <queryString> <![CDATA[select * from aasc_exporttoexcel_report_view where organization_id = $P{IP_ORG_ID} AND inv_organization_id = $P{IP_INV_ORGANIZATION_ID} and carrier_code = $P{IP_CARRIER_CODE} and user_shipmethod_meaning = NVL ($P{IP_USER_METHOD_MEANING}, user_shipmethod_meaning) and shipment_date between $P{IP_FROM_DATE} and $P{IP_TO_DATE} order by shipment_date desc]]> </queryString> <field name="VOID_FLAG" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="SHIPMENT_DATE" class="java.sql.Timestamp"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="COUNT" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="CUSTOMER_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="REFERENCE1" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ORDER_NUMBER" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DELIVERY_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="PACKAGE_VOID_FLAG" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="TOTAL_PKG_WEIGHT" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="WEIGHT" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="WAYBILL_NUMBER" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="CARRIER_PAY_CODE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="FREIGHT_CHARGES" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="SHIP_FLAG" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ORGANIZATION_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="INV_ORGANIZATION_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="CARRIER_CODE" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="USER_SHIPMETHOD_MEANING" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <background> <band/> </background> <title> <band height="66"> <line> <reportElement x="0" y="0" width="1947" height="1"/> </line> <staticText> <reportElement x="460" y="13" width="523" height="25"/> <textElement> <font size="18" isBold="true"/> </textElement> <text><![CDATA[Carrier Shipment Activity Detail Report]]></text> </staticText> <line> <reportElement x="0" y="49" width="1947" height="1"/> </line> </band> </title> <pageHeader> <band/> </pageHeader> <columnHeader> <band height="21"> <staticText> <reportElement mode="Opaque" x="0" y="-2" width="154" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT VOID INDICATOR]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="165" y="-2" width="136" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT PICKUP DATE]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="386" y="-2" width="103" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[NO. OF PACKAGES]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="499" y="-2" width="127" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIP TO CUSTOMER ID]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="638" y="-2" width="131" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[PACKAGE REFERENCE1]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="779" y="-2" width="145" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[PACKAGE REFERENCE2]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="934" y="-2" width="135" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[PACKAGE REFERENCE3]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1082" y="-2" width="155" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11" isUnderline="false"/> </textElement> <text><![CDATA[PACKAGE VOID INDICATOR]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1247" y="-2" width="162" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT BILLABLE WEIGHT]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1419" y="-2" width="105" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[PACKAGE WEIGHT]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1534" y="-2" width="116" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT ID]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1662" y="-2" width="152" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIPMENT BILLING OPTION]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="1832" y="-2" width="115" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[FREIGHT_CHARGES]]></text> </staticText> <staticText> <reportElement mode="Opaque" x="312" y="-2" width="62" height="18" forecolor="#FFFFFF" backcolor="#999999"/> <textElement> <font size="11"/> </textElement> <text><![CDATA[sHIP FLAG]]></text> </staticText> </band> </columnHeader> <detail> <band height="21"> <textField> <reportElement x="0" y="-5" width="154" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{VOID_FLAG}]]></textFieldExpression> </textField> <textField pattern=""> <reportElement x="165" y="-5" width="136" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{SHIPMENT_DATE}]]></textFieldExpression> </textField> <textField> <reportElement x="386" y="-5" width="103" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{COUNT}]]></textFieldExpression> </textField> <textField> <reportElement x="499" y="-5" width="127" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{CUSTOMER_ID}]]></textFieldExpression> </textField> <textField> <reportElement x="638" y="-5" width="131" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{REFERENCE1}]]></textFieldExpression> </textField> <textField> <reportElement x="779" y="-5" width="145" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{ORDER_NUMBER}]]></textFieldExpression> </textField> <textField> <reportElement x="934" y="-5" width="135" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{DELIVERY_ID}]]></textFieldExpression> </textField> <textField> <reportElement x="1082" y="-5" width="155" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{PACKAGE_VOID_FLAG}]]></textFieldExpression> </textField> <textField> <reportElement x="1247" y="-5" width="162" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{TOTAL_PKG_WEIGHT}]]></textFieldExpression> </textField> <textField> <reportElement x="1419" y="-5" width="105" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{WEIGHT}]]></textFieldExpression> </textField> <textField> <reportElement x="1534" y="-5" width="116" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{WAYBILL_NUMBER}]]></textFieldExpression> </textField> <textField> <reportElement x="1662" y="-5" width="152" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{CARRIER_PAY_CODE}]]></textFieldExpression> </textField> <textField> <reportElement x="1832" y="-5" width="115" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{FREIGHT_CHARGES}]]></textFieldExpression> </textField> <textField> <reportElement x="312" y="-5" width="62" height="20"/> <textElement> <font size="12"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[$F{SHIP_FLAG}]]></textFieldExpression> </textField> </band> </detail> <columnFooter> <band/> </columnFooter> <pageFooter> <band height="28"/> </pageFooter> <summary> <band/> </summary></jasperReport>

Hi Srikanth, Thanks for ur reply. I dont have groups in my report,but still column headers are not printed in all the pages of the report.

Hi friends, Please let me know which attribute to change inorder to display column names on all pages of Jasper report while printing.. Thanks Madhavi

Hi shiyam, I am also unable to generate Jasper report in text format..So,got shifted to display it in CSV and HTML format. Here,I am placing my entire code. I am using following jar files: jasperreports-3.1.4.jar commons-collections-2.1.jar commons-digester-1.7.jar commons-logging-1.0.2.jar classes12.jar iText-2.1.4.jar commons-beanutils-1.7.jar Please let me know if u have any queries. Bye Madhavi Code: HashMap parameters = new HashMap(); parameters.put(JRParameter.IS_IGNORE_PAGINATION, Boolean.TRUE); jasperDesign = JRXmlLoader.load(reportFile); parameters.put("IP_ORG_ID",orgId); parameters.put("IP_INV_ORGANIZATION_ID",inv_organization_id); parameters.put("IP_CARRIER_CODE",carrierId); parameters.put("IP_USER_METHOD_MEANING",shipMethodStr);jasperReport = JasperCompileManager.compileReport(jasperDesign);Connection jdbcConnection = connectDB(databaseName, userName, password); jasperPrint = JasperFillManager.fillReport(jasperReport, parameters,jdbcConnection); OutputStream ouputStream = response.getOutputStream(); JRExporter exporter = null;if( "HTML".equalsIgnoreCase(reportType) ) //working fine without images { exporter = new JRHtmlExporter(); request.getSession().setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, jasperPrint); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream); // gonna set url pattern given for Image servlet with a reponse parameter <url-pattern>/image</url-pattern> exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI,"imageServlet?image="); response.setContentType("text/html"); response.setHeader("Content-Disposition","inline;filename=file.html"); // exporter.exportReport(); } else if( "CSV".equalsIgnoreCase(reportType)) { exporter = new JRCsvExporter(); exporter.setParameter(JRCsvExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRCsvExporterParameter.FIELD_DELIMITER, ","); exporter.setParameter(JRCsvExporterParameter.RECORD_DELIMITER,System.getProperty("line.separator")); exporter.setParameter(JRCsvExporterParameter.OUTPUT_STREAM, ouputStream); response.setContentType("text/csv"); response.setHeader("Content-Disposition","inline;filename=file.csv"); } try { exporter.exportReport(); } catch (JRException e) { throw new ServletException(e); } finally { if (ouputStream != null) { try { ouputStream.flush(); ouputStream.close(); } catch (IOException ex) { logger.info("exception=="+ex); ex.printStackTrace(); } } } public static Connection connectDB(String databaseName, String userName, String password) { Connection jdbcConnection = null; try{ Class.forName("oracle.jdbc.driver.OracleDriver"); jdbcConnection = DriverManager.getConnection(databaseName,userName,password); }catch(Exception ex) { String connectMsg = "Could not connect to the database: " + ex.getMessage() + " " + ex.getLocalizedMessage(); logger.info(connectMsg); } return jdbcConnection; }

Hi friends, Here is my situation. I am creating jasper report of various outputs from java. I am getting it successful but i am getting blank pages when no data is retrived from backend query. I need to display some user friendly message from java on to webpage. 1) Is there any way to do that? Can we catch any exception from Jasper --reportexporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); 2) I am unable to get images in html format.What do I need to change? Thanks... Code: HashMap parameters = new HashMap(); parameters.put("IP_ORG_ID",orgId); parameters.put("IP_INV_ORGANIZATION_ID",inv_organization_id); parameters.put("IP_CARRIER_CODE",carrierId); parameters.put("IP_USER_METHOD_MEANING",shipMethodStr); jasperReport = JasperCompileManager.compileReport(jasperDesign); Connection jdbcConnection = connectDB(databaseName, userName, password);jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, jdbcConnection); OutputStream ouputStream = response.getOutputStream(); JRExporter exporter = null; if( "PDF".equalsIgnoreCase(reportType) ) { response.setContentType("application/pdf"); exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream); } else if( "HTML".equalsIgnoreCase(reportType) ) { exporter = new JRHtmlExporter(); request.getSession().setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, jasperPrint); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream); parameter <url-pattern>/image</url-pattern> exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI,"images/aasc_logo.gif"); }exporter.exportReport();

I am unable to generate csv reports with Jasper reports. Problem: System Doesn't recognize the format for csv. It gives the download file box with save & cancel buttons & then open & associate with box. Its showing File name : File.csv Type: Unknown type Please help me solve this issue Code:Code: OutputStream ouputStream = response.getOutputStream(); JRExporter exporter = null; exporter = new JRCsvExporter();exporter.setParameter(JRCsvExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRCsvExporterParameter.FIELD_DELIMITER, ",");exporter.setParameter(JRCsvExporterParameter.RECORD_DELIMITER,System.getProperty("line.separator"));exporter.setParameter(JRCsvExporterParameter.OUTPUT_STREAM, ouputStream);response.setContentType("text/csv");response.setHeader("Content-Disposition","inline;filename=file.csv"); exporter.exportReport();

Hi Srikanth, Thanks for your reply. Using JRCsvExporter only, we can export the report to plain text format itseems. But I am unable to do it. Even, I am unable to export a report to RTF format.Donno the reason. Its opening as unknown document.Please provide me code to export to csv(tab delimited) or look at my code and tell me where i am going wrong. Snippet code: jasperDesign = JRXmlLoader.load(reportFile); jasperReport = JasperCompileManager.compileReport(jasperDesign); Connection jdbcConnection = connectDB(databaseName, userName, password); jasperPrint = JasperFillManager.fillReport(jasperReport, null, jdbcConnection); OutputStream ouputStream = response.getOutputStream(); JRExporter exporter = null; response.setContentType("application/csv"); response.setHeader("Content-Disposition","inline;filename=file.csv"); exporter = new JRCsvExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream); Thanks

Hello friends, Can anyone please send me code of how to create plain text output using Jasper Reports. I am using, Tomcat server and Open Office Thanks

Hi friends, I am able to get pdf,html(without images),xml output while running jasper reports.But unable to get rtf,xls and csv reports. I am getting excel file without any data. I am using Open Office 3.0 and IE 7 Please let me know how to proceed with jasper reports for getting output in rtf,xls and csv formats. How to find images in html file? Thanks in advance. Code:jasperPrint = JasperFillManager.fillReport(jasperReport, null, jdbcConnection); String reporttype="xls"; OutputStream ouputStream = response.getOutputStream(); JRExporter exporter = null; if( "pdf".equalsIgnoreCase(reporttype) ) //working fine { response.setContentType("application/pdf"); exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream); } else if( "htm".equalsIgnoreCase(reporttype) ) //working fine without images { exporter = new JRHtmlExporter(); request.getSession().setAttribute(ImageServlet.DEFAULT_JASPER_PRINT_SESSION_ATTRIBUTE, jasperPrint); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream); // gonna set url pattern given for Image servlet with a reponse parameter <url-pattern>/image</url-pattern> exporter.setParameter(JRHtmlExporterParameter.IMAGES_URI,"image?image="); // exporter.exportReport(); } else if( "csv".equalsIgnoreCase(reporttype)) { response.setContentType("application/csv"); response.setHeader("Content-Disposition","inline;filename=file.csv"); exporter = new JRCsvExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, ouputStream); } else if("xml".equalsIgnoreCase(reporttype)) //working fine { JasperExportManager.exportReportToXmlStream(jasperPrint,ouputStream); } else if( "xls".equalsIgnoreCase(reporttype) ) { response.setContentType("application/vnd.ms-excel"); response.setHeader("Content-Disposition","inline;filename=xlsFile.xls"); exporter = new JRXlsExporter(); 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) { } } }

Hi Friends, I am facing a typical problem I have my web application(using Jasper Reports) in my windows tomcat.I am able to run it from here,and view the output through Jasper Viewer. But when I run it from another system(using my IP address,thus becoming client to my server tomcat),I am unable to get the output, Instead,I am getting output in my machine(Server) Could you please help this out. Thanks

Thanks a lot for your reply.. Now,a faced a typical problem I have my application in my windows tomcat.I am able to run it from here,and view the output through Jasper Viewer. But when I run it from another system(using my IP address,thus becoming client to my server tomcat),I am unable to get the output, Instead,I am getting output in my machine(Server) Could you please help this out. Thanks

Hi All, I am new to Jasper Reports. I tried to create a jasper report and run it in windows Tomcat server.It worked fine.But,when I tried to port that in linux, I am getting following exception: java.awt.HeadlessException: No X11 DISPLAY variable was set, but this program performed an operation which requires it. java.awt.HeadlessException: No X11 DISPLAY variable was set, but this program performed an operation which requires it. at java.awt.GraphicsEnvironment.checkHeadless(GraphicsEnvironment.java:159) at java.awt.Window.<init>(Window.java:318) at java.awt.Frame.<init>(Frame.java:419) at java.awt.Frame.<init>(Frame.java:384) at javax.swing.JFrame.<init>(JFrame.java:150) at net.sf.jasperreports.view.JasperViewer.<init>(JasperViewer.java:173) at net.sf.jasperreports.view.JasperViewer.viewReport(JasperViewer.java:448) at net.sf.jasperreports.view.JasperViewer.viewReport(JasperViewer.java:396) at com.aasc.model.ReportDriver.runReport(ReportDriver.java:88) at com.aasc.view.ReportsInfoAction.execute(ReportsInfoAction.java:709) at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484) at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274) at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482) at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Thread.java:595) Could not create the report Here,I am using JASPER VIEWER as my output display. Searched in google but could'nt get proper response. Please help me solve out my problem Thanks in advance.