How do you sum columns in same view
I have a search component (drag and drop the viewCriteria) with a table.
In the table is a column for an amount (number). I need to sum the amount and put it in the footer.
I have done this many times with master/detail. Lots of info on that on the web as well. Really simple.
In the view:
So I create a transient attribute (sumAmount).
I set the value to Expression and use one of the following (and several others that are not here).
On the screen:
drag SumAmount from the DC onto the footer. (OutputText no label)
OK so far!?
Run and query - (wishful thinking)
Change the query and new totals appear (not that far yet).
I have tried several permutations.
adf.object.sum("Amount")
sum("Amount")
adf.object.ViewVO.getrowset.sum("Amount")
All show absolutely nothing - I have the output text defined in the footer and the footer is displaying fine.
The table also has some dates in the criteria - when I generate the rowImpl - the search panel is rendered useless due to the Date Domain vs Sql Date ( I know how to manage this)
This has to be simple - just need to get a bit of help on it.
I have tried to do this similar to the master/detail (but in this case - no detail). Still no value.
I should be able to create a "formula" column without the use of java rowImpl.