Forum:

Other Open Source Projects

jasper report- error

Greenhorn

Posts: 13

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi,

I need to generate a report as a pdf using ireport through db connection

This is my code...i'm using IDE 6.9

[color=blue]
import java.sql.*;
import java.util.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;
import net.sf.jasperreports.engine.*;
import net.sf.jasperreports.engine.design.*;
import net.sf.jasperreports.engine.export.*;
import net.sf.jasperreports.engine.JasperExportManager;

public class Report
{
    public static void main(String[] args)throws ClassNotFoundException, SQLException, JRException
    {
        //JasperDesign jasperDesign;
        
        try
        {
               Class.forName("org.postgresql.Driver");
               //Class.forName("com.microsoft.postgresqlserver.jdbc.postgresqlDriver");
               //String ConnectionUrl = "jdbc:postgresql://220.226.2.43;"+"databaseName = mysorepoc;user=postgres;password=secretcloset";
               //Connection connection = DriverManager.getConnection(ConnectionUrl);
               String reportFile = "D://report1.jrxml";
               Connection connection = DriverManager.getConnection("jdbc:postgresql://220.226.2.43:5432/mysorepoc","postgres" ,"secretcloset");
              // connection.setAutoCommit(false);
               Statement statement=connection.createStatement();
               String q="Select * from archived_obu_data where obu_serial_number ='5946'  and speed > '30' and obu_time between '2010-08-08  01:00:00' and  '2010-08-08  23:59:59'";
               ResultSet result=statement.executeQuery(q);
               //System.out.println(result);

HashMap jasperParameter = new HashMap();
               Map parameters = new HashMap();
              // JasperDesign jasperDesign = JasperManager.loadXmlDesign("D://report1.jrxml");
               //JasperReport jasperReport = JasperManager.compileReport(jasperDesign);

JasperReport jasperReport = JasperCompileManager.compileReport(reportFile);
               System.out.println("1");
               //JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters,new JRResultSetDataSource(result));
               JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters,new JRResultSetDataSource(result));
               System.out.println("2");
               JasperExportManager.exportReportToPdfFile(jasperPrint,"D://report1.pdf");
               System.out.println("3");

/* if(jasperPrint.getPages().isEmpty()== false)
            {
                JasperExportManager.exportReportToPdfFile(jasperPrint,"D://1.pdf");
                System.out.println("your file updated to pdf file plz check pdf file on desktop");
            }*/

}
        catch(Exception e)
        {
              System.out.println("Error"+e);

}
    }

}[/color]

have added these jar files

Jasper.jar
commons-beanutils-1.8.2.jar
commons-collections-3.2.1.jar
commons-digester-1.7.jar
commons-logging-1.1.jar
iText-2.1.0.jar
jasperreports-3.7.1.jar
postgresql-8.4-701.jdbc3.jar
jdt-compiler-3.1.1.jar

error is:

Errornet.sf.jasperreports.engine.JRException: Errors were encountered when compiling report expressions class file:
1. The operator % is undefined for the argument type(s) Integer, int
value = (java.lang.Boolean)(((java.lang.Integer)variable_REPORT_COUNT.getValue())%2 == 0); //$JR_EXPR_ID=10$
<----------------------------------------------------->
2. The operator % is undefined for the argument type(s) Integer, int
value = (java.lang.Boolean)(((java.lang.Integer)variable_REPORT_COUNT.getOldValue())%2 == 0); //$JR_EXPR_ID=10$
<-------------------------------------------------------->
3. The operator % is undefined for the argument type(s) Integer, int
value = (java.lang.Boolean)(((java.lang.Integer)variable_REPORT_COUNT.getEstimatedValue())%2 == 0); //$JR_EXPR_ID=10$
<-------------------------------------------------------------->
3 errors

BUILD SUCCESSFUL (total time: 7 seconds)

can anyone please help in solving this.

Thanks.

Jigar Naik

Ranch Hand

Posts: 763

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Can you please share your report1.jrxml file ?

Jigar Naik

Saranya Sivakumar

Greenhorn

Posts: 13

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

This is my report1.jrxml

