Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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?

Example 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

10/12                         05

10/12                         10

Any help would be greatly appreciated.

Former Member
Not what you were looking for? View more on this topic or Ask a question