JasperServer default XLS Export

[leonardomartinez]

Hi, I have a report in JasperServer embedding via iFrame like this:

<iframe height=100% width=100% seamless id="frame1" name="frame1" frameborder="0" marginheight="0" marginwidth="0" src="server:port/jasperserver/flow.html?_flowId=viewReportFlow&standAlone=true&_flowId=viewReportFlow&ParentFolderUri=%2Freports&reportUnit=%2Freports%2FReporte_Ventas_Cliente_Under_Armour_Mexico&j_acegi_security_check&j_username=jasperadmin&j_password=jasperadmin&decorate=no</cfoutput>">

Ant that give me the standard view of jasperserver where I can export to pdf, xls, etc,  but i'd like to access direct to xls view, is there a way for accomplish it?

 

Thanks.

[marianol]

Yes to get direct access to a specific report output you can set the ourput parameter in the HTTP API call so something like this:

http://localhost:8080/jasperserver-pro/flow.html?_flowId=viewReportFlow&reportUnit=%2Fpublic%2FSamples%2FReports%2FAllAccounts&output=xls

You can also use the REST API (see the doc in the Webservices Guide http://community.jaspersoft.com/documentation/tibco-jasperreports-server-web-services-guide/v60/running-report) the call will look somethig like this:

http://<host>:<port>/jasperserver[-pro]/rest_v2/reports/reports/samples/Cascading_multi_select_report.xls? Country_multi_select=USA&Cascading_state_multi_select=WA&Cascading_state_multi_select=CA

I think that from the HTTP APi there is an outputformat param but I'm not sure

[leonardomartinez]

Thanks! it works with &output=xls parameter in the HTTP API Call

 

Regards.