Reports is our new and enhanced reporting module for Supplier Review Forms. It includes: filter and sort capabilities, increased performance and load time, data visualizations, the ability to create Saved Reports, and new insights around the Review Form responses from your Suppliers.
In this article, we will cover how to:
- Build Review Form Reports
- Visualization Charts
- Sort Columns
- Apply Filters
- Save Reports
- Export Reports
Building Review Form Reports
Step 1: Navigate to Reports tab
From your Pipeline home page click the Navigate button and then select Reports from the drop-down menu:
Step 2: Select Review Forms Report Type
Under Report Data, click on Dataset, then select Review Forms:
Notice that you have the ability to report on Projects, Suppliers, Milestones, Savings, Contracts and Events, and etc.
Step 3: Select your Report Fields
From the Reports page, click the Filters button in the Report Data section above or the Reports button in the Action Bar to open the Reporting side panel. You can then click the Choose Filters & Columns to select the Data Fields you would like to report on:
If you have any previous Data Fields selected and you would like to start building your Report from scratch, you can click the Uncheck All button to clear any selected Data Fields. You can then begin going through the different Data Fields and selecting the Fields you would like to include in your Report:
Note: All of the Custom Fields will appear in order of the Custom Field Groups. For example, in the image above, notice we are currently viewing the Custom Fields that are in the Default Field Group. If you scroll through the page you will find the rest of your Custom Fields properly placed under their appropriate Custom Field Groups.
Step 4: Save and Update Report
Once you have selected all of the Data Fields for your Report click the Save button:
Then click Refresh Report to make your Report reflect the changes you have made:
It is important to note that your table may not display every filter you have selected. The reason for this lies in certain fields not being selected via the Editor button:
The Editor allows us to hide or show certain fields within the table itself once we have selected our desired Filters. While in the Editor, we can accomplish other things such as rearranging columns and manipulating the layout of our table.
To view your Report in different formats, select Charts at the top of your page. Here, you will notice that you can present your Report in eight different chart formats:
Changing the Data Fields in the Editor will allow you to control what appears in your Chart. You may also add Report Filters, Rows, Columns, and Calculated Values:
For this Report, I have chosen to visualize it as a Pivot Table, which displays a visualization of the Review Form Title, Review Status, and number of Reviewers in the Review Forms submitted.
If you hover your mouse cursor over a column, you’ll notice a small arrow icon appears next to the column name. You may change the arrow direction by clicking it, which will toggle between alphabetical and reverse alphabetical order:
If you’d like to filter out a specific cell in the column, click on the small gear icon next to the column name:
This will allow you to select and deselect specific selections that you want to exclude from your Report:
To apply Filters to the Report you have built fill in the criteria you would like to filter by and again, click Refresh Report. Notice in the example below that I have filtered by Supplier Names (that are not empty), and by Category (Business Services):
Once you have applied Filters you are able to Export the Report or save the Report. Continue reading to learn how to save Reports!
Creating Saved Reports in Scout will allow you to build and save Reports so that each time you need to pull Reports you can log into Scout and you can easily view your desired Report without having to re-build it each time. Leveraging Saved Reports can help you save time with Reports that you run daily, monthly, quarterly or annually!
To create a Saved Report, select all of the columns as well as any applied Filters you would like to be reflected in your Report and then click the Save As button:
Another way to save your Report by clicking on Save in the Save & Update Report section:
Save and Update Report is useful if you’re already viewing a Saved Report. Clicking on this will save your current Report progress. Save As New Report will allow you to create and save a new Report. This will open the Reporting side panel, where you can enter your Report details.
When you are ready, enter a Report name and a Description if you wish to do so, and then click Save:
When you log into Scout next time and go to your Reports page, you can click Reports button above to view all of your Saved Reports:
This will open the Reporting side panel that will reveal if you are using a Saved View:
If you wish to Export your Report to Excel, locate and select Export from the top of your page options. Here, you will have the option to Export your Report in six different formats (Print, HTML, CSV, Excel, Image, and PDF):
After selecting your desired Export format, your download will begin immediately!
Our hope with the new Review Form Reports functionality is that you will be able to run more relevant and robust Reports to meet your teams reporting needs!