Changing aging buckets in Crystal

[Former Member]

Post Author: jshynes

CA Forum: Formula

I need to have a custom aging buckets (ranges) created in Crystal.

I use CRXI, MSSql database. pretty much a new user.

I'm also aware of the functions Aged0to30days, Aged31to60days etc... but I need the ranges to be different. Is there anyway to use a formula to create a custom date range so that it'll be 0-60, 61-90, 91-120, 120-180 and over 180 days? The data is invoice dates and invoice amounts.

If noone has an example, can you point me in the direction or suggest for other resources.

Thanks,

Dude

[Former Member]

Post Author: jshynes

CA Forum: Formula

Thanks, that help alot...

[Former Member]

Post Author: Archmage

CA Forum: Formula

Hi,

why not approach it from the server side? Create a stored proc that processes the data from the tables and band it using whatever time banding you are looking to do...

0-60

61-90

91-120

121+

Then have the data returned as separate fields. Crystal reports will then merely show the results of the banding.

[Former Member]

Post Author: SKodidine

CA Forum: Formula

Check out this thread for ideas on how to accomplish this.

http://technicalsupport.businessobjects.com/cs/forums/thread/3531.aspx