Thread: Creating Calendar in Crystal

Is there a way to create a calendar in Crystal Reports.? I have to show a list of contacts for a month and we were wondering if we can somehow display it in calendar form or some type of form that would show that.
Thanks
Nancy

Hi,

You can see how to create it here:

Create a calendar-style report

I finally am having time to create this. But I got to the following step # 19 and cannot get the SQL expression for DAYOFWEEK to work.

19. Also create three SQL expressions in the subreport, using the delimiters appropriate to your database or connectivity, and naming them as indicated here:

{%DayOfWeek}:
{fn dayofweek(`Appointments`.`Appointment Date`)}{%Month}:

Any help would be appreciated. I am so close.

Nancy