Skip to Content
0
Former Member
Mar 26, 2009 at 08:39 PM

Hierarchical Crystal Reports report but based on same field

19 Views

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.