Crystal Report Specified Sort Order not working correctly in InfoView
I created a Crystal report which groups on division then project id. However, I want the report to be sorted by division, project date, then project ID. The issue is the project date needs to be formatted and sorted as MM/YY. So if 2 projects have the same MM/YY, the sorting should look at the project id to determine order. Now, the report looks at the full mm/dd/yyyy to determine order. Any way to use the date field formatted as MM/YY and sort on the formatted value, not the underlying data?
Date MM/YY Format Proj ID
10/12/2012 10/12 10
10/20/2012 10/12 05
using this, the display should be
MM/YY Format proj ID
Any help would be greatly appreciated.