v2019.2 Release Notes

Release 46

2021-11-24

Issues Fixed

Fixed an issue where creating an Advanced Report Group section on a Data Object and another Group section on a formula with the previous Data Object in it caused an error
Fixed an issue with the Report Viewer's Interactive Dock Sorts module not sorting the report data when the environment included a Remote Execution server
Fixed an issue where the session would time out if the first tile added to a new Dashboard were an Advanced Report referencing a Custom SQL Object with the IfExistReportDataObject Data Object Macro included in the code
Fixed an issue where a Linked Report would return a No Data Qualified message if the link was in a Report Footer section
Fixed an issue where opening a report for editing that was already open in another Report Designer tab would open the Designer with the View Data Objects option on the Main Menu disabled

Release 45

2021-11-04

Issues Fixed

Fixed an issue with Automatic Database Discovery failing to add Data Objects and Joins when the Data Source contains tables with the same name but different schemas and there is a join between those tables
Fixed an issue with the Report Viewer's Interactive Dock Sorts module not sorting the report data when the environment included a Remote Execution server
Fixed an issue where the a This cell references a cell that does not exist. message would appear in a cell even after adding data to the referenced cell in the Report Designer
Fixed an issue were Advanced Report Design Grid columns are added in the wrong location if an additional Category was added to the report right before adding the column to the Design Grid
Fixed an issue with ExpressView filters with the In Between operator showing an error message if the second value of the set included a Filter Function
Fixed an issue where the Dashboard Filter Item Detail popup would overflow the window making some controls inaccessible if the window size was too small
Fixed an issue where a cell reference that refers to a cell in a Repeating Group with an aggregate in it would cause an error message to be displayed

Release 44

2021-10-14

Issues Fixed

Fixed an issue causing degradation of report execution performance after the system being under load for several hours
Fixed an issue where the time portion of a DateTime would always display as 12:00 AM in an Advanced Report
Fixed an issue where text could not be copied from the tiles of a Dashboard

Release 43

2021-09-29

Issues Fixed

Fixed an issue where an error message would be displayed and the application would not load when Exago was deployed on a Linux server and Remote Execution was enabled

Release 42

2021-09-24

Features Added

Replaced the Automatic Database Discovery Tool icon in the Admin Console, to make it more descriptive of its function.

Issues Fixed

Fixed an issue that prevented the use of an apostrophe in a Column Alias.
Fixed an issue where a Data Object's folder location was not saved completely when exporting an ExpressView to an Advanced Report, so the Data Objects in the Advanced Report may appear to be from a different folder than the intended one.
Fixed an issue with SQL generation when calling a database function in a PostgreSQL Data Source that caused an error message to be displayed
Fixed an issue for Apache users where the environment would lock up entirely if the first report executed after system startup was a Dashboard

Release 41

2021-09-03

Features Added

Added new language file element DashboardVizChartTypeLbl to translate the Chart Type label in the Dashboard Designer

Issues Fixed

Fixed an issue where parenthesis indicating filter precedence were removed from the generated SQL when Admin Console > General > Database Settings > Convert Formula Filters and Sorts to SQL is set to True
Fixed an issue where an ExpressView chart that does not have a subtitle would have the subtitle enabled with a value of null when the ExpressView was converted to an Advanced Report
Fixed an issue where the Group Totals and Report Totals label formatting was lost when exporting an ExpressView to a PDF or Excel file
Fixed an issue where cell formatting was not applied correctly if a cell contained a conditional function in it

Release 40

2021-08-13

Features Added

Added language file translations for the different function categories in the ExpressView Designer formula builder

Issues Fixed

Fixed an issue with incorrect number formatting when German or French-Canadian culture settings are applied
Fixed an issue where collated Chained Reports would incorrectly attempt in-database aggregation which caused incorrect results in the report
Fixed an issue where a PDF tab in the Web Application user interface would have no content after switching back to the PDF from another tab
Fixed an issue where report execution would fail with an error message if a DateDiff() function was included inside a DateAdd() function with Formula to SQL enabled and the formula is being executed in a PostgreSQL Data Source

Release 39

2021-07-22

Features Added

Added a new Licenses directory to the Web Application that includes third party package licenses

Issues Fixed

