Help on the Oracle query string

[2005 IR Help]

By: mezclax - mezclax

Help on the Oracle query string

2004-08-26 04:59

Hi alll;

 

Please help me on this, when i want to view the jasper report it give me this Error:

 

 

[java] 24995 [socketListener-4] ERROR jasper.JasperReportServer - Error cr

eating report: Error executing report query :

 

[java] SELECT kmsEventlog.*, eventActivityId.description, statusId.StatusD

esc, kioskInfo.FriendlyName FROM ((kmsEventlog inner join eventActivityId on kms

Eventlog.eventActivityId = eventActivityId.ID) inner join statusId on kmsEventlo

g.StatusValue = statusId.StatusValue ) inner join kioskInfo on kmsEventlog.kiosk

Id = kioskInfo.KioskId ;

 

 

 

BELOW ARE THE XML THE TO REPORT REFER TO:--->

 

 

 

 

<?xml version="1.0" encoding="UTF-8"?>

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

 

<jasperReport name="EventLog" pageWidth="595" pageHeight="842" columnWidth="515" leftMargin="40" rightMargin="40" topMargin="50" bottomMargin="50">

<reportFont name="Arial_Normal" isDefault="true" fontName="Arial" size="12" isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<reportFont name="Arial_Bold" isDefault="false" fontName="Arial" size="12" isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<reportFont name="Arial_Italic" isDefault="false" fontName="Arial" size="12" isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false" pdfFontName="Helvetica-Oblique" pdfEncoding="Cp1252" isPdfEmbedded="false"/>

<parameter name="From_Date" class="java.util.Date">

</parameter>

<parameter name="To_Date" class="java.util.Date">

</parameter>

<queryString><![CDATA[sELECT kmsEventlog.*, eventActivityId.description, statusId.StatusDesc, kioskInfo.FriendlyName FROM ((kmsEventlog inner join eventActivityId on kmsEventlog.eventActivityId = eventActivityId.ID) inner join statusId on kmsEventlog.StatusValue = statusId.StatusValue ) inner join kioskInfo on kmsEventlog.kioskId = kioskInfo.KioskId ;]]></queryString>

<field name="dateTime" class="java.lang.String">

</field>

<field name="KioskID" class="java.lang.String">

</field>

<field name="eventActivityId" class="java.lang.String">

</field>

<field name="statusValue" class="java.lang.String">

</field>

<field name="description" class="java.lang.String">

</field>

<field name="StatusDesc" class="java.lang.String">

</field>

<field name="FriendlyName" class="java.lang.String">

</field>

<variable name="IdNumber" class="java.lang.Integer" resetType="Group" resetGroup="IdGroup" calculation="System">

<initialValueExpression><![CDATA[($V{IdNumber} != null)?(new Integer($V{IdNumber}.intValue() + 1)):(new Integer(1))]]></initialValueExpression>

</variable>

<variable name="ReportTitle" class="java.lang.String">

<initialValueExpression><![CDATA["Event Log"]]></initialValueExpression>

</variable>

<variable name="ReportDateTime" class="java.util.Date" calculation="System">

<initialValueExpression><![CDATA[new java.util.Date()]]></initialValueExpression>

</variable>

<group name="IdGroup" minHeightToStartNewPage="60">

<groupExpression><![CDATA[$F{KioskID}]]></groupExpression>

<groupHeader>

<band height="20">

<rectangle>

<reportElement positionType="Float" x="0" y="4" width="515" height="15" forecolor="#c0c0c0" backcolor="#c0c0c0"/>

<graphicElement/>

</rectangle>

<textField>

<reportElement positionType="Float" mode="Opaque" x="0" y="4" width="515" height="15" backcolor="#c0c0c0"/>

<textElement>

<font reportFont="Arial_Normal" isBold="true" pdfFontName="Helvetica-Bold"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[" " + String.valueOf($V{IdNumber}) + ". " + $F{KioskID} + " " + $F{FriendlyName}]]></textFieldExpression>

</textField>

<line>

<reportElement positionType="Float" x="0" y="19" width="515" height="1"/>

<graphicElement/>

</line>

</band>

</groupHeader>

<groupFooter>

<band height="20">

<line>

<reportElement positionType="Float" x="0" y="0" width="515" height="1"/>

<graphicElement/>

</line>

<staticText>

<reportElement positionType="Float" x="350" y="0" width="100" height="15"/>

<textElement textAlignment="Right">

<font reportFont="Arial_Normal" pdfFontName="Helvetica-Bold"/>

</textElement>

<text><![CDATA[Count:]]></text>

</staticText>

<textField>

<reportElement positionType="Float" x="460" y="0" width="30" height="15"/>

<textElement textAlignment="Right">

<font reportFont="Arial_Normal" isBold="true" pdfFontName="Helvetica-Bold"/>

</textElement>

