Configuring Resource Reports

There is already a detailed topic on resource reporting. In this section we will therefore focus on Resource Reporting in Project Request Manager.

There are two recommendations:

  1. Show All Data
    For Resource Allocation planning you will want to see the entire time frame so the recommendation is to show all data.
    To set this when configuring the resource report select:
    Time Windows Settings | Time Window | All Data.
  2. Allocation Data
    To prevent Project Requests appearing in the resource report you can limit the report to only display items that have work, and a start and finish date.
    To set this when configuring the resource report select:
    Resource Report Display Settings | Allocation data | Only render items with allocation data.

Adding Roles

Resource Allocation focuses by default on tracking and reporting on individuals. However, many organizations plan without knowing the individuals concerned and instead use Roles.

This section explains how to configure the Resource Allocation list to support Roles. It assumes that you have already followed the steps in the Configure Resource Allocation topic.

Adding Support for Roles

The steps to add roles really involves making roles more visible. To do this:

  1. Add roles to the Project Roles list
    1. Select Site Contents in the Quick Launch.
    2. Open the Project Roles list.
    3. Add all relevant roles for the organization.
    4. Optionally, add roles to the Quick Launch to make ongoing maintenance easier.
      1. Select Settings and Site settings.
      2. Under Look and Feel, select Quick launch.
        1. Select New Navigation Link:
        2. Paste the following into the Type the Web address field:
        3. Paste the following into the Type the description field:
          Project Roles
        4. Select the Heading 'Resource Management'.
        5. Click on OK.
  2. Update the Resource Allocation list
    1. Open the Resource Allocation list.
    2. Select the ribbon's List | List Settings.
    3. Select the Column visibility settings (BrightWork) setting.
    4. Uncheck the checkbox for Hide from Forms and Views to make the Role column visible.
    5. Click on OK.
    6. Remaining in the List Settings, select the View Resource Allocation.
    7. Select the Role Display checkbox and change the Position from Left to 4, or before Assigned To.
    8. Click on OK.
    9. Now update any existing Resource Allocation items with the Role as needed.
  3. Supporting Multiple Resources Per Role
    Often when planning by role you need more than one. To set the number of role holders:

    1. Add a new column to the Resource Allocation list:
      1. Open the Resource Allocation list.
      2. Select the ribbon's List | List Settings.
      3. Select Create column.
      4. Set column name (to a reporting friendly internal name):
      5. The type of information in this column is: Number (1, 1.0, 100)
      6. Default value 1.
      7. Click on OK.
      8. Rename the column (to a friendly name) by re-editing the column you just created and setting the Column name to:
        Number of Role Holders
      9. Click on OK.
    2. Update the formula used to calculate work:

      1. Select Available Work (Hrs).
      2. Change the Formula to:
        =([Allocated Work (Days)]*8)*([% Allocation]*[Number of Role Holders])
      3. Click on OK.
      4. Finally, you MUST now set the Number of Role Holders for any existing Resource Allocation items otherwise it will be '0'.

  4. Update the Resource Report
    1. On the Resource Management page, select the Resource Report.
    2. In the ribbon, select Reporter | Configure Reporter Settings.
    3. In the Group By section group by Owner Role first.
    4. Click on OK.

Tips on reporting on Roles across sites

  • To report on Resource Allocation roles with Project data you need to be able to group by role values that are common to Resource Allocations and projects. This means that the column to use is Owner Role. However, in projects Owner Role is typically a combination of the team and role and has values like, 'Project Team/Project Manager'. To have a common grouping then the role names need to be the same.

  • To report on Role used across projects and resource allocations it is also recommended that the Work Cache data source is used and not BrightWork reports. The main reason for this is because BrightWork reports do not extract the unique names from lookup columns used in different sites. However, the Work Cache does and therefore offers cleaner reporting in this scenario. It is also faster which is going to be critical is larger environments.

Include Roles on the Resource Allocation page

If you would like to add a link to Roles to the tiles in the resource allocation page:

  1. Select Site Contents in the Quick Launch.
  2. Open the Resource Management list. This should default to the All Promoted Links view.
  3. Click on new item and add values as follows.
    1. Title: Project Roles
    2. Background Image Location
      1. Type the Web address: /_layouts/15/images/bw_15_tile_ResourceRole.png
      2. Type the description: Project Roles Image
    3. Description: Add and maintain Project Roles.
    4. Link Location
      1. Type the Web address:
        1. Copy the current site URL.
        2. Append Lists/Project Roles to it.
      2. Type the description: Project Roles List
    5. Select the Launch Behavior: In page Navigation.
    6. Order: 2. You could also change the Overview Diagram Order to 3.

Was this article useful?

Back to Top