Earning wise Hours rate report in oracle BI Report rtf template

I have one GLB_PAY_ARCH_PR_EARNINGS group in xml output in which it has REPORTING_NAME field.

There is another group for GLB_PAY_ARCH_PR_HOURS_X_RATE in which it has REPORTING_NAME field

I need to get the hours data for each reporting name.

Example : 

Group 1    Group2

GLB_PAY_ARCH_PR_EARNINGS  GLB_PAY_ARCH_PR_HOURS_X_RATE

REPORTING_NAME       REPORTING_NAME  Hours

A A 12

B B 11

C  

D C 8

How to achieve this BI Report i need syntax to print for each reporting names to get data for hours in report shown in above example.