Add one extra field - error

mathieu.ververken · March 12, 2015

Hi,

I modified an existing report in iReport, and it works perfectly.

Until I wanted to add one more field 'SalesPerson' to it. I don't get any 'report warnings', but when I want to open the report in Fishbowl I receive an error "Fishbowl serer error null".

Anyone that could help me to find the mistake?

The original code that works perfectly is code 1, the code with field 'SalesPerson' is code 2 (put the changes in bold).

Thx a lot for your help,

Mathieu

mathieu.ververken · March 12, 2015

CODE 1:

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

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

<![CDATA[sELECT $P!{cbGroupBy} AS groupby, so.num AS sonum, customer.name AS custname, soitem.productnum, soitem.description,

(case when soitem.uomid != product.uomid then ((postsoitem.qty*uomconversion.multiply)/uomconversion.factor) else postsoitem.qty end) as qty,

postsoitem.postedtotalcost,

(CASE WHEN soitem.uomid != product.uomid then ((soitem.unitprice + (CASE WHEN soitem.adjustamount > 0 THEN (soitem.adjustamount / soitem.qtytofulfill) ELSE 0 END))/uomconversion.multiply)*uomconversion.factor else (soitem.unitprice + (CASE WHEN soitem.adjustamount > 0 THEN (soitem.adjustamount / soitem.qtytofulfill) ELSE 0 END)) end) as unitprice,

COALESCE(uom.code, miscuom.code) AS uomcode, producttree.name AS producttreenode

FROM so

INNER JOIN customer ON so.customerid = customer.id

INNER JOIN soitem ON so.id = soitem.soid

LEFT JOIN product ON soitem.productid = product.id

INNER JOIN postsoitem ON soitem.id = postsoitem.soitemid

INNER JOIN postso ON postsoitem.postsoid = postso.id

LEFT JOIN uom ON product.uomid = uom.id

left JOIN uom as miscuom on soitem.uomid = miscuom.id

LEFT JOIN producttotree ON soitem.productid = producttotree.productid

LEFT JOIN producttree ON producttotree.producttreeid = producttree.id

LEFT JOIN uomconversion on product.uomid = uomconversion.touomid and soitem.uomid = uomconversion.fromuomid

WHERE UPPER(so.num) LIKE UPPER($P{soNum})

AND UPPER(so.salesman) LIKE UPPER($P{salesPerson})

AND so.customerid LIKE $P{customerID}

AND postso.postdate BETWEEN $P{dateRange1} AND $P{dateRange2}

AND soitem.typeid IN (10,11,12,21,30,31,50,80,$P{ckIncludeShipping},$P{ckIncludeReturns})

AND soitem.productnum LIKE $P{productNum}

AND so.locationgroupid IN ($P!{locationGroupID})

AND (COALESCE(producttreeid,0) IN ($P!{productTree1}) OR COALESCE(producttreeid,0) LIKE $P{productTree2})

ORDER BY 1, soitem.productnum, soitem.uomid, so.num]]>

</queryString>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</group>

</group>

</group>

</subDataset>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

<![CDATA[sELECT (CASE WHEN $P!{cbGroupBy} = ''

THEN soitem.description

ELSE $P!{cbGroupBy} END) AS groupby, so.num AS sonum, customer.name AS custname,

(CASE WHEN soitem.typeid = 11

THEN 'Misc. Sale'

ELSE (CASE WHEN soitem.typeid = 21

THEN 'Misc. Credit'

ELSE soitem.productnum END) END) AS productnum, soitem.description,

SUM((case when soitem.uomid != product.uomid then ((postsoitem.qty*uomconversion.multiply)/uomconversion.factor) else postsoitem.qty end)) AS qty,

SUM(postsoitem.postedtotalcost) AS postedtotalcost,

(CASE WHEN soitem.uomid != product.uomid then ((soitem.unitprice + (CASE WHEN soitem.adjustamount > 0 THEN (soitem.adjustamount / soitem.qtytofulfill) ELSE 0 END))/uomconversion.multiply)*uomconversion.factor else (soitem.unitprice + (CASE WHEN soitem.adjustamount > 0 THEN (soitem.adjustamount / soitem.qtytofulfill) ELSE 0 END)) end) as unitprice,

COALESCE(uom.code, miscuom.code) AS uomcode

FROM so

INNER JOIN customer ON so.customerid = customer.id

INNER JOIN soitem ON so.id = soitem.soid

LEFT JOIN product ON soitem.productid = product.id

INNER JOIN postsoitem ON soitem.id = postsoitem.soitemid

INNER JOIN postso ON postsoitem.postsoid = postso.id

LEFT JOIN uom ON product.uomid = uom.id

LEFT JOIN uom as miscuom on soitem.uomid = miscuom.id

LEFT JOIN uomconversion ON product.uomid = uomconversion.touomid AND soitem.uomid = uomconversion.fromuomid

WHERE UPPER(so.num) LIKE UPPER($P{soNum})

AND UPPER(so.salesman) LIKE UPPER($P{salesPerson})

AND so.customerid LIKE $P{customerID}

AND postso.postdate BETWEEN $P{dateRange1} AND $P{dateRange2}

AND soitem.typeid IN (10,11,12,21,30,31,50,80,$P{ckIncludeShipping},$P{ckIncludeReturns})

AND soitem.productnum LIKE $P{productNum}

AND so.locationgroupid IN ($P!{locationGroupID})

GROUP BY soitem.productnum, uomcode, sonum, custname, soitem.description, soitem.unitprice, groupby, soitem.typeid, product.uomid, uomconversion.multiply, uomconversion.factor, unitprice

ORDER BY 1, productnum, uomcode, sonum, custname, soitem.description, soitem.unitprice]]>

