Crystal Reports Crystal reports Layout- Unable to group,sort

Message

I want to create a report in Crystal Reports 10.

I have already created this is Oracle reports 10g using the Group left layout 
and I want to recreate same layout in Crystal.

Issue 1: Scenario is one employee John is both a Chef and Waiter , his User 
Id is Unique and his status can be different as per his role.In the sense he can 
have multiple roles, he can be a chef and a waiter and he both either active as 
chef and inactive as Waiter or versa or can be active as both chef or waiter or 
Inactive as both chef and waiter. No restriction on this.

But when I create this in Crystal , the User id  and name email 
address are always repeating. Is there any way you can tell me how to group this 
in Crystal like I did in Oracle reports 10g.In Oracle 10g I used wizard and 
chose Group left report style which gave me desired output as I grouped them 
with Role User Id then name, email address and then role.

I scanned through all built-ins in Crystal like the Group Expert but nothing 
worked out. The group expert gives me an output 3 shown below.

Question 1)

Can anyone tell me is there any way to group or do something which will get 
me my Required layout.

Question 2)

Can we write a sql query and generate report in Crystal like we do in Oracle 
Reports? Or is it like we have to design everything and then only we can see 
query but cannot write query before designing it.

Required 
:

UserId  Name   
Email address   Role       
Status

A         John     John@al.com   Chef       
Active

Waiter    Inactive

B          Sam     Sam@al.com    Chef       
Inactive

C         Jim       Jim@al.com     Waiter    
Inactive

Bartender Active

D         Ted      Ted@al.com    Waiter     
Inactive

Supervisor Active

Obtained 
in Crystal 
Reports :

User Id Name   
Email address   Role     Status

A         John     John@al.com   Chef     Active

A         John     John@al.com   Waiter  Inactive

B          Sam     Sam@al.com    Chef     Inactive

C         Jim       Jim@al.com     Waiter Inactive

C         Jim       Jim@al.com     Bartender Active

D         Ted      Ted@al.com    Waiter  Inactive

D         Ted      Ted@al.com    Supervisor Active

Obtained 
with Group Expert in Crystal 
and chose Role as grouping field :

User Id Name   
Email address   Role     Status

Chef

A         John     John@al.com   Chef     Active
B          Sam     Sam@al.com    Chef     Inactive

Waiter  

A         John     John@al.com   Waiter  Inactive
C         Jim       Jim@al.com     Waiter Inactive

Edited by namitanamburi - 30 Mar 2009 at 10:33pm