Apex - Interactive Report - Hide Column in CSV Download?

oracle-apex
Paul Fresner picture Paul Fresner · Mar 14, 2012 · Viewed 7.5k times · Source

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

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

(Background: one column is a custom link that should not be exported into the CSV)

Thank you ! Paul

Answer

Jason Lyle picture Jason Lyle · Mar 20, 2012

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

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

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

More info
To stop a column from showing up for an email, you can use the following:

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

Related questions

Is it possible to output a SELECT statement from a PL/SQL block?

How can I get a PL/SQL block to output the results of a SELECT statement the same way as if I had done a plain SELECT? For example how to do a SELECT like: SELECT foo, bar FROM foobar; …

Read More
Get started link does not work in oracle 11g server

I have started using Oracle database server on Windows 7 64 bit OS and I have encountered the following error. "Error- Windows cannot find 'http://127.0.01:%HTTPPORT%/apex/f?p=4950'. Make sure you typed the name correctly, and then try again" I …

Read More
Inner Join Three Tables

I am working in Oracle APEX.i want to make a report from three tables through INNER JOIN .The Tables are as Fallows. PATIENT (Par_Id(Pk),Pat_Name,Pat_Gender) HISTORY (His_Id(Pk),Pat_id(Fk),Treated_By) …

Read More