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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Column grouping interactive reports

Rohit MittelOct 17 2024 — edited Oct 17 2024

Hi All,

I am trying to create column groups in Interactive Report. I am using the following approach, but it does not work for an IR. it works for a classic report please suggest what is wrong in this.

Create a Dynamic Action on the corresponding report that fires on the event AfterRefresh
Execute JavaScript code, which should also be executed on load

apex.jQuery(this.triggeringElement).find('thead').prepend(` 
<tr id="tab-group-heading"> + 
<th class="t-Report-colHead" align="center" colspan="1"></th> + 
<th class="t-Report-colHead" align="center" colspan="5">The Book</th> + 
<th class="t-Report-colHead" align="center" colspan="2">Publish</th> + 
</tr>` 
);

Also, if there is another approach to achieve this, please suggest that too.

I am using oracle apex version 23.1.

Thanks & Regards,

Rohit

Added on Oct 17 2024

#coulumn-group, #interactive, #interactive-report, #oracle-apex

6 comments

446 views