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

Sorting Group Based on Age

Status
Not open for further replies.

Fadius

IS-IT--Management
Jul 25, 2001
139
US
I have a report using Xi which is grouped on Cred Type.

I have a formula providng the age of each record called @_cred_age

What I am in need of is to arrange the groups based on the oldest cred in each group.

How can I accomplish this?
 
right click on the group, choose 'Change Group' and on the Common tab select the sort method you need.
 
Depending upon the content of your formula (which you should always show), you can insert a summary (maximum) on {@credage} at the group level, and then go to report->group sort and select maximum of credage for your sort. You can then remove the inserted summary which is just necessary to activate the group sort feature.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top