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.

[liamwhelehan]

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

[fionarambarran]

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

[markusbecker]

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

[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

[MiguelAngelramirez-sh]

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

[parthparth]

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