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.
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:
- 1 query for headers information
- 1 query for lines information (the linews must be linked to 1 record of header query)
----------------------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 ?
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