Release 15

2021-04-08

Features Added

• Added the thread ID to log files on Linux
• Changed the way interactive filter controls appear when there is only a single choice for the filter
• Changed the way the Exago-provided Storage Management assembly is loaded so that if the path in the Admin Console's Storage Management Assembly Location field is inaccessible, Exago will now default to the internal Storage Management implementation instead of displaying an error message

Issues Fixed

• Fixed an issue where an error message would be displayed when including a custom column in a Group Footer section on a report with no Detail section
• Fixed an issue where the prompting parameter dropdown would open at the top of the list instead of near any entered search value
• Improved error messaging when a report times out by reaching the Max Report Execution Time (minutes) limit
• Fixed an issue with handling @Parameter.Value@ and @Parameter.DisplayValue@ in the formula editors and formula bar
• Fixed an issue with unexpected SQL generation when data fields with similar names are included on a report and role level filtering is active
• Fixed an issue with SQL generation when advanced joining tables from two different Data Sources
• Fixed inconsistent application of the AggCount() function when included in Group Footer sections versus Group Header sections with cell references
• Fixed an issue where an Advanced Report filter that was changed to Prompt for Value in the Filters dialog would not appear in the Dashboard Designer's Filters menu if the report is included on a Dashboard
• Fixed an issue where re-ordering the Groups or Values for a Dashboard visualization tile would not display those changes in the tile
• Fixed an issue where an error message would be displayed if a cloned data object was included on a report and the original data object had column tenancy applied to it
• Fixed an issue where only one User Report would be actually be removed even if deleting all of them from the User Preferences dialog

Release 14

2021-03-18

Features Added

• Added new smtp_timeout setting to the Scheduler Service configuration file
• Updated the Snowflake CData driver to version 20.0.7739.0
• Update the Redshift CData driver to 20.0.7654.0

Issues Fixed

• Fixed an issue where a legend would not display as expected for charts on a Dashboard
• Fixed an issue where conditional formatting would not be applied consistently to CrossTabs
• Fixed an issue with Performance Logging where the "Exit" line for a Chained Report would appear before any of the component reports had been executed
• Fixed an issue where an error message would be displayed when trying to open a recently saved Dashboard with a visualization tile
• Fixed an issue where an error message would be inadvertently displayed to users when executing an ExpressView and that user does not have permission to edit that ExpressView
• Fixed an issue with Dashboard tile contents resizing incorrectly when closing the Report Tree/Main Menu
• Fixed an issue where an ExpressView could not be filtered on a custom column
• Fixed an issue where a "Name already exists" error message appears when renaming a report but providing the same name instead of cancelling the rename operation
• Fixed an issue with the handling of default_job_timeout and max_job_execution_minutes in the Scheduler Service
• Fixed an issue where Infinite Scrolling would not work correctly with Remote Execution enabled
• Fixed an issue where charts would display an error message if the data referenced in the chart is in a group header section and the chart is in the group footer section
• Fixed an issue where the total page count would not automatically update as expected in the Report Viewer toolbar
• Fixed an issue where currency formatting was not automatically applied to currency fields in ExpressView
• Fixed an issue where the canvas background color would peek through on a Dashboard tile with a border
• Fixed an issue where exporting a Dashboard to PDF when strong>Admin Console > General > Feature/UI Settings > Save on Report Execution is True would cause an error message
• Fixed an issue where the status of the Shadow checkbox in the Dashboard Designer would not be saved as expected
• Fixed an issue where an ExpressView could not be saved if all of the export types were not selected
• Fixed two issues with the Linux installer on CentOS7
• Fixed an issue in the Admin Console where clicking Apply twice in rapid succession might cause an error about duplicate objects or settings that already exist
• Fixed an issue where server events that reference .NET assemblies would pass previously referenced values in a static-dynamic configuration file

Release 13

2021-02-25

Features Added

