My Oracle Support Banner

PDF Output in APEX report with TWO Queries (Doc ID 2700534.1)

Last updated on AUGUST 18, 2020

Applies to:

Oracle Application Express (APEX) - Version 18.2 and later
Information in this document applies to any platform.

Goal

Is there a standard way to create a pdf report with headers and lines information (where the lines are linked to the headers)?
APEX permits to me to create a pdf report with one query behind.
The problem is to create a pdf report that must work on two queries:

for example:
----------------------query 1 (HEADERS query):

select HEADER_ID, HEADER_NAME from ( 
select 100 HEADER_ID, 'TESTATA_1' HEADER_NAME from dual
UNION ALL
select 200 HEADER_ID, 'TESTATA_2' HEADER_NAME 
)

----------------------query 2 (LINES query):

select HID, LINE_ID, LINE_NAME from ( 
select 100 HEADER_ID HID, 11 LINE_ID, 'LINEA_11' LINE_NAME from dual
UNION ALL
select 100 HEADER_ID HID, 12 LINE_ID, 'LINEA_12' LINE_NAME from dual
UNION ALL
select 200 HEADER_ID HID, 21 LINE_ID, 'LINEA_21' LINE_NAME from dual
)
where HID = :HEADER_ID  --> where :HEADER_ID is retrieved from query 1 (HEADERS query)

Is this possible ? if so, any steps ?


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.