Blog / Oracle Application Blog

Include or Exclude column in APEX interactive report download

Doyensys 1 min read
Include column only in download
Hidden
column cannot be downloaded in interactive report if,
Display As :
Hidden
Include In
Export : Yes
This can be achieved using the PLSQL Function
body returning a Boolean :
Column attributes->
Display As : Display as Text
Column attributes-> Conditional
display->
Condition Type : PLSQL Function body
returning a Boolean
Expression:   
RETURN NVL(:REQUEST,’EMPTY’)IN(‘CSV’,’XLS’,’RTF’,’HTMLD’)
              
OR NVL(wwv_flow.g_widget_action,’EMPTY’)=’SEND_EMAIL’;
Exclude column only in download
Display
column will be downloaded in interactive report if,
Display As :  Display as Text
This can be achieved using the PLSQL Function
body returning a Boolean :
Column attributes->
Display As : Display as Text
Column attributes-> Conditional
display->
Condition Type : PLSQL Function body
returning a Boolean
Expression :    RETURN NVL(:REQUEST,’EMPTY’)NOT
IN(‘CSV’,’XLS’,’RTF’,’HTMLD’)

               OR NVL(wwv_flow.g_widget_action,’EMPTY’)<>’SEND_EMAIL’;


By
Angel

Related blogs

Oracle Application Blog

Preventing Duplicate Form Submission in Oracle APEX

Introduction / Issue One of the common issues encountered while developing Oracle APEX applications is duplicate form submission. Users may unintentionally clic…

Akthar Basha 2 min read
Oracle Application Blog

UI Mistakes Oracle APEX Developers Should Avoid

Introduction / Issue Many Oracle APEX applications successfully meet business requirements but often overlook one critical aspect—the User Interface (UI) and Us…

Akthar Basha 3 min read
Oracle Application Blog

WIP Job Close via Apex Application

Introduction / Issue Closing a WIP job in EBS normally means going through the Discrete Jobs form manually — checking if all transactions are done, confirming t…

Sivaguru Karunanidhi 6 min read