Exporting report results to the file system

Is there any way to schedule a report such that its output is expported to the file system instead of being stored back in the database?

I'm asking because some of the reports that will be generated will be 40M in size and I don't really want the overhead of
1) transferring this to the DB
2) writing it in the DB
3) retrieving from the DB
4) transferring it from the DB

especially when I could write it straight to the file system and have a web server serve it directly from there.

William
william_ferguson_au's picture
Joined: Jul 25 2006 - 9:14am
Last seen: 16 years 8 months ago

6 Answers:

This functionality is not present in JasperServer.

In which way do you intend to use the exported files? Do you need to access them via the web gui or would the files be accessed only directly on the server file system?

Regards,
Lucian
lucianc's picture
72629
Joined: Jul 17 2006 - 1:10am
Last seen: 8 hours 34 min ago
We don't intend to use any of the JasperIntel UI.

All access to JasperIntel is via a WebService.
The generated report files will be served directly off the disk by another Servlet or WebApp.

William
william_ferguson_au's picture
Joined: Jul 25 2006 - 9:14am
Last seen: 16 years 8 months ago

William,

I would like to know how did you solve the issue? We have same issue now (using Jasper 3.7).

thank you,

 

jeaninfogix's picture
Joined: May 6 2010 - 7:13am
Last seen: 12 years 11 months ago
Can we do this in Jasper 4.0 ?
sendarnav's picture
396
Joined: May 10 2011 - 1:41am
Last seen: 6 years 12 months ago

 Was wondering if this was ever implemented. I am looking at Jasper for a new reporting environment and this is one of my requirements. Our goal is to start with community edition and if it works then move to the enterprise version. Today we have some reports that could be served by the Jasper Server UI itself but some others would be required to be in the file system so another application moves it around to other places. 

I know we could write a web service to suck it up elsewhere but the tools we have are really tailored to do file movement (and re-writing them will be time consuming and costly).

Can we extend the server code to do this if it is not a feature?

Thanks!

 

el_eduardo's picture
Joined: Jun 8 2012 - 11:19am
Last seen: 10 years 9 months ago

The funtionality to schedule reports to an FTP service was added in Jasper Server 4.7 using the new REST API, check the Web Services Guide on Chaper 3 section 3.7.11 http://community.jaspersoft.com/sites/default/files/docs/jasperreports-s...

marianol's picture
15804
Joined: Sep 13 2011 - 8:04am
Last seen: 4 years 5 months ago
Feedback
randomness