Increased performance when exporting a report with a document template with more than 500 form fields
Fixed an issue where filter fields that are not directly joinable to the fields on an ExpressView tile on a Dashboard could be added, causing an error message to appear when Admin Console > General > Feature/UI Settings > Fields Enabled in Data Fields Tree is set to Direct joins only
Fixed an issue where tooltips for cells with cell references in Repeating Group sections would show the wrong cell content
Fixed an issue where incorrect SQL was generated when joining a vertical table to a standard database table
Fixed an issue with HTML Tag Sanitization where JavaScript code that was contained in a Filter Dropdown Object or Parameter Dropdown Object would be executed regardless of tag filterting strategy

Release 38

2021-07-12

Issues Fixed

Fixed an issue where report execution would hang if there are long formulas that reference other cells with long formulas on the report

Release 37

2021-07-01

Features Added

Added additional context help sensitivity points for the Dashboard and ExpressView Designers

Issues Fixed

Fixed an issue where a vertical table transform would generate invalid SQL if a vertical column name included an apostrophe
Fixed an issue where Page Breaks were not being applied to the first Group Header or Group Footer section on the first page of an Advanced Report as expected
Fixed an issue where a the Detail section of a report would not fill the length of the page if it included a hyperlink
Fixed an issue where errors would appear when adding tiles to the canvas of a Dashboard it the Designer was started with the EditReport API Action

Release 36

2021-06-10

Issues Fixed

Fixed an issue where an Execution Cache would be removed from a report if the caching update failed
Fixed an issue where temporary files are not cleared from a Temp Cloud Service
Fixed an issue where the Data Objects Pane would be inadvertently disabled when opening an Advanced Report for editing from the Report Tree that is already open in another Report Designer tab

Release 35

2021-05-21

Features Added

Changed handling of null values as argument inputs to many of the Date functions. If any of the arguments of the affected functions is null, the function will return null instead of an error message in the cell.

Issues Fixed

Fixed an issue where requests for vertical table schema were being passed to the Data Source even when the Schema Access Type is set to Metadata
Fixed an issue where the regular expression parsing engine would sometimes timeout for very large or complex formulas when executing reports with Remote Execution
Fixed an issue where CrossTab reports were appearing off-center in the Report Viewer and a JavaScript console error would be logged
Fixed an issue where unhiding a hidden column in the Report Viewer caused the column to shrink in width
Fixed an issue where the filter operator would not change when converting a formula filter to a conditional formula filter therefore causing a No Data Qualified condition when the report was executed
Fixed an issue where the Parameters dropdown for a report in the Chained Report wizard would offer no values to choose from
Fixed an issue where the column headers in the Report Viewer are too narrow and appear on top of each other if clicking to another tab while the report is executing
Fixed an issue where the font size and horizontal alignment styling attributes were not being applied to Dashboard interactive filter tiles
Fixed an issue with Dates and DateTime interactive Advanced Report filters causing exports to fail when the interactive filter has the same value as one of the standard filters on the report

Release 34

2021-04-30

Features Added

Execution time for certain CSV exports decreased by up to 41%

Issues Fixed

Fixed an issue where a report would fail to execute if it included a link to a child report on a field being aggregated in the database and the child report was linked on a field that doesn't appear on the report itself
Fixed an issue where the Test email button in the Schedule Report Wizard would throw an error message when scheduling an ExpressView
Fixed an issue with the processing of the SecurityToken when securing cookieless sessions
Adjusted the point where the Settings are processed to allow the OnConfigLoadEnd Server Event to see all changes to the Settings as expected
Fixed an issue what would cause an infinite loop in the execution engine if a formula with unbalanced parenthesis or brackets appeared on a report
Fixed an issue where a report would be truncated to the Row Limit Step Size when a User Report was saved
Fixed an issue where Vertical Tables were not considering the Data Type column in a Data Object's Column Metadata as expected
Dashboard Advanced Filters now utilize the Data Object ID and Column Name instead of the Alias
Fixed an issue with the loading of cached PageInfo objects
Fixed incorrect 1000 Separator character handling in ExpressView
Fixed an issue causing inconsistent behavior of Dashboard interactive filters with the Is Between operator on date columns

Release 33

2021-04-16

Issues Fixed

Fixed an issue that caused all scheduled jobs to be canceled after 60 seconds of execution time

