Crystal report grouping

See more:

.NET3.5

.NET

CrystalReports

Hello

I want to generate a report from the following three tables

1- Roles
2- Users
3- Access Rights

Assume we have the following Roles and Users

1- Manager
a- User A

2- Supervisor
a- User B
b- User C

3- Operator
a- User D
b- User E
c- User F

The table im getting is of the following format

Role ------ User ------ AccessRight

Operator ------ User D --------------- Action A
--------- ------------------- -------- Action B
--------- ------------------- -------- Action C
--------- ------------------- -------- Action D
--------- ------------------- -------- Action E

------ ------ User E --------------- Action A
--------- ------------------- -------- Action B
--------- ------------------- -------- Action C
--------- ------------------- -------- Action D
--------- ------------------- -------- Action E

------ ------ User F --------------- Action A
--------- ------------------- -------- Action B
--------- ------------------- -------- Action C
--------- ------------------- -------- Action D
--------- ------------------- -------- Action E

Supervisor------ User B --------------- Action A
------ ------- -- ------ --------------- Action B
.
.



I want the users to be grouped under each role rather than having to repeat the access rights for each user. I want to have the table with THIS format.

Role ------ User ------ AccessRight

Operator ------ User D --------------- Action A
--------------- User E --------------- Action B
--------------- User F --------------- Action C
--------------- ---- --------------- -- Action D
--------- ------------------- -------- Action F

Supervisor------ User B --------------- Action A

.
.


Any help would be of great assistance... thank you