How to do the Drill down in XI?

[rajrev]

Hi,
I am using Crystal XI and DB2 database.

Q: How to do the drill down in XI?

Example:
There are two levels 1. Manager and 2. Emplyee
Parameter for the report is ManagerID.

Once select the manager ID, I have to provide the Manager detail and in the bottom of the report i need to provide the Employee's ID LINKS "who are falling under that selected Manager".
If we click on any of the EmployeeID, I need to provide that particular Employee information as a report.
(Means that I need to pass the selected Employee ID as a parameter in that new report.)

--------------------------------------------
Report1 (Parameter SID value = 101010)

SName :Name1
SId :101010
Location :xxxx

....
....
...

Emplyee's under "SuperV Name1"
12345 (Hyperlink)
67890 (Hyperlink)
11111 (Hyperlink)
---------------------------------------
If we click on the link 12345 then
we need the following report

Report2

Emp Nam: Emp1
Emp ID : 12345
Address :aaaa
Phone : 9993333
....
...

Please let me know your suggestion/comments.

If you need more information please let me know.

Thanks,
M

 

[synapsevampire]

Levels and required output are difficult to nail if you don't post information about the tables.

Try to Group by the Manager, then by the employee, place the manager data in the Group 1 Header, Employee ID in the Group 2 header, then the employee data in the details, right click the details and select HIDE.

Now ehen they click on an Employee ID the details will show.

-k

 

[rajrev]

Thanks for your response -k.

I will try to expain the problem in detail.

Manager_Tbl
ManID ManName ManAddress
1 Man1 xxx
2 Man2 yyy
3 Man3 zzz

Superv_Tbl
SupID ManID SupName SupAddress
S10 1 Sup1 aaa
S20 1 Sup2 bbb
S30 2 Sup3 ccc
S40 3 Sup4 ddd
S50 1 Sup5 eee
S60 3 Sup6 fff

Emp_Tbl
EmpID SupID EmpName EmpAddress
E111 60 Emp1 ppppp
E222 50 Emp2 qqqqq
E333 40 Emp3 rrrrr
E444 10 Emp4 sssss
E555 10 Emp5 ttttt
E666 20 Emp6 uuuuu
E777 30 Emp7 vvvvv
E888 10 Emp8

http://wwwww

Table Links

Manager_Tbl.ManID --> Superv_Tbl.ManID
Superv_Tbl.SupID --> Emp_Tbl.SupID

Parameter
Manager ID
--------------------------------------------------------
For Example
Form the parameter drop down, if we select the manager id= 1)

The output of the report is:

Manager Info. Report

Manager ID : 1
Manager Name : Man1
Manager Addr : xxx

SupID under Man1
S10 (Need to be a Hyperlink)
S20 (Need to be a Hyperlink)
S50 (Need to be a Hyperlink)

------------------------------------------------
if user click on SupID S10 then need to provide the following output:

Supervisor Info. Report

Superv ID : S10
Superv Name: Sup1
Superv Addr: aaa

Manager Name: Man1 (need to be a Hyperlink)

Employees under Sup1
E444 (Need to be a Hyperlink)
E555 (Need to be a Hyperlink)
E888 (Need to be a Hyperlink)


------------------------------------------------------
click on E555 link need to provide the following output:

Employee Info. Report

Emp ID : E555
Emp Name : Emp5
Emp Addr : ttttt

SuperV name: Sup1 (need to be a Hyperlink)

---------------------------------------------------
---------------------------------------------------

Please let me know if you have any questions.

Thanks,
M