Release 32

2021-04-08

Features Added

Improved error messaging when a report times out by reaching the Max Report Execution Time (minutes) limit
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

Issues Fixed

Fixed an issue where the prompting parameter dropdown would open at the top of the list instead of near any entered search value
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 inconsistent application of the AggCount() function when included in Group Footer sections versus Group Header sections with cell references
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 31

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

Issues Fixed

Fixed an issue where a legend would not display as expected for charts on a Dashboard
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 where conditional formatting would not be applied consistently to CrossTabs
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 with the handling of default_job_timeout and max_job_execution_minutes in the Scheduler Service
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 Infinite Scrolling would not work correctly with Remote Execution enabled
Fixed an issue where server events that reference .NET assemblies would pass previously referenced values in a static-dynamic configuration file
Fixed an issue where currency formatting was not automatically applied to currency fields in ExpressView
Fixed an issue where cell references would not work as expected in custom aggregate functions
Fixed an issue where the canvas background color would peek through on a Dashboard tile with a border
Fixed an issue where an ExpressView could not be saved if all of the export types were not selected
Fixed an issue where an unhelpful error message would be displayed when including a cell reference inside of an aggregate function and the referenced cell is also an aggregate
Fixed two issues with the Linux installer on CentOS7

Release 30

2021-03-05

Issues Fixed

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

Release 29

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
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 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
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 where data fields originating from unique Data Sources could not be added to an ExpressView if Remote Execution was enabled in the environment
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
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 that would cause the screen to go black on mobile devices when exporting an ExpressView as a PDF
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 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 cell borders are not aligned in PDF exports although they are aligned as expected in the Report Viewer
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

Release 28

2021-02-05

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 that prevented creating a scheduled report with a filter via the REST Web Service API
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 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 a potential cross-site scripting (XSS) attack through ExpressView visualization titles, sub-titles and axis labels

Release 27

2021-01-18

Issues Fixed

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

Release 26

2021-01-14

Issues Fixed

Fixed an issue where the list of Data Categories would not load in the Advanced Report Wizard in certain circumstances
Fixed an issue where filter dependency did not honor logical grouping with an OR conjunction
Corrected the tooltip description of the LoadImage() function to indicate it must be the outermost function in a report cell

Release 25

2020-12-30

Issues Fixed

Fixed an issue when executing a Dashboard containing a prompting parameter using a parameter dropdown object

Release 24

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 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 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

Release 23

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 22

2020-11-12

Issues Fixed

Fixed an issue where an error message would be displayed if a function referenced an empty cell (for example =AddSum([A4]) when cell A4 has no contents)
Fixed an issue where an error message would be displayed if AutoSum was enabled on an empty merged cell
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 appear instead of filter values when clicking on a filter dropdown for a data object attached to an ODBC data source
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 (for example WebReports.xml.enc) would not be uploaded to a cloud configuration storage repository

Release 21

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 filter originating from a Stored Procedure would not show the Filter Dropdown in the Report Designer's Filters dialog
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 issue where ExpressView content would unexpectedly disappear if a formula column's formula ended with double quotation marks
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

Release 20

2020-10-08

Issues Fixed

Fixed an issue where the ReportId of a chained report would not be included in log messages

Release 19

2020-10-02

Features Added

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 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 scroll bar 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 where comments in a Custom SQL Object could cause any subsequent SQL to also be commented and therefore not be executed
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

Release 18

2020-09-15

Features Added

Cloned data objects may now specify a unique description and a different folder than their "parent" object

Release 17

2020-09-10

Issues Fixed

Fixed an issue where the Filters tab of the ExpressView Designer Properties Pane would sometimes appear blank in some specific circumstances
Fixed an issue where the Entity.MakeUpdateable() method would not apply to cloned data objects for static/dynamic configuration environments
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 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
Fixed an issue that prevented a Dashboard visualization type (for example from pie to line) with the Tile Properties Pane

Release 16

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

Issues Fixed