</queryString>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</group>

</group>

</group>

</subDataset>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

<![CDATA[sELECT company.name AS company

FROM company

WHERE id = 1]]>

</queryString>

</variable>

</background>

</pageHeader>

<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetRun>

<jr:columnGroup width="1174" uuid="28b68d85-d5a6-4462-859d-6c1599746e35">

<jr:column width="90" uuid="f12cd1df-15e3-41df-ac91-facec8190a40">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1">

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="85" uuid="0d6bd9ba-b6f3-4ece-8466-bdc17341517b">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1">

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="369" uuid="9da2a37f-789f-41d7-8e2d-ca0eba9e2e94">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1">

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="22a8714a-e612-4f7d-9e9d-10dcbc3686ad">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:tableFooter height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1"/>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1"/>

</jr:column>

<jr:column width="90" uuid="d4b8b5ed-420a-4a70-b8a4-93b0c01af98f">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:tableFooter height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1"/>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1"/>

</jr:column>

<jr:column width="90" uuid="975b954f-be10-4b0b-b4ad-22a66212caa5">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1">

</textField>

</jr:detailCell>

</jr:column>

<jr:columnGroup width="360" uuid="7bfd772a-992b-4c05-b19e-0448de5d6278">

<jr:column width="90" uuid="4bd6be5f-3468-4ab8-972c-5f25ac8ea4cf">

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="a579f110-9084-42ae-ba76-c3e4bd18eee5">

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</box>

</textElement>

</textField>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="9cc1c8f2-aff5-4a24-bb01-317bfbb1c2d7">

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="9fe7e67e-a522-425f-8f7e-387b3fce08ad">

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

</jr:columnGroup>

<jr:column width="90" uuid="90dd48ef-35fe-4c04-bbb8-d26e3e941644">

<jr:tableFooter height="0" rowSpan="1"/>

<jr:groupHeader groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupHeader groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupFooter groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:groupFooter groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="20724816-aab5-44dd-a800-df9f4408384b">

<jr:tableFooter height="0" rowSpan="1"/>

<jr:groupHeader groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupHeader groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupFooter groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:groupFooter groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="92" uuid="1a41def9-dd1a-45cc-b66d-68ef1b27443c">

<jr:tableFooter height="0" rowSpan="1"/>

<jr:groupHeader groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupHeader groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupFooter groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:groupFooter groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

<textFieldExpression><![CDATA[($F{UNITPRICE} > 0) ? ((($F{UNITPRICE} * $F{QTY}) - $F{POSTEDTOTALCOST}) / ($F{QTY} * $F{UNITPRICE})) : 0 / 100]]></textFieldExpression>

</textField>

</jr:detailCell>

</jr:column>

</jr:table>

</componentElement>

</band>

</detail>

</pageFooter>

</jasperReport>

mathieu.ververken · March 12, 2015

CODE 2:

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

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

