Create portfolio reports to aggregate project data across your portfolios or Control Center programs. Choose specific templates from each portfolio or program blueprint.
USM Content
Portfolio reports let you pull data from project templates across one or more portfolios or Control Center programs into a single report. Use them to compare progress, surface trends, or track work across your entire project landscape.
Create a portfolio report from a portfolio
You must be a Portfolio Admin or Program Lead to access the option to create a portfolio report. You also need access to all relevant portfolios or programs, blueprints, and templates.
- In your portfolio, select Add to portfolio.
- Choose Report > Row Report.
- Choose Select sheets or go to Source data > Select sheets in the toolbar to pick your source data.
- In the Select source sheets window, select the portfolio that contains your source sheets. Use either the Current portfolio or the All portfolios option to find your template sheets.
- Under Projects included in report, choose to include active projects, archived projects, or both.
- Select your source sheets and follow the instructions to complete your report. Learn how to create a report.
When using portfolio templates, the report shows only active projects.
You can include templates from different portfolios, blueprints, and programs to create cross-portfolio or cross-program reports.
Create a portfolio report from a workspace
To create a portfolio report from within a workspace:
- In your workspace, select Add to workspace.
- Choose Report > Row Report.
- Choose Select sheets or go to Source data > Select sheets in the toolbar to pick your source data.
- In the Select source sheets window, use the All portfolios option to select the portfolio that contains your template sheets.
- Under Projects included in report, choose to include active projects, archived projects, or both.
- Select your source sheets and follow the instructions to complete your report. Learn how to build a report.
Things to consider
- Each time you run the report, it reflects the current state of your portfolios and programs. The report only returns project sheet instances that match the filters you defined. For example, if you configure the report to show only active projects, archived projects don't appear.
- The report's Columns, Filter, Group, Calculation, and Sort controls use column information from the templates, not the underlying project sheets.
- You need to share the report and the underlying sheets with anyone who needs access to the report.
- To duplicate the report, select the File menu next to the report name, and then select Duplicate. This creates an exact copy of the report, which you can then edit to change the templates in scope or other settings.
Delete and archive templates, portfolios, programs, and projects
- When you delete or archive a project, the report scope automatically updates to remove the associated project sheets based on the project status filter.
- When you delete or remove a template from a blueprint or a project template from a portfolio, you can't select it anymore, and the report updates to remove the associated projects.
- Deleting a blueprint removes its associated projects from the scope.
- When you delete a portfolio or program, the associated projects are removed from the scope, and you can't select them anymore.