Quadbase

February 23 2024, Version 7.0 update 15 released

Quadbase Systems is pleased to announce the release of version 7.0 update 15 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 15:

• Added support for more Chinese, Japanese and Korean fonts and character encodings to PDF export
• Fixed a DataSheet issue for Informix database
• Fixed a PDF export bug - layout broke in PDF when some elements were hidden by a script
• Fixed Report Viewer - missing libraries for XLS and XLSX export
• New feature - reports with sub-reports merge PDF font mapping settings together
• Fixed a Java compatibility issue in Espress Page Viewer
• Fixed a problem with chart drill-downs missing in dashboards
• Fixed a problem with parameter drill-down Save As dialog saving two tpl files instead of one
• Fixed a problem in PAC format - it was still saving tpl files in the drilltemp directory instead of saving everything to the PAC file
• Fixed a problem with Save As for CHT files with data drill-down throwing an error
• Fixed a problem with nullpointer error when exporting reports with sub-reports
• Fixed numerous minor issues in parameter drill-downs in chart
• Fixed an image loading issue in EC and ER in Linux systems when EspressManger was running as a servlet
• Improved error messages in QbChart API class for easier debugging

September 27, 2023, Version 7.0 update 14 released

Quadbase Systems is pleased to announce the release of version 7.0 update 14 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 14:

• New code signing certificate for signing our Jar files
• Added support for time-limited licenses
• Added support for MongoDB CData JDBC driver
• Added support for BigData CData JDBC driver
• Added support for Excel CData JDBC driver
• Added support for SalesForce CData JDBC driver
• Added support for JSON CData JDBC driver
• Added support for Kintone CData JDBC driver
• Added an option to allow editing and moving elements in crosstab reports
• Added a support for Office 365 SMTP mail servers
• Added support for OpenShift containers
• Added support for SVG and Google map link generation (with automatic log-in)
• Added a support for deploying EC and ER as servlet in a default install directory
• Added a support to run install EC and ER EspressManager as a Windows service (option set in Windows installer)
• EspressChart Chart Designer and Chart Viewer JNLP (Java WebStart) fixes
• EspressReport Report Designer and Page Viewer JNLP (Java WebStart) fixes
• Added “Prevent Self-Destruct” argument to JNLP files
• Added a new way of launching EspressReport and EspressChart EspressManager as a servlet in Tomcat
• Dropped flash support from charts
• Improved crosstab report compatibility with version 6.6
• Unified PDF export in MenuPage and Report Viewer
• Fixed doughnut charts “Arc Length Ratio” setting in both GUI and API
• Numerous fixes in PAC chart files with file drill-downs
• Fixed a bug in EC API - line thickness could not be set lower than 1 in EC API
• Fixed multiple issues with QuickDesigner data view parameter initialization
• Fixed a bug with CPU-core detection in license
• Fixed EC and ER user password compatibility issue when upgrading from older versions
• Fixed support for SalesForce connection
• Fixed a bug in reports, images couldn't load sometimes
• Fixed multiple issues in running EspressManager as a servlet in an application server
• Fixed Java Web Start issues related to libraries upgrades
• Fixed an issue with aggregation formulas in Table Footer sub section
• Fixed multiple problems with parameter dialog in reports

Quadbase Systems is pleased to announce the release of version 7.0 update 13 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 13