Fixed an issue with Advanced Report formatting where an error message would be displayed if a report had a repeating row, a depressed 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 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 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 with imported filters in the Dashboard Designer where the name of the importing report would be listed more than once
Fixed an issue where a DateTime value that included milliseconds (for example 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 15

2020-08-04

Issues Fixed

Fixed an issue where an error message would be displayed if a wild card character (for example % was used in a preceding filter value with a "Contains" operator in a set of dependent filters

Release 14

2020-07-30

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 with interactive Dashboard filters not showing the selected Date formatting option when the input type control is a range slider
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 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 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 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 (for example 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 Advanced Report execution would hang if the report included an unusually large image (that is, 20 MB+)
Fixed an issue with the RunningSum() aggregate function not returning the expected sum value
Fixed an issue with consolidated filters on Dashboards with large numbers of existing report files where the "Affected Tiles" list would cover up the "On Execute" controls and Close button
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)

Release 13

2020-07-15

Issues Fixed

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

Release 12

2020-07-10

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.
Added Dashboards and Chained Reports to the OnReportSaveStart Server Event

Issues Fixed

Fixed an issue with the Linux installer displaying error messages about mono packages not being installed if the user opted out of installing mono with the installer
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 Top N filtering with formulas with ExpressView
Fixed an issue in the Dashboard Designer when changing a visualization tile to a Tabular visualization would load perpetually
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 an error message would be displayed when clicking on a drilldown from a chart and the chart included characters that needed to be escaped
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 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 an ExpressView that references data object columns that are no longer available could not be edited
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 REST Web Service API calls to edit column metadata would take an unusually long amount of time to complete when the Temp Path is configured for an S3 Cloud Service
Fixed an issue where quotes would be inadvertently removed from SQL when filtering on a Bit data type causing an error and report execution to stop
Fixed an issue where an error message would not be displayed if a user attempted to send a Debug Package to our Support Group through the automatic debug package submission process for an Advanced Report with a linked report on it
Fixed an issue where an error message would be logged into the Scheduler Service's log file when creating a new schedule, even though the schedule was successfully added with the Scheduler Queue implemented
Fixed an issue with GeoCharts not appearing in PDF, RTF and Excel exports when using the WkHtmlToImage rendering library

Release 11

2020-06-18

Features Added

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

Issues Fixed

Fixed some issues with text alignment in Dashboard Interactive Filter tiles
Fixed an issue in Advanced Report Designer what would cause the the design grid to re-arrange if a Category was added or removed
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 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 that could cause an error message when saving a Dashboard when using Folder Management for content storage if Enable Reports Tree Drag And Drop is False in the Admin Console
Fixed an issue preventing Data Objects from being created if the Data Source contained a column of Geometry data type
Fixed an issue where an error message would be displayed if a formula sort included fields from two different data sources
Fixed an issue where an error message appears preventing a report from being edited if one or more data objects contained on the report are no longer available
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 Dashboard Visualizations whose Color setting was set to Linear Range wouldn't apply the colors in a gradient as expected
Fixed an typographical error in the "Flush Schedules" confirmation dialog
Fixed an issue where an error message would be displayed 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.

Release 10

2020-06-09

Issues Fixed

Fixed an issue where BIT literals were not being properly quoted when generating SQL for PostgreSQL Data Sources

Release 9

2020-05-29

Features Added

Changed user interface cues in the Dashboard Designer when moving an interactive filter on the canvas back to the Filters menu on the toolbar
Improved performance running Advanced and Express Reports on Linux by changing to a different JSON deserialization library

Issues Fixed

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 would show an error message if a blank Group was moved to the top of the list of Groups when building a visualization tile
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 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 the Puppeteer library would fail to lunch in certain circumstances when Exago was running in an Docker container
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 in the Dashboard Designer that would show an error message if a blank Group in a visualization tile was moved to the top of the list of Groups
Fixed an issue with Google Maps visualizations that prevented more than one label to be added
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 Linux Installer not installing Chromium dependencies as expected
Included additional information on the use of the Hyperlink() function in other functions and formulas

Release 8

2020-05-07

Features Added

Added All checkbox and Direction dropdown to the Top N Filters dialog, enabling easy Top N aggregate filtering/sorting
Added a new ExagoApi constructor to the JavaScript API to provide an OnError() callback function
The OnExecuteReport Action Event now supports Promises

Issues Fixed

Fixed an issue where the user interface would not fully load when FIPS encryption was used
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 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 prompting filters on chained reports would not display the filter title from the component reports
Fixed an issue where adding an ExpressView existing report tile would disable the Refresh icon in the Dashboard Designer
Fixed an issue where disabled checkboxes that were checked appeared as if they were not checked
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 In-Database Aggregation would fail when there was an in-memory filter such as a formula filter
Fixed an issue where schedules created on weekends would be pushed to start on Monday with a weekday recurrence pattern
Fixed an issue where some vertical table integrations that use the DataType enumeration were broken
Fixed an issue loading images on the Getting Started tab when accessing Exago with the JavaScript API

Release 7

2020-04-16

Issues Fixed

Fixed an issue where scheduled Dashboards would not include all Dashboard tiles in the resulting output file
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 an issue preventing the ExcelFormula() function from working
Fixed an issue where Microsoft Excel exports would fail in certain circumstances when Exago is running on Linux
Fixed an issue where an Advanced Report with a chart in the Report Footer section using an aggregate in the Group Header section would throw an error when the report was run
Fixed an issue where document templates including the RepeatForEach feature would throw a stack trace when exported as RTF
Fixed an issue where linking to a child report that returns "No Data Qualified" and the "No Data Qualified Display Mode" was set to "Show Message", the child report would hang and never display the "No Data Qualified" message
Fixed an issue where Dashboards containing at least one interactive filter with a formula would display an "Undefined" error message when it was opened in the Dashboard Designer
Fixed an issue where Dashboard interactive filter tiles with vertically aligned checkboxes would not line up correctly
Fixed an issue where the hidden flag to select a default ExpressView theme would not be honored in either a static or dynamic configuration file
Fixed an issue where the SortsResource property of the Report object in the REST Web Service API's Session endpoint would return "null" regardless if sorts are defined on the report or not
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 where Category aliases would appear in the Advanced Report Wizard's list of Categories
Added a missing language element for "JobStatus Removed"
Fixed an issue with the AggDistinctCount() function where "null" values would not be counted even if the "includeNulls" argument was passed as true
Fixed an issue where SameSite=None support would not work as expected when there is a proxy between the user and Exago and the connection between Exago and the proxy is not encrypted

Release 6

2020-03-27

Issues Fixed

Fixed an issue where charts whose data values came from aggregates in group header sections would show 0 instead of the value
Fixed an issue where filter dependencies with grouped filters would show the wrong values in Simple Filter window dropdowns
Fixed an issue where exporting reports to PDF via the REST interface with showTabs = false would display a message dialog instead of the Report Viewer as expected
Fixed an issue where images in PDF exports might not appear under very specific sizing conditions
Fixed an issue with Dashboard visualizations showing an error message if a data object's alias contained an apostrophe
Fixed an issue where the Number Formatting options on Scatter and Bubble Charts would only apply to Y-axis values
Fixed an issue where the background color could not be seen on interactive filter tiles on Dashboards when the selector type was a dropdown control
Fixed an issue where linking from an Advanced Report to a Dashboard would execute the Dashboard's component reports and visualizations twice
Fixed an issue where executing or editing an ExpressView that included a column whose column metadata visible attribute was set to false would cause a JavaScript error in the browser console
Fixed an issue where Dashboard visualizations would have a blank file name when exported
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 with compatibility of Mono versions 5.18 and higher
Fixed a potential man-in-the-middle attack vector in the CrossTab Report Designer
Fixed an issue where the email subject or body text would not be updated when setting them in the OnScheduledReportExecuteStart Server Event
Fixed an issue where extra columns would be added in scheduled ExpressViews exported as Excel Workbooks or CSV files
Fixed an issue where filter value dropdowns would not appear in the Prompting Filter dialog when a Chained Report was executed
Fixed an issue where row-based multi-series charts would not sort by report order as expected
Fixed an issue where the Scheduler Service was saving the wrong time in its job working files which may cause a time zone conversion problem

Release 5

2020-03-06

Issues Fixed

Fixed a potential man-in-the-middle attack vector in the CrossTab Report Designer
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 tiles may overlap when using the Tile Stretch (Shift + Click) feature
Fixed an issue where ExpressView visualizations containing a formula column would show an error message when exported as a PDF file
Fixed an issue where reports with a "Top N Filter" and another filter would not sort correctly
Fixed an issue where filtering on Boolean data type columns in Stored Procedure Data Objects would cause an error
Fixed an issue where filters were not properly being applied to Chained Reports even though the expected output would be produced when the component reports were run individually
Fixed an issue where Existing Report tiles with an ExpressView that returns No Data Qualified will show a blank tile
Fixed an issue with the Monitoring Service that would cause an error message if not using cookieless sessions
Fixed an issue where Join Weights were not being honored correctly
Fixed an issue where the prompting Parameter dialog in the Dashboard Viewer would show the full file system report path when running in a Linux environment
Fixed an issue with interactive filters in the Advanced Report Viewer where the orientation of displayed filter values would change from vertical to horizontal when scrolled
Fixed an issue with filter tiles in the Dashboard Viewer would scroll horizontally even when vertical scrolling was selected
Fixed an issue with the DELETE method in Batch REST Web Service API calls where a success would return HTTP status code 200 instead of HTTP status code 204
Fixed an issue with the GET method in Batch REST Web Service API calls on Role Property endpoints where extra metadata would be returned along with the expected payload

Release 4

2020-03-05

Features Added

Added "Test email" button to the Schedule Report Wizard. This allows email message output to be sent to alternative test recipients before finalizing the schedule in the application

Release 3

2020-03-03

Issues Fixed

Fixed an issue where row level multi-tenancy filters (Role filters) were broken if data objects were cloned

Release 1

2020-02-13

Features Added

New Linux installer with additional wizard options and silent installation parameters
Changed handling of links in theme style sheets from client-side to server-side to improve performance with the JavaScript API
Improved thread safety around the theme cache

Issues Fixed

Fixed an issue where malformed SQL could be produced when using the simple filter window on a report with no sorts defined and the Admin Console > Database Settings > Row Limit Step Size setting is greater than 0
Fixed an issue where changes made to custom joins in the Advanced Report Designer would be lost after closing the Categories dialog
Fixed an issue where a row level tenancy filter applied to two cloned data objects joined together could cause an error if the column alias is part of the filter
Fixed an issue where the Scheduler Service would not release the communication port when the process was ended
Fixed an issue where the Simple Filter Window would produce different SQL than the Full Filter Window when using filter dependencies
Fixed an issue where a report with both a horizontally merged cell and a page break in the same section could cause an error when exporting to PDF
Fixed an issue with incorrect cell text color being applied to exported Excel files under certain conditions
Fixed an issue where a report with both prompting and unprompting filters could cause changes to the AND/OR operator to not take effect
Fixed an issue where an error would be displayed when uploading .docx or .rtf template files
Fixed an issue where KPI visualization tiles on a Dashboard would remove their background color when the Dashboard canvas height was changed
Fixed an issue where filter values including an underscore character could throw an error if the data source is a stored procedure
Fixed an issue where scrolling upwards in a filter dropdown would show duplicate records when the data source is a stored procedure without the Programmable Object Settings implemented
Fixed an issue where Advanced Reports with multiple filters on the same field can't be added to a Dashboard
Fixed an issue where Linked Reports would not filter by the clicked value if the data source is a Stored Procedure using the Full Filter Parameter Name Programmable Object Parameter
Fixed an issue where columns would not load if their alias contained file path delimiters
Fixed an issue where reports with Group Min or Group Max filters could throw an error depending on the sort fields on the report
Fixed an issue where docked "is between" filters on a Dashboard do not get applied correctly
Fixed an issue where an error could be thrown when clicking on the Formula Editor icon while building an Interactive Filter on a Dashboard in a Dynamic configuration environment
Fixed an issue where the incorrect objId parameter was passed to assembly data sources in the Admin Console when specifying key columns, metadata or tenant columns
Fixed an issue where calling api.savedata(true) for a dynamic configuration file could produce unexpected output in the config file
Fixed an issue where an ExpressView that has no data qualified will throw a JavaScript error
Fixed an issue where data objects with aliases the same as data categories could cause them to be displayed as categories instead of objects in the Data Objects pane

Release 0

2020-01-31

We are proud to release Exago BIv2019.2!

Check out the list of new features and other changes below.

Dashboard Upgrades

The hallmark of v2019.2 is a complete re-design of our Dashboard Designer and Dashboard Viewer tools. We've made the workflow for building Dashboards simpler and more streamlined. Dashboard visualizations are now based on Advanced Reports instead of ExpressView. This means that the flexible sorting, filtering, formulas and aggregation offered by the Advanced Report Designer are now available to Dashboard Visualizations.

The Filters and Parameters menu in the Dashboard Designer has been made easier to use by grouping all content together. Filters and Parameters contained on reports with the same data field or name will automatically consolidate into a "stack". This allows a cleaner, more intuitive filtering and interaction experience in both the Dashboard Designer and Dashboard Viewer.

The Advanced Report Designer now supports drilling down (aka linking to) a Dashboard in additional to another Advanced Report. The linking filter is applied to all the tiles on the Dashboard automatically.

Report Designer Upgrades

Changes to our Report Designer will mean enhancements for both users designing reports and for those viewing and interacting with reports. The new toolbar is easier to work with and easier to see. Prompting parameters now include dropdown lists with values from the data source that can be scrolled up or down. Prompting filters with a formula can also display a dropdown list of values—taking the guesswork out of filtering! Conditional formatting with formulas allows more powerful conditional formatting. A new color picker and "sticky" headings round out enhancements to the Report Designer for an all-around better experience for all users.

A new color picker is in use throughout the application. The new color picker makes more colors available to report designers, as well as directly entering hexadecimal or decimal color codes. The bottom row of colors can show a default set of colors, can save preferred colors on a per-user basis or with extensibility, can be set by a system administrator.

Conditional formatting in cells now permits the foreground or background color to be set by a formula instead of just a static color choice.

Scheduling with the REST Web Service API

A number of REST Web Service API endpoints have been added to the application that allow developers to create, modify, view and delete schedules programmatically. Several new enumerations and constants have been added as well to accommodate this new functionality.

Custom Aggregate Functions

Just as Exago administrators can already create their own Custom Functions, administrators can now create their own Custom Aggregate Functions for aggregating data. Custom Aggregate Functions can be implemented in either C# or VB.NET directly through the Admin Console or programmatically through the .NET API. We have provided several examples of Custom Aggregate Functions in our documentation.

Also see What’s New in v2019.2 for more information regarding these features.

Other Changes

New Admin Console setting Run Aggregate Functions at Record Level by Default is set to True. This setting configures how Exago handles one-to-many relationships when an Aggregate Function is called without the recordLevel argument.
Express Report settings removed from the Admin Console
Use Sample Data for Dashboard Visualization Design setting removed from the Admin Console
Prompting Parameters with dropdowns allow you to scroll above the currently selected value
If Remote Execution is enabled, the GetExecute() API methods can now use the remote execution servers for report generation

Issues Fixed

Fixed an issue where filter dropdowns on a Dashboard using a formula with a report-level parameter would display an error message
Fixed an issue where Dashboards and ExpressViews could not be created if the configuration contained a File Data Source but the path did not exist to the file
Fixed an issue where disabling the Google Maps wizard would disable the Geochart wizard instead
Fixed an issue where values of 0 or less for SpecificEveryNMonths and RelativeEveryNMonths in the Scheduler would cause an infantile loop
Fixed several Action Event user interface IDs that did not respond in the Advanced Report Designer to click events
Fixed an issue where setting the Custom Function "Prevent In-Database Grouping When Included in Detail Section" setting was not being honored
Fixed an issue where Top N filters for groups would not work
Fixed an issue where prompting filters on reports contained in a Chained Report would be persist between openings of the Filters dialog
Fixed an issue where "Select All Objects" and then "Add Objects" with incomplete objects in the Automatic Database Discovery dialog would not automatically change to the Incomplete Objects tab
Fixed an issue where Formula Interactive filters were not being passed through to linked reports
Fixed an issue where an interactive Dashboard filter that used a formula would remove the dropdown arrow after a value was selected
Fixed an issue that incorrectly left the "Save as Advanced Report" and "Open in Designer" tile menu options available when "api.ShowTabs = false" and the Dashboard Viewer was launched via the API"
Fixed an issue where filter dependencies were not being honored between prompting and non-prompting filters
Fixed an issue where choosing a value from a dropdown would be overriden by a previously typed value for Parameters in the Dashboard Viewer
Fixed an issue where values in Dashboard docked interactive filter dropdowns could come from data objects not included on a report if that data object is included on another report on the same Dashboard