• Added capability to support multiple embedder origins in Cross-Origin Resource Sharing environments. Added two new Applications Settings nodes: AccessControlAllowCredentials and CorsAllowedOrigins
• Including custom columns on a report no longer disqualifies it from Database Aggregation
• Added support for Database Aggregation on Elasticsearch Data Sources
• Added the /rest/schedulesv2 endpoints, to replace the legacy /rest/schedules/ endpoints
• The Linux installer will now install Mono version 6.8 when requested during the installation process

Issues Fixed

• Fixed an issue where clicking parameter value dropdown for a report-level Boolean parameter would cause a JavaScript console error
• Fixed an issue where visualization tiles on Dashboards would not load as expected or display an error when Admin Console > General > Feature/UI Settings > Fields Enabled in Data Fields Tree is set to Direct joins only
• Fixed an issue where an error message would appear if using the AutoSum feature in a Report Footer section and Admin Console > General > Database Settings > Aggregate and Group in Database is set to True
• Fixed an issue where the ExpressView Save dialog would erroneously say the report was blank and could not be saved if it contained a Data Object with a special character in its name
• Fixed an issue where the report ID of the last report in the chain instead of the report ID of the Chained Report itself would appear in performance logs
• Fixed an issue where visualizations in an Existing Advanced Report tile on a Dashboard would undesirably resize if the Dashboard was loading in another tab than the one currently in focus
• Increased the number of file watchers on Linux when using Mono versions greater than 5.14 to improve performance
• Fixed an issue where the Now() function would always return 12:00 AM when used on an ExpressView
• Fixed an issue where the DateAdd() function would add or subtract days, not weeks when passing w as the value of the Interval argument
• Fixed an issue with incorrect SQL generation when joining two different data sources and one of the data sources included a vertical table
• Fixed an issue with visualization creation on an ExpressView that has three or more groups
• Fixed an issue where non-numeric totals would be included when initially creating an ExpressView visualization
• Fixed an issue where a confusing error message would be displayed when attempting to sort an Advanced Report on a custom column
• Fixed an issue where a data field of type bit being included in a Group Footer section from the same Data Object as the group by field caused SQL generation errors
• Fixed an issue where a Dashboard tile's Tile Menu would be cut off if Exago was embedded with the JavaScript API and the containing browser window was smaller than full screen
• Fixed an issue where the OnReportExecuteInit Server Event would not be triggered for scheduled report executions
• Fixed an issue where an error message would be displayed, and an incorrect value would be displayed when including a Custom SQL Data Object on a report with a parameter in the SQL statement that references a Parameter Dropdown Object
• Fixed an issue where a Dashboard Visualization tile's Save as Advanced Report Tile Menu option would not respect the Admin Console > General > Feature/UI Settings > Allow Creation/Editing of Advanced Reports setting
• Fixed an issue where the join relation type would not be properly restored when clicking the Recreate icon in the Report Designer Joins dialog
• Fixed an issue that would cause the screen to go black on mobile devices when exporting an ExpressView as a PDF
• Fixed an issue that would cause an error message to be displayed when filtering on a formula that includes the Or() function
• Fixed an issue where changing a Data Object's Alias would break filter formulas
• Fixed an issue where a report's Setup Data would appear unexpectedly throughout the body of a report if General Options &gt Include Setup Info was set to Bottom in the Report Designer options and the report qualified for Incremental Loading
• Fixed an issue with the handling of Excel template files causing an error message in certain circumstances
• Fixed an issue where cell borders are not aligned in PDF exports although they are aligned as expected in the Report Viewer
• Fixed an issue where Group Header sections were not breaking as expected when breaking (sorting) on a formula and Admin Console > General > Database Settings > Convert Formulas to SQL is False
• Fixed an issue where the Switch() function was unable to differentiate between 0 and null
• Fixed an issue where collating a Chained Report on a custom column would display an error message
• Fixed an issue where the child report of a Linked Report relationship would not display with the correct page formatting as expected when strong>Admin Console > General > Feature/UI Settings > Linked Report Display is New Tab
• Fixed an issue where the Export Settings in the ExpressView Designer would display all possible export file types even if some had been disabled in the Admin Console
• Fixed an issue where not defining a Center series of a Heatmap visualization would render a blank preview in the Report Designer and cause a JavaScript console error