<?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="report1" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<style name="Title" isDefault="false" forecolor="#FFFFFF" fontName="Times New Roman" fontSize="50" isBold="false" pdfFontName="Times-Bold"/>
	<style name="SubTitle" isDefault="false" forecolor="#CCCCCC" fontName="Times New Roman" fontSize="18" isBold="false" pdfFontName="Times-Roman"/>
	<style name="Column header" isDefault="false" forecolor="#666666" fontName="Times New Roman" fontSize="14" isBold="true" pdfFontName="Times-Roman"/>
	<style name="Detail" isDefault="false" mode="Transparent" fontName="Times New Roman" pdfFontName="Times-Roman"/>
	<style name="Row" isDefault="false" mode="Transparent" fontName="Times New Roman" pdfFontName="Times-Roman">
		<conditionalStyle>
			<conditionExpression><![CDATA[$V{REPORT_COUNT}%2 == 0]]></conditionExpression>
			<style isDefault="false" style="Row" mode="Opaque" backcolor="#F0EFEF"/>
		</conditionalStyle>
	</style>
	<queryString language="SQL">
		<![CDATA[Select * from archived_obu_data where obu_serial_number ='5946'  and speed > '30' and obu_time between '2010-08-08  01:00:00' and  '2010-08-08  23:59:59']]>
	</queryString>
	<field name="obu_serial_number" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="lat" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="lon" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="speed" class="java.math.BigDecimal">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="obu_time" class="java.sql.Timestamp">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="102" splitType="Stretch">
			<image>
				<reportElement x="725" y="0" width="77" height="102"/>
				<imageExpression class="java.lang.String"><![CDATA["cherry.jpg"]]></imageExpression>
			</image>
			<frame>
				<reportElement mode="Opaque" x="0" y="0" width="721" height="66" backcolor="#000000"/>
				<staticText>
					<reportElement style="Title" x="0" y="0" width="370" height="66"/>
					<box topPadding="4" leftPadding="4" bottomPadding="4" rightPadding="4"/>
					<textElement verticalAlignment="Bottom">
						<font isBold="false"/>
					</textElement>
					<text><![CDATA[Cherry Title]]></text>
				</staticText>
				<staticText>
					<reportElement style="SubTitle" x="370" y="37" width="316" height="29"/>
					<textElement textAlignment="Right">
						<font size="22" isBold="false"/>
					</textElement>
					<text><![CDATA[Cherry SubTitle]]></text>
				</staticText>
			</frame>
			<frame>
				<reportElement mode="Opaque" x="0" y="70" width="721" height="32" forecolor="#000000" backcolor="#CC0000"/>
				<textField pattern="EEEEE dd MMMMM yyyy">
					<reportElement x="553" y="12" width="144" height="20" forecolor="#FFFFFF"/>
					<textElement textAlignment="Right">
						<font size="12"/>
					</textElement>
					<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</title>
	<pageHeader>
		<band splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="18" splitType="Stretch">
			<staticText>
				<reportElement style="Column header" x="0" y="0" width="159" height="18" forecolor="#000000"/>
				<textElement>
					<font isBold="false"/>
				</textElement>
				<text><![CDATA[obu_serial_number]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="159" y="0" width="159" height="18" forecolor="#000000"/>
				<textElement>
					<font isBold="false"/>
				</textElement>
				<text><![CDATA[lat]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="318" y="0" width="159" height="18" forecolor="#000000"/>
				<textElement>
					<font isBold="false"/>
				</textElement>
				<text><![CDATA[lon]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="477" y="0" width="159" height="18" forecolor="#000000"/>
				<textElement>
					<font isBold="false"/>
				</textElement>
				<text><![CDATA[speed]]></text>
			</staticText>
			<staticText>
				<reportElement style="Column header" x="636" y="0" width="159" height="18" forecolor="#000000"/>
				<textElement>
					<font isBold="false"/>
				</textElement>
				<text><![CDATA[obu_time]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="18" splitType="Stretch">
			<frame>
				<reportElement style="Row" mode="Opaque" x="0" y="0" width="797" height="18"/>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" positionType="Float" x="0" y="0" width="159" height="18"/>
					<textElement>
						<font size="14"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[$F{obu_serial_number}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" positionType="Float" x="159" y="0" width="159" height="18"/>
					<textElement>
						<font size="14"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{lat}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" positionType="Float" x="318" y="0" width="159" height="18"/>
					<textElement>
						<font size="14"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{lon}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" positionType="Float" x="477" y="0" width="159" height="18"/>
					<textElement>
						<font size="14"/>
					</textElement>
					<textFieldExpression class="java.math.BigDecimal"><![CDATA[$F{speed}]]></textFieldExpression>
				</textField>
				<textField isStretchWithOverflow="true">
					<reportElement style="Detail" positionType="Float" x="636" y="0" width="159" height="18"/>
					<textElement>
						<font size="14"/>
					</textElement>
					<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{obu_time}]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</detail>
	<columnFooter>
		<band height="7" 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="25" splitType="Stretch">
			<frame>
				<reportElement mode="Opaque" x="0" y="0" width="802" height="25" forecolor="#D0B48E" backcolor="#000000"/>
				<textField evaluationTime="Report">
					<reportElement style="Column header" x="757" y="3" width="40" height="20" forecolor="#FFFFFF"/>
					<textElement verticalAlignment="Middle">
						<font size="10" isBold="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
				</textField>
				<textField>
					<reportElement style="Column header" x="677" y="3" width="80" height="20" forecolor="#FFFFFF"/>
					<textElement textAlignment="Right" verticalAlignment="Middle">
						<font size="10" isBold="false"/>
					</textElement>
					<textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
				</textField>
				<textField pattern="EEEEE dd MMMMM yyyy">
					<reportElement style="Column header" x="2" y="3" width="197" height="20" forecolor="#FFFFFF"/>
					<textElement verticalAlignment="Middle">
						<font size="10" isBold="false"/>
					</textElement>
					<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
				</textField>
			</frame>
		</band>
	</pageFooter>
	<summary>
		<band splitType="Stretch"/>
	</summary>
</jasperReport>

Jigar Naik

Ranch Hand

Posts: 763

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Here is the issue :

% is not applicable to Integer, convert it into int.

try using

intValue()

Jigar Naik

Saranya Sivakumar

Greenhorn

Posts: 13

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

If i convert it like the code below i'm not able to execute(preview) my report in ireport.

if i remove the jdt-compiler-3.1.1.jar i'm not getting the error which i have mentioned previously but with this

i can't get with this " report1_1281420667859_69790.java "

can you please help me in solving this...
thanks.

Saranya Sivakumar

Greenhorn

Posts: 13

posted 14 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

hi Jigar Naik,

Thanks a lot...got it done...

added this jar also -
commons-javaflow-20060411.jar

mooooooo ..... tiny ad ....

We need your help - Coderanch server fundraiser

https://coderanch.com/wiki/782867/Coderanch-server-fundraiser