Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

grouping by birthmonth

Status
Not open for further replies.

rubberhead10

Technical User
Sep 13, 2006
49
US
I am looking for a way to group by someones birth month. I must admit that I am rather new at crystal and would appreciate any help........
 
Insert a group on {table.birthdate} and on the insert group screen choose "print on change of month".

-LB
 
thanks for the reply. that worked but it also showed the changes for the birth year. in the report I don't care what year they were born just the month......
 
Sorry, yes, do what SV suggested. Then go to report->group expert->options->customize groupname->use a formula->x+2 and enter:

monthname(month({table.birthdate}))

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top