<textFieldExpression class="java.lang.Integer"><![CDATA[$V{IdGroup_COUNT}]]></textFieldExpression>

</textField>

</band>

</groupFooter>

</group>

<title>

<band height="50">

<line>

<reportElement positionType="Float" x="0" y="0" width="515" height="1"/>

<graphicElement/>

</line>

<textField isStretchWithOverflow="true">

<reportElement positionType="Float" x="0" y="10" width="515" height="30"/>

<textElement textAlignment="Center">

<font reportFont="Arial_Normal" size="22"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$V{ReportTitle}]]></textFieldExpression>

</textField>

</band>

</title>

<pageHeader>

<band height="20">

<rectangle>

<reportElement positionType="Float" x="0" y="5" width="515" height="15" forecolor="#333333" backcolor="#333333"/>

<graphicElement/>

</rectangle>

<staticText>

<reportElement positionType="Float" mode="Opaque" x="0" y="5" width="100" height="15" forecolor="#ffffff" backcolor="#404040"/>

<textElement textAlignment="Center">

<font reportFont="Arial_Normal" isBold="true" pdfFontName="Helvetica-Bold"/>

</textElement>

<text><![CDATA[Date Time]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" mode="Opaque" x="110" y="5" width="60" height="15" forecolor="#ffffff" backcolor="#333333"/>

<textElement textAlignment="Right">

<font reportFont="Arial_Normal" isBold="true" pdfFontName="Helvetica-Bold"/>

</textElement>

<text><![CDATA[id]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" mode="Opaque" x="190" y="5" width="80" height="15" forecolor="#ffffff" backcolor="#0"/>

<textElement textAlignment="Left">

<font reportFont="Arial_Normal" isBold="true" pdfFontName="Helvetica-Bold"/>

</textElement>

<text><![CDATA[Activity]]></text>

</staticText>

<staticText>

<reportElement positionType="Float" mode="Opaque" x="280" y="5" width="80" height="15" forecolor="#ffffff" backcolor="#0"/>

<textElement textAlignment="Right">

<font reportFont="Arial_Normal" isBold="true" pdfFontName="Helvetica-Bold"/>

</textElement>

<text><![CDATA[status]]></text>

</staticText>

</band>

</pageHeader>

<columnHeader>

<band>

</band>

</columnHeader>

<detail>

<band height="20">

<textField>

<reportElement positionType="Float" x="0" y="4" width="120" height="15"/>

<textElement textAlignment="Left">

<font reportFont="Arial_Normal"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{dateTime}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="true">

<reportElement positionType="Float" x="110" y="4" width="60" height="15"/>

<textElement textAlignment="Right">

<font reportFont="Arial_Normal"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{eventActivityId}+ "/" + $F{statusValue}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="true">

<reportElement positionType="Float" x="190" y="4" width="80" height="15"/>

<textElement textAlignment="Left">

<font reportFont="Arial_Normal"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{description}]]></textFieldExpression>

</textField>

<textField isStretchWithOverflow="true">

<reportElement positionType="Float" x="280" y="4" width="80" height="15"/>

<textElement textAlignment="Right">

<font reportFont="Arial_Normal"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[$F{StatusDesc}]]></textFieldExpression>

</textField>

<line>

<reportElement positionType="Float" x="0" y="19" width="515" height="1" forecolor="#808080"/>

<graphicElement/>

</line>

</band>

</detail>

<columnFooter>

<band>

</band>

</columnFooter>

<pageFooter>

<band height="40">

<line>

<reportElement x="0" y="10" width="515" height="1"/>

<graphicElement/>

</line>

<textField>

<reportElement x="200" y="20" width="80" height="15"/>

<textElement textAlignment="Right">

<font reportFont="Arial_Normal"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA["Page " + String.valueOf($V{PAGE_NUMBER}) + " of"]]></textFieldExpression>

</textField>

<textField evaluationTime="Report">

<reportElement x="280" y="20" width="75" height="15"/>

<textElement>

<font reportFont="Arial_Normal"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[" " + String.valueOf($V{PAGE_NUMBER})]]></textFieldExpression>

</textField>

<staticText>

<reportElement positionType="Float" x="3" y="19" width="180" height="18"/>

<textElement>

<font reportFont="Arial_Normal"/>

</textElement>

<text><![CDATA[Kiosk Management System]]></text>

</staticText>

<textField isBlankWhenNull="true">

<reportElement positionType="Float" x="380" y="18" width="130" height="18"/>

<textElement>

<font reportFont="Arial_Normal"/>

</textElement>

<textFieldExpression class="java.lang.String"><![CDATA[string.valueOf($V{ReportDateTime})]]></textFieldExpression>

</textField>

</band>

</pageFooter>

<summary>

<band>

</band>

</summary>

</jasperReport>

 

 

 

i DUNNO WHAT WENT WRONG.

 

rEGARDS

MEZCLAX