ArrayList with Group Reset

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("")
<initialValueExpression><![CDATA[new ArrayList()]]></initialValueExpression>
<variable name="capacity" class="java.math.BigDecimal" resetType="Group" resetGroup="Group3" calculation="Sum">
<variable name="volume" class="java.math.BigDecimal" resetType="Group" resetGroup="Group3"/>
<variable name="cost" class="java.math.BigDecimal" resetType="Group" resetGroup="Group3">
<group name="Group3">



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

0 Answers:

No answers yet