Crystal Reports SQL expression

I am following the guide from

The guide says to create sql expressions in the subreport (the data is coming from tables from Outlook's calendar).
However the sql expressions section isn't present in the field explorer for this data source.

Am I able to just create regular formulas?

The sql expressions should be

{fn dayofweek('Appointments'.'Appointment Date')}

When I tried in formulas dayofweek{Apppointments.Appointment Date} the error returned was "The remaining text does not appear to be part of the formula" referring to the expression inside {}.

I am running crystal reports 2008 (v 12)

Any thoughts? Thanks Ed.
Who is Participating?
peter57rConnect With a Mentor Commented:
dayofweek({Apppointments.Appointment Date} )
edmaceyAuthor Commented:
Brilliant thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.