v2021.1 Release Notes
Release 31
Issues Fixed
- Advanced Attribute “toolTipSepChar” for works now for bubble charts
- Dashboards, while undoing added data field, now re-execute the tile
- Added httpRuntime executionTimeout on WebServiceApi\web.config.Linux
- Added “CloudToJson” tool in Linux installs
- Dashboard w/ report that has prompting formula filter on a report-level custom SQL object removed stack trace
- Fixed Having a “>” (special characters ) in a Column Name sorting
- Fixed ReportTemplatesAllowEdit language element to render correctly
- Chart advance Features: Bar 2D, specifically the Chart Cosmetics attributes, now gets applied to chart elements
- Fixed dashboard Import filter 'from' naming appears on the new interactive filter
- Dashboard filters dropdown menu is now resizing correctly when the page window changes
- Fixed Cell background of hidden columns shown on PDF Snapshot export of dashboard report
- Dashboard Slider ranges now accept values exceeding starting values
- Fixed the issue when too many filters that cause pagination/scroll on the filter menu
- Fixed issue when in express view auto-formatting string to date
- Fixed issue parameter prompt text does not appear in the dashboard parameter modal
- Fixed issue for templates inheriting access flags from the user rather than the parent object
- Fixed the issue of the date picker being displayed out of place when calling a single report from the JS API
- Fixed issue on report viewer Page navigation buttons getting disabled after the first use
- Fixed issue with debug package generation code to account for the new Salesforce Ticketed format
- Fixed issue with advanced reports designer freezes after trying to move a repeating group section
- Fixed issue with the exception being thrown when trying to schedule a report
- Custom SQL now handling parameters without default values
Release 30
2022-12-06
- The AR Interactive Filter value input is no longer empty after you save a value in the Date Time field
- The Hyperlink() function in column metadata now returns correct results
- The “DateFormatMethodString” for Postgres now uses a valid database function for Postgres v13
- You can now close the executed report tab when running through wrApiAction.EditReport
- 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 29
2022-11-07
- You can now double click toolbar icons for dialogs without opening the dialog
- You can now click undo twice after adding a filter to the dashboard without causing a JS error
- 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 28
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 27
2022-09-06
- Credential-less SMTP now works with your Mail Kit
- RTF Exports now populate consistently
- You can now export a Linked report, and it returns all data and applies all parent filters
- Dashboard date parameters no longer allow string values that break your dashboard execution
- You can now export reports and all the data you want in the report can be viewed
- When you export a Crosstab from the HTML viewer, Exago does not convert numbers to Zeros
- Express View reports are no longer vulnerable to cross-site scripting
- You can now set an OnReportExecuteInit event and it will execute reports on the dashboard
Release 26
2022-07-28
- PDF exports for specific expressView report structure now function properly
- Date quick functions now work properly for null date values
- Clearing an interactive filter value for a dashboard tile now functions correctly when it is refreshed
- Heat Map style & color distribution now allows you to use "Percentage of data" checkbox in chart wizard
- Heat map slider scale max value is output now matches the largest value in the associated dataset
- Report editor no longer allows categories to be enabled that should not be enabled
- You can now apply a Role filter to a Stored Procedure Data Object without getting an error
- You can now add reports to a chained report
- Column header bar is no longer duplicated when you press the down arrow of the search bar twice in report viewer
Release 25
2022-07-05
Issues Fixed
- Dashboard filter menu no longer goes off screen when you embed the dashboard
- The "Is One Of/Is Not One Of" symbol now remains in the filter menu
- Merged Cells no longer need to be un-merged to work in Columns when you have cells in a merged area
- You can now save custom filter functions in report metadata
Release 24
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 23
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 Existing Report tiles with an ExpressView would not show the chart if moving away from Dashboard tab
- 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 22
2022-04-04
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 special characters that do appear in the Report Viewer do not appear in PDF exports when Exago is running on Linux in certain environments
- Fixed an issue where large tables in reports could spill off the Report Viewer page if several instances of the report were executed simultaneously
- 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 with column width calculation in the Report Viewer in certain circumstances
- Fixed an issue ports 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 deleting a report from the Report Tree didn't close any Designer or Report Viewer tabs that are open related to the report
Release 21
2022-03-15
Features Added
- Improved error messaging when launching a session fails
Issues Fixed
- Fixed an issue with the horizontal scroll bar on a Dashboard existing report tile rendering behind another user interface element preventing access to it
- Fixed an issue where the Scheduler Service would not send emails with credential-less or unauthenticated SMTP connections
- Fixed an issue where an incomplete list of Dashboard interactive filter values was presented in the user interface
- Fixed an issue where reports grouping on non-sort fields stopped working in v2021.1.11+
- 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 Advanced Reports would load uncentered in their Dashboard tile if the Dashboard loads in a tab other than the currently selected one
- Fixed an issue where the X and Y Axis Labels do not get saved or display for Statistical Process Charts
- Fixed an issue where the Dashboard canvas color shows through an existing report tile after scrolling the report in the tile
Release 20
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 issue where an error message would appear if linking to another report in a Report Footer section and the linking field is both a Key Column and has a Column Alias
- 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 19
2022-01-28
Features Added
- Add official support for Oracle Linux in the Linux installer
- Added support for proxying the Storage Management assembly for environments where access to the Storage Management system outside of the domain are required
- Added support for table functions in Snowflake Data Sources
Issues Fixed
- Fixed an issue where adjusting an interactive range slider on a Dashboard could cause repeated data rows to appear in the child report of a Linked Report
- Fixed an issue where the pointer on a range slider Dashboard Filter tile appears on the wrong value even though the Affected Tiles were filtered as expected
- Fixed an issue where an interactive range slider filter on a Dashboard using the
MonthName()
function could inadvertently cause month names to appear out of chronological order - 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 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
- Fixed an issue where a consolidated Dashboard filter that was unconsolidated in the Dashboard Designer would not save in the unconsolidated state
- 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
- Fixed an issue where a visual glitch occurred when viewing an Advanced Report on a Dashboard
Release 18
2022-01-07
Features Added
- Decreased the line height in ExpressView cells to increase readability for narrow width columns
Issues Fixed
- Fixed several issues with the handling of Collapsed Rows in the Report Viewer if the collapsed rows included vertically merged cells or groups
- Fixed an issue where a consolidated Dashboard filter that was unconsolidated in the Dashboard Designer would not save in the unconsolidated state
- 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
- Fixed an issue where the pointer on a range slider Dashboard Filter tile appears on the wrong value even though the Affected Tiles were filtered as expected
Release 17
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
- Added new
maxexportfilesizebytes
hidden flag to stop execution if exported file size grows too big
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
- Fixed an issue where a linked report would show No Data Qualified if it was linked on a date field with a range of values, but there was no end date selected
- Fixed an issue with the Column Headers in the Report Viewer resizing to fit the available window size when Simulate PDF was turned off, although the columns were the correct size
- Fixed an issue where choosing Export to Advanced Report in the ExpressView Designer would export the first opened ExpressView in the interface, not necessarily the chosen ExpressView
Release 16
2021-11-24
Features Added
- Added new
errorondbrowlimitexceeded
hidden configuration flag. If an executing report requires more than this number of records for execution, an error message appears to the user indicating the report has failed, instead of silently truncating the report data set
Issues Fixed
- Fixed an issue with an error being generated when resizing a Dashboard canvas with tiles on it
- 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 where reports executed with the JavaScript API and the Incremental Loading feature enabled caused filters to be ignored on the subsequent calls for data
- Replaced missing SQLite files for the Storage Management utilities that were not being installed as expected
- 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 a Dashboard interactive filter tile with an In Between operator and two date filter functions as default values in it caused the tile to show an loading icon indefinitely
- Fixed an issue where a CellDataFieldNotFound error message would appear if executing a report via the REST Web Service API and the environment included a static/dynamic configuration setup
- Fixed an issue where a Row-Based (Layout 3) chart including a DateTime field as a Data Label field would not be included in exported report output
- 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
- Updated the Google BigQuery CDATA driver from version 21.0.7894.0 to version 21.0.7993.0 to resolve an issue with intermittent HTTP 404 errors
Release 15
2021-11-04
Features Added
- Added New Parameter button to the Advanced Report Designer's Custom SQL dialog for adding a new parameter to the report's definition
- Schedule and ScheduleListItem REST Web Service API JSON objects now included a new
ParentJobId
property
Issues Fixed
- Fixed an issue where emails could not be sent by the Scheduler Service running on Linux if the SMTP server required TLS 1.2
- 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 Dashboards created in a pre-v2020.1 environment using Folder Management for report storage including data in the UDF field cannot be loaded in v2021.1 and an error message was shown
- Fixed an issue where Group Footer sections could not be modified once added to an Advanced Report
- 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 where aggregate formulas including an apostrophe would cause an error
- 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 JavaScript errors would occur in certain circumstances when creating a new report via the JavaScript API
- 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 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 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 where the Use Thousands Separator setting is unset after making changes to the Number tab of the Cell Formatting dialog in the Report Designer
Release 14
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 a running sum in a Group Footer section would return an error message instead of the expected running sum
- Fixed an issue where an ExpressView could not be exported from within the ExpressView Designer
- Fixed an issue where a complex Dashboard could appear unexpectedly in the full Web Application user interface if it does not completely load in a JavaScript API call and is subsequently disposed of before the full Web Application user interface is launched
- Fixed an issue where long Section Header names or fields could collide with the Row Menu icon
- Fixed an issue where report data appears out of order when Enable Paging in Report Viewer is False
- Fixed an issue where the Filter Item Detail dialog wouldn’t close when closing the Formula Editor dialog in the Dashboard Designer
- Fixed an issue creating monthly schedules with the ReportScheduler.CreateMonthlySchedule method in the .NET API, where the EveryNMonths value would be set to 1 regardless of intended value
- 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 where the signature for the DeleteContent method in IStorageManagement did not include the virtual keyword
- 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
- Fixed an issue where Date functions were not translating properly for Google BigQuery Data Sources
Release 13
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 12
2021-09-24
Features Added
- Replaced the Automatic Database Discovery Tool icon in the Admin Console, to make it more descriptive of its function.
- Added a tooltip to the Name field in the report designer's Save dialogs to mention that a user does not have permission to provide a new name if the user's party does not have the CanRename access flag enabled on the report
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 with a Dashboard inadvertently swapping the height and width properties if the Fit type were set to Specify Height and Width
- Fixed an issue in the Dashboard Designer where new tiles could not be added if the Fit type were changed from Scale to Screen to Specify Height and Width then back again
- 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
- Changed an expected Storage Management system log message about an empty UDF string from the WARN log level to the DEBUG log level. The UDF string is only used in a small number of cases
- Fixed an issue where a period (.) could not be entered into the filter dropdown field when filtering on a formula that included the division of two integers.
- Changed the way Exago translates formulas to SQL when performing division between two integers to match the way Exago performs division between two integers in-memory.
Release 11
2021-09-02
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
- Decreased execution time, in some cases by almost three times, for reports with charts containing thousands of data points
Issues Fixed
- Fixed an issue where report-level parameters could not be used in report-level Custom SQL Objects
- Fixed an issue where a text field on a report that includes a CRLF newline character shows [wrCellStr] instead of the expected text content
- 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 an issue where interactive filter tiles with checkboxes that included default values could sometimes break if the there were a large number of selectable filter values to choose from
- Fixed the sorting of content in the Report Tree to give the sort order property of the Storage Management system first priority
- Fixed the setting of the language file when utilizing the Batch endpoint in the REST Web Service API which would sometimes only cause a partial translation of the user interface
- Fixed an issue with the Automatic Database Discovery Tool taking a long to complete with the Redshift CDATA driver
- Fixed an issue with SQL generation with nested CASE statements for Google BigQuery Data Sources
- Fixed an issue where an error message is displayed when passing a decimal number to the interval argument of the DateAdd() function and the formula was translated to SQL for a Google BigQuery Data Source
- Fixed an issue where an error message is displayed when using the DateAdd() function translated to SQL for a Google BigQuery Data Source, and adding hours, minutes or seconds
Release 10
2021-08-13
Features Added
- Added built-in support for Google BigQuery as a reportable Data Source
- Added language file translations for the different function categories in the ExpressView Designer formula builder
- Added language file translation for SQLite Data Sources
Issues Fixed
- Fixed an issue where Ctrl+drag on a cell in the Advanced Report Designer would cause changes to the source (dragged) cell, not the destination cell
- 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 Group Footer sections on Advanced Reports would appear below Page Footer sections
- 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 9
2021-07-22
Features Added
- Added a new Licenses directory to the Web Application that includes third party package licenses
- Changed the default flush time for completed Scheduler Service jobs from no automatic flushing to automatic flushing every 24-hours
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
- Fixed an issue where many concurrent report exports including charts, GeoCharts and Google Maps being rendered by the Puppeteer renderer could cause the execution of the reports to hang
- 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 a few issues with updates to Dashboard visualization tile previews not being consistent in all situations
- Fixed an issue where the Export options were still available on a read-only ExpressView
- Fixed an issue where pressing the Enter key to dismiss the color picker dialog on the Advanced Report Designer toolbar would open the text editing window unexpectedly
- Fixed an issue where data fields could not be drag-and-dropped to the Advanced Report Designer's cells when using the Safari web browser
- Fixed an issue where an error message would be displayed if a Data Object was removed from an Advanced Report and that report has an interactive filter on a field in that Data Object
- Fixed an issue where a filter tile on a Dashboard with vertically oriented checkboxes would not scroll bar so all filter values could not be seen or selected
- 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
- 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 in Internet Explorer where a filter dropdown value would not be displayed in the Simple with Operator or Simple without Operator Filter Execution Window, but the report would still be filtered on the selected value
Release 8
2021-07-01
Features Added
- Added built-in support for SQLite as a reportable Data Source
- Added additional context help sensitivity points for the Dashboard and ExpressView Designers
- Changed the way images included in PDF Document Templates are exported, increasing their resolution in the output file
- Added new Admin Console > General > Other Settings > Max Chained Report Collation Executions setting (chainedreportmaxcollationexecutions in the XML configuration file) to place a limit on the number of executions a collated chained report is allowed
- Added support for the Automatic Database Discovery tools to use standard ADO.NET
GetSchema()
methods - Increased responsiveness of the Report Viewer toolbar when the Report Viewer is open in a small window, such as when displaying the child report of a Linked Report relationship
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 the letter case of the schema was not being respected as expected with the Npgsql driver
- Fixed an issue where null values were being displayed as their own group in an ExpressView instead of either a blank cell or the word "null" 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 where the Edit menu in the Report Viewer could still be clicked even when it was disabled via the configuration
- 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 7
2021-06-10
Features Added
- Added new
maxRasterizationsBeforeReset
directive to the Application Settings to release resources after a finite number of chart, gauge and map exports
Issues Fixed
- Fixed an issue where an Execution Cache would be removed from a report if the caching update failed
- Fixed an issue where extra characters were being added to formulas when adding suggested cell references and data fields
- Fixed an issue where the Export Options in the ExpressView Designer would not necessarily follow the CanEdit or Read Only permissions of the report as expected
- 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 a Dashboard would fail to execute if an Existing Advanced Report tile contained a group on a data object with Interactive Filtering in Database enabled
- Fixed an issue where after duplicating a Dashboard, changing the Selected Report in an Existing Report Tile would not be saved in the duplicate
- 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 6
2021-05-21
Features Added
- Added a new Minimum Column Width control for Advanced Report, ExpressView and Tabular visualization tiles in the Dashboard Designer
- Storage Management databases initialization now sets the text_content field in the content table to be NTEXT type
- Increased the speed of large (thousands of pages) Report Viewer executions by as much as 5.75x
- 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.
- Added the canreexecuteindb flag to the REST Web Service API's Data Objects endpoint
Issues Fixed
- Fixed an issue where the report path would not be properly interpreted and the report would be bumped to the root of the Report Tree when Api.Action = wrApiAction.EditReport
- Fixed an issue where an error message would be displayed when adding new Data Objects to a report if the report is the parent in a Linked Report relationship
- Fixed an issue where formulas were not being translated to SQL for vertical table transforms
- 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 trailing commas were erroneously removed form the Report Designer's Formula Bar when adding functions
- Fixed an issue where unhiding a hidden column in the Report Viewer caused the column to shrink in width
- Fixed an issue in the Dashboard Designer where changing a filter field to a formula would not recognize the change and trigger the Refresh Reminder as expected
- Fixed an issue with adding nested formulas in the Formula Editor dialog causing an argument placeholder message to appear unexpectedly
- Fixed an issue with the size of some dropdowns and messages being too narrow on some monitors
- 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
- Fixed an issue where a report execution could sometimes fail if the cell contents were very large
Release 5
2021-05-04
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%
- The outermost ExpressView Group column will now be the default Data Label, and the second outermost ExpressView Group column will not be the default Series Label when clicking the Add Chart toolbar icon in the ExpressView Designer
- The default location for the Advanced Report Viewer's Interactive Dock is now on the right
- Updated the Snowflake CData driver to version 20.0.7768.0
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 an Imported Parameter on a Dashboard that is used in a filter does not get passed into the filter SQL as expected
- Fixed an issue where a report would result in a blank tile if on a Dashboard with an interactive filter that filters on an aggregate field in the report
- Fixed an issue where Dashboard multi-select or single select interactive filters would return No Data Qualified erroneously if the Affected Report used the Top N filtering technique to sort by aggregates
- Fixed an issue where cell content was cleared when changing formatting options (for example foreground or background color; text size; alignment)
- 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
- Removed the short delay displaying the Run Report or Export button in the Report Tree for each report
- Fixed an issue where a chart in a Report Footer section would disappear from the report if trying to move it to a Report Header section instead of displaying an error message
- Fixed an issue where Vertical Tables were not considering the Data Type column in a Data Object's Column Metadata as expected
- Fixed an issue with the loading of cached PageInfo objects
- Dashboard Advanced Filters now utilize the Data Object ID and Column Name instead of the Alias
- Fixed an issue where the Save dialog would not close on the next click of the Save icon if the report was unmodified but dialog had been opened
- Fixed an issue where an "Undefined" tooltip would appear for certain tabs in the Admin Console and Schedule Wizard
- Fixed incorrect 1000 Separator character handling in ExpressView
- Fixed an issue where the Dashboard Designer would become unresponsive after refreshing an Advanced Report tile that has a interactive filter tile affecting it
Release 4
2021-04-16
Issues Fixed
- Fixed an issue that caused all scheduled jobs to be canceled after 60 seconds of execution time
Release 3
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
- Added new Merge Cells and Split Cells options to the Cell Context Menu
- 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 when Data Objects are included on a report, it is not obvious that the Add SQL button is not available until all Data Objects are removed
- Improved error messaging when a report is read-only because the CanEdit access flag is not enabled and a user attempts to edit it
- Changed the nomenclature of "Drag onto Canvas" interactive filters in the Dashboard Designer's Filters menu to be more intuitive
- Fixed an issue where moving data in a cell referenced by a chart to another cell would break the chart
- 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 a Dashboard Interactive Filter tile would erroneously display "No Data to Display" due to filter dependencies and tiles on the Dashboard
- Tweaked some styling on the Save menu in the Advanced Report Designer
- Fixed an issue with Scatter Charts in Dashboard tiles not prompting for their Y-Value when creating a new visualization
- Fixed an issue with new visualization and existing report tiles incorrectly displaying the Paging controls when added to the canvas
- Fixed an issue where the handle to resize the left pane (for example Report Tree, Data Field Pane) shrank to 1 pixels wide when the Dashboard Viewer is open
- 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 where the Add Group drop zone in the ExpressView Designer would appear even when the ExpressView is read-only
- Reverted the order of the Report Viewer's Interactive Dock modules to the pre-v2021.1 order of Filters, Conditional Filters, Sorts then Columns
- 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
Release 2
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 where "Folder" was erroneously changed to "Data Object" for the Limit Reports and Visualizations to One Folder setting in the Admin Console
- Fixed an issue where the reference to an Existing Report tile would break in a Dashboard if the Advanced Report was renamed and the Dashboard was open in the Designer
- Fixed an issue with the placement of icons in the linked report/drilldown popup window
- 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 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 with the handling of
default_job_timeout
andmax_job_execution_minutes
in the Scheduler Service - 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 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 with the Storage Management GetCacheKey() method would not return the ReportListCacheKey as expected
- Fixed an issue where Infinite Scrolling would not work correctly with Remote Execution enabled
- Fixed an issue where reports could not be executed in a web farm environment with Remote Execution enabled unless using sticky sessions
- Fixed an issue where long column name labels would overflow their container in the Report Viewer
- Fixed an issue where Column Sorts would not work as expected in the Report Viewer
- Fixed an issue where removing one of the Custom Functions associated with the new Quick Functions would cause an error in the Admin Console
- Fixed an issue with a minimum height being applied to the Filters module in the Report Viewer's Interactive Dock even when there were only a small number of filter values
- Fixed an issue where a Linked Report from a chart would not work in Internet Explorer
- 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 an issue where server events that reference .NET assemblies would pass previously referenced values in a static-dynamic configuration file
Release 1
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
- The Linux installer will now install Mono version 6.8 when requested during the installation process
- Admin Console > General > Feature/UI Settings > Allow Editing ExpressView with Live Data now defaults to True
- Added the
/rest/schedulesv2
endpoints, to replace the legacy/rest/schedules/
endpoints - "Suppress Duplicates" has been renamed to "Hide Repeated Values"
Issues Fixed
- Fixed an issue that prevented using report-level parameters in the Custom SQL Object editor
- Fixed an issue that would make the Canvas menu appear unexpectedly, or even clear the Dashboard Canvas when clicking on the Undo button in the Dashboard Designer
- Fixed an issue where a visualization would not fit in the cell as expected even when the Fit to Cell checkbox was checked and the cell width was less than 100 pixels
- 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 changing an Existing Advanced Report tile's Advanced Filters would not display the Refresh Reminder icon as expected
- 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 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 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
- Made some changes to the way the "report already exists" message is displayed in the Advanced Report Designer when trying to save a report with a name that already exists in the system
- 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
- Updated error messaging that appears in the logs when the system is unable to establish a connection with Storage Management
- 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
- Section menus will now close as expected when scrolling the Report Designer's Design Grid vertically
- Fixed a visual styling issue with the Report Designer's toolbar
- Fixed an issue where saving a report with a duplicate name would silently fail instead of properly displaying a warning message to the user
- Fixed an issue with the handling of Excel template files causing an error message in certain circumstances
- Fixed an issue that allowed items from the Report Designer's toolbar Insert menu to be added to CrossTabs
- 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
Switch()
function was unable to differentiate between 0 and null - 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 0
2021-02-05
We are proud to release Exago BI v2021.1!
Check out the list of new features and other changes below.
ExpressView Overhaul
The ExpressView Design experience has been completely re-imagined—from a new report layout, new themes and exporting formats to new summary building tools and two new chart types!
The Designer retains its simple drag-and-drop interface but presents data in a new table format that expands from left-to-right and top-to-bottom. Summarizing at the group and report level can be done in as few as two clicks of the mouse. Adding a chart requires just one more click.
New Quick Functions transform data from the data sources with two clicks, without having to write a formula. Formula columns can also work in conjunction with Quick Functions to tailor the analysis of data quickly. A number of Quick Functions are built-in to the application, and administrators may add their own at any time.
New formatting and theming controls empower users to create beautiful, professional looking reports in as few as one or two clicks. These modifications also carry through to exported files (PDF, Excel and RTF formats).
When the Incremental Loading feature is enabled, a link explaining the partial data set is displayed instead of an icon.
A maximum of seven groups may be added to an ExpressView. For existing ExpressView opened in the new Designer, no new groups may be added until less than 7 groups are on the report.
Advanced Reports Overhaul
Like ExpressView, Advanced Reports have been given a fresh new look in both the Report Designer and Report Viewer tools.
The Advanced Report Wizard has been removed. Now, when creating a new report, users will be brought directly to the Report Designer and prompted to add Data Objects (formerly known as Categories). Once users add their Data Objects, they are able to begin designing and building immediately in any order or workflow that suits them.
The design grid has a new look and new interaction points — such as the new Add Section and Select All buttons and cell highlighting when editing formulas in the Formula Bar. The Row, Column and Section menus are easier to access.
Clicking on a row or column header will select all of the cells in that row or column.
A new indicator appears above the Save icon and in the Designer's user interface tab in the Report Designer's toolbar to indicate unsaved changes pending to be saved.
Controls on the toolbar have been rearranged to make them easier to find. The Sorts and Filters icons now have dedicated toolbar icons. To change the Data Objects on the report, use the new Manage Data Objects button in the Data Objects pane. Insert charts, gauges, maps, images and others by using the new consolidated Insert menu.
Fixed an issue where the Font dropdown in the Advanced Report Designer would not open instantly on click.
The Report Tree in the Linked Report dialog is now searchable by the Report Name.
The modules of the Interactive Dock (the left pane in the Report Viewer) work differently — they are easier to access and match the design of the rest of the application. The column headers are always visible at the top of the window and a new Report Viewer Option can turn them off on a report-by-report basis.
A new Open Dock and Close Dock icon appears in the Report Viewer making the Interactive Dock easier to find and open/close
The prompting filter and prompting parameter dialogs have changed with a new look. By default, a simpler prompting filter dialog (officially called the Simple With Operator Filter Execution Window) appears in place of the previous Standard Filter Execution Window. This can be overridden on a report-by-report and system-wide basis.
When the Incremental Loading feature is enabled, a link explaining the partial data set is displayed instead of an icon on the Report Viewer's toolbar.
The Admin Console > General > Feature/UI Settings > Default Designer Font Size has been changed from 8 to 10, to increase text readability and WCAG 2.0 Accessibility standards compliance.
Dashboard Changes
Big changes continue for Dashboards in v2021.1!
By default, a new Admin Console Feature/UI Setting named Automatically Refresh Reports is set to False. This has the effect of preventing changes to tiles in the Dashboard Designer from triggering a complete reload of the data on that tile. By reducing the number of report executions, the Dashboard Designer will feel more responsive and the load on the network and data source servers is reduced. A new Refresh Reminder appears in the tiles and on the toolbar indicating that the tile is due for a refresh to show updated information.
When Automatically Refresh Reports is False, a placeholder image will be displayed when adding a new Existing Report Tile to a Dashboard until the tile is refreshed.
Dashboards with interactive filters can now pull the interactive filter values from the data source, then execute or re-execute their associated reports with those values in the data source. This can lead to considerable performance improvements, in some cases going from a couple of minutes of execution time to under ten seconds. A new setting for Data Objects in the Admin Console allows this behavior to be disabled on a per-object level.
The Suppress Detail Rows checkbox has been removed for the Existing Report tiles with an ExpressView in the Dashboard Designer.
Some styling changes to both the Dashboard Viewer and Dashboard Designer create a more unified appearance across the application .
Visualizations
Added two new chart types available to ExpressView, Advanced Reports and Dashboards: Radar Charts and Stacked Area Charts.
New chart themes are available throughout the application wherever charts may be added to reports. Single series charts will now assign a single color to a series (a.k.a. a group) instead of a value.
Storage Management
The Storage Management Access Flags introduced in v2020.1 have been activated. The flags can be used to give fine grained control over access to themes, templates, folders and reports in the system on a per-user, per-company or per-user class level. Read more about the flags in Storage Management: Introduction.
The Access Flags setting in the Admin Console has been renamed Default Access Permission and has additional controls for affecting access to newly created content.
A new Update Reports button in the Admin Console generates additional metadata stored in the Storage Management database's content table.
The Storage Management Utility, a standalone tool for managing Storage Management database content has been re-written from the beginning and now supports Windows, Linux and Mac OSX. Users can create, modify or delete content items, folders and content access records directly with the utility now. This application is available on the Downloads page of the Support Center.
The IStorageManagement methods have been virtualized, so the entire interface does not need to be re-implemented when only implementing some methods is desired.
Added the -o
command line parameter to the LoadReportsToDb Storage Management transitioning utility to set the command timeout
Fixed an issue where the LoadReportsToDb transitioning utility would not read the OwnerID from the intermediate JSON file as expected
Methods for accessing Storage Management have been added to the SOAP Web Service API to support clients utilizing this deprecated API
Fixed an issue the prevented Exago from connecting to a PostgreSQL Storage Management database with the NPGSQL driver on Linux
Please also review the What’s New in Version 2021.1 topic for more information regarding these features.
Other Changes
- Increased performance of in-memory sorting
- The name Categories has been replaced with Data Objects in all parts of the application that reference the tables, views, functions, stored procedures or custom SQL objects that reports retrieve data from
- DB2 data sources now support converting formula filters and sorts to SQL
- Added Switch() conditionals to the SQL formula translation library in dbconfigs.json so that formulas containing them can be executed in the data source
- Added translations for AND and OR operators with more than two arguments to the SQL formula translation library in dbconfigs.json
- Changes to the Storage Management implementation allow report properties (for example data objects/entities) to be retrieved programmatically versus first creating a ReportObject object in the API
- New CrossTab themes are available in the CrossTab Data Designer that match the new chart themes
- The default colors for Charts, GeoCharts, Google Maps, Gauges and Heatmaps have been changed to
#3B5BD2,#4E80F4,#95B3F8,#CAD8FB,#FDD9B2,#FCB467,#FE9001,#F87206
. These can be changed in the Admin Console > Feature/UI Settings. - Added XML validation for ExpressView reports executed by Scheduler Services. When an older ExpressView is executed on a newer Scheduler Service, it will be checked and updated if necessary.
- 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
- The REST Web Service API now allows loading reports with their content ID from the Storage Management database
- Improved performance in the Dashboard Designer by removing several extraneous cases where content in visualization tiles would indicate the need for a refresh
- Improved an error message that displays when a language file cannot be found
- Increased vertical padding on the nodes displayed in trees throughout the application (Report Tree, Data Objects pane, the list of folders in the Admin Console's Roles section, etc...
- The AutoSum icon has been disabled by default from the Advanced Report Designer's toolbar. The feature can be turned back on with a new Admin Console Feature/UI Setting named Show Auto Sum Button
- The internal log4net library has been updated to version 2.0.12
- The internal charting library (FusionCharts) has been updated to version 3.15.2
- The Advanced Report Designer's toolbar no longer collapses (hides icons) as screen size reduces. Instead, modules of icons will shift onto new lines keeping all icons visible
- The data type icons at the top of the Data Objects pane on the left side of the user interface have been removed
- The ETL feature has been removed from the product
- The ExpressView Tutorial and ExpressView Hints features have been removed
Issues Fixed
- Fixed an issue in the Dashboard Designer that prevented a report name and folder name from being selected when saving a visualization tile as an Advanced Report
- Fixed an issue with the Admin Console > General > Feature/UI Settings > Update All Application Themes button displaying an error when clicked
- Fixed an issue with the SQL generation for ExpressViews with sorts on a formula field or a field used in a formula
- Fixed an issue when executing a Dashboard containing a prompting parameter with a Parameter Dropdown 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 filter dependency did not honor logical grouping with an OR conjunction
- Fixed an issue where changing the name of a report on an existing report tile on a Dashboard was not an Undoable action
- 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 an error message would appear if filtering on a date field originating from an IBM DB2 or IBM Informix Data Object
- Fixed an issue where the New Report menu could flash or blink when the browser's cache is empty
- Fixed an issue where images uploaded to Advanced Report Cells in a Detail section would sometimes fail to load when Exago is hosted in a web farm environment
- Fixed an inconsistency with the name of filter operators across the Standard, Simple With Operator and Simple Without Operator Filter Execution Windows
- Fixed an inconsistency with the spelling of CrossTab used throughout the application
- Corrected the tooltip description of the LoadImage() function to indicate it must be the outermost function in a report cell
- 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