Report - group by month/year?

[flojos1999]

I am a newbie to crystal
I am trying to create a report that groups by the month and year. The data contains a create date field. I would like to know what month/year the record was created on.

Example:

user enters the values for begin date(1/1/2002) and end date(4/25/2002)

The report will display the month/year

1/2002
Product Description Product Price Unit
2/2002
Product Description Product Price Unit
3/2002
Product Description Product Price Unit
4/2002
Product Description Product Price Unit


thanks for your help
FLOJOS1999

 

[synapsevampire]

Group on the date field, and when doing so, select This Section Will Be Printed For Each Month, Crystal will perform this grouping for you.

You can then right click the Group 1 Name field that it creates and select format field->Date->

Month = 3

and

Year = 1999

and

separator of /

Now place your columns in the Detail section, you should have what you've described.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com