Unable to export Jasper Report in html format.

[Anshuman Chakraborty]

Hi,

I am using Jasper Report [ver 4.0.2] for the first time and was going through one of the tutorials.

The code goes like this

        JasperReport jasperReport = null;
        JasperPrint jasperPrint = null;

        Connection connection = createConnection();
        HashMap jasperParameter = new HashMap();

        String absolute_path="D:\\";
        try {
            jasperReport = JasperCompileManager.compileReport(absolute_path+"Sample.jrxml");
            jasperPrint = JasperFillManager.fillReport(jasperReport, jasperParameter, connection);

            // 1- export to PDF.
            JasperExportManager.exportReportToPdfFile(jasperPrint, absolute_path+"sample_report.pdf");

            // 2- export to HTML
            JasperExportManager.exportReportToHtmlFile(jasperPrint, absolute_path+"sample_report.html");
            
            // 3- export to Excel sheet
            JRXlsExporter exporter = new JRXlsExporter();
            exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
            exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, absolute_path+"sample_report.xls");
            exporter.exportReport();

        } catch (JRException ex) {
            Logger.getLogger(JasperExample.class.getName()).log(Level.SEVERE, null, ex);
        }

Well the problem is
1. The exported pdf file is fine and contains all the records from database.
2. html and xls file doesn't contain records but the head and footer is present and the line separating the records are also present.
Basically, formatting is present except for actual database records.

JasperViewer shows all the records.

