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!

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

Comments
Post Details
Added on Oct 17 2024
6 comments
559 views