For example, I have a table called "office" that stores different offices
It has three fields "office_code","office_parent" and "description"
Now, the situation is, in each office, there may be a sections and each sections could have any sub-sections.
I have designed the table this way:
"office" table
office_code - office_parent - description
1 - null - executive office
2 - null - HR-Office
3 - 1 - Department Head
4 - 1 - IT Staffs
5 - 2 - Recruitment Section
by these, we know that IT Staffs in under Executive Department
and Recruitment Section is under HR-Office.
Now, my problem is, I want to show it in crystal report. and I want grouped heirarchical
like organization chart.
How can I do this in crystal report?
It has three fields "office_code","office_parent" and "description"
Now, the situation is, in each office, there may be a sections and each sections could have any sub-sections.
I have designed the table this way:
"office" table
office_code - office_parent - description
1 - null - executive office
2 - null - HR-Office
3 - 1 - Department Head
4 - 1 - IT Staffs
5 - 2 - Recruitment Section
by these, we know that IT Staffs in under Executive Department
and Recruitment Section is under HR-Office.
Now, my problem is, I want to show it in crystal report. and I want grouped heirarchical
like organization chart.
How can I do this in crystal report?