Group sort question

[shannonlp]

Hi,

I’ve got a Crystal Report that has two groups: Group 1 is the transaction type and Group 2 is the Month.

I am trying to sort Group 2 chronologically so that the months are in the right order. I’ve been looking at the Group Sort Expert and Record Sort Expert but can’t figure it out.

The end result needs to be a chart that displays the count of the transactions per month. Right now it’s displaying it July, May, June where I need it to display May, June, July. I think its displaying it this way because it going by the count of transactions (lowest to highest). I need to override this and create a specified sort order based on the month.

Any help would be greatly appreciated.

 

[shannonlp]

Also, I'm on Crystal 11.5. Database is Oracle.

 

[hilfy]

Where are you getting Month from? Is it a calculation from a date field or is it a text field?

What you'll need to do is actually group on the month number, then display the month name instead of the month number.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[shannonlp]

The month was derived by using this formula:

MonthName (DatePart ("m", {CORAUDIT.AUDITDTTM}))

I was grouping on that formula.

I basically did what you suggested. I created another formula field:

DatePart ("m", {CORAUDIT.AUDITDTTM})

which gives me a number and I’m sorting on that. To ensure that my chart displays the month name, not the number, I went to group options, checked customize group field name, formula and then used the formula field that displays the month name.

Thanks!