• Upgraded Jakarta-activation library from 1.1.1 to 1.2.2
• Upgraded Jakarta-mail (sending emails) library to 1.6.7
• Upgraded Xerces library (XML parser) from 2.9.0 to 2.21.1
• Upgraded the POI libraries (ooxml-schemas, ooxml, poi) from 3.17 to 5.2.0
• Upgraded commons-codec library from 1.11 to 1.15
• Upgraded commons-collections library from 4.2 to 4.4
• Upgraded commons-compress library from 1.18 to 1.21
• Upgraded commons-fileupload library from 1.2.1 to 1.4
• Upgraded commons-io library from 2.4 to 2.11
• New library commons-math3 version 3.6.1 (because of POI)
• Upgraded zxing-core from 3.3.0 to 3.4.1
• Upgraded zxing-javase from 3.3.0 to 3.4.1
• Upgraded wsdl4j library from 1.5.1 to 1.6.3
• Upgraded xml-apis (Batik SVG) from 1.3.04 to 1.4.01
• Added xml-apis-ext library, version 1.3.04
• Upgraded xmlbeans library from 2.6.0 to 5.0.3
• Added SparseBitSet library version 1.2 because of POI
• Removed unused and outdated references in all bat, sh and jnlp files because of libraries upgrades
• Implemented Secured Parameters for Maps
• Fixed a problem with Secured Parameters with custom user database
• Fixed a database connection problem with custom user database
• Fixed a minor problem with non responding OK button while initializing parameters in QuickDesigner
• Fixed a problem with Data Format and View Column mapping in crosstab reports
• Fixed a problem with barcode 128 export to PDF
• Fixed a problem in QuickDesigner Charts with & in the file name
• Fixed a problem with security levels with & in the names
• Fixed a problem with secured params in sub-reports
• Fixed a crosstab report compatibility problem between 66 and 70
• Fixed a problem with ERES scheduler email delivery
• Fixed a problem with initializing Data View parameters in QuickDesigner
• Fixed an important problem in connection pooling (causing SQLNonTransientConnectionException in reports with sub-reports)
• Fixed a problem with scheduler printer delivery
• Fixed a problem with login applet in remove browsers in EspressChart

Quadbase Systems is pleased to announce the release of version 7.0 update 12 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 12

• Migrated to Java 8. Java 7 is no longer supported.
• New feature: allow crosstab report element movement
• Upgraded the Microsoft SQL Server driver to 9.4.0
• Upgraded the MySQL driver to 8.0.26
• Added a file identifying the product build (useful for beta and testing versions)
• Upgraded the mongodb driver
• Removed Log4J library from the product
• Improvements in PDF export: if an image is being displayed multiple times, it’s added only once to the PDF export (lowers the file size, improves speed and saves bandwidth)
• Fixed a bug in scatter charts
• Fixed a bug in column charts with secondary axis
• Fixed a bug in connection pooling
• Fixed a scripting problem in Excel exports
• Fixed a scripting problem in RTF export
• Fixed an issue with frontward compatibility in EspressChart
• Charts: added Combo Line Panel to column and bar options
• Fixed a problem with “stepline” settings when changing the chart type
• Fixed a backwards compatibility with Chart annotations
• Fixed a bug with the removal of uploaded files with “%” in the file name
• Fixed a problem with editing user groups with “%” in the group name
• Fixed a bug in txt export, the export had a wrong extension
• XSS security fix in importing users from a text file
• Secured Parameters logic change: non admin user--no level no
• permission
• Numerous fixes in Secured Parameters
• Implemented Secured Parameters in Quick Designer Reports
• New minor feature: added “Copy URL” button to Generate URL dialog in Organizer
• Fixed a bug in subreports without parameters: it always refreshes the data now

Quadbase Systems is pleased to announce the release of version 7.0 update 11 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 11

