New Features (6)

Ticket Severity Summary Notes
MS-22322 Critical Add a [Table.MergeRows] macro Added the [Table.MergeRows:] macro that works with Word and HTML (or Report Studio) input documents.
MS-20006 Major Connection stats should be available in reports - new macros required Connection Stats can be queried by [MagicSuite.ConnectionList:] and [MagicSuite.ConnectionProperty:]
MS-23430 Major New macro parameters required: expected type and expected result expectedType and expectedValue parameters are now available to assist in testing and debugging efforts.
MS-16773 Major Files browser should provide the ability to download a zipped selection of files and folders The ReportMagic Files browser in the Files page now allows files and folders to be downloaded as a ZIP archive file. This applies to 'local' file systems only, i.e. not from cloud / remote system like SFTP or Azure).
MS-22060 Major [While:] loop macro New [While:] / [EndWhile:] macros enable condition-based looping in templates, repeating a section as long as a condition remains true. Supports [Break:], [Continue:], nesting, configurable iteration limits, and works across RmScript, Word, and HTML documents.
MS-21190 Minor Macro Help: parameter tables in the Help should split inherited parameters into a separate, collapsible table Parameters in the macro help documentation are now organised into two clear sections: parameters specific to the macro and inherited parameters from the base macro. Each section shows a mandatory parameter count badge, and a warning appears when mandatory parameters exist in the inherited section so they are not overlooked.

Improvements (13)

Ticket Severity Summary Notes
MS-23309 Major Report Library: Report Group Description should be displayed The Report Group description is now displayed (if present for a group) in the Report Library.
MS-23431 Major Show help should be clearer on Report Studio "Insert" Macro popup Restyled help icon/button on the Report Studio insert macro popup.
MS-23443 Major Report Studio "Insert macro" pop-up should provide direct links to the Docs app for each macro The macro examples pop-up in Report Studio now includes links to the Docs app help for each macro.
MS-23468 Major Doc/Help: MagicSuite macros help should not have ReportMagic examples Macro help in ReportMagic and the Docs app for the [MagicSuite.xxx:] macros now have the correct syntax in the examples, rather than the now-deprecated [ReportMagic.xxx:] versions (which still work but generate a warning).
MS-23289 Major Add page grouping to Progress Page for large reports Progress Page now groups macro pages when there are more than 25.
MS-23901 Major Library Reports: [LogicMonitor.ResourceAnalysis:] macro parameter override requirements for QA LogicMonitor Library Reports have been modified to use the [LogicMonitor.ResourceAnalysis:] macro in favour of the deprecated [LogicMonitor.DeviceAnalysis:]. These reports now detect non-production environments and override a Warning outcome to Success for the [LogicMonitor.ResourceAnalysis:] macro.
MS-23268 Major Progress Page: Right-hand scroll bar should not scroll the left-hand macro execution pane Improved Progress Page layout and scrolling behaviour in Report Studio and in the Batch Progress page.
MS-23333 Major Add retry interval and total timeout cap to [Database.XXX:] macros Added the 'maxTotalTimeoutMs' and 'retryIntervalSeconds' parameters to the [Database.XXX:] macros, to provide better control over timeout scenarios.
MS-23353 Major Macro parameters table (Docs app and in Report Studio help) should be grouped Parameters in the macro help documentation are now organised into groups
MS-23274 Major Macros that send emails that fail (notification = system error) and where the macro becomes macro error - should have an indication on the macro itself why the notification failed to send When an email macro's notification (the sending of the email) fails, the macro's output text is updated to append the failure reason / message so it's clearer to the user why it failed.
MS-23294 Minor [List.Count:] help should have extra examples for itemAtIndex Added an additional help example to the [List.Count:] macro.
MS-23293 Minor [List.Where:] help should have extra examples for itemAtIndex Added an additional help example to the [List.Where:] macro.
MS-23761 Trivial ReportMagic: Fix casing and naming inconsistencies on Batch Progress page and Rerun dialog Improved casing of various "Re-run" texts (dialog headings, etc.). The "Re-Run Pop-up" button label is now "Re-run Options" on the Progress Page.

