Print Page | Close Window

Display Department in Column format

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Technical Questions
Forum Discription: Formulas, charting data, Crystal syntax, etc.
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22641
Printed Date: 01 May 2024 at 8:03pm


Topic: Display Department in Column format
Posted By: dax007
Subject: Display Department in Column format
Date Posted: 12 Jul 2018 at 11:09am
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...



Print Page | Close Window