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>
0 Answers:
No answers yet
