Skip to Main Content
Feature Request FR-4374
Product Area Application Builder
Status CLOSED

2 Voters

Page level Export/Print when multiple regions are present (through APEX APIs or other ways)

nikhil.aragonda2 Public · Mar 27 2025

Idea Summary
Currently using the APEX APIs one can only export one region using

apex_region.export_data 

But its not sufficient when we have two or more regions within a page for example a  master detail region.

It would be great if apex can provide a way to club the clob content from the apex_export.t_export variables to one to enable clubbing data from multiple regions to one and printout using the 

apex_data_export.download( l_final_export ); 

Use Case
As with any major application most of the pages follow a master - Detail pattern. 

The printing/downloading of such regions into a single PDF or XLS file is not currently supported out of the box from APEX. 

Also the problem is not solvable using the APIs from APEX. Because apex_data_export and apex_region doesn't have a support to combine the clobs from mutiple t_export variables 

This will force us to use the AOP or Jasper or any other reporting servers. Having a report server and maintaining is a tedious task and not all of our clients are ready to do that.

Preferred Solution (Optional)
The ideal solution will be to have a declarative Print option available at page level instead of individuual region level that will ask users to choose regions to download from and export the data into a single PDF file or the format choosen.

Or Alternatively it would also be sufficient if the current apis can support combining the clob content from two apex_export.t_export type variables

l_final_export, l_export1, l_export2  apex_data_export.t_export%TYPE;
l_export1 := apex_region.export_data (
p_format => :P3_FORMAT,
p_page_id => :APP_PAGE_ID,
p_region_id => l_region_id);
l_export2 := apex_region.export_data (
p_format => :P3_FORMAT,
p_page_id => :APP_PAGE_ID,
p_region_id => l_region_id);
l_final_export.content_clob = l_export1.content_clob + l_export2.content_clob
apex_data_export.download( l_final_export );
This request is likely a duplicate of FR-2762.

Comments

Comments

  • nikhil.aragonda2 OP 1 years ago

    Hi,

     I see the the mentioned ticket talks about exporting the data in to Multiple Workbooks.

    Where as my Idea is about exporting data from multiple regions into a single pdf or Excel file.

    Is there any plan to include the multi region export capability as mentioned above with FR-2762 as well?

    Best Regards

    Nikhil

  • jayson hanes Admin OP 1 years ago

    These 2 ideas are similar but not exact - we group them accordingly as potential duplicates - and generally when work is done on one, the other sometimes becomes a natural fit. Admittedly, not always.

     However, any idea that is placed on our roadmap is not guaranteed to become reality. With each release planning cycle, ideas are reviewed, and prioritized - which also can mean, not prioritized. We do make every effort to be as transparent as possible but there is no advance notice to features being available in a particular release - all we can say is “in a future release of APEX".