Include or Exclude column in APEX interactive report download

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.