This discussion is archived
10 Replies Latest reply: Dec 7, 2012 9:49 AM by 872999 RSS

Display column totals on ADF 11g table using read-only View Object

668719 Newbie
Currently Being Moderated
Hi,

I need to display column totals in a table - sort of like a summary row. I am using ADF and Jdeveloper 11g. I am using a read only View Object. I followed the example from Steve Muench - "Recalc Sum of Salary at the View Object Level". I am able to see the totals, but at a column level. For example:


Success Failed SuccessTotal FailedTotal
1 2 10 11
3 4 10 11
4 3 10 11
2 2 10 11


However, I need the following:


Success Failed
1 2
3 4
4 3
2 2
Total: 10 11

How can I achieve this? I have tried to insert a new row in the View Object"s Impl.java, but since this is a read-only View Object, that failed with an error:

May 20, 2009 8:42:57 PM oracle.adfinternal.view.faces.config.rich.RegistrationConfigurator handleError
SEVERE: Server Exception during PPR, #1
oracle.jbo.ReadOnlyViewObjectException: JBO-25016: View object ProcessSummaryVO1 is read only.
at oracle.jbo.server.ViewRowSetImpl.doCreateAndInitRow(ViewRowSetImpl.java:2232)
at oracle.jbo.server.ViewRowSetImpl.createRow(ViewRowSetImpl.java:2216)
at oracle.jbo.server.ViewObjectImpl.createRow(ViewObjectImpl.java:9008)
at model.ProcessSummaryVOImpl.executeQuery(ProcessSummaryVOImpl.java:124)

I have also tried to use the column footer facets (dragging the total attributes to the appropriate column footer facet, but that was not showing up in the UI (even though it is there on the source code). Any suggestions/help will be greatly appreciated.

Thanks.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points