Download CSV file from Report with button in Oracle APEX

1：go to the report attributes,choose download setting all formats such as CSV,PDF, XLS, HTML,RTF etc.
2: set the item as 'submit page'
3: set the download button behavior : Action：Redirect to URL
URL:f?p=&APP_ID.:8:&SESSION.:CSV:::P8_DEP_ID:&P8_DEP_ID.
4: If you want to change the downloaded name, go to the report attributes--download--filename
Download URL：
CSV: f?p=&APP_ID.:8:&SESSION.:CSV:::P8_DEP_ID:&P8_DEP_ID.
Excel: f?p=&APP_ID.:8:&SESSION.:XLSX:::P8_DEP_ID:&P8_DEP_ID.
PDF: f?p=&APP_ID.:8:&SESSION.:PDF:::P8_DEP_ID:&P8_DEP_ID.
HTML: f?p=&APP_ID.:8:&SESSION.:HTML:::P8_DEP_ID:&P8_DEP_ID.

[@liamwhelehan2703]

This is excellent I have been searching for something like this al day

[@weililiu2119]

Thank you!

[@fionarambarran3390]

Is there a way to set the automotive download path to a specific directory path e.g. C:\Users\fi\Documents?

[@danielborgstrom]

If you filter using the default search box in your IR this will not work. You will not get the same result in your EXCEL as what is shown on the screen

[@markusbecker4597]

How to set a dynamic filename? (with date or so)

[@MiguelAngelramirez-s4h]

I can download the csv file of the table without using the P8_DEP_ID, only download the data that the table returns without performing the select list

[@sumanthgajula4065]

Great! Can you tell me how did you do it?

[@parthparth8680]

Good Video but I want to Open Excel Report or PDF Report in New Window when I click on Button

[@weililiu2119]

Excel: f?p=&APP_ID.:8:&SESSION.:XLSX:::P8_DEP_ID:&P8_DEP_ID. PDF: f?p=&APP_ID.:8:&SESSION.:PDF:::P8_DEP_ID:&P8_DEP_ID. HTML: f?p=&APP_ID.:8:&SESSION.:HTML:::P8_DEP_ID:&P8_DEP_ID.

[@vladimirtrajkoski7859]

what is dep_id?