v2020.1 Release Notes
Release 42-2020.1
2022-12-06
- The AR Interactive Filter value input is no longer empty after you save a value in the Date Time field
- The “DateFormatMethodString” for Postgres now uses a valid database function for Postgres v13
- Advanced report background now fills the entire tile of the dashboard
- The Scheduler <error_report_to> now sends emails to everyone on the list, not just to the last person in the list
- The Dashboard Toolbar Menu Title text now uses the correct language file, and is no longer hard coded
Release 41
2022-11-07
- You can now add custom columns without getting a non-grouping sort problem
- Dynamic filters on executed advanced reports now work properly
- Dashboard visualizations now properly fill the entire tile when the dashboard is first to run
Release 40
2022-10-05
- Updated security for Advanced reports
- Reports now display correctly when you disable pagination
- You can now use the Move Folder option for Read-only Folders
Release 39
2022-09-06
Issues Fixed
- RTF Exports now populate as you would expect
- Report exports now contain all necessary data
- Dashboard date parameters no longer allow string values that could break the dashboard's execution
- Numbers are no longer converted to Zeros when exporting a Crosstab from the HTML viewer
Release 38
2022-07-28
Issues Fixed
- PDF exports for specific expressView report structure now function properly
- You can now apply a Role filter to a Stored Procedure Data Object without getting an error
- Column header bar is no longer duplicated when you press the down arrow of the search bar twice in report viewer
Release 37
2022-07-07
Issues Fixed
- The "Is One Of/Is Not One Of" symbol now remains in the filter menu
Release 36
2022-06-06
Features Added
Better logging for AWS SKD for S3 uploads, to help with debugging issues.
Issues Fixed
- Prefix settings now work properly when you confirm operations when using the import/export storage management utility.
- You can now export special characters without experiencing problems .
- The update run count now works properly after your first execution, when you migrate to the latest version of Exago BI.
- The Boolean field in the Npgsql driver now works properly when you use the import/export storage management utility.
Release 35
2022-05-02
Features Added
- The color picker dialog suggests the previously selected element color, rather than white, when clicking the Reset button in the dialog
- Increased security around the handling of serving image files from the web server
- Added new
EncryptionKey
andEncryptionIV
tags to theAppSettings.config
file for the Web Application
Issues Fixed
- Fixed an issue where an incorrect SQL statement was constructed when executing a Linked Report with an interactive multiple choice filter and one of the values was null
- Fixed an issue where calculations with Date paramters using dd/MM/yyyy format returned an incorrect result
- Fixed an issue where Filter Functions were not evaluated for every execution of a report, only for the first execution
- Fixed an issue where clicking the X in the Data Objects Pane search field wouldn't actually clear the search value
- Fixed an issue where using the
AggSum()
function in a Repeating Group Header section returned the first value in the data set rather than the sum - Fixed an issue where a disabled Dashboard Canvas background color shows through on interactive filter tiles during execution
- Fixed an issue where no error message would be displays when opening a report with a Data Objects that has been disabled by the active Role
Release 34
2022-04-05
Features Added
- Changed the order in which jobs are sent to Scheduler Services, to first validate the connection to the Scheduler Service
Issues Fixed
- Fixed an issue where In Between filters did not apply if one of the filter values was not provided
- Fixed an issue where Conditional Formatting did not apply when in a Footer Section, Aggregate and Group in Database is True and Convert Formulas to SQL is True
- Fixed an issue where the FilterValue() function returned different output if the filter had one value or several values
- Fixed an issue where the wrong language file element was being referenced when including Setup Data at the start or end of a report that included one or more Top N Filters
- Fixed an issue where a "this cell references a cell does not exist" warning appears when the cell is on the last line of repeating group and the cell reference is actually valid
- Fixed an issue where deleting a report from the Report Tree didn't close any Designer or Report Viewer tabs that are open related to the report
Release 33
2022-03-15
Features Added
- Improved error messaging when launching a session fails
Issues Fixed
- Fixed an issue where reports grouping on non-sort fields stopped working in v2020.1.29+
- Fixed an issue where an error message would be displayed and report execution would be canceled if the @pageNumber@ parameter or PageNumber() function were included in either a Page Header or Page Footer section
- Fixed an issue where the Dashboard canvas color shows through an existing report tile after scrolling the report in the tile
Release 32
2022-02-22
Features Added
- Improved error messaging when launching a session fails
Issues Fixed
- Fixed an issue with certain in-memory filters on Assembly Data Sources compared to SQL Data Sources causing different result sets
- Fixed an isuse with Excel exports not honoring the Apply Numeric Decimal Places to General Cell Formatting Culture Setting
- Fixed an issue that prevented the use of the FitlerValue() function's third argument
- Fixed an issue with the placement of the Open Rows icon when the first few cells of a row are empty
- Fixed an issue where an existing report tile on a Dashboard could not be deleted if the report could not be loaded
- Fixed an issue where the DateAdd() function shows different output in Excel export versus the Report Viewer if cell formatting set to General and DateTime values are being treated as dates
- Fixed an issue where scrolling a visulziation's scroll bar in the Dashboard Deigner moved the tile up and down the canvas with the scrolling action
- Fixed an issue preventing a warning message from being displayed when adding or removing Data Objects from an Advanced Report that could affect the reports join configuration
- GlobalNumericFormat() is now listed in the Arithmetic and Geometric Functions category for all versions of Exago
- Fixed an issue where the Formula Editor opens behind the Column Metadata dialog when creating a custom column or a Sort-and-Group By Value
Release 31
2022-01-28
Features Added
- Added support for proxying the Storage Management assembly for environments where access to the Storage Management system outside of the domain are required
Issues Fixed
- Fixed an issue where a Pie Chart with an Other category percenter value greater than zero would show No Data to Display instead of rendering the chart
- Fixed an issue where changing the foreground color of an Express Report cell would change it to white regardless of selected color
- Fixed an issue in the Advanced Report Designer where making no changes except clicking on a cell would cause a prompt to save changes when closing the Designer
- Fixed an issue where the filter operator and value are displayed in the Report Viewer even if the filters are hidden or removed
- Fixed an issue where a scheduled Chained Report or scheduled report with an associated linked report would fail if one of the component or child reports was modified after the report had been scheduled
- Fixed an issue where Group Headers set to Repeat Header on new pages were not doing so
- Fixed an issue with the Report Viewer's Conditional Formatting dialog filter list forgetting the setting for conditionally formatted sections of the report
Release 30
2022-01-07
Issues Fixed
- Fixed an issue where a Dashboard filter with values set outside of the range of possible values from the Data Source would cause an error message to appear in the Affected Tiles
Release 29
2021-12-17
Features Added
- Log messages when a scheduled report starts execution now include the time the job is scheduled to start
- Moved Affected Tiles control to the top of the the Dashboard Filter Item Detail popup
Issues Fixed
- Fixed an issue where report schedules with a yearly recurrence pattern would be scheduled to occur on the wrong date in the future
Release 28
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
RunningSum()
function resetting for each group section when aggregating in the database and the Detail section was suppressed - 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 27
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 where an error message would be displayed and report execution would stop if an Advanced Report contains a Group and sorts on a Data Field and a formula containing the same Data Field
- Fixed an issue connecting Storage Management to a PostgreSQL database in Linux due to a missing entry in the
web.config
file - 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 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 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
- 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
Release 26
2021-10-14
Issues Fixed
- Fixed an issue where filter dependency would not work as expected on a Dashboard if the first filter utilized a prompting parameter as the value
- 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 when the Date and Time formats are configured in the Culture Settings
- Fixed an issue where invalid SQL would be generated when the linking cell of parent report in a Linked Report relationship contained a formula and the parent report's Data Objects are not joined
- Fixed an issue with the Storage Management ImportExportStorageMgmt utility throwing an error message during an Import operation to a MySQL database with the MySql.Data.MySqlClient database driver
- Fixed an issue where text could not be copied from the tiles of a Dashboard
Release 25
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 24
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 with interactive Dashboard filter range tiles on date fields that would malfunction when they had a default value set that did not exist in the Data Object
- 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 for Apache users where the environment would lock up entirely if the first report executed after system startup was a Dashboard
- 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 where an ExpressView could not be saved with a new name or description if it already had one
Release 23
2021-09-03
Features Added
- Added new language file element
DashboardVizChartTypeLbl
to translate the Chart Type label in the Dashboard Designer - Added the capability to execute a report with the report's ID instead of the report name with the JavaScript API
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 range sliders for interactive filters using the
MonthName
function would show the month names in a different order on each change of the slider's position - Fixed an issue where cell formatting was not applied correctly if a cell contained a conditional function in it
- Fixed the sorting of content in the Report Tree to give the sort order property of the Storage Management system first priority
Release 22
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 in the ExpressView Designer formula builder that would misinterpret a period in a static text string as the name of a Data Object, which would cause the report to fail
- Fixed an issue where a Chained Report filtered by a Parameter Dropdown Object with distinct Display Value and Value incorrectly passed the Display Value to the filter statement
- Fixed an issue where creating a Custom SQL Object with the same name as an existing Data Object displayed an error message in the incorrect format
- Fixed an issue with in-memory CSS caching that caused some Application Themes to be incompletely applied after restarting the web server
- 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 21
2021-07-22
Features Added
- Added a new Licenses directory to the Web Application that includes third party package licenses
Issues Fixed
- Corrected the formula to SQL translations for DateAdd() functions on PostgreSQL Data Sources
- Fixed an issue where report execution would hang if there are long formulas that reference other cells with long formulas on the report
- 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 where creating a session with a cloned data object in a dynamic configuration file whose parent is in a static configuration file would cause an error
- 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 20
2021-07-01
Features Added
- Added additional context help sensitivity points for the Dashboard and ExpressView Designers
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 with an Oracle Data Source
- Fixed an issue with the ImportExportStorageMgmt utility where Boolean columns would not be imported to a target PostgreSQL database due to a type mismatch with the Npgsql driver
- 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 an error message could appear when clicking the Save and Close button in the Chained Report Wizard
- Fixed an issue in the Schedule Report Wizard where setting up a recurrence with no end date would result in an error message being displayed and the schedule would not be created
- 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 EditReportAPI Action
Release 19
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 with the LoadReportsToDb Storage Management Transitioning Utility where using the MySql.Data.MySqlient driver caused an exception at runtime and the tables are not populated with data during an Initialize operation
- 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 18
2021-05-21
Features Added
- Storage Management databases initialization now sets the text_content field in the content table to be NTEXT type
- 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 clicking Save as Advanced Report on a visualization tile menu in the Dashboard Designer would re-open the Dashboard Designer in a new tab without the tile instead of the Advanced Report Designer
- Fixed an issue where unhiding a hidden column in the Report Viewer caused the column to shrink in width
- Fixed an issue with adding nested formulas in the Formula Editor dialog causing an argument placeholder message to appear unexpectedly
- 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 where child reports in a Linked Report relationship would appear to flicker when loading
- Abended scheduled jobs will now be flushed along with completed, and deleted jobs
- 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
- Fixed an issue where changing the filter value of an Imported Dashboard filter that shows on output would cause the report to reload, but the report would not be filtered by the new value
Release 17
2021-04-30
Features Added
- Added the ability to override the DbName for a Data Object clone in the XML configuration file
- Added a new ImportExportStorageMgmt command line utility to transitioning from one Storage Management database to another
- Execution time for certain CSV exports decreased by up to 41%
Issues Fixed
- Fixed an issue where the Heatmap Wizard would not recognize AggCount() or AggDistinctCount() as numeric series if the field being counted was not itself numeric
- 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 16
2021-04-16
Issues Fixed
- Fixed an issue that caused all scheduled jobs to be canceled after 60 seconds of execution time
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 canceling the rename operation
- Fixed an issue with the handling of
default_job_timeout
andmax_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 > 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 email messages sent by the Scheduler Service. emails 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 (for example
=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 (for example
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 (for example 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 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 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 (for example 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 suppressed 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 wild card character (for example
%
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 (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 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 (for example 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 (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 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
Please also review the What’s New in v2020.1 topic for more information regarding these features.
Other Changes
- The Linux installer no longer includes an ADO.NET MySQL connector provided by Exago.
- The System.Data.OracleClient driver is no longer supported in Linux. Use Oracle.ManagedDataAccess.Client instead.
- The ExpressView exporter has been re-written to give a fresh new look that makes data easier to consume. This affects ExpressView exported as files and those saved as Advanced Reports.
- The default ExpressView theme has been updated with a fresh set of colors
- A new Getting Started page has been given a refreshing re-design.
- The new color picker (introduced in v2019.2) has been extended to the rest of the application.
- The internal FusionCharts library has been updated to version 3.15.
- The internal Log4Net library has been updated to version 2.0.6.
- The internal Puppeteer rendering library is now turned on by default.
- A new constructor has been added to the JavaScript API which adds an OnError() callback function.
- New in-memory caching for certain JavaScript files, CSS and language files. They can be served from memory without having to build and compress them repeatedly.
- Added All checkbox and Direction dropdown to the Top N Filters dialog, enabling easy Top N aggregate filtering/sorting
- Changed the default state of the Hide Detail checkbox for tabular Dashboard visualizations to checked
- Several Action Events (
OnRightClickReport, OnRenameReport, OnEditReport, OnDeleteReport, OnDuplicateReport, OnExecuteReport, OnSelectReport, OnDoubleClickReport
) now support returning Promises - Relocated the Save and Close and Delete buttons in the Dashboard Designer's Filters menu, to make their location more consistent with the rest of the user interface
- Changed user interface cues in the Dashboard Designer when moving an interactive filter on the canvas back to the Filters menu on the toolbar
Issues Fixed
- Fixed an issue where all visualization tiles on a Dashboard wouldn't be included in an output file when the Dashboard was executed by a Scheduler Service
- Fixed an issue where reports with a Stored Procedure data object whose "Category" property in the configuration contained a backslash would throw an error when the report was executed
- Fixed some issues in the Dashboard Designer that would cause Visualization tiles to reload when not expected
- Fixed an issue that prevented the ExcelFormula() function from working as expected
- Fixed an issue where Microsoft Excel exports would fail in certain circumstances when Exago is running on Linux
- Fixed an issue with error messages being displayed if Mono was not installed as part of the installation process on Linux
- Fixed an issue where the user interface would not fully load when FIPS encryption was used
- Fixed an issue where Action Event code stored in the static part of the static-dynamic configuration could cause incorrect session information to be referenced.
- Fixed some issues with text alignment in Dashboard Interactive Filter tiles
- Fixed an issue where small white borders could be seen around tiles on a Dashboard with a dark canvas background color
- Fixed an issue where an error message could be displayed when a chart referenced an aggregate in a Group Header section
- Fixed an issue with filtering Boolean data fields from PostgreSQL data sources
- Fixed an issue where filter dependencies do not work as expected when the report is included on a Dashboard
- Fixed an issue where a Dashboard created pre-v2018.2 could break in v2019.2+
- Fixed an issue where an error message would be displayed if three or more column headers were added to a CrossTab Report
- Fixed an issue with the Report Designer user interface that could cause the grid to unexpectedly resize after closing the Categories dialog from the Report Settings menu
- Fixed an issue that could cause an Advanced Report to show an error message if a page break occurs right after a suppressed row and a repeating row
- Fixed an issue where Group Headers would print twice if that header included a Repeat Row and a Page Break
- Fixed an issue in the Admin Console that could cause the browser to freeze if the ID of a Data Object was cleared
- Fixed an issue preventing reports containing a Gauge visualization from being exported when Exago is run on Linux
- Fixed an issue preventing reports containing a Date field on the X-axis of a chart from being exported
- Fixed an issue in the Report Viewer where right-clicking on a column and selecting Hide Column for a CrossTab Report would not hide the selected column, including on exported output
- Fixed an issue where charts appear very small in an RTF export
- Fixed an issue in the ExpressView Designer with changing the groups and values of charts from the properties pane on the right side of the screen
- Fixed an issue preventing Existing Report tiles from changing their contained report with the Content tab of the Tile Properties Pane when using custom Folder Management for report storage
- Fixed an issue where an "root element is missing" error message might be displayed when running reports in a web farm environment
- Fixed an issue where the data field with the desired color information for Conditional Formatting with a Formula had to be included in the section where the conditional formatting was applied
- Fixed an issue where an error message would be displayed when reports are executed on Remote Execution servers accessing temporary file storage hosted in the cloud
- Fixed an issue where executing a scheduled report with batch execution may return a No Data Qualified error message even though running the report returns data as expected
- Fixed an issue preventing Data Objects from being created if the Data Source contained a column of Geometry data type
- Fixed an issue where document templates including the RepeatForEach feature would display an error message when exported as RTF
- Fixed an issue where prompting filters on chained reports would not display the filter title from the component reports
- Fixed an issue with some charts not rendering correctly in PDF exports using the Puppeteer library with Exago running on Linux
- Fixed an issue where an error message would be displayed if a formula sort included fields from two different data sources
- Fixed an issue with the Monitoring Service not recording data if either the userId or companyId system parameters contained the at-sign (@) in their value
- Fixed an issue that would prevent editing or running a report that contained a data object that had been removed from the system configuration instead of showing an error message
- Fixed an issue in the Dashboard Designer where the Refresh button on the toolbar would become disabled if an Existing Report tile containing an ExpressView was added to the canvas
- Fixed an issue where the "No Data Qualified" message could not be dismissed if it appeared on a child report in a linked report relationship
- Fixed an issue with Batch REST Web Service API calls to
PATCH entities/Fields/{FieldName}
where the values would actually be updated in the configuration, but would not be reflected in the return value if doing aGET entities/Fields/{FieldName}
to verify - Fixed an issue with REST Web Service API calls to
GET /rest/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 theAggDistinctCount()
function - Fixed an issue with fetch and XHR requests to allow cookies to be set when Exago is accessed from a different origin than the host page. This was necessary to allow Exago to be embedded at a different origin without the need to turn on cookieless sessions
- Fixed an issue where an error message would appear if a user attempted to send a Debug Package to our Support Group through the automatic debug package submission process and they were submitting a Dashboard, a Chained Report, or an Advanced Report with a linked report on it.
- Fixed an issue where an error message relating to cross-origin embedding would incorrectly be displayed from the same origin if the WebEndpoint JavaScript API constructor argument contained any capital letters in the URL's origin.