Working with Report Data Sources

The purpose of this guide is to introduce you to Reporter Data Sources and to working with Reporter Definitions.

1. Introduction

In this training guide, you will learn about working with Reporter Definitions so you can do things like report on the columns and lists you added to your templates. You will also learn how to add filters to reports, add metrics to reports and improve report performance.

Prerequisites

You will need to have completed the following guides:

  1. Create a BrightWork Training Office Guide
  2. Project Metrics List Training Guide
  3. Working with Lists and Libraries
  4. Configuring BrightWork Reporter

If it has been a while since you completed these guides, you should review them again so you can remember the changes you made to your training environment, as you will be building on those changes in this guide.

If you have not completed these other guides, you can use the Report Editor Training Scenarios BrightWork Help topic to get a high-level overview of using the Report Editor to edit Reporter Definitions.

Suggested Exercises

At the end of nearly every chapter you will see some Suggested Exercises that you should be able to complete on your own, based on what you have just done.

These suggested exercises will not contain any steps – you will need to apply what you have learned to do the exercise.

We strongly recommend you complete these suggested exercises, as they will help to reinforce what you have just learned.

About User Names

This guide uses fictional user names that exist in our TrainingZone, for example you may see an instruction like ‘Select Dan Bacon from the Assigned To menu’.

If you are taking the training in your own environment, then these names will not likely exist and you should use other names.

2. About Report Data Sources

A Report Data source defines the columns available to be reported on. Every BrightWork Report is driven by one of two data sources: a Reporter Definition or the Project Cache.

The majority of this guide is devoted to working with Reporter Definitions.

About Reporter Definitions

Most BrightWork Reports are driven by Reporter Definitions. A Reporter Definition is an XML file that includes the basic structure for a report. The XML files are stored on the server or in the BrightWork Reporter document library in your site collection. BrightWork includes an interface called the Report Editor for editing the XML in the Reporter Definitions.

BrightWork ships with many Reporter Definitions – see the Supplied Reports topic in the BrightWork Help for a description of all the Reporter Definitions supplied with BrightWork.

The flexibility of BrightWork Reporter means that a single Reporter Definition can result in many different reports, for example, four of the reports shown below are driven by a Reporter Definition called All Project Summaries (the Project Office Scorecard is driven by the Metrics list).

The Reporter Definitions that ship with BrightWork are stored on the server. You will not edit these as it means they would be edited for all users and you would also run the risk of losing your updates when you next upgraded BrightWork.

The Reporter Definitions you work with are generally stored in the BrightWork Reporter library. This library is located at the top of every BrightWork site collection. The BrightWork Reporter library has the ability to create a copy of any report on the server or in the library. It also has the ability to create a blank report.

The BrightWork Reporter Library includes the Report Editor that you use for editing the Reporter Definitions you add to the library. The Report Editor enables you to make code changes to a Reporter Definition in the BrightWork Reporter Library without having to touch any of the XML code that defines the Reporter Definition. You can do things like: add columns to reports, add and/or update lists being reported on, edit site filters etc., all without having to edit a single line of XML.

NoteEditing the XML can be useful in edge cases, such as modifying a large number of reports at once. For more information, see the Report XML Reference Guide BrightWork help topic.

About the Work Cache

The Work Cache data source is designed as an alternative to work and issue reports that report across multiple sites. The Work Cache reports across the following lists: Tasks, Issues, Goals, Risks, Project Change Requests as well as Project Requests. The Work Cache is a hidden list where all changes made to the lists mentioned in the site collection are written.

NoteAs each BrightWork site collection only contains one Work Cache, for best practice reasons, it will not be possible to use your site collection for training with the Work Cache.

To find out more about the Work Cache, see the following BrightWork help topic.

About the Project Cache

The Project Cache in an alternative report data source designed to offer speedier cross-project reports (for example, the All Project Summaries reports mentioned in the previous section can all be delivered via the Project Cache).

The Project Cache is a hidden list to which all changes in the various Project Statements, Projects Tracker and Project Metrics lists in all Project and Project Office sites in the site collection are written. This means that BrightWork Reporter only has to query a single list to generate the report, instead of querying multiple lists in multiple sites.

Note: As each BrightWork site collection only contains one Project Cache, for best practice reasons, it will not be possible to use your site collection for training with the Project Cache.

For more information on the Project Cache see the BrightWork help and the below webcast link.

The About the Project Cache training webcast includes information on the following:

  • Why and when to cache a report
  • Locating the project cache
  • Adding entries to the project cache

Also, see the Project Cache topics in the BrightWork help for more information on the same topics.

3. Create Copy of a Reporter Definition

In this section, you will learn how to create a copy of a Reporter Definition that you can customize for your own needs.

Create Copy of a Reporter Definition

The majority of custom reports you make will likely be variations on an existing Reporter Definition. This is why you should use an existing Reporter Definitions as a starting point when creating a new Reporter Definition.

