ESM’s Purchase, Sourcing and Contract Repository contains several report types. This guide is an overview of how to build an Advance Report.
Advanced Reports follow the same process for Express Reports, but the layout has more options. To Create an Advanced Report, click the create button and select Advanced Report.
When the wizard pops up, enter a name for the report and select the folder you would like to store the report in. The folder determines which users can read or author the report based off the permissions assigned by the Admin users. The author can add a description of the report if desired.
Select Next at the bottom of the screen or the Categories tab to select categories.
Note: Save and Run are in the right corner of the screen and allow a user to save any changes and view an example of the report. It is HIGHLY recommended to use these functions throughout the creation process
Select the Categories that contain the desired data required for the report.
Categories are stored in Folders. As each category is selected, unavailable options are greyed out. Select the necessary category and click the add button, or double click the category name to add it. Highlight the category name and click the view button to view the data elements available. The Suppress duplicates option, if checked, will prevent duplicate fields from appearing during the creation process. The red “x” will delete the category from being assigned to the report.
Note: If the category Entity Admin is selected, the user cannot combine transactional data categories and fields with that category.
It is recommended to apply Sorts and Filters after performing tasks under the Layout tab.
Save and select the layout tab. This will allow users to add the data elements to the report. Fields can be added from the categories dropdown menu by double clicking or selecting the add button. These fields can be ordered by dragging and dropping. A standard text tool is available for stylistic elements. This type of report includes a view for formatting and editing.
Select Run to test the output of the report.
Advanced reports allow for formulas to be added to perform advanced calculation. To add a formula, select the formula button in the main menu.
The Formula Editor will prompt the user to select a cell that is appropriate for the formula.
An advanced report can include different sections including Page Headers(Titles), Report headers (Labels), Details (Data), Report Footers (Summary Data, i.e. Charts and Aggregate Sums), Page Footers (Page Numbers), Group Headers (Grouped Data Labels), Group Footers (Summary Data) and Repeating Groups.
Note: Group Headers will prompt users to select a field. This requires a sort to be added to the report.
If a user clicks on a cell number for each section, the following options can be implemented:
Insert Rows (Before or After), Delete Rows, Suppress Rows