ArrayList with Group Reset

0

Can enyone help me Studio 6.3.1

I have a variable that is collecting information from a field in the main Query, i wish to print data from all the sales items at group level .

using a sub select in the sql will not work doue to other issues with the odbc driver

 

when I run the report I get data that comes after the next Group, group 3 is the sales order number.

I have tried testing the group count, 

java.util.List, java.util.ArrayList and Collection

I get the same results the system seems to add the next data to the  array which is from the next group

 

 

<variable name="orderitems" class="java.util.List" resetType="Group" resetGroup="Group3" calculation="System">
<variableExpression><![CDATA[$V{orderitems}.size() < $V{Group3_COUNT} ? $V{orderitems}.add($F{orderitems})  : $V{orderitems}.add("")
]]></variableExpression>
<initialValueExpression><![CDATA[new ArrayList()]]></initialValueExpression>
</variable>
<variable name="capacity" class="java.math.BigDecimal" resetType="Group" resetGroup="Group3" calculation="Sum">
<variableExpression><![CDATA[$F{capacity}]]></variableExpression>
</variable>
<variable name="volume" class="java.math.BigDecimal" resetType="Group" resetGroup="Group3"/>
<variable name="cost" class="java.math.BigDecimal" resetType="Group" resetGroup="Group3">
<variableExpression><![CDATA[$F{cost}]]></variableExpression>
</variable>
<group name="Group3">
<groupExpression><![CDATA[$F{orderReference}]]></groupExpression>
</group>
</subDataset>

 

 

markbeardhome's picture
Joined: Mar 5 2012 - 2:00am
Last seen: 6 months 5 days ago

0 Answers:

No answers yet
Feedback
randomness