on 09-05-2012 7:07 PM
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.
Hi,
Change the Query in Order By ProjId Asc
Thanks,
Nithi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
78 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.