Skip to Content
avatar image
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Sep 06, 2012 at 05:06 AM


    Change the Query in Order By ProjId Asc



    Add comment
    10|10000 characters needed characters exceeded