Problems due to font in HTML,PDF,EXCEL

2002 JI Open Discussion · August 19, 2006

By: jayalakshmi - jayashaki

2004-01-03 01:28

Hello all,

The reports are generating fine in PDF,HTML,EXCEL formats, but the font size in HTML is very small when compared with PDF,EXCEL.I cannot do modifications in XML as b'cos it will refelct in all the three. So, i have written a function using the class JRDesignReportFont, but the problem is I want some text to be bold and some to be in normal. The Bold is not working, so i started to use the normal font with isBold="true", but as i change the size in java file it affects only to the textFieldExpressions i.e. $F not for static text,the size is changed only to the datas from the database and for the static text, it remains the same. Kindly help me.

XML file:

<?xml version="1.0"?>

<!DOCTYPE jasperReport PUBLIC "-//JasperReports//DTD Report Design//EN" "http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">

<jasperReport

name="UserBasedReport"

columnCount="1"

printOrder="Vertical"

pageWidth="595"

pageHeight="842"

columnWidth="270"

columnSpacing="15"

leftMargin="20"

rightMargin="20"

topMargin="30"

bottomMargin="30"

isTitleNewPage="true"

isSummaryNewPage="false"

whenNoDataType="AllSectionsNoDetail">

<!--<reportFont name="Times_Bold" isDefault="false" fontName="Times New Roman MS" size = "10" isBold="true" pdfFontName="Times-Bold" pdfEncoding="Cp1252" isPdfEmbedded="true"/>

<queryString>$P!{MySQLQuery}</queryString>

</group>

<title>

</textElement>

</staticText>

</textElement>

$P{date}

</textFieldExpression>

</textField>

</textElement>

<text>USER BASED REPORT</text>

</staticText>

</textElement>

<text>Selection Criteria</text>

</staticText>

</textElement>

$P{SELECTION}

</textFieldExpression>

</textField>

</textElement>

<text>Report generated by </text>

</staticText>

</textElement>

$P{FOOTER}

</textFieldExpression>

</textField>

</textElement>

</staticText>

</textElement>

$V{PAGE_NUMBER}

</textFieldExpression>

</textField>

</band>

</title>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

<line>

</line>

</elementGroup>

<line>

</line>

</elementGroup>

</textElement>

</staticText>

</textElement>

<text>Product</text>

</staticText>

</textElement>

<text>Therapeutic Name</text>

</staticText>

</textElement>

</staticText>

</textElement>

<text>No.of Inquiries Assigned</text>

</staticText>

</textElement>

<text>No.of Inquiries</text>

</staticText>

</band>

</columnHeader>

</textElement>

$F{USER_ID}

</textFieldExpression>

</textField>

</textElement>

$F{PRODUCT_NAME}

</textFieldExpression>

</textField>

</textElement>

$F{THERAPEUTIC_NAME}

</textFieldExpression>

</textField>

</textElement>

$F{ROLE}

</textFieldExpression>

</textField>

</textElement>

$F{QUERY_COUNT}

</textFieldExpression>

</textField>

</textElement>

$F{F410999}

</textFieldExpression>

</textField>

</band>

</detail>

<line>

</line>

</band>

</columnFooter>

</textElement>

<text>Report generated by </text>

</staticText>

</textElement>

$P{FOOTER}

</textFieldExpression>

</textField>

</textElement>

</staticText>

</textElement>

$V{PAGE_NUMBER}

</textFieldExpression>

</textField>

</textElement>

</staticText>

</textElement>

$V{PAGE_NUMBER}

</textFieldExpression>

</textField>

</band>

</pageFooter>

</jasperReport>

JAVA file:

package com.sysarris.medcomm.app;

import java.util.*;

import java.sql.*;

import java.io.*;

import java.net.*;

import dori.jasper.engine.JasperExportManager;

import dori.jasper.engine.xml.JRXmlLoader;

import dori.jasper.engine.design.*;

import dori.jasper.engine.util.JRQueryExecuter;

import dori.jasper.engine.*;

import dori.jasper.engine.export.*;

import dori.jasper.engine.util.*;

import dori.jasper.view.*;

import java.awt.*;

