Report Printing in APEX 20.2
-------------------------------------
1. Create to Faceted Search Page.
2. Create a Select List Item to allow users to select report format.
3. Create a button to download the report.
4. Navigate to Faceted Search and for Static ID, Name faceted_search.
5. Create a Before Header process to execute the following code that we provide in this video discription. Here when users click on Download button and when the format item (P37_FORMAT) is not null.
This process exports the information depending on the SQL query you have in the specified region.
-----------------------------------------------------
declare
l_export apex_data_export.t_export;
l_region_id number;
begin
select region_id into l_region_id
from apex_application_page_regions
where application_id = :APP_ID
and page_id = :APP_PAGE_ID
and static_id = 'faceted_search';
l_export := apex_region.export_data (
p_format => :P37_FORMAT,
p_page_id => :APP_PAGE_ID,
p_region_id => l_region_id);
apex_data_export.download( l_export );
end;
Comments
Post a Comment