I have a table that uses SAP Data with a Period Key, Customer and Measure. I need to sort on the Measure for the minimum Period Key only. All other Period Key Customers need to be unsorted. Any ideas?
fknaut 
(BOB member since 2005-08-04)
Hi,
In crystal reports, we have three types of sorting: ascending; descending; custom sort.
In the custom sort, we can specify the order of elements based on our choice. Probably as i see from your query, it would fit in this category. Please try and let me know if this helps.
Thanks,
Krishnam
krishnam raju yeluri (BOB member since 2008-08-04)
If you have a group and you want to sort in the way you have asked, It’s Group Sort Expert.
Group Expert–>select the group–>Options–>select Specified Order from drop down–>Specified Order tab appears—>select the period key you want to sort from Named Group drop down–>Then “Others” tab will be available–>select the required radio button.
Hope this helps.
anil.ganga1 (BOB member since 2007-07-04)