<![CDATA[sELECT $P!{cbGroupBy} AS groupby, so.num AS sonum, customer.name AS custname, soitem.productnum, soitem.description,

(case when soitem.uomid != product.uomid then ((postsoitem.qty*uomconversion.multiply)/uomconversion.factor) else postsoitem.qty end) as qty,

postsoitem.postedtotalcost,

(CASE WHEN soitem.uomid != product.uomid then ((soitem.unitprice + (CASE WHEN soitem.adjustamount > 0 THEN (soitem.adjustamount / soitem.qtytofulfill) ELSE 0 END))/uomconversion.multiply)*uomconversion.factor else (soitem.unitprice + (CASE WHEN soitem.adjustamount > 0 THEN (soitem.adjustamount / soitem.qtytofulfill) ELSE 0 END)) end) as unitprice,

COALESCE(uom.code, miscuom.code) AS uomcode, producttree.name AS producttreenode

FROM so

INNER JOIN customer ON so.customerid = customer.id

INNER JOIN soitem ON so.id = soitem.soid

LEFT JOIN product ON soitem.productid = product.id

INNER JOIN postsoitem ON soitem.id = postsoitem.soitemid

INNER JOIN postso ON postsoitem.postsoid = postso.id

LEFT JOIN uom ON product.uomid = uom.id

left JOIN uom as miscuom on soitem.uomid = miscuom.id

LEFT JOIN producttotree ON soitem.productid = producttotree.productid

LEFT JOIN producttree ON producttotree.producttreeid = producttree.id

LEFT JOIN uomconversion on product.uomid = uomconversion.touomid and soitem.uomid = uomconversion.fromuomid

WHERE UPPER(so.num) LIKE UPPER($P{soNum})

AND UPPER(so.salesman) LIKE UPPER($P{salesPerson})

AND so.customerid LIKE $P{customerID}

AND postso.postdate BETWEEN $P{dateRange1} AND $P{dateRange2}

AND soitem.typeid IN (10,11,12,21,30,31,50,80,$P{ckIncludeShipping},$P{ckIncludeReturns})

AND soitem.productnum LIKE $P{productNum}

AND so.locationgroupid IN ($P!{locationGroupID})

AND (COALESCE(producttreeid,0) IN ($P!{productTree1}) OR COALESCE(producttreeid,0) LIKE $P{productTree2})

ORDER BY 1, soitem.productnum, soitem.uomid, so.num]]>

</queryString>

<field name="SALESPERSON" class="java.lang.String"/>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</group>

</group>

</group>

</subDataset>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

<![CDATA[sELECT (CASE WHEN $P!{cbGroupBy} = ''

THEN soitem.description

ELSE $P!{cbGroupBy} END) AS groupby, so.num AS sonum, customer.name AS custname,

(CASE WHEN soitem.typeid = 11

THEN 'Misc. Sale'

ELSE (CASE WHEN soitem.typeid = 21

THEN 'Misc. Credit'

ELSE soitem.productnum END) END) AS productnum, soitem.description,

SUM((case when soitem.uomid != product.uomid then ((postsoitem.qty*uomconversion.multiply)/uomconversion.factor) else postsoitem.qty end)) AS qty,

SUM(postsoitem.postedtotalcost) AS postedtotalcost,

(CASE WHEN soitem.uomid != product.uomid then ((soitem.unitprice + (CASE WHEN soitem.adjustamount > 0 THEN (soitem.adjustamount / soitem.qtytofulfill) ELSE 0 END))/uomconversion.multiply)*uomconversion.factor else (soitem.unitprice + (CASE WHEN soitem.adjustamount > 0 THEN (soitem.adjustamount / soitem.qtytofulfill) ELSE 0 END)) end) as unitprice,

COALESCE(uom.code, miscuom.code) AS uomcode

FROM so

INNER JOIN customer ON so.customerid = customer.id

INNER JOIN soitem ON so.id = soitem.soid

LEFT JOIN product ON soitem.productid = product.id

INNER JOIN postsoitem ON soitem.id = postsoitem.soitemid

INNER JOIN postso ON postsoitem.postsoid = postso.id

LEFT JOIN uom ON product.uomid = uom.id

LEFT JOIN uom as miscuom on soitem.uomid = miscuom.id

LEFT JOIN uomconversion ON product.uomid = uomconversion.touomid AND soitem.uomid = uomconversion.fromuomid

WHERE UPPER(so.num) LIKE UPPER($P{soNum})

AND UPPER(so.salesman) LIKE UPPER($P{salesPerson})

AND so.customerid LIKE $P{customerID}

AND postso.postdate BETWEEN $P{dateRange1} AND $P{dateRange2}

AND soitem.typeid IN (10,11,12,21,30,31,50,80,$P{ckIncludeShipping},$P{ckIncludeReturns})

AND soitem.productnum LIKE $P{productNum}

AND so.locationgroupid IN ($P!{locationGroupID})

GROUP BY soitem.productnum, uomcode, sonum, custname, soitem.description, soitem.unitprice, groupby, soitem.typeid, product.uomid, uomconversion.multiply, uomconversion.factor, unitprice

ORDER BY 1, productnum, uomcode, sonum, custname, soitem.description, soitem.unitprice]]>

