Release 6
2020-10-22
Issues Fixed
- Fixed an issue with Conditional Formatting formulas where they would stop working if a data object referenced in the formula had its alias changed
- Fixed an issue where a prompting Filter Dropdown would not appear until the filter was removed and then re-added when the filter field originates from a Stored Procedure
- Fixed an issue where a prompting Filter Dropdown would not appear until the filter was removed and then re-added when the filter field originates from a Stored Procedure
- Fixed an issue where the ReportId of a chained report would not be included in log messages
- Fixed an issue with ExpressViews that had been converted to Advanced Reports where two cells would erroneously have the same position coordinates in the report definition file
- Fixed an issue where Advanced Report exports would fail with an error message if the report contained a link/drilldown to another report, and Exago is running in a Docker container
- Fixed an error with the Admin Console < Storage Management < Show Prepare Database SQL button causing an error message to be displayed
- Fixed an issue where ExpressView content would unexpectedly disappear if a formula column's formula ended with double quotation marks
- Fixed an issue where if a report has been duplicated in the Report Tree, and then subsequently deleted, the duplicate will be deleted instead leaving the original report behind
- Fixed an issue where an error message would be displayed when accessing Exago cross-origin over HTTP with cookiesless sessions turned off
- Fixed an issue where Parameter values would not be saved for Scheduled Report jobs
- Fixed an issue with the Tile Properties Pane in the Dashboard Designer not showing all of the available settings if the screen height was short
Release 5
2020-10-02
Features Added
- Added a new ReportProperties class to WebReports.Api.Reports that allows retrieving report properties without first having to load the entire report with LoadReportFromRepository()
- Added a new SourceId property to the Api.Common.ContentMetadata class that can be used to determine if a report being saved is new, being saved again or duplicated
- Cloned data objects may now specify a unique description and a different folder than their "parent" object
- Added support for ExpressView to the
GetExecute()methods - Adjusted control spacing in the Dashboard Designer filters menu to increase usability
Issues Fixed
- Fixed an issue where new API actions would fail if
DisposePage()has previously been called on a page with the JavaScript API - Fixed an issue with Excel Workbook output files generated by a
GetExecute()method displaying an error message when the file is opened - Fixed an issue where empty folders could not be deleted but would instead display a prompt requiring the folder be empty first
- Fixed an issue that prevented a formula from being used in a Group on a Dashboard Visualization
- Fixed an issue where an error message would be displayed if a a cell referenced by a widget (e.g. a chart, gauge, GeoChart, Google Map) is removed from the report and the corresponding wizard is opened
- Fixed an issue where the To Category dropdown would be obscured on the Fields tab of the Linked Report dialog if the child report was a Dashboard
- Fixed an issue where the collapsed rows icon is partially hidden in the Report Viewer if Simulate PDF is off
- Fixed an issue where a scrollbar would not appear on the ExpressView Designer's Properties Pane if its contents extended beyond the bottom of the available screen space
- Fixed an issue where an error message would be displayed executing a report when data objects of an ORACLE data source have a Custom SQL Parameter Dropdown object present
- Fixed an issue where cell references between Report Footer sections and the Footer section in the Repeating Group would cause an error message to be displayed
- Fixed an issue in the Formula Editor that prevented column aliases with a forward slash character in them from being recognized
- Fixed an issue with filter dependency for interactive Dashboard filters
- Fixed an issue with changing properties of a Parameter in the Admin Console would display an error message
- Fixed an issue where comments in a Custom SQL Object could cause any subsequent SQL to also be commented and therefore not be executed
- Fixed and issue where values on a combination chart can sometimes overlap unexpectedly
- Fixed an issue with Batch Scheduled jobs, where editing the schedule in the Schedule Manager would unexpectedly change the output file type
- Fixed an issue with the
LoadImage()function in ExpressView - Fixed an issue applying filters to MS OLAP Data Sources
Release 4
2020-09-22
Issues Fixed
- Fixed issue preventing dashboard Visualization tiles from changing type to KPI
Release 3
2020-09-10
Features Added
- Added Heatmaps as a new chart type for Advanced Reports
- Improved performance in the Dashboard Designer by removing several extraneous cases where content in tiles would refresh
- Added the ability to create new Application Themes directly in Admin Console > General > Feature/UI Settings > Application Theme Selection
Issues Fixed
- Fixed an issue where the
OnRightClickReportGlobal Action Event would not be called on custom third-party report objects added to the Report Tree - Fixed an issue where embedding with the JavaScript API and cross-origin cookies would add script headers without including the WebReportsBaseUrl property
- Fixed an issue where changing a visualization tile type on a Dashboard to Tabular by right-clicking on the visualization would cause an error message to be displayed
- Fixed an issue where the wrong value may be passed to the SQL WHERE clause when using a custom parameter dropdown object and the Value Fields is different than the Display Value Field
- Fixed an issue where the
Entity.MakeUpdateable()method would not apply to cloned data objects for static/dynamic configuration environments - Fixed an issue where an ExpressView visualization may flicker or flash when its location is changed by clicking on one of the options in the bottom-right corner
- Fixed an issue where scrolling upwards in a filter dropdown would show duplicate records when the data source is a stored procedure
- Fixed an issue where duplicate records may be displayed in a filter dropdown when dragging the scroll box of a scroll bar
- Fixed an issue where reports and visualizations on a Dashboard may not display as expected when the Dashboard is set as a Startup Report
- Added missing language file elements for some Storage Management Admin Console elements
- Fixed an issue where the entire Storage Management configuration would be copied from the parent to the child configuration in static/dynamic configuration environments
- Fixed an issue that prevented a Dashboard visualization type (e.g. from pie to line) with the Tile Properties Pane
Release 2
2020-08-20
Features Added
- Added a new Bulk Insert function for Extract-Transfer-Load (ETL) operations to Microsoft SQL Server databases
- Updated the MongoDB CDATA driver from 19.0.7202.0 to 20.0.7524.0
- Improved performance on Linux by changing to a different JSON deserialization library
- Formula-to-SQL conversion is now supported for DB2 data sources
Issues Fixed
- Fixed an issue with Advanced Report formatting where an error message would be displayed if a report had a repeating row, a suppresses row and a page break in sequential rows
- Fixed an issue where a script was too aggressively being cached which could cause some users to get outdated versions potentially leading to issues in some circumstances
- Fixed an issue where an error message would be displayed if a wildcard character (e.g.
%was used in a preceding filter value with a "Contains" operator in a set of dependent filters - Fixed an issue with the Scheduler Queue where the
QueueApiJob.JobInfo.EmbeddedReportIdsproperty was not updated when reports were added or removed from a Chained Report - Fixed an issue where clicking the "Open in Designer" option on a Dashboard Tile's Tile Menu would open the same Dashboard in the Designer instead of the requested report
- Fixed an issue that prevented the JavaScript API's DisposePage() function from properly executing if a Dashboard was present
- Fixed an issue where Arabic characters where rendering backwards in reports exported to PDF
- Fixed an issue where Advanced Reports on a Dashboard would not be filtered by interactive filters when the Dashboard was exported
- Fixed an inconsistency between Linux and Windows environments where the full report path was not returned on Linux when making REST and BATCH REST calls to the
/rest/Schedulesendpoint - Fixed an issue where a DateTime value that included milliseconds (e.g. 2020-06-01 23:59:59.999) would not be passed to the SQL WHERE clause if it were included in a custom filter function
Release 1
2020-07-30
Features Added
- The Admin Console > General > Culture Settings > Time Zone Name will now be used for all time related features, including DateTime functions such as Now(). Admin Console > General > Culture Settings > Server Time Zone Offset only applies if Time Zone Name is not set.
Issues Fixed
- Fixed an issue where a date field in the X-Axis label on a chart from a report header section would show an error when exporting a report with the WkHtmlToImage rendering engine enabled
- Fixed an issue where a chart in a Repeating Group included values that were outside of the group
- Fixed an issue with report XML data missing when creating a schedule with a Chained Report and the Scheduler Queue is implemented
- Fixed an issue with report XML data missing when renaming a schedule that would cause the old schedule name to be displayed in the Scheduler Manager when the Scheduler Queue is implemented
- Fixed an issue with imported filters in the Dashboard Designer where the name of the importing report would be listed more than once
- Fixed an issue with interactive Dashboard filters not showing the selected Date formatting option when the input type control is a range slider
- Corrected the sample
DatabaseToJson.config.jsonconfiguration file to match the schema of Exago reference example of Folder Management - Fixed an issue connecting to Oracle data sources in Linux with the Oracle.ManagedDataAccessClient driver
- Included the CloudToJson Storage Management transitioning utility which was inadvertently excluded from previous builds
- Fixed an issue with GeoCharts not appearing in PDF, RTF and Excel exports when using the WkHtmlToImage rendering library
- Fixed an issue where an error message would be displayed when adding a CrossTab to an existing Advanced Report
- Fixed an issue where a tenant column would not be honored if the configuration contained two data objects that had an identical table name and the same tenant parameter name
- Fixed an issue with the OnSaveReportSuccess Action Event being triggered when clicking the Finish button in the Advanced Report Wizard even if Admin Console > General > Feature/UI Settings > Save on Finish Press is set to False
- Fixed an issue where custom data object columns would evaluate incorrectly if one of the component column's Visible property was set to false
- Fixed an issue where a "Folder must be empty before deleting" error message would be displayed when trying to delete an already empty folder when running Exago on Linux
- Fixed an issue where Group Headers print twice if both Page Break and Repeat Row properties are set for that header
- Fixed an issue where an error message would be displayed when opening a Dashboard if it had been created in a pre-v2019.2 environment and included an ExpressView visualization with a missing data object
- Fixed an issue where Dashboard visualizations with a large number of data points could cause the browser to hang
- Fixed an issue that prevented more than 10,000 records from being retrieved from an Elasticache data source
- Fixed an issue with scheduling Dashboards with server events where
sessionInfo.Report.DownloadFnwould not point to a file that exists - Fixed an issue where font names would be duplicated in the Designer's font name dropdown after installing a particular fonts package on Linux
- Fixed an issue where the Dashboard Designer would always prompt the user to save changes even if no changes had been made
- Fixed an issue with Number Formatting choices made in the ExpressView Designer were not reflected for aggregates in ExpressView export output files
- Fixed an issue where an ExpressView that had errors on it (e.g. a missing data object) could not be duplicated
- Fixed an issue where an error would occur if a third group was added to an ExpressView with two groups and a visualization
- Fixed an issue where the ExpressView Hints could not be reset from the User Preferences dialog
- Fixed an issue where expanding and then collapsing a tile in the Dashboard Viewer could cause the tile to shrink instead of returning to the pre-expanded size
- Fixed an issue where the Tile Properties Pane in the Dashboard Designer would not always open to the Content tab when creating a new visualization tile as expected
- Fixed an issue where an Express Report with a prompting filter would not prompt for a filter value when the Run button in the Report Designer was clicked
- Fixed an issue where an error would occur if using a negative value for the second argument (the addend) of the DateAdd() function
- Fixed an issue where a DateTime value that included milliseconds (e.g. 2020-06-01 23:59:59.999) would not be passed to the SQL WHERE clause if it were included in a filter function
- Fixed an issue that required custom function names in the
dbconfigs.overrides.jsonfunction dictionary to be in all lowercase in order for them to be pushed to the data source - Fixed an issue where the Cancel button would incorrectly appear in the Report Wizard when the wizard was launched by the API (where the Cancel button is irrelevant)
- Fixed an issue where the Linux installer would not install the mono-4.0-service package on Ubuntu and Debian
- Fixed an issue where a Storage Management database would not be correctly initialized if the Party Type table was not empty
- Fixed an issue where the Font dropdown in the Advanced Report Designer would not open instantly on click
Release 0
2020-07-01
We are proud to release Exago BI v2020.1!
Check out the list of new features and other changes below.
Storage Management
Exago's Storage Management system replaces the legacy file system, cloud storage, folder management and web service (SOAP) storage methods with a relational database. All reports, templates, folders and themes are stored in this database.
As of v2020.1, all legacy storage methods are deprecated and are replaced with the Storage Management system. Storage Management enables a flexible folder and report permissions model and creates a future development platform for features such as collaboration, sharing, annotation, version control and more. All clients upgrading to v2020.1 will need to change their content storage strategy to the Storage Management system. Exago has built several handy utilities for this transitioning process.
The Storage Management system is virtually transparent to the end user, with one exception. The Owner 
icon will appear in the Report Tree if a user owns that content. Content ownership is a new concept in the Storage Management system.
Dashboard Designer Changes
Similar to the Advanced Report Designer, the Dashboard Designer toolbar now includes Undo 
and Redo 
icons. The Undo/Redo memory holds up to the last 100 actions taken in the Designer.
Some additional control is now available to Dashboard Visualizations that have multiple Groups and Values! Number Formatting options are now configurable on a per field basis rather on a per tile basis. Tabular Visualizations, Scatter Chart Visualizations and all other visualization types will now have their own number formatting user interface. Clicking on either a Group or Value for a Tabular or Scatter Chart visualization will pop up a small dialog to edit the field, aggregation, sorting and formatting individually. Number formatting options for the other visualization types remains in the same place as before—on the Style tab of the Tile Properties Pane.
Advanced Report Designer Formula Bar
A new Formula Bar has been added to the top of Advanced Report Designer. This formula bar is a new way to add content to cells. Formulas may be added by selecting a cell and then typing directly into the Formula Bar. Clicking the Formula Editor 
icon on the left side will open the standard Formula Editor dialog.
In-Database Grouping and Formula Aggregation
Exago can now push more grouping and aggregation tasks to the data source instead of performing them in-memory. This can mean noticeable gains in performance. Notably, changes made in v2020.1 if there are no other disqualifying factors that:
- Grouping on a formula, when that formula can be converted to SQL, can be done in the data source. Previously, the presence of a group header or footer on a formula would disqualify the report from in-database grouping.
- Aggregating with formula, when that formula can be converted to SQL, will be done in the database. Previously, aggregate formulas that contained a formula would disqualify it from in-database aggregation if any formula was passed as the data argument to the aggregate function.
- Aggregating on a field on the "one side" of a one-to-many join will be done in the data source if the Admin Console > General > Other Settings > Run Aggregate Functions at Record Level By Default setting is true or the recordLevel argument to the aggregate function is true. Previously, aggregating on the "one side" would disqualify from in-database aggregation regardless of the recordLevel value.
- Having multiple data sources on a report no longer automatically disqualifies it for in-database grouping
Additional Mono Support for Linux
A couple of changes around Exago on Linux have been introduced with v2020.1.0:
- Exago now supports Mono version 6.8.0.105 on Linux. The Linux installer will install this version if requested to do so on systems without Mono already installed.
- An issue was fixed that prevented the Exago Linux installer from installing Mono on CentOS 8.
- Improved performance running Advanced and Express Reports on Linux by changing to a different JSON deserialization library
- Increased verbosity during Mono installation (if elected) as an assurance the process is still working
NotePlease also review the What's New in Version 2020.1 articles for more information regarding these features.
Other Changes
- The Linux installer no longer includes an ADO.NET MySQL connector provided by Exago.
- The System.Data.OracleClient driver is no longer supported in Linux. Use Oracle.ManagedDataAccess.Client instead.
- The ExpressView exporter has been re-written to give a fresh new look that makes data easier to consume. This affects ExpressView exported as files and those saved as Advanced Reports.
- The default ExpressView theme has been updated with a fresh set of colors
- A new Getting Started page has been given a refreshing re-design.
- The new color picker (introduced in v2019.2) has been extended to the rest of the application.
- The internal FusionCharts library has been updated to version 3.15.
- The internal Log4Net library has been updated to version 2.0.6.
- The internal Puppeteer rendering library is now turned on by default.
- A new constructor has been added to the JavaScript API which adds an OnError() callback function.
- New in-memory caching for certain JavaScript files, CSS and language files. They can be served from memory without having to build and compress them repeatedly.
- Added All checkbox and Direction dropdown to the Top N Filters dialog, enabling easy Top N aggregate filtering/sorting
- Changed the default state of the Hide Detail checkbox for tabular Dashboard visualizations to checked
- Several Action Events (
OnRightClickReport, OnRenameReport, OnEditReport, OnDeleteReport, OnDuplicateReport, OnExecuteReport, OnSelectReport, OnDoubleClickReport) now support returning Promises - Relocated the Save and Close and Delete buttons in the Dashboard Designer's Filters menu, to make their location more consistent with the rest of the user interface
- Changed user interface cues in the Dashboard Designer when moving an interactive filter on the canvas back to the Filters menu on the toolbar
Issues Fixed
- Fixed an issue where all visualization tiles on a Dashboard wouldn't be included in an output file when the Dashboard was executed by a Scheduler Service
- Fixed an issue where reports with a Stored Procedure data object whose "Category" property in the configuration contained a backslash would throw an error when the report was executed
- Fixed some issues in the Dashboard Designer that would cause Visualization tiles to reload when not expected
- Fixed an issue that prevented the ExcelFormula() function from working as expected
- Fixed an issue where Microsoft Excel exports would fail in certain circumstances when Exago is running on Linux
- Fixed an issue with error messages being displayed if Mono was not installed as part of the installation process on Linux
- Fixed an issue where the user interface would not fully load when FIPS encryption was used
- Fixed an issue where Action Event code stored in the static part of the static-dynamic configuration could cause incorrect session information to be referenced.
- Fixed some issues with text alignment in Dashboard Interactive Filter tiles
- Fixed an issue where small white borders could be seen around tiles on a Dashboard with a dark canvas background color
- Fixed an issue where an error message could be displayed when a chart referenced an aggregate in a Group Header section
- Fixed an issue with filtering boolean data fields from PostgreSQL data sources
- Fixed an issue where filter dependencies do not work as expected when the report is included on a Dashboard
- Fixed an issue where a Dashboard created pre-v2018.2 could break in v2019.2+
- Fixed an issue where an error message would be displayed if three or more column headers were added to a CrossTab Report
- Fixed an issue with the Report Designer user interface that could cause the grid to unexpectedly resize after closing the Categories dialog from the Report Settings menu
- Fixed an issue that could cause an Advanced Report to show an error message if a page break occurs right after a suppressed row and a repeating row
- Fixed an issue where Group Headers would print twice if that header included a Repeat Row and a Page Break
- Fixed an issue in the Admin Console that could cause the browser to freeze if the ID of a Data Object was cleared
- Fixed an issue preventing reports containing a Gauge visualization from being exported when Exago is run on Linux
- Fixed an issue preventing reports containing a Date field on the X-axis of a chart from being exported
- Fixed an issue in the Report Viewer where right-clicking on a column and selecting Hide Column for a CrossTab Report would not hide the selected column, including on exported output
- Fixed an issue where charts appear very small in an RTF export
- Fixed an issue in the ExpressView Designer with changing the groups and values of charts from the properties pane on the right side of the screen
- Fixed an issue preventing Existing Report tiles from changing their contained report with the Content tab of the Tile Properties Pane when using custom Folder Management for report storage
- Fixed an issue where an "root element is missing" error message might be displayed when running reports in a web farm environment
- Fixed an issue where the data field with the desired color information for Conditional Formatting with a Formula had to be included in the section where the conditional formatting was applied
- Fixed an issue where an error message would be displayed when reports are executed on Remote Execution servers accessing temporary file storage hosted in the cloud
- Fixed an issue where executing a scheduled report with batch execution may return a No Data Qualified error message even though running the report returns data as expected
- Fixed an issue preventing Data Objects from being created if the Data Source contained a column of Geometry data type
- Fixed an issue where document templates including the RepeatForEach feature would display an error message when exported as RTF
- Fixed an issue where prompting filters on chained reports would not display the filter title from the component reports
- Fixed an issue with some charts not rendering correctly in PDF exports using the Puppeteer library with Exago running on Linux
- Fixed an issue where an error message would be displayed if a formula sort included fields from two different data sources
- Fixed an issue with the Monitoring Service not recording data if either the userId or companyId system parameters contained the at-sign (@) in their value
- Fixed an issue that would prevent editing or running a report that contained a data object that had been removed from the system configuration instead of showing an error message
- Fixed an issue in the Dashboard Designer where the Refresh button on the toolbar would become disabled if an Existing Report tile containing an ExpressView was added to the canvas
- Fixed an issue where the "No Data Qualified" message could not be dismissed if it appeared on a child report in a linked report relationship
- Fixed an issue with Batch REST Web Service API calls to
PATCH entities/Fields/{FieldName}where the values would actually be updated in the configuration, but would not be reflected in the return value if doing aGET entities/Fields/{FieldName}to verify - Fixed an issue with REST Web Service API calls to
GET /rest/schedulestaking significantly longer than expected when compared to making a similar request through the Web Application user interface - Fixed an issue where an error message would be displayed in the Dashboard Designer if a filter on Visualization tile contained a formula
- Fixed some issues in the Dashboard Designer that would cause Visualization tiles to reload when not expected
- Fixed an issue in the Dashboard Designer that could cause an error message to be displayed when reordering Group or Values on a visualization tile if one of the Groups or Values didn't have a field defined yet
- Fixed the look of the checkboxes when adding Custom Aggregate Functions in the Admin Console that made them difficult to determine their state
- Fixed an issue where the hidden flag
<expressviewdefaultformattheme>to select a default ExpressView theme would not be honored in either a static or dynamic configuration file - Fixed an issue where a filter applied to the right side of a Left Outer Join would still show values from the left side joined to null values
- Fixed an issue where Stored Procedure Data Objects connected to a MySQL Data Source would return all unfiltered rows if a date parameter is passed as a filter value
- Fixed an issue where aggregating in the database would fail if filtering was done in-memory
- Fixed an issue where schedules created weekends would be pushed to start on Monday with a weekday recurrence pattern
- Fixed an issue with Google Maps visualizations that prevented more than one label to be added
- Fixed an issue where some vertical table integrations that use the DataType enumeration were broken
- Fixed an issue with the automatic debug package submitter that prevented debug packages being submitted if the report contained a prompting parameter
- Fixed an issue with the embedded Roboto font not properly loading when integrating Exago with the JavaScript API
- Fixed an issue with REST Web Service API calls to where a call to any Sessions endpoint would return a
nullSortsResourceproperty even if a report has pre-existing sorts or new ones were added with the REST Web Service API - Fixed an issue where creating a child folder with the same name as a report in the parent folder could cause the new folder to take the icon of the report until the browser is refreshed
- Fixed an issue where cell formatting changes in the Advanced Report Designer may take a long time if a lot of cells are selected at once
- Fixed an issue that prevented JavaScript files from being cached when cookieless sessions is enabled
- Fixed an issue where styling applied to tooltips would be applied to client host application elements with a title attribute when implementing Exago with the JavaScript API
- Fixed an issue loading images on the Getting Started tab when accessing Exago with the JavaScript API
- Fixed an issue where Category aliases would appear in the Advanced Report Wizard's list of Categories
- Fixed an issue where an error message would be displayed is passing True to the
includeNullsargument of theAggDistinctCount()function - Fixed an issue with fetch and XHR requests to allow cookies to be set when Exago is accessed from a different origin than the host page. This was necessary to allow Exago to be embedded at a different origin without the need to turn on cookieless sessions
- Fixed an issue where an error message would appear if a user attempted to send a Debug Package to our Support Group through the automatic debug package submission process and they were submitting a Dashboard, a Chained Report, or an Advanced Report with a linked report on it.
- Fixed an issue where an error message relating to cross-origin embedding would incorrectly be displayed from the same origin if the WebEndpoint JavaScript API constructor argument contained any capital letters in the URL's origin.