Age Grouping

[TaTips]

hi:

I need to create groups in my report based on Age..

For example.. 30 - 50 and 60 - 70

The column is a number column.

Any examples of how to create these groups please ?

Thanks.
Tatips.

 

[TaTips]

NOTE:

The columnm is CUSTOMER_AGE. eg.30 No DOB arithmetic is required just how to group according to a number column.

Ta.

 

[HowardHammerman]

If you want to create typical Crystal groups, simply create a group on your age field and then in the order box pick "specific grouping". This will allow you to create groups in the way you want.

Or you could create a formula field using the following syntax:

select {table.age_field}
case 0 to 10 : 1
case 11 to 20 : 2
case 21 to 35 : 3
case 36 to 70 : 4
default : 5

Note: you must include a default line. The results on the right side of the colons can be text. Just include the text inside quotes.

Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[TaTips]

Thank You Hammerman.

 

[lyanch]

You can also do this directly in grouping in the "specified order" section, that also makes getting them in the proper order easy.

Lisa