Report Types

The two main report types are model reports and aggregated reports. Model reports display data from a single table. Aggregated reports display data from multiple related tables and can roll up data based on a code.

Examples of model reports are Calendar, Rates, and Project Data. Examples of aggregated reports are CPR Format 1, Time-phased, and Project Cost Set.

The applicable/available tags and parameters vary among the report types.

When you click All Reports in the Navigation pane's group bar to view the All Reports pane, you can see various reports and their types.

This table lists the available report types and provides a general description of each one. A Yes in the Aggregated column indicates that the time-phased data is summarized based on the report criteria before the report is generated. To run an aggregated report, you must select one or more criteria and one or more cost sets. A Yes in the Include Multiple Projects on Report column indicates that you can run the Report Wizard against multiple projects (not against a master project) to include on a single report.

Report Type Aggregated Description Include Multiple Projects on Report
Access No Dedicated report type for the File Access report. No
Change Management No Dedicated report type for the Change Management and Project Reconciliation reports. No
CPR Yes CPR reporting. Time-phased data; rows grouped by criteria; columns grouped by cost sets. Sort Code and subtotal options available in report footer. No
CPR3 Yes CPR3 reporting. Baseline data. No
CrossTab Yes CAP reporting. Time-phased data; rows grouped by criteria and cost sets. Yes
CrossTabCriteria Yes Time-phased data; rows grouped by criteriaN-1; columns grouped by CriteriaN.

Used for 1921-1 report.

No
Graph Yes Graphic reports. Time-phased data; rows grouped by criteria and cost sets. Yes
Model No Reports based directly on underlying data structures (for example, control accounts, code files, and so on.) The Report Table Type indicates the main table. No
Pivot Table Yes Pivot table reports. Time-phased data is grouped by criteria and cost sets on the Data worksheet. It is presented on the Report worksheet in a pivot table.
If exactly two criteria are selected, the pivot table is initialized as follows; otherwise, an empty pivot table is displayed:
  • Row Label 1: Criteria 1, No Subtotals
  • Row Label 2: Cost Set, Summed Subtotals
  • Column Label 1: Criteria 2
  • Values: Summed Value
Yes
Project Audit Yes Project log reporting. Rows are grouped by criteria. No
Project Planning Statistics No Dedicated report type for the Project Planning Statistics report. No
Summary Yes Time-phased data; rows grouped by criteria; columns grouped by cost sets. Yes