Master Table Summation of Detail Column

Master Table: "Stock"
Detail Table:  "UnitStockXrefUVO"

In my Master Table "Stock"we simply add the Transient Attribute "TotalSubQty";
as seen here below in the Attribute Detail Properites we have added the Transient Attribute TotalSubQty in Table "Stock"  and will use groovy to sum the column "SubQty" in Detail Table  "UnitStockXrefUVO" 

\Java\jre6\lib\ext\QTJava.zip was unexpected at this time.

Problem is with the entry below in the ClassPath - from QuickTime...

CLASSPATH=.;C:\Program Files (x86)\QuickTime\QTSystem\QTJava.zip

Remove from ClassPath --> C:\Program Files (x86)\QuickTime\QTSystem\QTJava.zip

Using Groovy to display Color Fonts based on inputValue.

Here the Binding/inputValue is a percent. This is placed in "PropertyInspector / Style / InLineStyle"

if Greater than 100% make Font Red, 100% make Font Green, otherwise make yellow.


#{bindings.Total.inputValue > 100 ?  'color:Red ' : bindings.Total.inputValue == 100.0 ?  'color:Green' : 'color:Orange' }

And something a little more complicated grabbing the Iterator RowCount:

#{row.bindings.Qty1.inputValue <bindings.ADescriptionVO1Iterator.estimatedRowCount ?'background-color:Red;':'background-color:White;'}