• Fixed a problem with non-database reports in Published Files
• Fixed a problem with non-transparent background in QuickDesigner Charts 3D charts legends
• Fixed a Secured Parameter problems in old QuickDesigner Reports
• Fixed a problem with QuickDesigner missing some database table column headers
• Fixed a problem with changing parameter names for reports created in version 6.6
• Fixed a problem with one-line comments between the FROM and WHERE clauses in queries (significant performance improvement)
• Fixed a forward compatibility problem for charts with “One Legend Set” feature enabled
• Fixed a problem with error message in log showing when charts with drilldowns are saved
• Fixed a problem with  backward compatibility in charts - axis had different font
• Fixed a problem with dashed lines for null data in charts being too thin
• Fixed a problem with Stack Column chart data mapping
• New feature in charts: “show/hide Zero data in Stack Column charts”
• New feature: parameterized summary break reports can use report bursting now
• Fixed a bug in “Limit Excel Cell Split” option in Scheduler
• Fixed a bug with invalid formula parameter reference in report scripting
• Fixed a problem with .getScriptValue() function not working in report Formula
• New feature in online maps: time zooming charts can now be used in tool tips
• Fixed a bug in reports: script was not applied to sub-report objects in Excel export
• Fixed a bug in Excel export: exception in log if a column had more than 255 characters
• Fixed multiple bugs in sub-reports in drill-down reports
• Fixed a DHTML export bug in drill-down reports
• Fixed a bug in reports: cannot insert new formula into report with parameters
• Fixed a bug in data sources: “Map to database function” was not working properly
• New feature: Quick Designer Reports can be exported into PAK files that can be scheduled or modified using the full version of Report Designer
• New feature: generate URL for Quick Designer Reports in Organizer
• Minor visual improvement in the Dashboard Builder
• New feature: automatic Shared Parameter mapping in dashboards
• Fixed a bug in dashboards: shared parameter “List Values” function caused errors

Quadbase Systems is pleased to announce the release of version 7.0 update 9 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 10

• New chart feature: dotted lines for chart gridlines
• New chart feature: display lines and data series in one legend block (or draw them separately)
• Added the option to “print on new Excel Sheet” to report footer
• More CSRF security fixes in Admin Console
• API feature - shift chart annotation border relative to it’s content
• New code signing certificate
• Fixed a bug in cross-tab report with parameterized queries
• Fixed a “fixed columns” legend for high-low charts
• Fixed several various graphical bugs in radar and doughnut charts
• Fixed a problem with Arabic fonts in QuickDesigner DataSource manager
• Fixed several problems with secured parameters in QuickDesigner and Dashboards
• Fixed a problem in QuickDesigner report with MS SQL data sources
• Fixed a problem with two-part database table name
• Fixed a problem with incorrect report sorting and grouping in database queries with joins
• Fixed several issues in scheduler email bursting

Quadbase Systems is pleased to announce the release of version 7.0 update 9 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 9

• Speed up Excel export
• Added a free geocoding option for Online Maps (using Nominatim geocoding service)
• Speed up the load time of QuickDesigner Reports
• Improved support for JNDI data sources
• Added a support for WebSphere
• Added sample configuration for running EspressManager as a servlet into EspressChart.jsp
• Fixed a problem with PAK file scheduler
• Fixed the “Data source doesn't have data types” error in SQL queries with the LIMIT statement
• Fixed a problem with dashboard alert email notifications
• Fixed a bug with null handler in cross-tab reports
• Fixed a problem with linked sub-reports not being loaded by report scheduler
• Fixed several bugs in Secured Parameters
• Fixed a bug with “Use Category Axis Scale” option not working in charts with only one “category”
• Fixed a bug with “Ghost Hyperlinks” in PDF export in reports with sub-reports and “Resize To Fit Content” feature enabled

Santa Clara, CA, January 2020 - Quadbase Systems Inc.’s Predictive Analytics Proof of Concept Now Available in the Microsoft Azure Marketplace

Press release: https://www.quadbase.com/press-releases/

Quadbase Systems is pleased to announce the release of version 7.0 update 8 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.


Changes in update 8:

• Fixed cross-site request forgery bugs in AdminConsole
• Fixed stored cross-site bugs in AdminConsole
• Fixed bugs in "Export Table Data to CSV" feature
• Fixed a bug in multi-value drilldown maps
• Fixed a bug with disappearing tooltips in online map map files
• Fixed multiple Excel export bugs
• Upgraded OpenLayers library used in Online Maps

Santa Clara, CA, April 2019 - We are excited to announce our new offering: Predictive Analytics as a managed service.

Press release: https://www.quadbase.com/press-releases/
Learn more about predictive analytics: https://www.quadbase.com/PredictiveAnalytics/

