May 2025 Official Release (5.0.0.82)

What's New
1

We are very excited to announce many new additions to ReportWORQ! Be sure to register for our webinar showcasing our new features! See the patch notes below for specific details.

5.0.0.82 - 05/05/2025

Passed 1309 Integration & Regression Tests

This release’s new PowerPoint and Reporting features will be showcased in a webinar on June 4th. Please register for the webinar below or contact us through https://reportworq.com for an earlier demonstration.

https://register.gotowebinar.com/register/1777086114801063518

New PowerPoint Addin

A new Office 365 PowerPoint Add-in is now available. This add-in is designed for ReportWORQ Administrators to create PowerPoint template files. Additionally, recipients can use it to refresh the contents of a PowerPoint presentation that is linked to a ReportWORQ job. New licensing options are also available for PowerPoint end users to utilize this add-in.

New Excel Reporting Addin

The ReportWORQ Office 365 Excel Add-in has been enhanced to include a new report writer experience. This feature allows users to connect to and report on data from various relational and API-based data sources. New licensing options are available for Excel users to access the Reporting add-in.

Known Issues

There is a known issue with this release’s latest version of Aspose. Jobs that use the RWSQL formula and are configured to import data into an Excel Table that contains a calculated column will generate #N/A values when processed by ReportWORQ. A hotfix will be released for this as soon as it’s available.

Enhancements

  • Authentication Administration now allows users access to Contribution, Reporting, and PowerPoint End User access (license required).
  • The Address Book now displays entries for users configured in the Authentication Administration screen.
  • New Datasources: SQL Server ADO.Net (native driver), DataBricks
  • Added support for using parameters in a PDF Table of Contents root title.
  • New RWREMOVEFORMULA formula can be used to remove formulas from a worksheet.
  • Improved Data Collection performance with unstable TM1 connections.
  • Improved support for Adaptive Expansions suppression.
  • Performance improvement for IBM Planning Analytics reports that contain multiple Active Forms (a.k.a. Dynamic Reports).
  • Cube monitoring support for parameters with commas.

Contribution Enhancements

  • Contribution User Management has moved from the Address Book to the Authentication Administration screen.
  • Enhanced RW.FILTER formula in Webview and Excel add-in.
  • Add support for Grouping (Expanding/Collapsing) rows and columns.
  • Added support for assigning multiple Contributors to one input form.
  • Added the ability to undo/redo in Contribution Input forms.

Fixes

  • Fixed issue using a leading “-” in a Contribution input cell.
  • Fixed issue locking the server when viewing large-sized logs; the viewable part of the log is now truncated, and the log must be downloaded to view in its entirety.
  • Fixed rendering issues with large input forms.
  • Fixed issue where conditional formatting was not rendering correctly.
  • Fixed issue where Repository Report creation failed when a source report provider was missing.
  • Fixed issue using RANK function in Excel.

Below are the patch notes for the April release in case you missed them.

5.0.0.81 - 04/01/2025

Passed 1327 Integration & Regression Tests

Enhancements

  • Added ability to filter available sites in the SharePoint Report Provider.
  • Added feature allowing the Workspace name to appear in the Browser tab name.
  • Added Global variable support for Planning Analytics MDX queries and SQL queries.
  • Added Test Query support for parameters that reference other parameters.
  • Added External text file support for Schedule filter lists.
  • Added the RWMDX formula to support source workbooks containing MDX queries.
  • Added the ability to produce a single zip file when combining emails and zip Files.
  • Added the ability to set which job email should be used when combining emails.
  • Added support for IBM Planning Analytics DefineCalc and TM1SET formulas.
  • Added an SFTP Distributor option.
  • Added support for Excel Sparklines.

Contribution Enhancements

  • Added support for Excel Sparklines.

Fixes

  • Improved Contribution Dashboard progress for larger input forms.
  • Fix for Contribution form row border height causing image placement issue.
  • Fixed issue rendering Workday Adaptive currency labels in ReportWORQ output.
  • Fixed issue with SharePoint folder selection dialog freezing.
  • Fixed with very long parameter names overlapping into adjacent fields.
  • Fixed issue with Data Collection UID duplication.