Include or Exclude column in APEX interactive report download

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