10 Replies Latest reply: Dec 7, 2012 11:49 AM by 872999 RSS

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


      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.