Custom Group -> Specified Order. Custom selection criteria?

[Guest_imported]

USING CR 9

Problem: Group records into the following groups: 0-1 Months, 1-3 Months, 3-6 Months, 6-12 Months, 1 Year and older

I know to go Insert->Group, select "in specified order", then click the specified order tab, and create groups. The problem I'm having is Crystal's restraints are pretty limited (1-3 months is "31-60 Days OR 61-90 days) and I can't create a group for 3-6 or 6-12 months.

I keep looking for a formula box but can't seem to find one. It wouldn't make any sense to me if I couldn't define custom selection criteria.

 

[synapsevampire]

Create a formula such as:

whileprintingrecords;
if {table.date} >= datserial(year(currentdate),month(currentdate)-1,day(currentdate)) then
1
else
if {table.date} >= datserial(year(currentdate),month(currentdate)-3,day(currentdate)) then
3
else
if {table.date} >= datserial(year(currentdate),month(currentdate)-6,day(currentdate)) then
6
else... you get the idea, the dateserial function takes the pain out of this for you.

Then just Group on this field.

-k

 

[Guest_imported]

Just for anyone else that views this post, you have to remove the "WhilePrintingRecords" clause in order to use the formula when grouping.

I think "WhilePrintingRecords" means to do it during the second pass, which is where all grouping is done, so Crystal wouldn't know about the formula results until the 3rd pass.

 

[synapsevampire]

Ahhhh, right, sorry, force of habit, good catch.

-k