Hi,

I m having an employee table with parent child relationship.



empid     parent_empid      name

1             null                      A

2             1                         B

3             2                         C

4             1                         D

5             3                         E



i want to display it in a crystal report. i achieved this using hierarchical grouping. but when i use parameter field it only displays the record for that employee only. i want the whole child record to be displayed. like if i pass parameter as 1, all child records should be displayed.



thanks