<?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="Sample" language="java" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20"> <property name="ireport.zoom" value="1.0"/> <property name="ireport.x" value="0"/> <property name="ireport.y" value="0"/> <style name="Title" fontName="Arial" fontSize="26" isBold="true" pdfFontName="Helvetica-Bold"/> <style name="SubTitle" forecolor="#666666" fontName="Arial" fontSize="18"/> <style name="Column header" forecolor="#666666" fontName="Arial" fontSize="12" isBold="true"/> <style name="Detail" fontName="Arial" fontSize="12"/> <queryString> <![CDATA[SELECT js_organisation.`name` AS js_organisation_name, js_organisation.`address` AS js_organisation_address, js_organisation.`contact_person` AS js_organisation_contact_person, js_organisation.`contact_1` AS js_organisation_contact_1, js_organisation.`contact_2` AS js_organisation_contact_2, js_organisation.`contact_3` AS js_organisation_contact_3, js_organisation.`remarks` AS js_organisation_remarks FROM `js_organisation` js_organisation]]> </queryString> <field name="js_organisation_name" class="java.lang.String"/> <field name="js_organisation_address" class="java.lang.String"/> <field name="js_organisation_contact_person" class="java.lang.String"/> <field name="js_organisation_contact_1" class="java.lang.String"/> <field name="js_organisation_contact_2" class="java.lang.String"/> <field name="js_organisation_contact_3" class="java.lang.String"/> <field name="js_organisation_remarks" class="java.lang.String"/> <background> <band splitType="Stretch"/> </background> <title> <band height="69" splitType="Stretch"> <image> <reportElement x="275" y="0" width="300" height="64"/> <imageExpression class="java.lang.String"><![CDATA["leaf_banner_green.png"]]></imageExpression> </image> <staticText> <reportElement style="Title" x="0" y="13" width="263" height="33"/> <textElement verticalAlignment="Middle"/> <text><![CDATA[Organisation]]></text> </staticText> <staticText> <reportElement style="SubTitle" x="110" y="46" width="164" height="22"/> <textElement> <font size="15" isItalic="true"/> </textElement> <text><![CDATA[Organisation Details]]></text> </staticText> </band> </title> <pageHeader> <band splitType="Stretch"/> </pageHeader> <columnHeader> <band height="21" splitType="Stretch"> <staticText> <reportElement style="Column header" x="0" y="0" width="79" height="20"/> <textElement/> <text><![CDATA[Organisation]]></text> </staticText> <staticText> <reportElement style="Column header" x="79" y="0" width="79" height="20"/> <textElement/> <text><![CDATA[Address]]></text> </staticText> <staticText> <reportElement style="Column header" x="158" y="0" width="79" height="20"/> <textElement/> <text><![CDATA[Contact Person]]></text> </staticText> <staticText> <reportElement style="Column header" x="237" y="0" width="79" height="20"/> <textElement/> <text><![CDATA[Contact 1]]></text> </staticText> <staticText> <reportElement style="Column header" x="316" y="0" width="79" height="20"/> <textElement/> <text><![CDATA[Contact 2]]></text> </staticText> <staticText> <reportElement style="Column header" x="395" y="0" width="79" height="20"/> <textElement/> <text><![CDATA[Contact 3]]></text> </staticText> <staticText> <reportElement style="Column header" x="474" y="0" width="79" height="20"/> <textElement/> <text><![CDATA[Remarks]]></text> </staticText> <line> <reportElement positionType="FixRelativeToBottom" x="0" y="19" width="555" height="1"/> <graphicElement> <pen lineWidth="0.5" lineColor="#999999"/> </graphicElement> </line> </band> </columnHeader> <detail> <band height="24" splitType="Stretch"> <textField> <reportElement style="Detail" stretchType="RelativeToTallestObject" x="0" y="0" width="79" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{js_organisation_name}]]></textFieldExpression> </textField> <textField> <reportElement style="Detail" stretchType="RelativeToTallestObject" x="79" y="0" width="79" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{js_organisation_address}]]></textFieldExpression> </textField> <textField> <reportElement style="Detail" stretchType="RelativeToTallestObject" x="158" y="0" width="79" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{js_organisation_contact_person}]]></textFieldExpression> </textField> <textField> <reportElement style="Detail" stretchType="RelativeToTallestObject" x="237" y="0" width="79" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{js_organisation_contact_1}]]></textFieldExpression> </textField> <textField> <reportElement style="Detail" stretchType="RelativeToTallestObject" x="316" y="0" width="79" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{js_organisation_contact_2}]]></textFieldExpression> </textField> <textField> <reportElement style="Detail" stretchType="RelativeToTallestObject" x="395" y="0" width="79" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{js_organisation_contact_3}]]></textFieldExpression> </textField> <textField> <reportElement style="Detail" stretchType="RelativeToTallestObject" x="474" y="0" width="79" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{js_organisation_remarks}]]></textFieldExpression> </textField> <line> <reportElement positionType="FixRelativeToBottom" stretchType="RelativeToTallestObject" x="0" y="19" width="555" height="1"/> <graphicElement> <pen lineWidth="0.5" lineColor="#999999"/> </graphicElement> </line> </band> </detail> <columnFooter> <band height="45" splitType="Stretch"> <line> <reportElement positionType="FixRelativeToBottom" x="0" y="3" width="555" height="1"/> <graphicElement> <pen lineWidth="0.5" lineColor="#999999"/> </graphicElement> </line> </band> </columnFooter> <pageFooter> <band height="20" splitType="Stretch"> <textField> <reportElement style="Column header" x="433" y="0" width="80" height="20"/> <textElement textAlignment="Right"> <font size="10" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression> </textField> <textField evaluationTime="Report"> <reportElement style="Column header" x="513" y="0" width="40" height="20"/> <textElement> <font size="10" isBold="false"/> </textElement> <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression> </textField> <textField pattern="EEEEE dd MMMMM yyyy"> <reportElement style="Column header" x="0" y="0" width="197" height="20"/> <textElement> <font size="10" isBold="false"/> </textElement> <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression> </textField> </band> </pageFooter> <summary> <band splitType="Stretch"/> </summary> </jasperReport>

Library used
* jasperreports-4.0.2.jar
* jasperreports-applet-4.0.2.jar
* jasperreports-fonts-4.0.2.jar
* jasperreports-javaflow-4.0.2.jar
* commons-beanutils-1.8.0.jar
* commons-collections-2.1.1.jar
* commons-digester-1.7.jar
* commons-javaflow-20060411.jar
* commons-logging-1.0.4.jar
* iText-2.1.7.jar
* poi-3.6.jar

[Anshuman Chakraborty]

Hi,

Any suggestion.