Quadbase Systems is pleased to announce the release of version 7.0 update 7 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 7:

• Updated POI library to 4.0.1.
• Improved histogram chart display and user interface
• Added an option to allow probability histogram chart
• Added suggested bin number for histogram chart
• Fixed bugs in normal curve
• Added GUI for adding and removing users to ER and EC
• Added GUI for changing user password to ER and EC
• Added control lines to stack charts
• Merged several XSS security fixes from 6.6
• Fixed a WebSphere container problem
• Fixed Excel export in EspressReport
• Fixed a problem with XML parameters in QuickDesigner Reports
• Fixed a QR code problem in group footers
• Fixed an EspressReport-specific QR code rendering problem
• Fixed problems with trendlines in EspressChart
• Fixed a barcode/QR code preview problem
• Fixed a data point rendering problem in box charts
• Fixed a bug with parameter mapping with sub-reports
• And many more smaller bug fixes

Quadbase Systems is pleased to announce the release of version 7.0 update 6 of EspressChart, EspressReport, EspressDashboard, and EspressReport ES.

Changes in update 6:

• Added QR codes to reports
• Improved drilldown mapping dialog by adding Parameter to Parameter mapping
• Numerous fixes in Crosstab reports
• Fixed several LDAP issues
• Fixed several email delivery scheduler problems
• Fixed an important bug in XML data source parser
• Fixed a problem with 2-part qualified table names for MySQL data sources
• And fixed many other less important bugs

Quadbase Systems is pleased to announce the release of version 6.6 update 28 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 28:

• XSS security fixes and improvements
• Added Google Map API key option
• Fixed memory leak in report images
• Added the option to save reports with no data
• Added web start support to EC and ER
• Improved LDAP support
• Fixed problems with XML parser
• Numerous Crosstab report fixes
• Fixed a Linux specific problems with Organizer
• Numerous Chart Designer fixes
• Fixed a String drilldown problem in reports
• Fixed the data view formula builder
• Fixed multi-page PDF
• Fixed a parameter problem - parameters with brackets didn't work properly
• Fixed database column aliases
• Fixed a date date type problem in parameter auto complete
• Fixed URLs for charts with drilldowns
• Fixed report line and rectangle rendering issues
• Removed unused internationalization options
• Fixed a SQL query parsing problem in queries with IFNULL functions
• And fixed many other less important bugs

Quadbase Systems is pleased to announce the release of version 7.0 update 5 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 5:

• Improved internationalization
  • Added translation support to QuickDesigner Reports
  • Added translation support to DataSource Manager in all QuickDesigners
  • Added translation support to many dialogs in the rest of the products
  • Fixed several translation bugs in all products
• Added "Google API Key" option to Online Maps
• Fixed a data order bug in summary break reports
• Do not show new QuickDesigner reports in the old QuickDesigner web application
• Fixed report rectangle export problems in PDF
• Fixed many other bugs

Quadbase Systems is pleased to announce the release of version 7.0 update 4 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 4:

