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
Recent Posts