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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hierarchial Grouping

Status
Not open for further replies.

crystal82

Technical User
Joined
Jun 13, 2008
Messages
7
Location
AU
Hi,

Currently, I have a report grouped by job name (which is split into 3 GF1 sections with conditional suppression so that:
GF1a – displays all job names in level 2
GF1b– displays all job names in level 3
GF1c – displays all job names in level 4

However, I want the groups to display hierarchically in the following format:
Job Name (100) @ Level 2
Job Name (101) @ Level 3
Job Name (102) @ Level 4

Job Name (200) @ Level 2
Job Name (201) @ Level 3
Job Name (202) @ Level 4

This means that the job level needs to sit underneath the Job Name group. However, I have my job name running totals in GF1a,GF1b, and GF1c so I cant move all of this information up to GH1 and have a job level group sitting underneath Group 1 because the running totals are then evaluated incorrectly.

Is there a way around this?
 
This is hard to follow when you use abstract field names (job name) instead of sample data. Could you translate the above into some sample data?

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top