Skip to Main Content

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!

Are there ways to create Data -> Aggregate programmatic in APEX 23.1 Interactive Report?

Jake HoughtonAug 22 2024

Hi, for my APEX page, I have a dynamic source query that have dynamic # of cols depending on `page items` values. I have control break set up and am needing to create Aggregates to provide subtotal for the report. However, I have ~180 columns and then using .remove() in js to remove them in html after dom load.

Instead of manually Aggregating 180 columns are there ways to generate them programmatically?

Also, does anyone know the performance impact of having a large amount of aggregates in a report?

Comments
Post Details
Added on Aug 22 2024
6 comments
568 views