Clara-
Do you have an example of the Advanced SQL option to get the results table? I too would like to see the execution record and the results. 

Hi Jeff,

I used Report Builder to create a report linking Test Suites and Test Execution Records, then I manually edited it to add the Test Suite Results (T4).  I added a few fields, but you can of course add more or remove the ones you don't need.  This is just an example of how the result records can be included in the report:

SELECT DISTINCT T1.PROJECT_NAME,
       T1.REFERENCE_ID,
       T1.NAME AS URL1_title,
       (CASE WHEN T1.URL IS NULL THEN ' ' ELSE CONCAT(CONCAT(CONCAT(CONCAT(SUBSTR(T1.URL, 1, LOCATE('service', T1.URL, 1)-1), 'oslc_qm/contexts/'), RTRIM(T3.EXTERNAL_KEY2)), '/resources/com.ibm.rqm.planning.VersionedTestSuite/'), T1.EXTERNAL_KEY2) END) AS URL1,
       T2.REFERENCE_ID AS REFERENCE_ID1,
       T2.NAME AS URL2_title,
       T2.URL AS URL2,
       T4.START_DATE AS Start_Date,
       T4.TESTSUITELOG_NAME AS Result_Name,
       T4.VERDICT AS Verdict
FROM RIDW.VW_TESTSUITE T1
INNER JOIN RIDW.VW_TESTSUITE_EXECUTION_RECORD T2
ON (T1.TESTSUITE_ID = T2.TESTSUITE_ID)
  INNER JOIN RIDW.VW_PROJECT T3
  ON T3.PROJECT_ID=T1.PROJECT_ID
  INNER JOIN RIDW.VW_TESTSUITELOG T4
  ON T4.TESTSUITE_EXECRECORD_ID = T2.TESTSUITE_EXECRECORD_ID
WHERE (T1.ISSOFTDELETED = 0 AND T2.ISSOFTDELETED = 0) AND
(T1.TESTSUITE_ID <> -1 AND T1.TESTSUITE_ID IS NOT NULL) AND
(T2.TESTSUITE_EXECRECORD_ID <> -1 AND T2.TESTSUITE_EXECRECORD_ID IS NOT NULL)

Thank you,
Clara Forero