Print Page | Close Window

Dynamic Hierarchical Report

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=16111
Printed Date: 18 Apr 2025 at 7:16pm


Topic: Dynamic Hierarchical Report
Posted By: karthikkjm
Subject: Dynamic Hierarchical Report
Date Posted: 06 Apr 2012 at 12:19am
my report output should be like this...

CEO
   |___GM
   |        |__HR Manager
   |        |            |__HR Executive
   |        |            |__HR Representative
   |        |__Purchase Manager
   |                     |__Purchase Executive
  

my table design is like this...

Desig_Code       Desig_Name                Reporting To
1                         CEO
2                         GM                                CEO
3                         HR Manager                   GM
4                         HR Executive                  HR Manager
5                         HR Representative          HR Manager
6                         Purchase Manager          GM
7                         Purchase Executive         Purchase Manager   


please help...
i tried with adding same table as alias, but not fitting to my needs, because n level of hierarchy is possible.

thanks in advance   
                     





-------------
karthik


Replies:
Posted By: lockwelle
Date Posted: 09 Apr 2012 at 3:30am
all that comes to mind is make it a cross tabs style report.
 
dynamic columns...well how do you code the report, it wants fixed number of columns, but a cross tabs report is by definition a dynamic column report.
 
Hope this helps, or at least points to a solution.


Print Page | Close Window