Enterprise Reporting:
- EspressReport ES Overview
- EspressReport ES Description
- Features and Release Notes
- Supported Data Sources
- Explore
- Examples
- Documentation
- Tutorial Videos
- Request Demo
- Download
Documents:
Product Brief [2.08 MB]
Ad-Hoc Reporting [267.56 kB]
Performance [724.74 kB]
Technical Overview [2.08 MB]
Features and Release Notes
Version 7.0.2
Dashboard and QD Designer
- Sound Alerts feature in dashboards
- Alert popup messages feature in dashboards
- Added 3D chart axis scaling to the QuickDesigner Charts
- Improved LDAP compatibility
- Fixed several GUI bugs in responsive dashboards
- Fixed a cross-site scripting security problem in report viewer
Report and Chart
- "Save report with no saved data" feature in Report Designer
- Fixed a problem with multi-value parameters with BigInteger data type
Version 7.0
General improvements
- Unified data registry dialog in Quick Designers and Map Designers allows users to view query, query result, and test with different parameter values, so users can locate the desired query easily.
- Diagrams on start page of Quick Designers and Map Designers helps end-users to understand how to use the tools quickly.
Dashboard Builder
- Being able to change chart type in dashboard preview gives end-users more control on dashboard contents.
- Directly opening report/chart/map designer from dashboard builder makes it much more convenient to edit existing components or add new components.
- Besides original static dashboard, responsive dashboard is added as a new dashboard type. Responsive Dashboard optimizes utilization of the display without exceeding the display width preset by user. Therefore, it’s useful for mobiles.
- Refresh Template icon on each report/chart/map makes it easier to test dashboard with real data.
QuickDesigner Reports
- Simplified UI includes only two steps: Select Datasource and Construct Report.
- Constructing and formatting report in only one interface makes it intuitive and easy to see what you get and flexible to make changes.
- Drag and drop to add report columns and order report column ease the work of report design.
- Right click on report column to do Aggregation/Format/Remove is straightforward.
- ’Excel-like’ search icon on each column header allows data filtering by column.
- Parameters pane on the right makes report testing easy.
- Less items on Toolbar reduces confusion and saves time.
- Collapse Sidebars allow more space for report design.
QuickDesigner Charts
- Simplified UI includes only two steps: Select Datasource and Construct Chart.
- Setting pane and chart preview pane are in the same window, so all design steps can be done in one window.
- Improved toolbar shows Chart-Specific Options based on current chart type and combines settings to reduce icons.
- Parameters setting on Chart Preview pane makes chart testing easy.
- Collapse Sidebar allows more space for chart design.
Online Maps
- Online Map is a newly designed Google Map. It is more straightforward to create a new map.
- Displaying setting on left pane, instead of popup dialog, makes UI more user-friendly.
- Save dialog shows Organizer node tree. It makes it easier to locate the desired organizer folder to save map file.
- Heatmap feature provides visualization of data intensity.
- Being able to set parameter values in Map Designer makes testing easier.
- More map types satisfy different needs.
- Users can draw various shapes instead of simple map points. The shapes are drawn in Coordinates Editor.
SVG Maps
- Redesigned UI is more straightforward to create a new map.
- Allow users to change SVG image after a map is created.
Version 6.6
General improvements
- Bug fixes and performance improvements - hundreds of bug from customers supports. Many of them are not included in lates V6.3 update, because their integration required deep code rewriting. Our software runs much faster and better than ever before.
- Java 7 and Windows 7 support.
New features
- PAK Files - make it easier to transport data registries, dashboards, and maps in a single file which makes them easier to share between servers.
- Improved Organizer with Advanced Search Dialog - features flexible sorting options and intuitive icons that improve ease of use and functionality. The Organizer is now embedded into the browser window, without any pop-ups.
- Support for Multiple Administrators - enhances the manageability of information and security.
- Improved LDAP Support - LDAP users can be integrated from any existing Active Directory, without any modifications to the Active Directory. Users can be managed completely in the Active Directory and all changes in the AD will take effect immediately.
- Import Users from CSV File with GUI - lets you import users by simply browsing the local directory and loading the file in an easy-to-use interface.
- Improved database upgrade - The most common databases are now upgraded automatically by the installer, which makes upgrading from any previous version to the new 6.6 version very easy.
- Tooltips for Charts in Dashboards - are now more detailed and easier to read. Users can clearly see data points and other key information.
- Touch Screen Gestures for Dashboards - make it even easier for users to view and analyze dashboards anytime, anywhere all while using intuitive touch screen gestures on mobile devices.
- QD Report/Chart Insert Variables Dialog - enables parameter values to be displayed on Quick Designer reports and charts, giving users more control over the content of their reports and charts.
- Tomcat 6 support.
Report features
- “ALL” Parameter Value - allows users to select the all values in a parameter, rather than selecting each value individually.
- Unexpanding PAK Files - allow users to seamlessly transport reports, sub-reports, and drill-downs in one file, making collaboration easy and effective.
- Round Corners for DHTML - offers another way to make reports more visually appealing and adds another element of customization.
- Vertical Text in Report Cells - allows users to further control report options to suit their visual requirements.
- Auto-Resize Column Width for Excel Export - makes the Excel export conform to Excel reporting.
- GUI for Inserting Data Source Column to RTF - gives users the flexibility to insert columns, formulas, and parameters into rich text without having to remember and type the item names.
- Data Types in Previews in Query Builder and Data Views - let users easily see the types of data in their reports which allows the tracking of data types and makes it easier to build formulas.
- New Chart and Report Designer Icons - make designing reports intuitive and aesthetically appealing.
- Dialog to Specify Section Height - enables users to easily create precise section heights by entering the desired value rather than by controlling the height of different sections with a mouse.
Chart features
- Time Based Zooming for HiLo and HLCO Charts - Users can select an aggregate data range to more efficiently analyze large amounts of data.
- Top N and Bottom N Options - allow users to get a quick overview of key performance metrics.
- Smooth Trend Lines - present a more accurate picture of the trend.
- More Configuration Options for Gradients - gives users complete control of gradient options for each part of a chart.
- Insert Vertical Line with Today as Value on Gantt Charts - lets users clearly label a point in time to show the progress of projects.
- Improved Transposition UI - for charts allows users to intuitively transpose charts visually, without the need to understand the underlying structure.
Version 6.3
New features
- Introducing Alerts - Keep track of key performance data in real time with the new Alerts feature.
- Alerts for All - Create alerts for reports, charts, and maps. Existing charts with control ranges and SVG maps with thresholds can be immediately used as alerts.
- Real Time Monitoring- Monitor your data by specifying the alerts to watch, defining the time interval and frequency of the check, and sending detailed emails to notify key personnel.
- Dashboard Alerts - Highlight components when a specific alert is triggered prompting the viewer to take timely actions.
- Excel Datasource - Extract data from Excel spreadsheets directly using the new Excel datasource feature in the data registry. Excel 2007 and 2010 are supported.
- Auto Start Server - Once configured, this new feature automatically starts the EspressDashboard server when the application server is started.
- Improved File Management - When saving maps, dashboards, and Quick Designer files, the new interface blocks users from overwriting other people's files.
- Map Parameters to SQL Query in Quick Designer - Quick Designer users can now map parameters directly to an SQL query.
- Quick Designer Dial Chart Options - New options such as draw full circle and needle options are available in the Quick Designer Dial Chart.
- HTTPS Install - Users planning to use HTTPS can install using the HTTPS option, which will automatically create a local certificate. This allows users to connect to the server using HTTPS immediately after installation.
Dashboard features
- Multiple Dashboard Drill-down - Dashboard components can have multiple drill-downs and the new interface allows for easier control.
- Maximize Dashboard Components - Components in dashboards can now be maximized so users can view the enlarged component clearly.
- Default Dashboard Options - Users that prefer options different from the default can now set their preferences in the admin console to have their settings loaded automatically.
- New Dashboard Options - Dashboard Designer can now enable auto refresh in the builder. Parameter ranges dialog now allows the flexibility of showing the entire dialog or only the drop down list portion.
Data export
- Export to the Latest Excel Format - An addition Excel enhancement, reports can now be exported to the XLSX format viewable in Excel 2007 and 2010.
Report features
- Excel Datasource - Extract data from Excel spreadsheets directly using the new Excel datasource feature in the data registry. Excel 2007 and 2010 are supported.
- New Barcode Library - Reports now support 30 different barcode standards.
- Expand and Collapse Grouped Reports - The new feature takes large summary break, master & detail, and crosstab reports and makes them much more manageable by allowing you to expand and collapse groups of data.
- Import Existing Charts to Reports - The new feature allows you to select an existing chart to add to your report rather than creating a new chart or going through work-arounds.
Chart Features
- Excel Datasource - Extract data from Excel spreadsheets directly using the new Excel datasource feature in the data registry. Excel 2007 and 2010 are supported.
- Chart Color Sets - New color sets are available to make your charts look better than ever. Choosing a color set means new data that did not have a color mapped will always use colors from the set rather than choosing a random color.
- PAC Files - The new PAC feature will combine all charts and their drill-downs into a single file for greater transportability and easier backups.
- Auto Adjust 3D Charts - Charts are automatically adjusted for scale and position to create a much better appearance when using the Chart Designer.
- Chart Designer Bounding Box - A convenient new bounding box has been added in the Chart Designer to help scale charts without using the right mouse button.
- Improved Sorting in Charts - When users choose to sort the data in the Chart Designer, the sort order will be applied to dynamic data as well.
- Chart Designer Dialog Enhancements - Several dialogs, such as Insert Link, Trendline, Control Area, etc., were updated to provide an easier to use interface.
- Single Color Column/Bar Chart - Column/Bar charts without series are drawn with single color by default.
Version 6.2
New features
- Animated Flash Charts - Take data visualization to a new level by utilizing the sleek and stylish flash option for charts. Create impressive presentations by incorporating animation in dashboards, integrating flash using the URL generator, and exporting flash directly from menu page. All the while maintaining a rich set of features such as mouse over hints, drilldowns, and hyperlinks.
- 2D and 3D Doughnut Charts - Highly customizable doughnut charts are here. Configure the data order, labels, exploding sectors, sector gaps, and more, as well as position, scale and rotate 3D doughnuts in true 3D.
- Improved 3D Curve Surface Rendering - The new rendering algorithm delivers smooth color gradients and realistic light shading making it the best looking 3D Pie and Doughnut charts to date.
- Internationalized by Default - Make internationalization a core feature rather than an after thought. With version 6.2, the entire ERES system will by default support all international characters using UTF-8 encoding. This includes all XML files used, all export formats, all filenames, all text data, all parameters, usernames and passwords, and more.
- Administrative Convenience - The administration console has been revamped to include more options and a more organized user interface. Now setting up the Google map key and enabling secured parameters are done by simply filling in a few fields.
- Optimized Libraries and Installers - All client side jars files have been optimized and compressed to allow for faster load time for applets. We have also reorganized the system to make the entire installer smaller and quicker to download.
- Windows 7 Support - Fully tested and ready to go on the Windows 7 Operating System.
- Custom Date Formats - Parameters mapped to columns and data view conditions are traditionally displayed in the raw database format making it difficult to read and choose from. The new feature allows users to build a custom date format using the new format builder. As such, all future parameter prompts and dataview conditions for date and time fields will be displayed using this format.
- No Data Message in Charts - A convenient new option has been added to give designers a way to set the no data message in the chart designer.
- Cut Corners - A new "cut corners" style as been added to chart legends and annotations. The legends can be modified in the chart designer as well as API and the annotations can be set via API only.
- Symbol Border Color - Users can now select a data point symbol border color in the chart designer.
- Finer Gradient Control - Users can now specify to display gradients for chart data only. For example, draw the bars in a bar chart with gradient but leave background gradient turned off.
Version 6.1
New features
- Improved Performance
- Enhanced Paging Algorithm & Data Structure for Large Reports - The enhanced vitural memory/paging algorithm allows users to run very large reports with millions of rows of data without any concern of running out of memory. The system automatically adjusts memory usage based on given quota and maintains performance for even high traffic servers. On-disk data structure is optimized for storage space as well as performance. A new set of configuration options is available to provide detailed control over system memory usage.
- Paging for DHTML Viewer - The DHTML Viewer commonly used to preview reports prior to export has been updated as well. The new version uses paging to display the first page as soon as it is available even while the rest of the report is still being run on the server side.
- DHTML Viewer User Interface Improvements - New glass pane, progress bar, and page navigator greatly enhance the user-friendliness.
- Parameter Value Validation - New parameter validation will alert users when they enter a value of the wrong format for unmapped parameters.
- ERES Using JNDI Data Source - Now administrators can connect ERES to a JNDI data source to increase portability across various testing and deployment environments.
- Scheduler Support for Secure FTP - The ERES scheduler can now deliver reports and charts to Secure FTP servers.
- User Friendly Column Mapping Dialog - The column mapping dialog in report designer has been updated with auto resize, auto select aggregation type, and improves default mapping features.
- Export GIF to Excel - Excel export now supports JPG, PNG, and GIF image formats.
- Multilevel Undo & Redo - Now, it is even easier to design reports and charts. New multilevel undo and redo in both Report and Chart Designer gives users the freedom to try different layout and styles without losing the previous settings.
- New Gauge Templates - A new set of circular, semicircular, and quarter circular gauges featuring realistic metalic covers in different shades and curvatures is now available.
- Flexible Translucency Setting - A new sliding scale gives designers added precision to creating elegant semi-transparent charts.
- Aggregated Charts - Rather than having to modify the database query for aggregation, this handy feature will perform a specified aggregation on the data before plotting the chart.
- Improved Gradient Controls - A new set of gradient options is available for all chart types. Designers can now control the direction as well as the start and end locations for the gradient. They can also fine tune the gradient range by specifying a start color and either an entirely different end color or a different shade of the same color.
- New Chart Label & Ticker Options - Even with label step intervals, large sets of data could clutter the x-axis with labels and tickers. Now designers can specify a maximum number of labels and tickers so that no matter what range their end users set, the chart will always look perfect.
- New Dial & Gauge Chart Pointer Options - Four new pointer options (Pointed Blade, Round Headed Blade, Triangular Pointer, and Step Pointer) add elegant options to any dial and gauge chart.
- Stack Bar & Stack Column Chart Enhancement - New option allows users to enable or disable padding for a better looking chart.
- Crisp HLCO & Candle Stick Charts - New option is available to add a border to HLCO and Candle Stick Charts for a crisp clean look.
Version 6.0
New features
- Introducing
- MapsSVG Maps - An SVG map allows users to define areas on the map and associate them with data points. It supports parameter options, customizable color code based on data ranges, and drilldowns to reports, charts, and dashboards.
- Google® Maps - Users can take advantage of Google® Maps' rich functionality and ease of use while viewing their own data. The new Map Designer makes it simple to embed Reports and Charts directly into Google® Map tooltips and allows users to add parameters and drilldown.
- Flexible Map Publishing - Present the maps by themselves in the menu page or publish alongside other reports and charts within executive dashboards.
- Drilldown to Dashboards - Now users can drilldown from dashboard to another dashboard, allowing for even more control over flow and detail.
- Improved Schedules & Archives
- Create Packages - Schedule multiple reports and charts into a single package. Send a single email with multiple attachments or links to the recipients.
- New Interval Options - Now users can specify time intervals for fixed day schedules. For example, run a report every hour between 9AM - 5PM, or specify the exact export time for irregular schedules.
- Informative Error Handling - In case a problem occurs when running the schedule (perhaps the database is down or network connection is faulty), users can send an alternative email to recipients notifying that they're on top of the situation. ERES can also send the error logs to an email address of their choice.
- Send Emails Based on Parameter Set - Users can now send a single parameterized report to multiple users based on the parameter set values. For example, a report with a region parameter can be scheduled to deliver each region's report to a different set of email recipients.
- Export Now - New option to run schedules immediately at the click of a button.
- Enhanced UI - The Scheduler is now shown with tabs allowing for easier back and forth navigation and improving functional clarity. A new email recipients page is added to give users further control over schedule delivery.
- Scheduler Logs - Admins can view past schedules, status, errors, recipients, parameter options, and much more with the new detailed scheduler logs.
- Intelligent File and Data Registry Node Locking - The ERES file and data registry node locking system has been updated to allow the same user to override their own locks from different locations, but still maintain proper concurrency control.
- Limit ERES Organizer Browse Directory - Adding a single parameter to the ERES Organizer restricts users from navigating away from the specified directory.
- Forward Compatibility - Starting in version 5.5, files created in later version can be opened in previous version. So now users can share v6.0 reports with their colleagues who are still using v5.5. Note that newer features will not be available in earlier versions.
- SalesForce® and WSDL SOAP - The new version includes two new SOAP datasource implementations to support WSDL Standards and the SalesForce® SOAP format.
- Multiple Databases in MS SQL Server® - Create a single query or dataview that retrieves data from multiple Microsoft SQL Server® databases on the same server.
- Scripted Image URLs - Add complex logic to Image URLs to display specific images under various scenarios in a single report.
- Chart Gauges - ERES provides dozens of gauge templates of various styles for the dial chart. Users can even create their own gauge template and add it to the designer options.
- QuickDesigner Aggregation Alias - Provide user-friendly names to aggregations that accurately reflect the purpose of each fields.
- Pie Chart Text Placement - New algorithm is included to improve pie chart text placement to minimize overlap and enhance readability.
- 3D Add On Charts (API Only) - Now users can display 3D charts on top of another 3D chart.
- Legend Enhancement for Line Charts (API Only) - A new method allows users to show the line within the legend icons.
- Scatter Chart Point Size (API Only) - A new method allows users to change the size of scatter chart point size to as small as a single pixel.
Version 5.5
New features
- Exciting Dashboard Features
- Radio Buttons and Check Boxes - Add radio buttons for single value parameters and check boxes for multivalue parameters.
- Parameter Ranges - Create ranges for dates, numbers, and strings. Range options can be customized to the user's needs. Using this feature, dashboards designers can create a simple to use drop down list with options such as "Last Month", "This Year", "Next Quarter".
- Folders - Pack more information into a single dashboard by adding reports and charts into folders. Users can quickly scan through the contents by clicking on the customizable tabs.
- Linking - Aside from drilldowns and parameters, the new verion allows even more interactive dashboards. ERES now provide a new feature where reports and charts can be linked together on a dashboard. Clicking on a linked report or chart will pass the values from the link as parameter values to other elements.
- Cascading parameters enhancement - Cascading parameters are now supported in subreports and drilldowns, cascading parameters can even be used in conjunction with linked sub-reports.
- LoginListener - The LoginListener is a flexible API tool which attaches information to each user when they log in. For instance, by attaching database credentials to each user, report designers can create a single report or chart, and have the database connection swapped on the fly when users view it from Dashboard Builder and Menu Page. The connection information will also be used when the user creates ad hoc reports in the QuickDesigner.
- ERES API Enhancement - A new set of API's has been added to ERES allowing developers to build custom UI for admins to manage users and groups directly through code.
- Report Designer Enhancement - Opening a report and canceling will no longer close the previous report.
- Script Management Enhancement - Users can now delete scripts that has been applied to elements in the report without having to remove the applications first.
- Chart Color Mapping - Colors are now mapped to category, data series, and sum by names. Setting green for "YES" will always appear this way regardless of how the data is structured.
- Dynamic step interval - User can now specify label step units for dates as dynamic, which will automatically calculate the interval based on the data range.
- Chart Zooming Enhancement - In chart viewer, changing the range will dynamically change the scale as well.
- Pie Chart Enhancement - New option is available to hide 0% elements in pie charts.
- Relative Background Images - Chart background images can now be saved with a relative url.