Introduction
This is to include or exclude column from interactive report during download.
Include column only in download
Hidden column cannot be downloaded in interactive report if,
Display As : Hidden
Include In Export : Yes
Solution
This can be achieved using the PLSQL Function body returning a Boolean :
Step 1:
In Column attributes->
Display As : Display as Text
Step 2:
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
Solution
This can be achieved using the PLSQL Function body returning a Boolean :
Step 1:
In Column attributes->
Display As : Display as Text
Step 2:
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’;
Call To Action:
For Oracle apex development and customization please do contact our company website https://doyensys.com/
Conclusion
Using above method we can easily include or exclude column from report download.
