Make report dates show days of the week in addition to date 1

[willz99ta]

Hi,

Is there any way to have my Crystal Reports graph show days of the week instead of just the date for my X-Axis?

Thanks for your help,
Will

 

[lbass]

Try the following as your "on change of" field:

{table.date} & " " & weekdayname(dayofweek({table.date}))

-LB

 

[willz99ta]

The only problem I run into is that the formula field won't group itself "every day" like the date field will.

 

[lbass]

Sure it will. If it is a datetime, wrap it in date():

date({table.date}) & " " & weekdayname(dayofweek({table.date}))

If you are still having trouble, please explain the results you are getting.

-LB

 

[willz99ta]

Looks like LBass wins again! That fixed it and grouped it.

Thanks,
Will