Extend the report source

Can you create a report showing a Closed sprint?

Yes.

You can create a report from the Manage Pivot Reports page or from within a Board, referencing up to two closed sprints.

Afterwards, you can update the report source to include up to five closed sprints, as shown in the screenshot above, by following the steps in the related article.

In the example below, a closed sprint appears with a green label and strikethrough text, while an active sprint is shown with a blue label and no strikethrough.

Can you create a report for Custom sprints?

Yes.

You cannot create a report that references custom sprints directly from the board. However, you can update the report source to include them, as described in the related article.

The screenshot below shows a custom sprint added to the report source.

Can you reference multiple projects when creating a report?

Yes.

A report’s source can include multiple projects. You can reference multiple projects when creating or modifying a report by using JQL or a filter from Jira’s Issue Navigator.

A Board that references multiple projects through JQL or a filter can also be used as a report source.

The report shown in the screenshot of the Cross Project demo report below is based on JQL referencing three projects.

Can you expand further the scope of the report?

Yes. You can expand the scope of a report using the Create New Report pop-up, which appears when you click Create Report on the Manage Pivot Reports page.

In the pop-up, select the checkboxes below the source type to include Parent and Child issues. This option extends the report source and adds more issues to the report.

For example, if the report source is a Board, you can enable Parent issues to include items such as Epics, which may not appear directly on the board.

You can update this configuration later from the report sidebar, as explained in the related article.

Can you create your own modified copy of the demo report?

Yes. You can change the source of the Cross Project demo report—for example, by reducing the number of referenced projects from three to two—and then save a public copy.

Can you use 'Blocked by' or another link to show a parent relationship?

Yes.

You can add links, such as as Blocked by, in the Issue View to represent a relationship with a parent item in your organization and display it using a custom hierarchy in a report. Other organizations may use different links, such as Belongs to, for the same purpose.

Follow these steps to verify relationship links, extend the report source, and configure a custom hierarchy:

1. In this example, the report source references three projects using JQL. Click Columns.

2. Select or search for Linked Issues.

3. Identify the highest-level parent and determine the relationship type. In this example, Epic SKP-17 blocks Initiative SSP-32, which belongs to a project not included in the report source.

4. Enable Parent Issues to extend the report source.

5. Click Apply.

6. Click + Add Link Type.

7. Select a Parent Issue Type, Link Type, and Child Issue Types.

In this example, Initiative SSP-32 is blocked by Epic SKP-17. As a result, Initiative is the parent issue type and Epic is the child issue type.

8. Click Apply.

After completing these steps, the parent relationship appears in the hierarchy, as shown in the screenshot below.

Note that Epic SKP-17 is grouped under the project associated with its parent Initiative as part of the custom hierarchy.