Release 12

2021-02-05

Features Added

• Added methods to the SOAP Web Service API to support interaction with the Storage Management system
• Added the -o command line parameter to the LoadReportsToDb Storage Management transitioning utility to set the command timeout

Issues Fixed

• Fixed an issue where an error message would be displayed when scheduling an ExpressView that has a formula column on it
• Fixed an issue that prevented adding a formula filter to an ExpressView in the Scheduled Report Wizard
• Fixed an issue where downloading a report definition from the Report Tree would not return the expected report XML file when Exago is running in a web-farm environment
• Fixed an issue where a Custom SQL Data Object would also be created when creating a Parameter Dropdown Custom SQL Object
• Fixed an issue where the Display Value Field of a Parameter Dropdown Object would be applied to a report on a Dashboard if the Parameter Dropdown Object had unique Display Value Field and Value Field settings and the default value was chosen in the Dashboard Viewer
• Fixed an issue where an error message would be displayed when attempting to create a report with a Report Wizard after setting the DefaultReportName property in the .NET API and then launching the user interface
• Fixed an issue where page breaks that are in suppressed rows or sections would not break the page as expected
• Fixed an issue where the list of parameters on a scheduled report that includes a Custom SQL Parameter Dropdown Object would be empty when called with the REST Web Service API
• Fixed an issue the prevented Exago from connecting to a PostgreSQL Storage Management database with the NPGSQL driver on Linux
• Fixed a potential cross-site scripting (XSS) attack through ExpressView visualization titles, sub-titles and axis labels
• Fixed an issue where the LoadReportsToDb transitioning utility would not read the OwnerID from the intermediate JSON file as expected
• Fixed an issue with the LoadReportsToDb transitioning utility that caused it to stop loading when attempting to load an invalid report

Release 11

2021-01-14

Features Added

• Added more detail to the error e-mail messages sent by the Scheduler Service. E-mails now contain the full exception stack trace, Scheduler host name, IP address, port, job ID and report ID

Issues Fixed

• Fixed an issue where the Tile Properties Pane for a visualization in the Dashboard Designer would not completely clear when the tile lost focus
• Corrected a Spanish translation in the language files when copying a folder to another with different access flags assigned to it
• Fixed an issue where the list of Data Categories would not load in the Advanced Report Wizard in certain circumstances
• Fixed an issue where the value of a prompting parameter associated with an Advanced Report on a Dashboard would not be applied when entering a new value for it
• Fixed an issue where filter dependency did not honor logical grouping with an OR conjunction
• Fixed an issue where Parameter Dropdown Objects with different unique Value Field and Display Value Fields would show an error message when included on a Dashboard
• Corrected the tooltip description of the LoadImage() function to indicate it must be the outermost function in a report cell

Other Changes

• The Storage Management Utility has been updated to v2.0.0.0. This new utility runs on Windows, Linux and Mac OSX. Facilities for adding, editing and removing the content access records are also provided.

Release 10

2020-12-24

Issues Fixed

