This feature is a part of Report Packages in the R365 Financial Report Writer. Click here for more information about Report Packages and the R365 Financial Report Writer.

In the Package Editor form, Reports and Documents can be grouped together as a sub-grouping, or Report Group. These Report Groups are used to properly order Reports as a group per Org Unit selected or per the selected Repeat Value when the Package is ran. Even though a Report Package may have one or more Report Groups, not all Reports and/or Documents need to be included in a grouping. Additionally, Report Groups can be edited at any time to better reflect reporting needs.

Note: This feature is only available to Channel Partner Users at this time but is currently being prepared to make available to all Users. 

Create a Report Group

One or more Report Groups can be created for each Report Package from the Package Editor. To open the Package Editor form, navigate to the Report Packages listing and click 'Edit' next to the desired Package. 

From the Package Editor, select all desired Reports/Documents in consecutive order and click the 'Group Reports' button. This will create a new Report Group.

  • Note: Multiple Report Groups can be created, but not all Reports and/or Documents need to be included in a Group.

The Report Group will appear just above the selected Reports and/or Documents. From here, the title can be viewed and manually updated if desired and then should be saved by clicking the 'Save' button listed next to the Report Group name. Once saved, the Report Group can be reordered, renamed, or ungrouped, if needed, as mentioned in the 'Edit a Report Group' section below. 

Ensure to save the changes made via the 'Save' menu in the top ribbon before closing the Report Editor.

Select Report Parameters

In navigating back to the Report Packages listing, ensure that each Report and Report Group has the desired Report Parameters set. 

When running a Package that contains a Report Group, the Report Group is treated like a typical Report, meaning that the Group can be ran based on Org Structure selections or set to Repeat. For example, if a Package has 3 individual Reports that are not grouped together and each Report is set to Repeat By Location, then the Package will be ordered to show the first Report for each Location, then the second Report for each Location, and finally the third Report for each Location. By grouping these same Reports together in a Report Group and set the Group to Repeat By Location, all three Reports will be ran for the first Location, then all three Reports will be ran by the second Location, and so on.

A common Package setup might contain those 3 reports as individual Reports that will run as Consolidated Reports and then the same 3 Reports again but grouped together so that the resulting Package contains Consolidated versions of the Reports followed by the same Reports repeating at a more detailed level.

  • Note: A Document included in a Report Group will act the same as a Report and will run for each unit in the selected parameter.

Edit a Report Group

Report Groups can be edited as needed to reflect reporting needs. Editing functions include:

  • Rearranging Reports/Documents
    • Reports/Documents within a Report Group can be rearranged by clicking the Move iconnext to the desired line item and dropping where desired

    • Reports/Documents can be added or removed from a Report Group by clicking the Move iconnext to the desired line item and dropping the Report/Document either within or outside of the Report Group, respectively, of the Report Group

  • Removing Reports/Documents
    • Reports/Documents can be removed by clicking the trash can iconat the end of the desired row

    • At least two Reports and/or Documents must be included in a Report Group at a time. If one of two Reports/Documents remains after attempting to remove the other, an error message will appear and the Report/Document will be returned to its Report Group

  • Editing or Removing a Group
    • Report Groups can be renamed by clicking the Edit iconor removed by clicking the Ungroup iconnext to the desired Report Group