public class JasperRepBean{

public static Connection conn = null;

private String sqlQuery = null;

private String realPath = null;

private int reportFormat = 0;

private String repTemplate = null;

private int reportNo = 0;

private String repCriteria = null;

private String repUsername = null;

private String destPath = null;

public void setSqlQuery(String FileStr) {

this.sqlQuery = FileStr;

}

public void setRealPath(String PathStr) {

this.realPath = PathStr;

}

public void setReportFormat(int reportFormat) {

this.reportFormat = reportFormat;

}

public void setRepTemplate(String repTemplate) {

this.repTemplate = repTemplate;

}

public void setreportNo(int reportNo) {

this.reportNo = reportNo;

}

public void setrepCriteria(String repCriteria) {

this.repCriteria = repCriteria;

}

public void setrepUsername(String repUsername) {

this.repUsername = repUsername;

}

public void setdestPath(String destPath) {

this.destPath = destPath;

}

public String getSqlQuery() {

return sqlQuery;

}

public String getRealPath() {

return realPath;

}

public int getReportFormat() {

return reportFormat;

}

public String getRepTemplate() {

return repTemplate;

}

public int getreportNo() {

return reportNo;

}

public String getrepCriteria() {

return repCriteria;

}

public String getrepUsername() {

return repUsername;

}

public String getdestPath() {

return destPath;

}

//This Estabilishes the connection

public static Connection getConnection(){

try{

String url = (String)InitApplicationParams.getApplicationProperty("DB_URL");

String userName = (String)InitApplicationParams.getApplicationProperty("DB_USER");

String password = (String)InitApplicationParams.getApplicationProperty("DB_PASSWORD");

String driverName = "oracle.jdbc.driver.OracleDriver";

Class.forName("oracle.jdbc.driver.OracleDriver");

conn = DriverManager.getConnection(url, userName, password);

return conn;

}catch(Exception se){

se.printStackTrace();

return null;

}

// this method gets the sysdate from oracle database

public static String getSysdate(){

try{

Connection lcnSysdate=null;

Statement lstmtSysdate=null;

ResultSet lrsSysdate=null;

String repSysdate = null;

lcnSysdate = getConnection();

lstmtSysdate=lcnSysdate.createStatement();

lrsSysdate=lstmtSysdate.executeQuery("select to_char(sysdate,'DD-Mon-YYYY HH:MM:SS') from DUAL");

while(lrsSysdate.next())

{

repSysdate=lrsSysdate.getString(1);

}

return repSysdate;

}catch(Exception se){

return null;

}

private JasperDesign getJasperDesign(String sourceFileName, int repFormat) throws JRException

{

try

{

JasperDesign jasperDesign = JRXmlLoader.load(sourceFileName);

jasperDesign.setName(getRepTemplate());

System.out.println("Getting Report Template");

//Fonts

JRDesignReportFont normalFont = new JRDesignReportFont();

normalFont.setName("Times_Normal1");

normalFont.setDefault(true);

normalFont.setFontName("Times New Roman MS");

normalFont.setBold(true);

/* normalFont.setPdfFontName("Times-Roman");

normalFont.setPdfEncoding("Cp1252");

normalFont.setPdfEmbedded(false);*/

jasperDesign.addFont(normalFont);

JRDesignReportFont boldFont = new JRDesignReportFont();

boldFont.setName("Times_Bold1");

boldFont.setDefault(false);

boldFont.setFontName("Times New Roman MS");

boldFont.setBold(true);

/*boldFont.setPdfFontName("Times-Bold");

boldFont.setPdfEncoding("Cp1252");

boldFont.setPdfEmbedded(false);

jasperDesign.addFont(boldFont); */

if(repFormat == 1)

{

System.out.println(" Getting into - PDF");

normalFont.setSize(14);

boldFont.setSize(13);

}

else if(repFormat==2)

{

System.out.println(" Getting into - HTML");

normalFont.setSize(20);

boldFont.setSize(25);

}

else if(repFormat==3)

{

System.out.println(" Getting into - EXCEL");

normalFont.setSize(12);

boldFont.setSize(50);

}

System.out.println("Getting Report Font");

return jasperDesign;

}

catch (JRException e)

{

e.printStackTrace();

System.exit(1);

}return null;

}

public String repNameCompileReport(String sourceFileName, int repFormat) throws JRException

{

File sourceFile = new File(sourceFileName);

System.out.println("Source file");

//JasperDesign jasperDesign = JRXmlLoader.load(sourceFileName);

// jasperDesign.setName(getRepTemplate());

JasperDesign jasperDesign = getJasperDesign(sourceFileName,repFormat);

System.out.println("Getting into Dest file");

File destFile = new File(sourceFile.getParent(), jasperDesign.getName() + ".jasper");

String destFileName = destFile.toString();

System.out.println("Getting out Destination file");

System.out.println("Starts to compile");

JasperCompileManager.compileReportToFile(jasperDesign, destFileName);

System.out.println("Compilation completed");

return destFileName;

}

// this method converts the xml to HTML

public void convertHtml(String repTempFill){

try{

//JasperExportManager.exportReportToHtmlFile(repTempFill);

JasperExportManager.exportReportToHtmlFile(repTempFill,getdestPath());

}catch (JRException e){

e.printStackTrace();

System.exit(1);

}catch (Exception e){}

}

//this method converts the xml to Pdf

public void convertPdf(String repTempFill){

try{

//JasperExportManager.exportReportToPdfFile(repTempFill);

JasperExportManager.exportReportToPdfFile(repTempFill,getdestPath());

}catch (JRException e){

e.printStackTrace();

System.exit(1);

}catch (Exception e){}

}

//this method converts the xml to EXCEL

public void convertExcel(String repTempFill,File sourceFile){

try{

JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(repTempFill);

File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");

JRXlsExporter exporter = new JRXlsExporter();

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);

exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());

exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);

// exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

exporter.exportReport();

}catch (JRException e){

//e.printStackTrace();

//System.exit(1);

}catch (Exception e){

//e.printStackTrace();

}

//This gets the parameters and build the query

public void buildReport(){

int repNumber = 0;

int repFormat = 0;

String repTempFill = "";

String repTemplate = "";

String destfileName="";

//Specify the parameters values and bind it to the key

Map parameters =new HashMap();

Connection conObj = null;

try{

conObj = getConnection();

if(!(getReportFormat()+"").equals("") ){

repFormat = getReportFormat();

}

if(!(getreportNo()+"").equals("") ){

repNumber = getreportNo();

}

if(repNumber==1)

{

System.out.println("Report number one is called");

parameters.put("MySQLQuery",getSqlQuery());

parameters.put("SELECTION",getrepCriteria());

parameters.put("date",getSysdate());

parameters.put("FOOTER",getrepUsername());

String lStrQry = parameters.get("MySQLQuery").toString();

//compiles the xml file

destfileName=repNameCompileReport(getRealPath(),repFormat);

repTempFill = JasperFillManager.fillReportToFile(destfileName, parameters, conObj);

}

if(repNumber==2)

{

parameters.put("MySQLQuery",getSqlQuery());

parameters.put("SELECTION",getrepCriteria());

parameters.put("date",getSysdate());

parameters.put("FOOTER",getrepUsername());

String lStrQry = parameters.get("MySQLQuery").toString();

//compiles the xml file

destfileName=repNameCompileReport(getRealPath(),repFormat);

repTempFill = JasperFillManager.fillReportToFile(destfileName, parameters, conObj);

}

if(repNumber==3)

{

parameters.put("MySQLQuery",getSqlQuery());

parameters.put("SELECTION",getrepCriteria());

parameters.put("date",getSysdate());

parameters.put("FOOTER",getrepUsername());

String lStrQry = parameters.get("MySQLQuery").toString();

//compiles the xml file

destfileName=repNameCompileReport(getRealPath(),repFormat);

repTempFill = JasperFillManager.fillReportToFile(destfileName, parameters, conObj);

}

if(repNumber==4)

{

parameters.put("MySQLQuery",getSqlQuery());

parameters.put("SELECTION",getrepCriteria());

parameters.put("date",getSysdate());

parameters.put("FOOTER",getrepUsername());

String lStrQry = parameters.get("MySQLQuery").toString();

//compiles the xml file

destfileName=repNameCompileReport(getRealPath(),repFormat);

repTempFill = JasperFillManager.fillReportToFile(destfileName, parameters, conObj);

}

if(repNumber==5)

{

parameters.put("MySQLQuery",getSqlQuery());

parameters.put("SELECTION",getrepCriteria());

parameters.put("date",getSysdate());

parameters.put("FOOTER",getrepUsername());

String lStrQry = parameters.get("MySQLQuery").toString();

//compiles the xml file

destfileName=repNameCompileReport(getRealPath(),repFormat);

repTempFill = JasperFillManager.fillReportToFile(destfileName, parameters, conObj);

}

if(repFormat==1)

{

convertPdf(repTempFill);

}

else if(repFormat==2)

{

convertHtml(repTempFill);

}

else if(repFormat==3)

{

File sourceFile = new File(getdestPath());

convertExcel(repTempFill,sourceFile);

}

else

{

System.out.println("unsupported format");

}

try{

if(!conObj.isClosed()){

conObj.close();

}

}catch(Exception e){}

}catch (JRException e){

//e.printStackTrace();

try{

if(!conObj.isClosed()){

conObj.close();

}

}catch (Exception e3){}

}catch (Exception e1){

//e1.printStackTrace();

try{

if(!conObj.isClosed()){

conObj.close();

}

}catch (Exception e4){}

}

By: Vinod Kumar Singh - vinodsingh

RE: Problems due to font in HTML,PDF,EXCEL

2004-01-03 03:19

While I am unable to fully understand your problem but to increase the font size in HTML file, without changing the xml source try to modify the <JRHtmlExporter.java> instead of <JRDesignReportFont.java>.

Sign In

Problems due to font in HTML,PDF,EXCEL

Recommended Posts

2002 JI Open Discussion

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

Create an account

Sign in

Activity

Products

Explore