By utilizing the Consolidated Report functionality, multiple separate reports and charts within SAP Fieldglass can be combined into one Microsoft Excel workbook with each of the individual reports on separate tabs. This can be beneficial when building custom dashboards, workbooks, and reporting suites that utilize multiple separate, yet related, reports at the same time.
Building Consolidated Reports
Objective
After completing this lesson, you will be able to demonstrate how to combine multiple reports into a single Consolidated Report workbook output.
Consolidated Reports
Create a Consolidated Report
Brian, the Program Manager for WorkingNet Networking Inc., a manufacturer of data networking equipment, decides that since his team consistently uses the same four reports each week to monitor program performance, it would be easier to create a Consolidated Report that combines them into a single report suite workbook that automatically delivers to their inbox each week.
As the SAP Fieldglass administrator for WorkingNet, you are tasked with creating this new Consolidated Report.
Summary
This lesson explains how to create a Consolidated Report in SAP Fieldglass to combine multiple reports into a single scheduled Excel workbook.
- Consolidated Report: combines up to six reports/charts into one Excel workbook, each on separate tabs, ideal for dashboards and report suites.
- Add up to six desired reports, reorder tab sequence by dragging, and optionally edit per-report filters.
- Schedule required: Consolidated Reports only run via schedules; set frequency, delivery format, recipients, and start time.