How can I group on a formula field?

[terenceb]

Hi ALL,

I am pulling data from SQL tabel on a Cashe Database with Crystal 8.5.

I run a report that shows the number of No Show Appts., Cancellations Appts., Rescheduled Appts. per medical facility. run for a selected date range. example.

Site 1 No Shows Canceled Rescheduled
34 15 68
Site 2 20 3 18

What I need now is to show this same data in a cummalative report that spans the last 12 months.

For Example.

March
Site 1 No Shows Canceled Rescheduled
34 15 68
Site 2 20 3 18

February
Site 1 No Shows Canceled Rescheduled
28 8 78
Site 2 13 16 12

ect.

How do I group it on the month when my tables do not have month field? I hope I have provided enough information, if not I have more.

 

[bdreed35]

You can create a group of a date field.

Go to Insert, Group.
Choose your Date Field in the first drop down.
In the third drop down, change it to "for each month".
In the Group Options, select Customize Group Name Field.
Choose "Use a formula as a Group Name" and select the X+2 button next to it.
In the editor add the following line:

ToText({Orders.Order Date},"MMMM yyyy")

This will give you month name and year (ie. March 2004)
If you want just month then use this:

ToText({Orders.Order Date},"MMMM")

Save and Close, then close the Group Options box.
You should now have the result you are looking for.

~Brian