Display Department in Column format

Printed From: Crystal Reports Book — Forum Name: Technical Questions

Hello All,
Is there a way to display department in column format. I'm writing a simple report but requirement is to be displayed in a column format and under each department list of the employees belongs to that department. So report outcome should be as follow

     AAA             BBB                 CCC                     
1.a.smith          1.k.smith          1.j.smith
2.b.smith          2.p.smith          2.a.smith
3.c.smith          3.l.smith
                     4.s.smith

    DDD        EEE           FFF                     
1.a.smith    1.k.smith     1.j.smith
2.b.smith    2.p.smith     2.a.smith
3.c.smith    3.d.smith     3.l.smith
4.s.smith     


Where AAA, BBB and so on Department name . Also want total for that block for example (AAA,BBB,CCC - TOTAL: 9)
(DDD,EEE,FFF - TOTAl : 10)

Can somebody please give me some idea as how do I achieve   this?

Any help will be appreciated.
Thank you...