Hi,
How do I write CRXIR2 report using following data?
Table1:
Type Name Dept.
EXEC ExecName1 dept1
PERS PersonName1 dept1
EXEC ExecName1 dept2
PERS PersonName2 dept2
EXEC ExecName2 dept3
PERS PersonName3 dept3
Table2:
Dept Amount
dept1 60
dept1 30
dept2 20
dept3 75
dept3 20
Report Required from above table:
ExecName1
PersonName1 dept1 90
PersonName2 dept2 20
ExecName1 110
ExecName2
PersonName3 dept3 95
ExecName2 95
THanks in advance for the help.