csv export directly from jasperserver without running the report

[sinsand]

HI,

we have a requirement that from jasperserver we direclty need to export the csv or excel without running the report in jasperserver and then to export in csv and excel format.

Currently the Jasperserver is embedded in iframe and from there we are generating the report. The client reqiurement is that without using the Iframe we need to connect to the Jasperserver and get the reports in csv or excel report.

Is that possible using JasperServer and if it is Please suggest how it can be achived?

Thanks,

Sandeep

[kkriplani]

Hi,
I have a very simple method. 
embedd an image/text field in the report (it may say "export"), give it hyperlink to the report you want to export in either csv or xls as ReportExecution and Parent. While linking parameters, pass a parameter name as "output" and expression as "xlsNoPag" or "csv" as required.

Refer the image below.

You can have two images/text fields saying "Export to CSV" and "Export to XLS".

This should help,
Regards,
KKriplani

[hozawa]

You can get call the REST API to retrieve in csv format. (specify format to be "csv")

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-rest-api-reference/v621/reports-service