• Fixed an issue where conditional cell formatting would not apply on a CrossTab Report if the condition formula included a data field that did not appear in the CrossTab itself
• Fixed an issue where Dashboard tiles would not refresh when changing a visualization tile to either KPI or Zoom Scatter types
• Fixed an issue where a browser console error would be logged when clicking on a Dashboard tile's Tile Menu icon in the Dashboard Viewer
• Fixed an issue creating filters in the Dashboard Designer that would removed "All" value from Filter Value dropdown if the dropdown had been scrolled past the first set of values
• Fixed an issue creating filters in the Dashboard Designer that would removed the first value from Filter Value dropdown if the dropdown had been scrolled past the first set of values
• Fixed an issue with aggregation in Group Header sections when using cell references referring to other Group sections
• Fixed an issue that caused an error message to appear when saving a Dashboard with a new visualization tile on it
• Fixed an issue where the column names displayed in the Report Viewer's Interactive Dock did not align with the columns of a CrossTab. The list of columns will no longer be displayed if the report contains a CrossTab.
• Fixed an issue that displayed an error message in cells that contained the RunningSum() function nested inside of the ExcelFormula() function. For example, =ExcelFormula(RunningSum(1))
• Fixed an issue that prevented Express Reports from being exported to Advanced Reports
• Fixed an issue that could cause an error message to occur when a report running in an environment with Cloud Temp File Storage contained a MS Word or Excel template file
• Fixed an issue where the Chart Menu would not open when clicking the icon in the Report Viewer on a mobile browser

Release 9

2020-12-08

Issues Fixed

• Fixed an issue where KPI visualizations in ExpressView would not display the correct value if the aggregate function was Sum

Release 8

2020-12-03

Features Added

• Increased performance of in-memory sorting

Issues Fixed

• Fixed an issue where only one row would be displayed on a CrossTab that was included in the Footer section of a Repeating Group on an Advanced Report
• Fixed an issue where clicking the Cancel button in a Custom SQL Object dialog would unexpectedly save any changes made in the dialog to the object
• Fixed an issue where a Top N Filter on a formula column with a custom alias/title would display the formula instead of the alias/title the next time the report was opened in the ExpressView Designer
• Fixed an issue where a Top N Filter on a formula column with a custom alias/title would not apply the Top N Filter
• Fixed an issue where the maximum Google Maps Primary Metric shading color is being applied across all regions equally until changing pages or drilling down in a region
• Fixed an issue where an error message would appear if filtering on a date field originating from an IBM DB2 or IBM Informix Data Object

Release 7

2020-11-12

Issues Fixed

• Fixed an error if you aggregate on a formula that contains the same cell reference repeated more than once
• Fixed an issue where an error message would be displayed if a function referenced an empty cell (e.g. =AddSum([A4]) when cell A4 has no contents)
• Fixed an issue with the Admin Console > General > Feature/UI Settings > Update All Application Themes button displaying an error when clicked
• Fixed an issue where an error message would appear in an ExpressView that had both a group and a detail field referencing the same field and detail rows were turned off
• Fixed an issue preventing the use of multiple parameters in report-level Custom SQL Objects
• Fixed an issue where an exception would be thrown when calling the GetExecuteData() method on a report that returned no data in an environment with Remote Execution enabled
• Fixed an issue where an error message would be displayed when executing a new Chained Report more than once
• Fixed an issue where an error message would appear instead of filter values when clicking on a filter dropdown for a data object attached to an ODBC data source
• Fixed an issue where an error message would be displayed if AutoSum was enabled on an empty merged cell
• Fixed an issue with images not loading on a report consistently with the LoadImage() function when in a Web Farm environment utilizing Amazon S3 temporary file storage
• Fixed an issue where the encrypted configuration file (e.g. WebReports.xml.enc) would not be uploaded to a cloud configuration storage repository
• Fixed an issue where the Linux installer would display error messages if it was not run from within the ./Installer directory

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 cookieless 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 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 an 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 OnRightClickReport Global 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 changing 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 supresses 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.EmbeddedReportIds property 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/Schedules endpoint
• 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.json configuration 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.DownloadFn would 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.json function 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

Note

Please 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
• Publication status Managed by Control who can edit and publish this article Admins Select who can manage this article Visible to Control who can see this article in Help Center Signed-in users (tag: download_access) Publish in section Changes affect all translations Application Installers Downloads Author Exago Development Exago Development Labels Attachments Source code 1

   

  2

  Download the Exago Installer

  3

  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 a GET entities/Fields/{FieldName} to verify
• Fixed an issue with REST Web Service API calls to GET /rest/schedules taking 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 null SortsResource property 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 includeNulls argument of the AggDistinctCount() 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.