• XSS implementation and fixes
• JNDI Datasource fixes
• Export:
• Excel Streaming feature to improve large report export experience; 
• PDF multi-page
• Dashboard:
• Memory leak;
• loading issue when report/chart file name has char of "()";
• QD report loading issue in dashboard; unpacked dashboard display issue;
• Calendar cannot be closed after removing shared parameters range panel;
• Auto-refresh interval 5 seconds doesn't work
• Crosstab report:
• crosstab drilldown;
• scripting;
• blocked cut&paste/drag&drop fields to crosstab sections;
• added an option to allow user keep column order in Data Mapping dialog
• QuickDesigner dataview builder:
• layout;
• parameterized query;
• spaces are displayed as "%20" when resetting column alias;
• warning message and error handling for QD dataview formula builder;
• column description
• QuickDesigner report:
• Refresh in QD Reports doesn't work;
• calculator formula date value doesn't follow Custom Date Format;
• Cannot drag and drop columns after resizing the last column of the report; 
• Data + format XML report export doesn't work due to a parsing error
• Chart Designer:
• line style issue of Trendline, Horizontal line, and Control line;
• null value handling in control line functions;
• stackcol/stackbar primary label;
• control range in dail chart;
• 2D overlay chart with multiple axes - couldn't change the color of additional axes;
• Log value on the y-axis;
• auto scale step option
• Datasource Manager:
• dataview "View" button doesn't show the changes made from QD dataview builder;
• COPY database node; Issue with DB view locking
• Report Designer:
• "use saved data" option should not connect datasource for subreports;
• logger exception
• Published Files:
• Set Date Variable dialog missing background and button style;
• unparseable date when changing param values
• Query:
• no data returned when parameter value contains " (" ;
• bugs when mysql/mssql table name has whitespace;
• subquery
• Internationalization:
• removed unused options;
• added support for js fiels translation
• Generated URL:
• URLs generated for charts with drilldown don't work ;
• PNG compression when generating URLs;
• Generated URL not for current user doesn't open the desired dashboard
• ERESOrganizer Batch File:
• Fixed ERESOrganizer.sh
• Increased memory setting in ERESOrganizer.bat/sh
• Maps:
• errors when open svg map example - SeatingPlan ;
• Cannot set different font for Online Map title on Linux;
• Cannot use an online map in dashboard
• Scheduler: doesn't send an email
• API:   setAllDatabaseInfo if report has chart in drilldown report
• ERES Home Page:  Upload Files
• Database Conversion for Oracle to MySQL
• Update jars: weld-servlet.jar, Redshift JDBC Driver jar

Santa Clara, CA, February 2018 - We are excited to announce the support of Linux container. Currently the container images supported are for EspressReport ES (ERES) running on Redhat and Ubuntu.

To learn more about the offering, please visit the following link.

http://www.quadbase.com/Container/

Quadbase Systems is pleased to announce the release of version 7.0 update 2 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 2:

• sound alerts feature in dashboards
• alert popup messages feature in dashboards
• "save report with no saved data" feature in Report Designer
• added 3D chart axis scaling to the QuickDesigner Charts
• improved LDAP compatibility
• implemented Java Web Start technology to launch EspressReport and EspressChart deployed in Tomcat
• fix a cross-site scripting security problem in report viewer
• fixed a problem with multi-value parameters with BigInteger data type
• fixed several GUI bugs in responsive dashboards
• ... and some more bug fixes

Santa Clara, CA-October, 2016 - Quadbase Systems, Inc. is excited to announce the availability of version 7.0 of EspressReport ES, EspressDashboard, EspressReport and EspressChart.
Press Releases

Quadbase Systems is pleased to announce the release of version 6.6 update 27 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 27:

• use less strict data type comparison when setting formula parameters
• handle newlines correctly when converting label to formula
• improve font size calculations in Excel export
• fix problem with opening parameter dropdown on Java 8
• fix problem with invalid formula value in Excel export
• fix backward incompatibility in XML data source
• fix problem when report cell format could be lost
• fix problem with when 3D pie chart changed position if it was exported several times
• fix problem when parameter dialog couldn't be displayed when creating parameter set for schedule job
• fix problem with transparent image background in exported PDF
• fix problems with map to dashboard drilldown
• fix parameter sharing issues
• ... and some more bug fixes

Quadbase Systems is pleased to announce the release of version 6.6 update 26 of EspressChart, EspressReport, EspressDashboard and EspressReport ES.

Changes in update 26:

• allow using parameters mapped to SQL Result Sets in parameter sequence in dashboards
• allow adding extra HTTP headers to EMSMessageServlet requests (API only)
• fix problem with missing data in XML data source
• fix problem with refreshing parameter ranges in dashboards
• fix incorrect title of overwrite coordinates file dialog
• fix problem with black background on transparent images in PDF export
• fix problem when script tried to access database even if backup data should be used
• fix problem with default query condition in QuickDesigner on Wildfly application server
• ... and some more bug fixes