Improved report interactivity - Reports created with JRXML table components are now interactive directly in the server's Report Viewer. Users can sort the table by clicking one or more column names and filter displayed rows by right-clicking the column name, selecting an operator, and entering a value.
Excel output format - New export options in the Report Viewer produce true single-page spreadsheet output in Excel and XLSX format. These options run the report again to seamlessly fill tables and crosstabs, so that the spread- sheet is ready for further data manipulation in Excel. The previous Excel and XLSX options are still available with the "paginated" label. The "paginated" options do not run the report again (faster), but may contain page artifacts such as column or row breaks.
Interface - The Report Viewer has been improved to show the report name at the top and move pagination controls above the report contents.
Ad Hoc for OLAP - In addition to Mondrian connections, users can now perform analysis on data from XML/A connections through the Ad Hoc Editor. In addition, OLAP-based reports can now be previewed, run, and exported from the Ad Hoc Editor. The similarities between Ad Hoc reporting and analysis simplify the product and shorten the learning curve for users. Note that the superuser cannot access cubes exposed by XML/A connections from the Source dialog of the Ad Hoc Editor.
Improved Ad Hoc Editor - With the integration of Ad Hoc for OLAP data sources, the Ad Hoc Editor has an updated interface:
Tables and crosstabs have a new color and line style that is consistent between all sources (Topic, Domains, and OLAP connections). As a side-effect, the Ad Hoc styles that set the colors of the report have been removed.
The display band replaces the grouping icon for tables and charts, thus unifying and simplifying the interface for all sources. The display band provides a visual shortcut for manipulating the fields and groups.
Topics and Domains now allow users to distinguish between regular fields and measures. Designating fields as measures provides extra metadata to help users create reports. In Topics, measures are determined automatically from numeric fields, but the interface allow users to manually designate fields and measures.
Fields and measures in Domains - To support the functionality of measures in the Ad Hoc Editor, Domains contain an extra setting in the Domain Designer interface (and in the XML design file) to mark items as fields or measures.
Web Services REST API - In this release, new RESTful web services provide complete access to repository resources and server administration. Remote applications can now manage organizations, users, and roles through RESTful methods. In addition, the REST methods are enhanced to interact with with report options, scheduled jobs, and for downloading dashboard resources.
Security - The JasperReports Server now has enterprise-grade security through the integration of a comprehensive security framework. This new security framework protects the server against common security threats. Customers can configure the security settings (switch on/off or change the security rules) based on their perceived threat level.
Database Server Support - JasperReports Server now supports MySQL 5.5 as an RDBMS host for the repository database. You must provide the required JDBC driver for this platform. Refer to the Installation Guide for details.