</queryString>

<field name="SALESPERSON" class="java.lang.String"/>

</variable>

</variable>

</variable>

</variable>

</variable>

</variable>

</group>

</group>

</group>

</subDataset>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

</parameter>

<![CDATA[sELECT company.name AS company

FROM company

WHERE id = 1]]>

</queryString>

</variable>

</background>

</pageHeader>

<jr:table xmlns:jr="http://jasperreports.sourceforge.net/jasperreports/components" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports/components http://jasperreports.sourceforge.net/xsd/components.xsd">

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetParameter>

</datasetRun>

<jr:columnGroup width="1174" uuid="28b68d85-d5a6-4462-859d-6c1599746e35">

<jr:column width="90" uuid="f12cd1df-15e3-41df-ac91-facec8190a40">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1">

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="85" uuid="0d6bd9ba-b6f3-4ece-8466-bdc17341517b">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1">

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="369" uuid="9da2a37f-789f-41d7-8e2d-ca0eba9e2e94">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1">

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="22a8714a-e612-4f7d-9e9d-10dcbc3686ad">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:tableFooter height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1"/>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1">

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="d4b8b5ed-420a-4a70-b8a4-93b0c01af98f">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:tableFooter height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1"/>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1"/>

</jr:column>

<jr:column width="90" uuid="975b954f-be10-4b0b-b4ad-22a66212caa5">

<jr:tableHeader height="0" rowSpan="1"/>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:columnFooter height="0" rowSpan="1"/>

<jr:detailCell height="14" rowSpan="1">

</textField>

</jr:detailCell>

</jr:column>

<jr:columnGroup width="360" uuid="7bfd772a-992b-4c05-b19e-0448de5d6278">

<jr:column width="90" uuid="4bd6be5f-3468-4ab8-972c-5f25ac8ea4cf">

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="a579f110-9084-42ae-ba76-c3e4bd18eee5">

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

</box>

</textElement>

</textField>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="9cc1c8f2-aff5-4a24-bb01-317bfbb1c2d7">

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="9fe7e67e-a522-425f-8f7e-387b3fce08ad">

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

</jr:columnGroup>

<jr:column width="90" uuid="90dd48ef-35fe-4c04-bbb8-d26e3e941644">

<jr:tableFooter height="0" rowSpan="1"/>

<jr:groupHeader groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupHeader groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupFooter groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:groupFooter groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="90" uuid="20724816-aab5-44dd-a800-df9f4408384b">

<jr:tableFooter height="0" rowSpan="1"/>

<jr:groupHeader groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupHeader groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupFooter groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:groupFooter groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

</textField>

</jr:detailCell>

</jr:column>

<jr:column width="92" uuid="1a41def9-dd1a-45cc-b66d-68ef1b27443c">

<jr:tableFooter height="0" rowSpan="1"/>

<jr:groupHeader groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupHeader groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupHeader>

<jr:groupFooter groupName="PRODUCTNUM">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:groupFooter groupName="GroupBy">

<jr:cell height="0" rowSpan="1">

<box>

</box>

</jr:cell>

</jr:groupFooter>

<jr:columnHeader height="16" rowSpan="1">

<box>

</box>

<box>

</box>

</textElement>

</textField>

</jr:columnHeader>

<jr:detailCell height="14" rowSpan="1">

</textElement>

<textFieldExpression><![CDATA[($F{UNITPRICE} > 0) ? ((($F{UNITPRICE} * $F{QTY}) - $F{POSTEDTOTALCOST}) / ($F{QTY} * $F{UNITPRICE})) : 0 / 100]]></textFieldExpression>

</textField>

</jr:detailCell>

</jr:column>

</jr:table>

</componentElement>

</band>

</detail>

</pageFooter>

</jasperReport>

Sign In

Add one extra field - error

Recommended Posts

mathieu.ververken

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

mathieu.ververken

mathieu.ververken

Create an account or sign in to comment

Create an account

Sign in

Activity