Skip to Main Content
Forums

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Report Layout sum of table in MS excel template for document generator print server

HI Experts,

How to add total row to table with vertical loop in MS excel template for doc gen , MS word has sum aggregator for array but not able to find similar for MS excel.

  1. using IR in page which has simple query select salary from employees.

  2. in excel template using manual formatting

    1. static row for header A1 as Salary
    2. next row A2 as {#items}{salary}{/items} with vertical loop
    3. and the last row with formula =SUM(A2:A$2), (placed in A3)

    now although vertical loop adds rows displaying each salary and formula cell gets moved to last row (lets say 10 records in array then formula moved to A12 but formula remains =SUM(A2:A$2) so the SUM only display that record

  3. in excel template also i tried to create table with both header and total rows but it seems the range size of table doesn't change when vertical loop for inserted rows even though total row moves to last it only totals top2 rows.
    thanks

Somesh
Comments
Post Details
Added 2 days ago
#documentgenerator, #fn, #pbf
1 comment
51 views