Most simple report - error

[mathieu.ververken]

Hello,

I made a simple report in iReport, a list of all sales order.

When I click on 'Preview' then it works fine. But when I open the report in Fishbowl, I get an error "Fishbowl Server Error:  null".

Does anyone know what is wrong with my code?

 

Thx a lot for your help,

Rgds,

Mathieu

 

<?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="report9" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ecc5ee2c-2dda-485e-9814-44735bbf7872">
 <property name="ireport.zoom" value="1.0"/>
 <property name="ireport.x" value="0"/>
 <property name="ireport.y" value="0"/>
 <queryString language="SQL">
  <![CDATA[sELECT
     SO."NUM" AS SO_NUM
FROM
     "SO" SO]]>
 </queryString>
 <field name="SO_NUM" class="java.lang.String"/>
 <group name="SO_NUM">
  <groupExpression><![CDATA[$F{SO_NUM}]]></groupExpression>
 </group>
 <background>
  <band splitType="Stretch"/>
 </background>
 <title>
  <band height="79" splitType="Stretch"/>
 </title>
 <pageHeader>
  <band height="35" splitType="Stretch"/>
 </pageHeader>
 <columnHeader>
  <band height="61" splitType="Stretch">
   <staticText>
    <reportElement uuid="ba6dc6df-885b-45a2-b622-27cd45a9620f" x="104" y="15" width="100" height="20"/>
    <textElement/>
    <text><![CDATA[sO_NUM]]></text>
   </staticText>
  </band>
 </columnHeader>
 <detail>
  <band height="125" splitType="Stretch">
   <textField>
    <reportElement uuid="6176b8c5-efaf-4b92-9f6c-4e415e8da1d5" x="104" y="34" width="100" height="20"/>
    <textElement/>
    <textFieldExpression><![CDATA[$F{SO_NUM}]]></textFieldExpression>
   </textField>
  </band>
 </detail>
 <columnFooter>
  <band height="45" splitType="Stretch"/>
 </columnFooter>
 <pageFooter>
  <band height="54" splitType="Stretch"/>
 </pageFooter>
 <summary>
  <band height="42" splitType="Stretch"/>
 </summary>
</jasperReport>

 

 

 

[mathieu.ververken]

<?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="report9" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" columnWidth="802" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="ecc5ee2c-2dda-485e-9814-44735bbf7872">
 <property name="ireport.zoom" value="1.0"/>
 <property name="ireport.x" value="0"/>
 <property name="ireport.y" value="0"/>
 <queryString language="SQL">
  <![CDATA[sELECT
     SO."NUM" AS SO_NUM
FROM
     "SO" SO]]>
 </queryString>
 <field name="SO_NUM" class="java.lang.String"/>
 <group name="SO_NUM">
  <groupExpression><![CDATA[$F{SO_NUM}]]></groupExpression>
 </group>
 <background>
  <band splitType="Stretch"/>
 </background>
 <title>
  <band height="79" splitType="Stretch"/>
 </title>
 <pageHeader>
  <band height="35" splitType="Stretch"/>
 </pageHeader>
 <columnHeader>
  <band height="61" splitType="Stretch">
   <staticText>
    <reportElement uuid="ba6dc6df-885b-45a2-b622-27cd45a9620f" x="104" y="15" width="100" height="20"/>
    <textElement/>
    <text><![CDATA[sO_NUM]]></text>
   </staticText>
  </band>
 </columnHeader>
 <detail>
  <band height="125" splitType="Stretch">
   <textField>
    <reportElement uuid="6176b8c5-efaf-4b92-9f6c-4e415e8da1d5" x="104" y="34" width="100" height="20"/>
    <textElement/>
    <textFieldExpression><![CDATA[$F{SO_NUM}]]></textFieldExpression>
   </textField>
  </band>
 </detail>
 <columnFooter>
  <band height="45" splitType="Stretch"/>
 </columnFooter>
 <pageFooter>
  <band height="54" splitType="Stretch"/>
 </pageFooter>
 <summary>
  <band height="42" splitType="Stretch"/>
 </summary>
</jasperReport>

[AbleAbeAble]

Fishbowl can't run Groovy.  Open the report in iReport and change the report language to Java, then upload it again.

[AbleAbeAble]

"And don't forget to compile it again first."

[AbleAbeAble]

I guess I don't have enough status for my answer to get a number...  :(

[mathieu.ververken]

Thx a lot for your help mate, really appreciat it.