Oracle apex Classic report CSV download to Restrict the columns

Use the below code to restrict what are the columns download the csv download in Oracle apex Classic report.

1. if one column is hidden column, if you download the csv you want the hidden column
NVL(:REQUEST, 'MY_REQ') LIKE 'FLOW_EXCEL_OUTPUT%'
NVL(:REQUEST, 'MY_REQ') NOT LIKE 'FLOW_EXCEL_OUTPUT%'

 

Use the below code for CSV , XLS and other formats

  1. Hidden column code like below, this column data only download the below mentioned format
  2. NVL(:REQUEST, ‘MY_REQ’) IN(‘CSV’,’XLS’,’PDF’,’XML’,’RTF’,’HTMLD’)
  3. Active column Server side condition code (Copy the below code and paste PL/SQL Expression Column ), while download below mentioned formats, current column not downloaded in the report
  4. NVL(:REQUEST, ‘MY_REQ’) NOT IN(‘CSV’,’XLS’,’PDF’,’XML’,’RTF’,’HTMLD’)

Check the below example

https://apex.oracle.com/pls/apex/f?p=44666:1:16075116997358::NO:RP,1:P1_TIMELINE_ID:74

Advertisements

2 thoughts on “Oracle apex Classic report CSV download to Restrict the columns

  1. Hi, I have a ID Column and value 00001 in interactive report. when I am download to csv, ID column value is showing 1. But i Need a value 00001. Please advice to me.

    1. Hi Tamil

      if you download the data in Excel sheet, the cell value 00001 to show 1, there is no meaning for 0
      if you want to download the value 00001 means you can add the before value like ‘00001 (single quot’s)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s