[how to create FTP datasource. I do not see it in the dropdown Type list]

I am trying to output the report export to FTP server. i want to create a FTP datasource so that user can select FTP datasource to export the report in Excel.

I could not find any FTP related drivers to create FTP source  OR  Ways to save FTP connection details without entering  each time a schedule created.

 

 

 

[JasperReport Export taking more than 15min.]

Jasper Report on the Jasper Server/Studio taking long time to load

Exporting the report to Excel is taking more than 15 minutes.

Report design:

Simple report with Title,RunDate,Table in the Summaryband with 10 columns.

Data: 500k records and Report shows pages nearly 15k.

SQL Query in the database runs in 0.6 seconds

Could you please help? .