The Reporting Options selection criteria  for this report allows you to specify:

• Calculate Project Metrics from Project/Task Budgets - This option will determine if the report should provide detail at the Project Level or at the Task Level.

• Show Tasks - When checked, the report output will include the display of all Tasks associated with each project.

• Show Project Account Numbers - When checked, the report output will include the display of the Project Account Number for each project.

• Show Project Managers - When checked, the report output will include the display of the Primary Project Manager for each project.

• Show Project Titles - When checked, the report output will include the display of the Project Title for each project.

• Show Comments - When checked, the report output will include the display of the Project Comments for each project.

• Show Gross Revenue - When checked, the report output will include 3 additional columns reflecting:

• • Funded Value - As entered on the project and/or task (blank if not available).

  • Gross Revenue - See calculation below.

  • Gross Revenue/Funded Value - Ratio of Gross Revenue to Funded Value (will be 0% if no Funded Value provided).

• Suppress Inactive Items - If this option is selected, the report output will not include any projects/tasks  that have a Status that has the Active status attribute set to Inactive.   Note: it is possible to provide conflicting selection criteria on this screen (e.g., you could specify an 'inactive' Project Status in the selection criteria above and then check this check box --- which would result in the report returning no results).

• Suppress Completed Items - If this option is selected, the report output will not include any projects/tasks that have a Completed Date populated.

Gross Revenue Calculation

The calculation of Gross Revenue (which should mimic what is calculated by the [Revenue (Gross)] tag of the Cost Report definition) based on the project or task Billing Type is determined as follows.

1. Gather all existing time, expense, and financial document expenses. Consider ALL existing actuals regardless of status.
2. Calculate revenue based on the rules for the project's billing type. Do not consider revenue caps, fee caps or write offs at this point.
3. Add in any revenue that has already been posted.
4. Add in any revenue-related "additional items" from Draft invoices.
5. Add in any FP items recognized on invoice completion from the Draft invoices.