| Category: | Enhancement request |
Priority: | Normal |
Status: | Acknowledged |
| Project: | Severity: | Feature |
Resolution: | Open |
|
| Component: | Reproducibility: | N/A |
Assigned to: |
Hello,
We're a software development shop interested in better integrating Jasper Reports output into our own software. We really like the ability to rapidly create reports via JasperReports Server, all of the "free" function we get (export formats, email delivery, etc) however we want to be able to better integrate JasperReports output into our own application. We're not averse to doing some front end (Javascript) development to make that happen, and it appears that the new Rest Report API gives a lot of what we need.
The one problem is that the report output formats as they are now would require a decent amount of work to apply our own formatting to. A JSON output format would help with this a lot, since it's readily manipulated with some Javascript. In fact, many table\chart processing libraries would allow this to be handle without much work at all if there was some JSON to work with.
From http://community.jaspersoft.com/documentation/jasperreports-server-web-s...
outputFormat Required Specifies the desired output format: pdf, html, xls, xlsx, rtf, csv, xml, docx, odt, ods, jprint.
We would LOVE to see JSON added to that list. The exact format is fairly negotiable since it can manipulated to the format that's needed via JavaScript.
Thanks!
3 Comments:
Currently there is no JSON exporter in JasperReports Library. But is extensible so if needed you can create your own exporter. See http://jasperreports.sourceforge.net/api/net/sf/jasperreports/engine/exp... the CSV exporter will be a good place to start. You can also add an enhancement request in the JR library project http://community.jaspersoft.com/project/jasperreports-library
But using a full report execution just to receive raw data may be an overkill, If you just need raw data in JSON you can use JasperServer Domians and the REST Query Executor service, see http://community.jaspersoft.com/documentation/jasperreports-server-web-s... there is a nice sample of this here: http://mdahlman.wordpress.com/2013/05/07/rest-endpoint-for-jaspersoft-qu...
Note: Domains are available in the Pro version of JasperReports Server