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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Grouping 1
- Thread starter pungigi
- Start date
Need more detail.
What is the criteria?
If you want to group G3 Status by a certain order - you can go back to Change group order and select specific order and create the way you want the grouping to show.
But if this is not what you want, you will need to give more example of what you want.
Lin
What is the criteria?
If you want to group G3 Status by a certain order - you can go back to Change group order and select specific order and create the way you want the grouping to show.
But if this is not what you want, you will need to give more example of what you want.
Lin
- Thread starter
- #3
I see....you want to lump some of the groups together depending on their first letters.
For that...in Group 3 have the group grouped by "Specified Order"
Then you define the order by naming the subgroup and giving the criteria for forming this subgroup.
Eg.
1. right-click on the group header in the grey margin and choose "change Group"
2. select the field you want grouped and sort by "Specified order"
3. press New to create a subgroup
4. Title the groupname "ALL D's"
5. in the box below select "Starts with" and enter "D"
6. Press New again to create another subgroup in a similar fashion.
7. rearrange the sort order of these groupings anyway you want....any situations not covered in Named groups will fall under "Other"
hope this helps
Jim Broadbent
The quality of the answer is directly proportional to the quality of the problem statement!
For that...in Group 3 have the group grouped by "Specified Order"
Then you define the order by naming the subgroup and giving the criteria for forming this subgroup.
Eg.
1. right-click on the group header in the grey margin and choose "change Group"
2. select the field you want grouped and sort by "Specified order"
3. press New to create a subgroup
4. Title the groupname "ALL D's"
5. in the box below select "Starts with" and enter "D"
6. Press New again to create another subgroup in a similar fashion.
7. rearrange the sort order of these groupings anyway you want....any situations not covered in Named groups will fall under "Other"
hope this helps
Jim Broadbent
The quality of the answer is directly proportional to the quality of the problem statement!
-
1
- #5
Or you could write a formula:
left({table.status},1) //assuming "DA","DB", etc. are instances of group 3 (status)
Then group on this formula. To make it your group 4, go to report->change group expert and use the direction key to move it into fourth position. Group 5 (vehicles) will now be nested within each Group 4 instance.
-LB
left({table.status},1) //assuming "DA","DB", etc. are instances of group 3 (status)
Then group on this formula. To make it your group 4, go to report->change group expert and use the direction key to move it into fourth position. Group 5 (vehicles) will now be nested within each Group 4 instance.
-LB
- Status
Similar threads
- Locked
- Question
- Locked
- Question