Crystal 9-Subtotal by MONTH

[OrionStar]

Dear Forum:

I need help setting up SUBTOTAL by MONTH. I have data as follows:

Date Check# AMT

12/20/04 1215 75.00
12/25/04 1229 50.00
01/01/05 1234 100.00
01/05/05 1235 200.00

I need to have a subtotal BY MONTH, not day. Can you tell me how to achieve this?

THX Mike


"A man is only as happy,... as he makes up his mind to be...

 

[oneilltnc]

Insert a group for your date field. When you setup this group in the section that says 'This section will be printed' choose for each month instead of for each day. This will allow you to subtotal by month.

 

[OrionStar]

THANKSSSSS I really appreciate the tip....

Mike

"A man is only as happy,... as he makes up his mind to be...