Create a custom download link for an Interactive Report

The default method of downloading an Interactive Report is clicking on the Action button, then the Download button and then selecting the desired format.

For the CSV report download format:

The download link will be:

http://localhost:8080/apex/f?p=105:2:67119041146700:CSV:

For the the HTML report download format:

The download link will be:

http://localhost:8080/apex/f?p=105:2:67119041146700:HTMLD:

 

The download link structure is:

URL/f?p=<app_id>:<page_id>:<session_id>:<format>

The Interactive Report download link structure contains the following substitution strings:

app_id is the application id
page_id is the page id
session_id is the session id
format is the download format: CSV or HTMLD

To create a custom download link at the bottom of the Interactive Report for direct CSV download, follow these steps.

1. Create a button in the Interactive Report region.
2. Place it on the bottom of the region, aligned right, and for Action select Redirect to URL.
3. Set the URL to: http://localhost:8080/apex/f?p=&APP_ID.:&APP_PAGE_ID.:&SESSION.:CSV:

The button will be created under the Interactive Report.
Clicking it will directly open the web browser’s download window:

 

 

3 thoughts on “Create a custom download link for an Interactive Report

  1. Pingback: Create a download link for an Interactive Report « HA IT Services Pvt Ltd

  2. Jesse Walker

    Can this be done for xls or xlsx or rtf file formats? I tried using the above approach and changing the format to something different, but they did not work. Thank you for your time and consideration.

  3. Peter

    Hi,
    I’ve found this post most useful, but when I implemented it I get the following error when I click the button:

    Error ERR-7620 Could not determine workspace for application (117).
    Expecting p_company or wwv_flow_company cookie to contain security group id of application owner.

    Any ideas?

    Cheers..

Leave a Reply