Sorting by Day of Week

[harrietohs]

Crystal 8.5

I use the following formula for a row in a cross tab report:

WeekdayName(DayOfWeek({activity.new_date}))

The report is run with start and end date parameters, with the intent to see which days of the week have the most actvities.

This formula sits within a group that divides the report by the different activity types.

It all works fine, except the report displays with the week day names in alphabetical order. I am trying to figure out how to get them to display in natural date order (i.e. Mon, Tues, Weds, Thurs,....)

Thanks,

Harriet

 

[lbass]

Use the following formula for your rowfield:

dayofweek({activity.new_date})

Then while the formula is highlighted in the crosstab expert, go to Group Options->customize groupname->use a formula for the groupname->x+2 and enter:

weekdayname(dayofweek({activity.new_date}))

-LB

 

[harrietohs]

Perfect! LB- as always,you are my hero!

Harriet