I want to create a report (dashboard widget) that will span RQM Projects.

Design:

The report will need to collect data from multiple RQM Projects. (The Test Plans will all have a common field, and value within the field, to allow the "right" Plans to be summarized.) The data to be summarized is the Test Case Execution Results for the Test Case Execution Records - regardless of whether the Test Case was added directly to the Test Plan, or if the Test Case was in a Test Suite that was added to the Test Plan.

In the standard widgets I could not find one that reported against Test Plans in multiple RQM projects, so I thought I would use JRS (Report Builder).

In Report Builder, I could not find a widget that met my needs (runs against LQE, runs across RQM Projects, and reports Test Case Execution Results in a Test Plan)

Problem:
In JRE, I tried to create my own report, and pull these two relationships together:

.   Test Plan -> Test Suite -> Test Case -> Test Case Execution Record -> Test Case Result

and

.    Test Plan -> Test Case -> Test Case Execution Record -> Test Case Result

But I don't see how to get the Test Case Result from each path into a common column for display and summarization.

Help!