BrightWork project report

How to Use BrightWork Reporter for Powerful Project Reports

May 23, 2019 by

‘’The goal is to turn data into information, and information into insight’’. Carly Fiorina, CEO, Hewlett-Packard, 1999-2005.


Effective project and portfolio management relies on actionable, data-driven insights to drive work forward.

Easy access to project data allows teams to collect, measure, interpret, and analyze project performance in meaningful ways.


See BrightWork Project Reporting for SharePoint in action with our video tour!


However, with so much information circulating in different channels, turning data into insight is often tricky.

Project managers waste too much time collecting data whilst senior executives are often waiting for reports – with varying degrees of quality and timeliness.

In this article, I’ll show you how BrightWork Reporter, a key capability of our PPM solution for SharePoint, can help you to create powerful project reports. You’ll learn how to configure reports to focus on what you need and see how to create Shared Reports for the team.


What is BrightWork Reporter?

BrightWork Reporter is a highly configurable web part, used to report on multiple sites, subsites, and lists in a single report.

This diagram shows the structure of a typical BrightWork site collection.



Instead of manually checking each project site for information, you can use BrightWork Reporter to pull information together into a single report.

BrightWork Reporter



Below is an example of various multiple sites, subsites, and lists rendering as a single report.


BrightWork Reporter Example Report



Using BrightWork Reporter, you can:

  • Create personal and shared reports.
  • Filter and sort data.
  • Create cross-list and cross-site report filters.
  • Render data as a chart, Gantt chart, list item report, or Resource Usage report.
  • Share reports via email.


Navigating BrightWork Reporter

Before we take a closer look at using BrightWork reporter, let’s run through the navigation options – the Reporter Ribbon and the Information icon (I).

1. The Reporter Ribbon


BrightWork Reporter Navigation


Using the Reporter Ribbon, it’s easy to:

  1. Toggle between Shared and Personal Reports.
  2. Personalize your reports.
  3. Display report information, such as data source and active filters.
  4. Share reports with the project team.
  5. Access ‘Configure Reporter Settings’ for shared reports.
  6. Show groupings and totals.



2. Report Information Icon

The Report Information icon is located in report web parts, such as lists and Gantt charts. Simply click the icon to access key information about the report.

BrightWork Reporter Information button



This data is also accessible by clicking the information icon (i) beside each report.


BrightWork Reporter Information button



Below, we’ll take a closer look at using BrightWork Reporter, starting with key configuration options.


BrightWork Reporter Configuration Options

Using options the ‘Personalize this Report‘ area in the Reporter Ribbon, you can:

  1. Filter data
  2. Sort data
  3. Group data
  4. Add Totals
  5. Add or remove columns.


Use these options to find the information you need quickly.


1. Filter

Project reports can often contain too much information, making it hard to spot problems. Filtering reduces the original dataset to key items you need to see, for example, ‘current projects by project manager’.

The filter is very similar to a SharePoint list view filter.

Click ‘Filters’ in the Reporter Ribbon to view the various filter options.

BrightWork Reporter Filter



2. Sort

Sorting data alphabetically, numerically or chronologically is available in the List Item and Resource Reports.

BrightWork Reporter Sort



3. Grouping

Various options are available to group information together in a logical way for a project.

Note – you can also choose to display data as ‘Collapsed’ or ‘Expanded’.

BrightWork Reporter Grouping


4. Totals

BrightWork Reporter performs the same totaling functions as a standard SharePoint view.

The display options depend on the column, for example, you can use ‘Minimum’ for numbers, currency, and date/time columns.


BrightWork Reporter Totals



5. Columns

In addition to adding or removing columns in a report, you can also re-arrange the order of columns in a report.

BrightWork Reporter Columns


Now that you understand how to configure a report in BrightWork, it’s time to apply these options to Personal and Shared Reports.


Personal Reports

BrightWork Reporter allows users to create their own personal report, which becomes the default report upon login.

Follow the same configuration options as outlined above. The end result is only available to you.

As you work through the various options, you’ll see a message at the top of the dialog box, highlighted in yellow. When editing a Shared Report, this box is highlighted as grey – an easy way to remember where you are!

A caveat – if you are in a meeting with your team or stakeholders, it’s best to use the ‘Shared’ Reports view. Otherwise, everyone will be talking about different information.


Shared Reports

Depending on your SharePoint permissions, you can configure reports available to all team members and stakeholders. This feature is especially useful for PMO managers, making it easy to implement standardized reports throughout your organization.

The ‘Shared Report is typically the default view for users – unless they have already created their own personal views.

The main configuration options are the same as above, and are found under ‘Configure Reporter Settings’.

Simply make the required changes, saving your work as you move through the various options.

If you want to make more advanced changes, click ‘Configure Reporter Settings’ and access options such as:

  • Data Source
  • Report Scope (current or specified site)
  • Report Type (chart, list, Gantt, or Resources Report).


BrightWork Reporter Settings



Grace Windsor

Grace is a content creator within the marketing team at BrightWork. She loves creating actionable content in different formats to help others achieve more project success. Grace spent far too long at university studying English literature, which instilled a life-long love of learning and upskilling.

In her free time, she enjoys a challenging session at the gym, tucking into a good book, and walking the beautiful Galway coastline with her dog.
Grace Windsor

Latest posts by Grace Windsor (see all)

    Pin It on Pinterest

    Share This