ReportMagic 3.8

New Features

PowerPoint enhancements

  • Macros in the Notes field are now processed
  • [Shape.Format:] macro supports various shape manipulations via shape text or shape alt text

Macros

  • [Xlsx.Embed:] macro lets you embed the output xlsx in your DOCX report output
  • [Convert:] can convert to or from base64
  • [File.Embed:] macro embeds a PPTX or XLSX file in your DOCX report output  
  • [List.Table: convertToWebLink=true] creates clickable links for any items that start with http:// or https://
  • [Meraki.ReportXXX:] macros were removed as these relied on unsupported Meraki data

    Improvements

    • Up to 10x generation speed improvements
    • [Jira.IssueLastCommentProperty:] now renders images
    • [Jira.InsertMarkup:] correctly orders multiple images, can insert different image file types
    • Better error message when a Jira macro fails due to authorisation issues
    • [LogicMonitor.DeviceGroupList:] supports the calculate parameter

    Help Improvements

    • RM Script help / documentation
    • Updated help and examples for macros:
      • [File.Csv.Row:]
      • [File.LoadList:]
      • [File.LoadObject:] 
      • [If:]
      • [Jira.IssueCommentList:]
      • [Jira.IssueResponseTime:]
      • [Jira.TimeInState:]
      • [LogicMonitor.DeviceList:]  
      • [List.GroupBy:]
      • [List.SummaryValue:] 
      • [LogicMonitor.Graph:] autoScaleYAxisLabelsAreData parameter
      • [LogicMonitor.SummaryValue:]
      • [LogicMonitor.SummaryValueList:] all supported aggregations are now shown
      • [Object:]
      • [Sql.Analysis:] 

    Bug Fixes 

    • Changing the Role on a Role Permission no longer gives an API error
    • Schedules that write to an SFTP location work without error and also create dated output folders correctly
    • Variable names can now end with json when using property/properties=AllAsJson without causing double json tags in the output

    Fixed Macros

    • [Calculate: format=String] now correctly formats as a string
    • [Delete:] macro with type=nextParagraph now works in Report Studio
    • [ForEach:] macro with multiple iterations no longer causes formatting issues in Report Studio
    • Macros within [Ignore:] / [EndIgnore:] when used in Report Studio no longer execute under any circumstances
    • [IssueCommentList:] and [List.Complement:] orderDirection parameter fixed
    • [Jira.IssueCommentList:] and [RepeatRow:] are no longer unexpectedly duplicated when working with Legacy and Normal mode in the same document
    • [Jira.IssueResponseTime: format=String] macro now correctly formats output
    • [Json.List:] in Normal mode now correctly reports variable contents in the Macro Variables pane
    • [List.GroupBy:] indicates that with Legacy mode you should use 'GroupByColumnIndicates' not 'GroupByObjectProperties'
    • [List.SummaryValue:] macro gives correct results when using PercentConditionMet aggregation
    • [List.Table:] can be used with a list of lists in Legacy Mode
    • [List.Table:] can use the header parameter to add headers to a table
    • [LogicMonitor.AppliesToFunctionList: property=InstallationMetadata] no longer returns null
    • [LogicMonitor.EventSourceGroupList:] no longer has any mandatory parameters
    • [LogicMonitor.PercentageAvailability:] when a NaN (divide by 0) is encountered, now gives 0%
    • [LogicMonitor.RoleList:] and [LogicMonitor.UserList:] macros now work correctly following a LogicMonitor.Api update to 3.138.38 
    • [LogicMonitor.SummaryValue:] and [LogicMonitor.SummaryValueList:] do not error when using two PercentConditionMet aggregations as long as they use the 'as XYZ' naming convention
    • [LogicMonitor.SummaryValue:] and [LogicMonitor.SummaryValueList:] do not create duplicate warnings in Legacy mode
    • [Meraki.NetworkDeviceList:] macro no longer returns a 404 error when no devices are present in a Meraki network
    • Macro Variables now show correctly in the User Interface
    • [MicrosoftGraph.Connection:] macro no longer states name parameter is unused when it is used
    • [Meraki.Connection:] macro no longer states name parameter is unused when it is used
    • [ReportMagic.ReportConnectionSummary:] macro shows a macro error for unsupported types
    • [Sql.Analysis: addTitle] parameter works as expected
    • [String:] macro correctly uses late evaluation in Normal mode to insert a value
    • [Switch:] macro now recognizes backtick-protected values


    Comments