Geek Answers Handbook

Apex - Interactive Report - Hide Column in CSV Download?

I have an interactive report in Apex with some columns. The user has the option to download the report as a CSV file with standard functionality.

Is there a way to hide the column in the export, but display it on the screen.

(Background: single column is a custom link that should not be exported to CSV)

Thank! Floor

+5
source share
2 answers

You can hide it by placing a condition on a column of type PL / SQL Expression and using the following expression as an expression:

NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF','HTMLD')

This will check the APEX "REQUEST" binding variable, and if it is CSV, XLS, PDF, XML, RTF or HTML, then the column will not be displayed!


, :

NVL(wwv_flow.g_widget_action, 'EMPTY') != 'SEND_EMAIL'
+11

:

NVL(:REQUEST,'EMPTY') NOT IN('CSV','XLS','PDF','XML','RTF','HTMLD')

:

instr(nvl(:REQUEST,'~'),'XLS') = 0 and instr(nvl(:REQUEST,'~'),'PDF') = 0 and instr(nvl(:REQUEST,'~'),'HTMLD') = 0

csv, rtf ..

+1

More articles:


All Articles