Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Suppressing Hierarchy

Status
Not open for further replies.

Krusher

IS-IT--Management
Jan 2, 2003
70
0
0
US
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
 
Never mind, figured it out by adding a variable to store the top-level parent. Thanks anyway.

-RT
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top