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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sorting
- Thread starter lbunch
- Start date
lbunch,
please clarify as to the layout of your report.
is {ID} a grouping level or a field in your Details section?
1) If it is a grouping level:
Right Click on the group and choose "Change Group"
In the second drop down, choose "Specific Order" and then set the order you wish your sort to be.
2) If not a grouping level (and the orer you wish is not the numerical order of {ID}):
You may need to create a "Dummy" field to store the order you wish your report to be in. Using IF statements would be simplest.
If situation is either or the above and you need clarification, or if it is a different scenario entirely, let me know.
Hope This Helps,
Mike
![[banghead]](/data/assets/smilies/banghead.gif "[banghead] [banghead]")
"It Seems All My Problems Exist Between Keyboard and Chair"
please clarify as to the layout of your report.
is {ID} a grouping level or a field in your Details section?
1) If it is a grouping level:
Right Click on the group and choose "Change Group"
In the second drop down, choose "Specific Order" and then set the order you wish your sort to be.
2) If not a grouping level (and the orer you wish is not the numerical order of {ID}):
You may need to create a "Dummy" field to store the order you wish your report to be in. Using IF statements would be simplest.
If situation is either or the above and you need clarification, or if it is a different scenario entirely, let me know.
Hope This Helps,
Mike
"It Seems All My Problems Exist Between Keyboard and Chair"- Status
Similar threads
- Locked
- Question
- Locked
- Question