CROSSTAB REPORT - GROUPING BY "DAYS OUTSTANDING" BUCKETS

[dcanfield]

I am trying to create an Accounts Receivable crosstab report, where the columns are set on the number of days outstanding. For each record, I have a field that already displays the number of days outstanding for that record.

I want to be able to group my columns into the following days ranges

0-30
31-60
61-90
91-120
121-150
151-180
181-365
366+

Is there a way to create a formula or group that would let me set up my colums with the above range?

Thanks,

David

 

[dcanfield]

Sorry....more info:

CR10
Access DB.

 

[lbass]

Assuming that your days outstanding are integers, you can create a formula like:

if {table.daysout} in 0 to 30 then "0 - 30" else
if {table.daysout} in 31 to 60 then "31 - 60" else
//etc.

Then use this as your column field.

-LB