Bugs Fixed (68)

Ticket Severity Summary Notes
MS-23643 Blocker PowerPoint shape and formatting macros should work as expected PowerPoint macros (e.g. [Shape.Format:] and [Shape.Add:]) now work as expected.
MS-23582 Blocker [Graph.XXX:] macros (e.g. [Graph.Update:], [Graph.AddData:] etc.) should work [Graph.XXX:] macros (e.g. [Graph.Update:] now work correctly again.
MS-23506 Blocker Azure Blob Storage should be able to overwrite files in output location Fixed an issue where Schedules could not overwrite output files in Azure Blob Storage file systems.
MS-23630 Blocker The xAxisType=String parameter should work as expected for all [xxx.Graph:] macros (4.1 fix) All [xxx.Graph:] macros now correctly display the x-axis labels when xAxisType=String is used.
MS-14969 Blocker The [LogicMonitor.DeviceList:] macro should return results for deviceGroup with brackets in the name Updated LogicMonitor.Api to version 3.188.21 to fix an issue where the [LogicMonitor.DeviceList:] macro could fail when device groups contained parentheses.
MS-23479 Blocker The Save feature should work as expected in Report Studio Report Studio file save issues fixed. Other related bug fixes and improvements in Report Studio related to file restore.
MS-23602 Blocker The [Shape.Format:] macro should work as expected in Word input documents [Shape.Format:] macro now works as expected when used with Word input documents.
MS-23444 Critical Various [List.xxx:] macros should not generate a macro error when filtering mixed-type lists Fixed an issue where the [List.Where:] and other [List.XXX:] macros would throw a FormatException when filtering mixed-type lists (e.g. integers and strings), causing a macro error rather than the correct result (output / variable) with the new list.
MS-23574 Critical Schedules which use GitHub should not intermittently give a system error GitHub Schedule now do not produce System Errors internittantly when running and getting the files
MS-23498 Critical Unsaved changes dialog should not pop-up when there are no changes in Report Studio [not easy to reproduce] Fixed an issue where sometimes the unsaved changes icon / dialog might show in Report Studio even if there were no changes.
MS-23497 Critical Files page toolbar buttons should be in the correct order Toolbar buttons are now always in the correct order in the Files browser.
MS-23528 Critical Files: Should be able to copy/move a file from RM filesystem location to Azure Blob Storage filesystem It is now possible to copy local file system files to Azure Blog Storage folders, without an error.
MS-23720 Critical The [LogicMonitor.DeviceCount:] macro should not fail with deviceGroup parameter when the device group has parentheses in the name Fixed various LogicMonitor macros that were broken in 4.2 (but not released) for device groups that contain parentheses, due to changes in the LogicMonitor API.
MS-23779 Critical Regular users should be able to view feedback in the dialog on My Feedback page without an error pop-up Fixed an issue where regular users (i.e. not Tenant Admins or above) could not view the feedback details (in the pop-up) due to a forbidden error.
MS-23782 Critical Schedules page should not show error popup for regular users Fixed an issue where ALL regular users would see an error pop-up on the Schedules page (saying "Forbidden") in regards to loading DataMagic Sync Chains (which requires a minimum of Tenant Admin access).
MS-23261 Critical [List.Table:] macro should preserve distinct cell values when columns have duplicate header names Fixed an issue where the `[List.Table:]` macro produced incorrect data when multiple columns had the same header name. Previously, all columns with duplicate headers would display the value from the last column only; each column now correctly retains its own data.
MS-23529 Critical Report Studio: Various Macros: clipRight/clipLeft/clipTop/clipBottom should clip as expected Fixed broken clipping and MIME type on Report Studio images.
MS-23756 Critical Schedule with form: Run menu should not hide behind Report banner Fixed an issue in the progress page where the Run menu (on ha Schedule with a form) could appear hidden beneath the "Reports" title bar, when the button was clicked.
MS-24128 Critical [MagicSuite.ReportJobCount / List:] macros should not fail with a system error (4.2 fix) Fixed a performance issue in count macros where counting items (like Report Jobs) was unnecessarily slow. Count operations now use an optimized API endpoint that returns the count directly, rather than fetching all the data first. This makes count macros significantly faster, especially when counting large numbers of items. Users will notice faster execution of macros that count items, such as [MagicSuite.ReportJobCount] and similar counting operations throughout the application.
MS-23463 Critical Malformed [.:] macro should produce a macro error (not system error instead) and should not stop subsequent macros being processed Fixed an issue where invalid calculate macro shorthand would cause a system error and stop processing any more macros.
MS-23601 Major PPTX: [List.Graph:] and [Variable.Image:] should give the correct error message when using clipXXX parameters with unsupported chart image types Using unsupported (anything other than jpeg/png) images in PowerPoint macros with clipping parameters now generates the correct macro error with the explanation (documentation already states you must manually set chartImageFormat parameter when using clipping in PowerPoint), rather than a not meaningful error message.
MS-23522 Major [List.Where:] macro should not fail to filter numeric values from mixed-type lists Filtering mixed-type lists (containing both numbers and strings) now works in both directions - you can filter for numeric values like value == 100 or string values like value == 'banana' without errors. Previously, filtering for numbers when strings were present in the list would cause a "not in a correct format" error.
MS-23517 Major [Table.Graph:] Help example should not have superfluous '}' character on labelText parameter in example 3 Removed superfluous curly brace in example #3 of the [Table.Graph:] macro.
MS-23575 Major "Chained Schedule" field should be present and usable in create/edit/clone dialogs Fixed broken chain capability when a DataMagic Sync would chain to a schedule.
MS-23454 Major The Report Magic files page should have a Download button in the toolbar Added a Download button into the Files page toolbar in ReportMagic. Previously, it was only accessible from the right-click context menu.
MS-23134 Major Azure Blob Storage: upload/new file should be disabled at root level (root can only contain containers) The New FIle button / context menu and toolbar button is now disabled for the root (container) of Azure Blob Storage, which does not allow for creation of files, only containers.
MS-16818 Major [LogicMonitor.AlertCalendar:] should not give an unexpected system error Fixed broken [LogicMonitor.AlertCalendar:] macro.
MS-23539 Major [MagicSuite.ReportBatchJobProperty:] examples 3, 4 and 5 should be updated Updated the [MagicSuite.ReportBatchJobProperty:] macro examples for the help/docs.
MS-23606 Major [Graph.AddData:] fillColor=Yellow should fill a line on Line or Radar charts The [Graph.AddData:] macro now properly updates the series colours for line and radar charts, if the fillColor parameter is set. Markers (if present) are also set to the colour specified.
MS-23390 Major [List.Where:] help Example 1 should not error Fixed broken example number 1 for the [List.Where:] macro.
MS-23297 Major Batch Progress Page: deep linking - report job, macro page and macro index should work properly on F5 / going to a deep link URL Fixed an issue where the Progress Page deep link mechanism was not working as expected.
MS-24096 Major Macro feedback for: /*# format()**What this file demonstrates**Example 13 for format().**Source**PanoramicData.NCalcExtensions README.md**Expected result**'2020-03-13 12:00'*/format(theDateTime, 'yyyy-MM-dd HH:mm', 'Eastern Standard Time ... Fixed the format 13.ncalc test in the Library examples folder so that it provides all of the expected parameters for the format function under test.
MS-23713 Major ReportLibrary: Meraki report output folders should be in the /Library Report Output/Meraki/xxx folder Meraki reports from the Report Library now sets the output folders in the /Library Report Output/Meraki/xxx folder 
MS-23534 Major [MagicSuite.ReportMacroCount:] examples 1 and 2 should not give warning Updated the help examples for the [MagicSuite.ReportMacroCount:] macro.
MS-23531 Major [MagicSuite.ConnectionProperty:] examples 1 and 2 should not fail Fixed broken [MagicSuite.ConnectionProperty:] macro examples.
MS-19059 Major PowerPoint table text should honour fontSize directives if string contains newline control characters Fixed an issue where PowerPoint macros that inserted text containing newline characters did not honour formatting directives such as fontSize, fontBold, fontColor, and fontBackgroundColor. Previously, only the first line of text would receive the specified formatting while subsequent lines and line breaks reverted to the default size. All formatting directives now apply consistently across all lines of the replacement text.
MS-12604 Major Macros: (Report Studio only) RepeatRow should not generate System Error when skip/take leave insufficient values to work with [RepeatRow:] now does not give a system error in specific circumstances (Report Studio only)
MS-23742 Major Last Modified UTC column should not be empty for modified Schedules The Last Modified UTC column on the Schedules page is now populated again.
MS-23348 Major Schedules Import should not show invalid json types as being valid Invalid JSON types are now correctly shown as not supported in the Schedules import dialog.
MS-23346 Major Schedule/Connections Import dialog should not overwrite your selection of Schedule/Connections when altering the rename suffix Fixed an issue in the Schedule and Connection import dialogs where changing the rename suffix would unexpectedly change the selected items.
MS-21167 Major Batch Job Page: when filtering on the filterable columns the filter icons/search should show there are filters present Fix for batch jobs table in Report Magic which did not indicate which columns were active during filtering.
MS-23467 Major The [Execute:] macro should not use [ExecuteAsync:] in the examples Fixed an issue where the [Execute:] macro examples incorrectly used [ExecuteAsync:] rather than [Execute:].
MS-23537 Major [MagicSuite.ReportJobProperty:] examples 1-5 should be updated Updated the [MagicSuite.ReportJobProperty:] help examples.
MS-23535 Major [MagicSuite.ReportConnectionSummary:] example 1 should not fail when used The help example for the [MagicSuite.ReportConnectionSummary:] macro now works as expected.
MS-23533 Major [MagicSuite.Version:] help and example updates The [MagicSuite.Version:] macro now works correctly when using the allAsJObject parameter.
MS-23532 Major [MagicSuite.ConnectionStatusProperty:] example 1 should not fail Fixed broken [MagicSuite.ConnectionStatusProperty:] macro examples.
MS-21853 Major Report Studio: Switching from Rich Text to Code mode should preserve < and > symbols Report Studio: Fixed macro corruption when switching between Rich Text and Code editing modes. Macros containing < , > , or a => store-as suffix could be silently corrupted when switching modes, causing macros to fail with a parameter error. A new "Treat as plain text when switching to Rich Text" setting (Code Editor Settings, default ON) now correctly escapes < / > and preserves line breaks/tabs when moving Code content into Rich Text; turning it OFF instead renders Code content as interpreted HTML, for previewing raw HTML. Switching from Rich Text back to Code always converts correctly regardless of this setting.
MS-23616 Major Report Studio: Restore/Open Recent should not fail with FormatException when auto-saved file's original name starts with underscore Fixed an issue in Report Studio where the File > Recents or File > Restore popup dialog would fail and show an error if any recently opened files started with an underscore e.g. " myfile.rmscript".
MS-15865 Major The [Meraki.DeviceUplinkProperty:] macro should output a JObject (with names and values) and not throw an unconditional exception Reinstated the [Meraki.DeviceUplinkProperty:] macro which previously always resulted in a macro error, as it was not implemented. Now outputs a JArray of JObjects (in normal and legacy modes).
MS-23419 Major Root level Azure Blob Storage filesystem should not be allowed to be a Schedule's input or output location (multi-container mode only) In the Schedules edit/create form and the re-run report jobs dialog, choosing the root of an azure Blob Storage connection, when setup in multi-container mode, now provides the correct validation and errors shown in the UI, preventing you choosing those locations (as only Azure containers can be created there).
MS-23370 Major The Columns drop-down should persist across sessions in the Batch Jobs and Report Jobs tables Fixed an issue where changing the Columns selection in Report Magic's Report Jobs and Batch Jobs tables / pages would not remember the selection across sessions.
MS-21089 Major Macros inside shapes headers and footers of Word input documents should not be processed twice Fixed an issue where macros in Word headers and footers within shapes would always be processed twice (but the output documents were unaffected).
MS-23749 Major [LogicMonitor.InstanceCount:] Should return non-zero in Normal mode Fixed an issue where the [LogicMonitor.InstanceCount:] macro always returned 0 in Normal Mode.
MS-23577 Major [LogicMonitor.CollectorXXX:] macros should not be broken - affects LogicMonitor Health Check Fixed an issue where, depending upon the LogicMonitor API response, various [LogicMonitor.CollectorXXX:] macros would not work.
MS-23445 Major ReportMagic Release notes in the Docs app should show tickets with legacy 'ReportMagic 4' component The release notes for ReportMagic shown in the Docs app now include those small number of tickets that were incorrectly filtered out.
MS-23325 Major The .xlsx file generated by the LogicMonitor HealthCheck should not require repair when opening in Excel Fixed an issue where the HealthCheck spreadsheet file would appear corrupted and Excel would prompt for repair when opening the file. This was an undocumented Excel limit when there are more than 1024 columns in a pivot table, and the repair prompt is factually incorrect as the XML structure is fine (but there is no workaround to this behaviour). The macro was the [LogicMonitor.ResourceAnalysis:] macro (but could affect any macros that produce pivot tables, depending on the size of the data). Since this is an Excel limitation, the macro now displays a warning and the pivot table worksheet is left blank, without the corrupted file pop-up showing when the document is opened. It is possible to manually insert a pivot table, however.
MS-23329 Major Schedules created by the Report Library should have the Error Handling part properly configured When a user runs a library report and a schedule is created, the stop / notify email address is now set to the user's email, ensuring the schedule is shown as valid in the UI (even though the schedule would still run).
MS-23521 Major Progress page Track Latest should not show wrong macro page for running reports Fixed an issue where the progress page might occasionally show the wrong 'page' for running reports.
MS-23536 Minor [MagicSuite.ReportScheduleList:] example 2 should be updated so it does not error Fixed broken example 2 in [MagicSuite.ReportScheduleList:] macro.
MS-23420 Minor Magic Suite Version on Batch Job created for sending Certification pass email should not be "Unknown" The Magic Suite version is now present on the on Batch Job page and the Progress page when sending/running a Certification pass email/schedule
MS-23503 Minor Files: sort by Name should order correctly by number values Files sorted by Name now use natural sorting - numbers within filenames are compared by their numeric value, so files appear in the order 1, 2, 3, 10, 11, 20 rather than 1, 10, 11, 2, 20, 3. This applies to all file browser views across ReportMagic, Admin, and NCalc101.
MS-23660 Minor [MagicSuite.ReportConnectionSummary:] example 1 hould have a minor update Fixed the help example for the [MagicSuite.ReportConnectionSummary:] macro.
MS-23266 Minor [Web.Html:] example/s using the content parameter should be added to the help page New [Web.Html:] example added to the help using the content= parameter
MS-23347 Minor The Schedule import dialog should correctly report skipped items The Schedule import dialog now correctly reports skipped items.
MS-23509 Minor The [Email:] macro should preserve formatting More formatting is now preserved when sent via the [Email:] macro, especially in table formatting.
MS-23418 Trivial Progress Page items should retain icon on mouse over when macro occupies all available horizontal space Tweaked macro hover animation / scale on macros in the Progress Page so the icon does not disappear off the screen.
MS-23954 Trivial ReportMagic: There should be a footer on the ReportMagic landing page Trivial update to home page layout so the bottom of the content is not too close to the bottom of the browser.
MS-22958 Trivial Folders prefixed with an underscore should be ordered identically in both panes of File browser components Fixed sort order in the files browser tree views (underscores ordered first i.e. abc before abc) across all apps.

Reconnection

Reconnection

Reconnection

timed out

timed out

Attempt of

Reload
An unhandled error has occurred. Reload 🗙