User Story: 3541
We have refactored how and when the table in Excel is created and populated with report data. The result is a much faster and more reliable retrieval of report views in X-RA. The result of this overhaul is a decreased wait time for retrievals to complete. For larger retrievals, some results may be 500% faster!
User Story: 2630
Criteria dropdowns can now be horizontally resized so that the user can see all the data in dropdowns that contain wide options to select.
User Story: 370
Criteria fields that display a timestamp in RightAngle now also display a timestamp in X-RA. Dynamic criteria fields default to displaying the timestamp in RightAngle. These fields now show the time stamp in X-RA as well (the "Ignore Time" option is also respected in X-RA).
User Story: 2949
When a "Like" operator was used inside of an IF statement, the computed column was not translating correctly to an Excel formula. The "Like" operator now works correctly in computed columns.
User Story: 2630
Many error messages were missing vital information due to serialization. Client error messages are now more descriptive, and server error messages are now reliably logged to RA Event Log (or the Windows Event Viewer when RA is unavailable).
User Story: 3412
Saved Excel X-RA workbooks are now compatible with future upgrades of X-RA. Any Excel workbook saved in v1.6.3.1 moving forward will not need to be re-created with future X-RA version patches.
User Story: 2630
Wait times during the caching at X-RA’s first open have been decreased.
User Story: 2637
A button has been added to the X-RA Toolbar allowing users to access X-RA Training Videos.
User Story: 2099
All pop-up windows in X-RA have been restyled to have a similar look and feel that better matches the X-RA theme.
User Story: 76
External Column scan now be added to a report from within X-RA.
User Story: 2085
Columns in anX-RA report can now be re-ordered, re-named, made visible/invisible, be removed(if they are an external column) – all from within X-RA. External Columns that have been added to a report now display what path was used to add those columns.
User Story: 77
Dynamic Criteria can now be added to a report’s criteria from within X-RA.
User Story: 2136
External Columns on a report can now have their UOM/CurrencyConversion defined from X-RA. External Columns on a report can also now have their Aggregate Type defined from X-RA.
User Story: 1982
When an automated retrieval fails (bad criteria, server errors, etc.), the error is now displayed in the second title row of the report.
User Story: 68
Criteria values can now be reset to their original values from within X-RA.
User Story: 189
Criteria values can now be reverted to the criteria used when the report was last retrieved.
User Story: 2271
A custom report is now shipped with X-RA called “Search Inventory Workbench.” This report displays data in X-RA in a similar fashion to RightAngle’s Inventory Workbench.
User Story: 54
Report views that are saved in pivot format in RightAngle report views are now displayed in pivot format in X-RA.
User Story: 812
A scheduled task now exists that can schedule when a workbook (and all worksheets contained therein) will be automatically refreshed and saved for later viewing.
User Story: 901
All items referencing an X-RA table (custom pivots, graphs, etc.) are now updated when the X-RA report is refreshed.
User Story: 1933
When a user attempts to open a new report in X-RA by double clicking a report in X-RA’s RA Report Launcher, a new worksheet is created if the current worksheet contains any data.
User Story: 1092
Computed Columns that are saved in RightAngle Report Views are now displayed in report views within X-RA.
User Story: 1777
External Query Columns that are saved in RightAngle Report Views are now displayed in report views within X-RA.
User Story: 1788
When a RightAngle Report View contains Computed Columns, the column formatting in X-RA will reflect the formatting used in the RightAngle Computed Column.
User Story: 1789
If there is an error in a Computed Column in X-RA, the formula is displayed in the cell prefaced by “#ERROR:” to indicate that the formula will need to be adjusted.
User Story: 19
The ability to define a report as a favorite so that it appears in a separate “Favorites” category in the Launcher has been added to X-RA. Right clicking on a report title now displays the option to Add or Remove the report from the “Favorites” folder.
User Story: 1712
Users can now open PDF documents in X-RA by selecting a row (or rows) and clicking the ‘Open Document’ button in the X-RA add-in. Only reports that have the ‘Document ID’ column on the report (or added to the report view) will display the ‘Open Document’ button. If no document exists, an appropriate message is displayed.
User Story: 1505
The ability to filter criteria dropdowns and reports by internal BAs has been added to X-RA.
User Story: 1508
When moving tab to tab, the 'Refresh Report' button was sometimes grayed out for a few seconds. This has been resolved.
User Story: 1511
If there is an error on a parent report from some failed navigation action, we now clear that error when attempting to navigate again.
User Story: 1512
Users can now view editable reports (and the Inventory Rundown report) in X-RA. Any report views saved for editable reports are also visible to the user. The following reports are not included: Contract Management and Approval, Global Price Maintenance, Form C Capture, Product and Location Structure Maintenance, Portfolio and Strategy Structure, Posted Price Maintenance, Rapid Price Maintenance.
User Story: 1559
Saved options will no longer appear when typing data into text and date fields.
User Story: 1565
A thorough check has been done on the efficiency of code resulting in a 20% increase in retrieval times.
User Story: 45
Comparison operators (contains / begins with / ends with / etc.) in X-RA criteria can now be modified directly from X-RA. Similar to RightAngle, the comparison operators display in blue text and lower a dropdown when clicked.
User Story: 634
The ability to apply currency conversion to an X-RA report (where it is available on RightAngle reports) has been added to X-RA. Currency conversions work the same as UOM conversions and require a refresh to see changes. The Currency conversion selectors will be under the Criteria section of the add-in.
User Story: 1489
When a child report was open, selecting a row on the parent report was bolding the text which was causing some fields to display as "#######". The bolding has been removed.
User Story: 1514
SQL has been provided that parses out the data contained in the 'Search Event Log' for each X-RA retrieval. This data can be then moved to Excel where users can group and aggregate the data.
User Story: 315
When formatting changes were saved in a RightAngle report view, the X-RA report was still using the base report's formatting. The X-RA reports now use the formatting that was applied to saved report views (filtering, conditional formatting, and sorting changes in Excel are still persisted between retrievals). This User Story does not include formatting changes dealing with font, text color, background color, etc.
User Story: 1406
In an effort to help with the performance of Excel writing data into the table, data will now be written in batches. When a user clicks the 'Refresh Report' button, the database retrieval occurs. Then, the data is handed over to Excel to be painted and formatted. The size of the batches is configurable in the Configurations.js file under the following:
window["TableWriteBatchSize"] = 10000;
The batch size defaults to 10,000. Changing this number can potentially increase or decrease retrieval times and can also affect CPU utilization on the client machine.
User Story: 1423
Data recorded about each retrieval in X-RA is written to the RightAngle Event Log. An entry is inserted for retrieval start and each retrieval finish.
User Story: 1230
When logging in for the first time of that day, users would have to wait or click ‘Login’ multiple times. This was caused by the Triangle Reporting Service not running until it receives its first request. This would cause a delayed login for the user if they were the first to login since the app pool had started, IISRESET had been run, or the server had been restarted. With the addition of caching, there are items that get loaded that “wake up” the service and keep it awake for the next user interaction. The service is now initialized at all times.
User Story: 1278
The ‘New Report’ and the ‘New Child Report’ buttons in the Add-in were originally displayed in a dropdown. This caused the ‘New Child Report’ to always require 2 clicks. The ‘New Child Report’ has been moved to be right next to the ‘New Report’ button. Spacing and highlighting have also been updated.
User Story: 1225
When a user would create a new worksheet, the new excel tab was created at the end of the list of worksheets. If the user has many worksheets open, the new tab could be too far from the tab that is currently being worked on. New tabs are now created directly to the right of the current worksheet. If focus is on a tab that is in a group of worksheets (groups are created by opening child reports and are colored to indicate the grouping) then the new worksheet is created to the right of the current group.
Bug: 3373
If a computed column was looking for "(Empty)" text, Excel was displaying these values as blank cells. X-RA now correctly sees blank cells as "(Empty)" cells.
Bug: 3375
Navigating to a report view in X-RA where the child report contained computed columns would crash Excel if the child report view also contained computed columns. X-RA now correctly handles sorting on all child reports.
Bug: 3022
Users can now clear error messages that appear in X-RA.
Bug: 3326
A computed column that is so long that it will translate into an Excel formula that is greater than 8,192 characters is no longer wrapped in the "IF ERROR" text in X-RA. If the computed column itself is greater than 8,192 characters, it will display the following message in the X-RA column: "The formula is too long. The max length an Excel formula can be is 8,192 chars."
Bug: 3107
When a user filtered a child report in X-RA and then returned to the parent report and refreshed the report, the filters were removed from the child report. Filters on child reports are now retained when the parent report is refreshed.
<Multiple Bugs>
Several bugs addressed the bad translation of computed columns over to X-RA. Customers discovered several edge cases where a computed column prevented the retrieval in X-RA from finishing. These edge cases are now handled by X-RA, and code was added to not let columns that error out prevent the rest of the X-RA report from retrieving.
Bug: 2613
If a computed column attempts to do mathematical computations inside of a string, X-RA will display the computed column without error.
Bug: 2632
XRA’s “Manage Columns” window did not allow users to remove columns besides External Columns. Now, Computed Columns and External Query Columns contained in a report view can also be removed.
Bug: 2633
If a computed column references a column that is no longer on the report, X-RA will retrieve all the other columns and rows of the report without erroring.
Bug: 2639
If a report view has been corrupted where a column exists in the Dynamic Column Collection but not in the Devex Grid, X-RA will retrieve all the rows of the report without erroring.
Bug: 2649
If a computed column references one of many columns with the same title, X-RA will retrieve all the rows of the report without erroring despite the column titles being updated by Excel (title1, title2, etc.).
Bug: 1557
When attempting to open 'Search Fuel Forecast', 'Search Fuel Forecast Detail', or 'Search Fuel Variance' in X-RA, an error message was displayed. This has been resolved.
Bug: 1753
When a user enters search data into the ‘Search’ field of the RA Report Launcher, the up and down arrow keys were placing focus on non-visible rows. Focus is now only placed on visible rows.
Bug: 1782
RightAngle Report Views that contain a dot (.) were not visible in X-RA. Now all Report Views are displayed in X-RA’s ‘RA Report Launcher’.
Bug: 1694
RightAngle report views that were built with the same external column added multiple times were displaying incorrect columns in X-RA. We now take into account the possibility of this happening and display the correct columns.
Bug: 1696
In the RightAngle Event Log, when logging the retrieval information, the username of the TRS service account was being logged rather than the X-RA client user. This has been resolved.
Bug: 1701
When focus was placed in the Search bar and the user began typing, the text would not show up for a couple seconds. This was caused by the system performing an “expand all” of all report folders. The order of operations has been changed slightly to help with this user interface.
Bug: 1702
The comparison operators (“contains”, “equals”, “begins with”, etc.) were difficult to see against the dark background when using a dark theme. The color of the text has been changed to one that works well with light and dark themes.
Bug: 1741
The error message that the LocationID is not valid in the display style was occurring when a value conversion could not take place. This has been corrected on known reports and will not prevent retrieval of other reports should it exist on other reports.
Bug: 1407
The 'Cancel Report' button was changing back to the 'Refresh Report' button before all the rows were painted into Excel. Now, the 'Cancel Report' button remains on the screen until the last row is painted into the Excel table.
Bug: 1500
Selecting all the rows in a parent report returned 0 rows in the child report. The appropriate rows are now displayed in the child report when all the rows are selected in the parent report.
Bug: 1501
When Security by Internal BA is on, navigating to child reports now works correctly, only pulling back rows in child reports base on BAs.
Bug: 1509
When a row on a parent report was sorted, an error was thrown. This has been fixed. When a column on a parent report is sorted, any row selections are now removed.
Bug: 1518
When X-RA retrieved 0 rows, the header indicated that 1 row had been retrieved. This has been resolved.
Bug: 1466
Criteria dropdowns that contain large amounts of data were taking too much time to open. Dropdowns now use virtualization to display the data in the dropdowns, which will allow the dropdowns to open without loading all of the data within them first.
Bug: 1388
When formatting changes were made on a retrieved X-RA report, those changes were lost after subsequent retrievals. Formatting changes, as well as filtering, conditional formatting, and sorting changes in Excel are now persisted between retrievals.
Bug: 1402
Reports not opening when double clicked
Occasionally, reports were not opening when the user would double click a report title in the "RA Report Launcher". Reports will now open when they are double clicked.
Bug: 1405
Opening the add-in on a new sheet was causing the loading screen to leave before the report launcher loaded, thus displaying the "You do not have access to any reports" message to appear. The message will now only appear when a user truly does not have access to any reports.
Bug: 1408
Reports with a time on the end date in the criteria were only retrieving records to 11:59 AM and not PM. This was due to a time zone issue and has been corrected to 11:59 PM.
Bug: 1435
When security was enabled, the users were unable to see any reports in the launcher because the reports were not being filtered properly. The appropriate reports are now visible for all users.
Bug: 1451
An error was displayed when the user attempted to save Contact and User Maintenance after adding the "X-RA License" attribute. Contact and User Maintenance now saves correctly.
Bug: 1175
When using a “Dark Gray” or “Black” MS Office theme, the X-RA icons were not adjusting their color properly. New icons were created that adjust correctly with the different Office themes.
Bug: 1404
When attempting to render the criteria for Search Deal Details, it would take a long time to load due to a timeout when attempting to retrieve the PriceCurveComboBox datalist. The time for loading Search Deal Details is now the same as loading any other report.
Bug: 1224
In the Report Launcher, the user had to click directly on the report name in order to open a report. Now the user can click anywhere on the line of the report name.
Bug: 1264
When attempting to open the ‘Search Tax Licenses’ report, an error message was displayed, and the report was not opened. The report now opens successfully in X-RA.
Bug: 1408
There were a few reports (for example, Search Accounting Transactions) that were using time zones when passing the End Date time to the Triangle service. Time zones have been removed when passing data and now all reports use 11:59:59 PM.
User Story: 68
User Story: 76
User Story: 77
User Story: 189
User Story: 549
User Story: 1937
User Story: 577
User Story: 860
User Story: 867
User Story: 901
User Story: 1758
User Story: 76
User Story: 77
User Story: 557
User Story: 577
User Story: 860
User Story: 1902
User Story: 19
User Story: 68
User Story 76
User Story: 77
User Story: 576
User Story 577
User Story: 901
User Story 1092
User Story: 19
Add the ability to define a report as a favorite and appear in a favorites folder.
User Story: 1505
Implement a new approach for handling Security by Internal BA.
User Story: 1508
When moving from tab to tab, the 'Refresh Report' button is sometimes grayed out momentarily.
User Story: 1511
If an error is displayed on a parent report, the error should be cleared once error is no longer relevant.
User Story: 1512
To accommodate users who would like to see report views created from editable reports, make editable reports (and the IRD) available in X-RA.
Bug: 1281
Opening or closing tabs in a group in a particular sequence causes tab coloring errors.
Bug: 1306
Using the ‘Ctrl’ key in a particular sequence causes data to not display in a child report.
Bug: 1407
The ‘Cancel Refresh’ spinner stops when the data rendering onto the sheet begins.
Bug: 1500
Using 'Ctrl' + 'A' to select all rows in a parent report returns 0 rows in the child report.
Bug: 1501
Selecting rows in a parent report in a particular sequence displays the following error: "TypeError: Cannot convert undefined or null to object".
Bug: 1509
When a child report is open, sorting certain rows on the parent column causes an error in X-RA.
Bug: 1518
A retrieval that results in 0 rows being retrieved displays that 1 row was retrieved in the report's title row.
Bug: 1281
Opening or closing tabs in a group in a particular sequence causes tab coloring errors.
Bug: 1306
Using the ‘Ctrl’ key in a particular sequence causes data to not display in a child report.
Bug: 1407
The ‘Cancel Refresh’ spinner stops when the data rendering onto the sheet begins.
Bug: 1466
Criteria dropdowns that contain large amounts of data take too much time to open.
User Story: 45
Give the user the ability to change how the criteria item is compared in X-RA.
User Story: 1498
When a child report is open, highlighting and bolding are causing some fields to display as "#######".
User Story: 1514
Display meaningful data about X-RA retrievals that can be consumed by customers.
User Story: 634
Add the ability to apply currency conversion to an X-RA report where it is available.
User Story: 315
X-RA report tables will be formatted the same way as they are in RightAngle report views.
User Story: 19
Add the ability to define a report as a favorite and appear in a favorites folder.
User Story: 1423
Adding the ability to track information about X-RA retrievals.
Bug: 1402
Opening reports in a particular sequence causes reports to not open.
Bug: 1405
The loading animation disappears when Add-in is opening in a particular order.
Bug: 1407
The ‘Cancel Refresh’ spinner stops when the data rendering onto the sheet begins.
Bug: 1388
Changes to formats are lost after user re-retrieves data.
User Story: 315
X-RA report tables will be formatted the same way as they are in RA report views.
User Story: 1406
Experiment with writing the X-RA rows in batches to ease the burden on Excel.
User Story: 45
Give the user the ability to change how the criteria item is compared in X-RA.
Bug: 1306
Using the ‘Ctrl’ key in a particular sequence causes data to not display in a child report.
Bug: 1281
Opening or closing tabs in a group in a particular sequence causes tab coloring errors.
User Story: 634
Add the ability to apply currency conversion to an X-RA report where it is available.
User Story: 19
Add the ability to define a report as a favorite and appear in a favorites folder.
.svg)
.svg)