See the Supplied Reports BrightWork help topic for a brief description of the Reporter Definitions supplied with BrightWork.

  1. Navigate to your Project Office home page and click ctrl-click on Home to open the site collection home page in a new browser tab.
  2. Click Settings | Site contents on the site collection home page.
  3. Click BrightWork Reporter Library.
  4. Click Files | New Document | Reporter Definition.
  5. Give the Reporter Definition a name that will allow you to distinguish it from the other custom reports (for example, Your Project Office Name; Project Summaries).
    NotePlease use your name or some other unique identifier in the name of the Reporter Definition. This will make it easier for you to identify the report if you are taking the training in our shared environment.
  6. Select Copy an existing Reporter Definition from the BrightWork Server Gallery.
  7. Select the All Project Summaries Reporter Definition.
  8. Click Create.
  9. Repeat the processes and create a copy of the Open Work report.

NoteSometimes it is useful to use reports in multiple locations. To monitor where these reports are being used, you can use the Report Locations feature. For more information, please see the Report Locations BrightWork help topic.

4. Add Columns to Reporter Definitions

In this section, you will learn how to add columns to a Reporter Definition, map columns, create new pages for reporting and configure reports to display mapped list data. You will also add tabs, configure charts and add site filters to your Reporter Definition.

Add Column to Reporter Definition

In this section, you will add the Region site column you added to the project statement in the ‘Working with Lists and Libraries’ guide to the copy of the project summary report you just created. You will need to know the Internal Column Name you gave this column.

You will also configure an instance of the reporter web part to use this report and column.

  1. Click Report Editor on the menu of the Project Summaries report you just created.
  2. Scroll down and click Add a new column.
  3. Enter the internal name you gave the column in the Column Internal Name field.
    NoteThe column internal name must be unique, i.e. you cannot have two columns in the one report with the same column internal name.
    The column internal name cannot contain spaces, leading numbers or unsupported characters. The only supported characters are letters, numbers and underscores (i.e. “_”).
    See the Identify the Internal SharePoint Column Name BrightWork help topic for some tips on identifying the internal column name.
  4. Enter the title you would like the column to have in the Caption field – again, use a combination of Region and your initials.
  5. Select Choice.
  6. Click Create.

NoteIt is important that you add Choice columns to reports as Choice column, as this gives you the ability to filter by the column contents in the Reporter UI – as you will see in later sections.

Deploy Custom Report

  1. Return to your Project Office home page (it should be open in another tab) and click in the Project Summaries header to expose the Reporter ribbon and click Reporter | Configure Reporter Settings.
  2. Select BrightWork Reporter Library and select the report you were just working on.
  3. Scroll down and expand the Column Settings section, select the column you just added and select 5 from the Position from Left menu.
  4. Click OK.
  5. The Region column will now show in the Project Summaries web part.

Project Statement and Reporting

You can display information from the Project Statement on the same row in a report with any list item in the same site.

This means you can create cross-project and cross-lit reports that can filter, group and sort list data based on criteria in the Project Statement.

  1. Return to the BrightWork Reporter library and click Report Editor on the menu of the Open Work report you created in a previous section.
  2. Click Add a new column.
  3. Enter the name of the column and select Choice.
  4. Make sure the Add this column to the List Query Templates checkbox is selected and click Create.
  5. Click Edit Column Mappings for the first item in the List Query Templates section.
  6. Select the Include Project Statement Columns checkbox.
    NoteYou may have to wait a second or two for the page to update. You will know the page has loaded when you see the scroll bars appear on the right.
  7. Scroll down to Region and select From Project Statement.
  8. Copy and paste the internal name of the column in the field beside this.
  9. Click Update.
  10. Repeat for all the other List Query Templates.

Create a New Page and Add Reporter Web Part

In this section you will create a new web part page for the report you just created and add the BrightWork Reporter and Tabs web parts to the page. You will use a BrightWork Web Part page as these include the Quick Launch by default (unlike the standard SharePoint web part page).

  1. Return to the Project Office home page and click Settings | Site contents.
  2. Click BrightWork Pages.
  3. Click Files | New Document.
  4. Give the page a name (for example, Work by Region) and click Create.
  5. Click Add a Web Part in the header section.
  6. Select BrightWork | Tabs (BrightWork) and click Add.
  7. Click open the toolpane on the Tabs web part.
  8. Select Work from the Page Group menu and click OK.
  9. Click Add a Web Part in the Top Row section.
  10. Select BrightWork Reporter | Reporter (BrightWork) and click Add.

Deploy Custom List Item Report

Next, you will configure the BrightWork Reporter web part you just added, so that it displays your report with the columns you added using the Report Editor.

  1. Click Configure Shared Reporter Settings on the Reporter (BrightWork) web part menu.
  2. Select BrightWork Reporter Library and select the custom Work report you just created and edited in the Report Editor.
  3. Select Include all sub-sites.
  4. Expand the Web Part Settings section and give the report an appropriate title.
  5. Scroll down to the Column Settings section, select the List Name column and select 5 from the Position from Left menu.
  6. Scroll down to the Group By section and select Region from the first menu and Web Name from the second.
  7. Click OK.

