Ok, Here's my problem. I have a report that shows workorders in a hierchical grouping, but don't want to show all of the hierarchies at once. I want the user to be able to enter a single work order number and show the entire hierarchy structure it appears in (front top level parent to the lowest child workorder). Below is a sample of the data. So, for instance, if the user enters "1573371" as a parameter for WONUM, I want Crystal to display the 1079707 through 1487893. Now they all have a common "top-level" parent workorder, but I extracted this top-level parent by writing a formula. Is there a way to basically have a WONUM parameter and then have Crystal look to find out the correpsonding "top-level" parent (formula) and use that as the criteria to suppress/show? Any help would be greatly appreciated!
WONUM
1709707
1573371
1709721
1487893
7851555
7878855
7787878
5454875
4875459
-RT
WONUM
1709707
1573371
1709721
1487893
7851555
7878855
7787878
5454875
4875459
-RT