Mark Wilson
asked on
Sorting on the first column of a crosstab
I am using a cross tab in a reports as follows.
Column (datefield) by day
Rows - resourcename
Summarized fields - this is a count
The report looks something like the following
12/05/2009 11/05/2009 10/05/2009 Total
Mark Smith 3 2 2 7
Mark Jones 23 3 9 35
Mark Cross 1 1 46 48
I now need to sort the crosstab, not by the total column but always be the first column, which contains
the previous days data, the reult would be
12/05/2009 11/05/2009 10/05/2009 Total
Mark Jones 23 3 9 35
Mark Smith 3 2 2 7
Mark Cross 1 1 46 48
I am using Crystal Reports XI
Does anybody know how this can be done?
Thanks
Column (datefield) by day
Rows - resourcename
Summarized fields - this is a count
The report looks something like the following
12/05/2009 11/05/2009 10/05/2009 Total
Mark Smith 3 2 2 7
Mark Jones 23 3 9 35
Mark Cross 1 1 46 48
I now need to sort the crosstab, not by the total column but always be the first column, which contains
the previous days data, the reult would be
12/05/2009 11/05/2009 10/05/2009 Total
Mark Jones 23 3 9 35
Mark Smith 3 2 2 7
Mark Cross 1 1 46 48
I am using Crystal Reports XI
Does anybody know how this can be done?
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You can delete the group header label
You can suppress the sectiions
mlmcc