Now, when you look across work items, you can see to which region they belong.

Add Report Tab

BrightWork Tabs allow you to extend a site horizontally, as opposed to vertically on the Quick Launch.

Click Work on the Quick Launch and note how there is no tab for your new Work By Region page.

The Tabs web part is driven by the tabs list and you will now add an item to this list for the web part page you just created.

  1. Click Settings | Site Contents.
  2. Click Report – Tabs.

    NoteThe Tabs web part is driven by this list. Every entry in the report is a tab and every page group is a collection of tabs.
  3. Click edit this list.
  4. Select the Work on the Page Group filter.
  5. Select the last five cells in the last item and drag them so as to create a new row.
  6. Update the Tab Order number to 8.
  7. Update the Title to Work by Region.
  8. Update the page name in the Page URL so that it reads ~site/BrightWork Pages/Work by Region.aspx (or whatever is the correct page name of the page you just created).
  9. Click Stop editing this list.
  10. Click Work on the Quick Launch.
  11. Click the Work by Region tab.

The report will display!

NoteIf the page you added does not load, check that you entered the page name correctly in the Tabs list datasheet.

Add and Configure a Chart

The Work by Region report you just added above shows the number of work items in each region; however, you can also show this information in a chart.

  1. Navigate to the Work by Region page you created in a previous exercise.
  2. Click Page | Edit Page.
  3. Click Add a Web Part in the Center-Left Column and add the BrightWork Reporter web part.
  4. Click Configure Shared Reporter Settings on the web part menu.
  5. Select the Work report you used to create the list report that is already on the page and select Include all sub-sites.
  6. Give the chart an appropriate title.
  7. Select Chart Report from the Report Type menu.
  8. Select Microsoft Chart Control for .NET Framework as the Chart Provider and Pie as the Chart Type.
  9. Select Region as the X-Axis column and select Enable categorization for this column.
  10. Select Display the number of items in this category.
  11. Scroll down to the Chart Data Display Settings section and select Show Data Labels.
  12. Click OK and the chart will display.

NoteIt is very important to realize here that the above chart is driven by the same Reporter Definition as the report you setup in Deploy Custom List Item Report. A single reporter definition can produce many different reports.

Suggested Exercises

  • Create a Recently Closed Work report page in the Work section of your Project Office site and set the default to display work completed in the past 30 days.
  • Modify this report to include the priority of the project the work belongs to from the Project Statement.

5. Add Metrics to Report

In this section, you will learn how to add Metrics to a report.

Introduction

NoteMetrics are measurements that allow you to quantify the state of a system. They enable you and other project stakeholders to quickly and scientifically measure progress and make important decisions as to the direction and scope of the project. Metrics are covered extensively in the Project Metrics List Training Guide.

You can add certain values generated by a Project Metric to a Project Statement report and display them on the same line as the project the metric belongs to in a report. This is known as Project Metric Join.

The values you can add include:

  • Metric Value
  • Target Value
  • Indicator Icon
  • Indicator Status
  • Formatted Metric Value
  • Formatted Target Value
  • Formatted Warning Value
  • Formatted Danger Value

Add Metrics to Reporter Definition

In this section, we will get you to add the Planned Finish Date Warning metric you created in the Project Metrics Guide to the first report you created in this guide.

NoteTo complete the exercises in this section, you will need to have completed the Project Metrics List Training Guide.

To create a Project Metric join:

  1. Return to the BrightWork Reporter library and select Reporter Editor on the menu of the Project Summaries report you created earlier (see Create Copy of a Report section).
  2. Scroll down to the Project Metric Joins section and click Add a new project metric join.
  3. Click Change Selected Site on the Selected Site menu.
  4. Click the page navigator at least twice until sites from the Training Area are displayed.
  5. Click on the site you created with the Project Standard template. This is the site where you added the Planned Finish Date Warning metric.
  6. Click Change Selected List on the Selected List menu.
  7. Click Project Metrics.
  8. Click Select the date metric ID and select the PlannedFinishDateWarning metric.
  9. Select Add a new report column to map to for the Target Value and enter an appropriate Caption. The Name will field automatically populate based on this.
  10. Repeat this process for the Indicator Icon column.
  11. Click Create at the bottom of the page. Now these items will be available for selection as columns in the report.

Configure Report to Include Metric

In this section, you will update a displayed report so that it includes the Metric you just added.

  1. Navigate to the site you created using the Project Standard template.
  2. Click Page | Edit Page.
  3. Click Configure Shared Reporter Settings on the Icon Summary web part menu.
  4. Load the report you added the Metric to.
  5. Scroll down the Columns section and unselect all the columns.
  6. Select the following columns and assign them the following positions:
    • Issues 1
    • Time 2
    • Health 3
    • PD Icon 4
  7. Select Disable Link Column.
  8. Click OK. The report will load.

Suggested Exercise

Add a new project metric join for the Internal Stop Date metric and add it to the Icon Summary report.