ReportMagic 3.2

Overview

ReportMagic 3.2 is here!  We have lots of macro improvements for you, and even a few new ones.  A few minor bugs have been fixed and we have tweaked the UI in a few places to make it easier to use.  A improved Agent is available and there are some RM Script improvements.

Here are the details:

Training and Certification

Our Certification System is now live. You can take an exam and become a Certified ReportMagic Professional. Exams:
  • Are free to all customers to sit or resit 
  • Can be taken any number of times, with a cool-down period in between attempts 
  • Your certification will stay valid for 12 months at the highest grade attempt you have achieved 
If you display your ReportMagic Certified Professional status on your LinkedIn profile, email us for some free goodies.
 
To take a certification:
  1. From your Profile Page, click My Certifications.
  2. Expand About the Certifications to read about the currently available certifications.
  3. Click New Certification Attempt and choose the required certification to begin taking the exam.
  4. Answer the questions then click Submit.
    You are told instantly whether you have passed or failed.  

New Macros

  • [Agent.Property]: macro returns information about the version and connection to the ReportMagic Agent
  • [MicrosoftDataverse.EntityDefinitionsList:] which maps Microsoft Dataverse definition values (numeric) to their associated label (string)
  • [ReportMagic.SystemProperty: ] macro which returns the current Global Setting for System_BaseUrl and System_Name 

Improvements to Macros

  • All macros that support find and replaceWith now also support regexFind and regexReplaceWith
  • All graph macros allow you to set marker style for each line in a chart series
  • [ForEach:] and [RepeatRow: ] macros now support the columnDelimiter property
  • [File.Image:] macro (and other image macros) now support imageWidthCm and imageHeightCm parameters for absolute sizes in Word and HTML
  • [Jira.UserList:] now avoids duplicate items, its property parameter is now optional and it has an additional propertyDelimiter parameter
  • [List.Count:] macro now respects the skip and take parameters and will also now convert numerical values corrrectly when performing a string comparison
  • [LogicMonitor.AlertList:] and [LogicMonitor.InstanceList:] macros now support multiple properties 
  • [Object:] macros have more Help examples
  • [ReportMagic.ReportBatchJobList:] and [ReportMagic.ReportJobList:] works in line with the reporting period restrictions
  • [ReportMagic.SetReportProperty:] macro now supports property=outputSubFolder
  • In the StoreAsHidden parameter, when assigning a value to multiple variables, blank variable names are now ignored
  • [Salesforce.List:] macro now supports .Name and .attributes.type and .attributes.url properties
  • [Table.Save:] macro now honours the borders and sizing provided by the Word table, when saveAsExcelTable is set to false. Cell widths are honoured for single lines (not dashed, dotted, etc.)

Bug Fixes 

  • Fixed an issue with [File.Image: wrapping=BehindText]
  • Fixed a transient error for [List.Graph:] macro
  • Fixed an issue that was causing Batch Jobs to be shown in a Pending state upon the update of a 
  • report schedule Cron definition
  • Fixed an issue with [LogicMonitor.DeviceCount:] and [LogicMonitor.DeviceList:] where they would sometimes return only 300 devices
  • Fixed an issue where it was possible to save a Schedule with an empty CRON when it was set to run at a set time
  • It is now once again possible to create folders in a SharePoint connection's root folder location
  • [LogicMonitor.Forecast:] help examples were corrected
  • Breaking Change: Fixes to Salesforce macro DateTime formats - a new parameter must be used to return date/times in the previous format.
  • Breaking Change: Fixes to Dataverse macro DateTime formats - a new parameter must be used to return date/times in the previous format.
  • Breaking Change: [+:] and [-:] macro shorthands now require the by parameter to be explicitly used if a value other than 1 is applied.

User Interface Improvements

  • On the Connections page, Admins can now search by ConnectionType
  • The Schedules page now shows the status of active Batch Jobs
  • The Schedules page provides the ability to delete multiple selected Schedules
  • The ReportBatchJobs page now shows the status of active Report Jobs
  • The Report Jobs page is now accessible directly from the Schedules and Batch Jobs pages with new functionality depending upon what is selected
  • The Progress page reports correct counts for Report Job System Errors and Macro Errors
New Agent
  • The ReportMagic Agent now uses the ReportMagic API, and you must upgrade.  Those customers using the Agent have either already been upgraded, or we have already agreed an upgrade plan with you.
  • You must now manually add Agent Connections and the installation / upgrade instructions have been updated.

RM Script improvements

  • RM Script now supports multi-line parameter values
  • RM Script is now more strict about how multi-line macros are interpreted.  We have upgraded any affected scripts for you, so no action should be required on your part.

Comments